Candidates About

Sabitha

Data Scientist

 

PROFESSIONAL SUMMARY:

 

·      Over 8 years of Experience in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousingWeb-based Applications and Databases and Experience in industries such as  Retail, Financial, Accounting, Distribution, Logistics, Inventory, Manufacturing, Marketing, Services, Networking and Engineering

·      Experience in all the Latest BI Tools Tableau, Qlikview Dashboard Design and SAS.

·      Strong Data Analysis skills using business intelligence, SQL and / or MS Office Tools.

·      Experience working in Agile/Scrum Methodologies to accelerate Software Development iteration.

·      Familiar on building models with big data frameworks like Cloudera Manager and Hadoop 

·      Experience in BigData with Hadoop, HDFS, MapReduce, and Spark. 

·      Experience in managing full life cycle of Data Science project includes transforming business requirements into Data Collection, Data Cleaning, DataPreparation, DataValidation, DataMining, and DataVisualization from structured and unstructured Data Sources. 

·      Sound RDBMS concepts and extensively worked with Oracle 8i 9i 10g 11g, DB2, SQL Server 8.0 9.0 10.0 10.5 11.0, MySQL, and MS-Access.

·      Expertise in Project Management, Analysis, Estimation, with a unique mix of managerial, 
functional, domain, technical and client handling skills

·      Expertise and experience in SQL, SAS and Relational databases. Deep understanding & exposure of Data mining

·      Excellent knowledge in Normalization (1NF, 2NF, 3NF and BCNF) and De-normalization techniques for improved database performance in OLTP, OLAP and Data Warehouse/Data Mart environments

·      2+ years' experience in Agile background of software/data design, development, deployment to build services and customer support in Enterprise applications using Object Oriented Analysis and Design (OOAD)

·      Experience in applying predictive modeling and machine learning algorithms for analytical reports.

·      Profound Analytical and problem solving skills along with ability to understand current business process and implement efficient solutions to issues/problems.

·      Experience using technology to work efficiently with datasets such as scripting, data cleansing tools, statistical software packages.

·      Strong understanding of how analytics supports a large organization including being able to successfully articulate the linkage between business objectives, analytical approaches &findings and business decisions.

·      Experience in using Python and statistical software (R, Excel, Tableau)

·      Experience with Azure, SQL and Oracle PL/SQL

·      Experience working with Amazon Web Services (AWS) product like S3

·      Involved in a Aveva start-up mode and contributed to projects using Amazon Web Services (AWS) to develop and deploy applications support on device and cloud

·      Hands on experience with scripting languages like Perl, Bash Shell and PHP (for automation)

·      Familiar with nightly build management tools like Visual Studio Team Foundation Server (VSTFS)

·      Experience developing software in traditional programming languages (in C, C++) using tools like MS Visual Studio Compact Framework (VSCF) for the Windows Mobile Platform

·      Familiar with configuration management and repository management of subversion (SVN) control system source code using tools like GIT and MS Team Foundation Version Control (TFVC)

·      Good Experience in database design using PL/SQL, SQL, T-SQL to write Stored Procedures, Functions, Triggers, Views

·      Extensive experience in Data Modeling, Data Analysis and design of OLTP and OLTP systems.

·      Expertise in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non-relational databases

 

EDUCATION:

 

Bachelor of Computer Science

 

PROFICINAL EXPERTISE

 

Languages	T-SQL, PL/SQL, SQL, C, C++, XML, HTML, DHTML, HTTP, MATLAB, DAX, Python
Databases	SQL Server 2014/2012/2008/2005/2000,  MS-Access, Oracle  11g/10g/9i and Teradata , big data, Hadoop
DWH / BI Tools	Microsoft Power BI, Tableau, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports, Informatica 6.1.
Database Design Tools and Data Modeling	MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, Fact & Dimensions tables, physical & logical data modeling, Normalization and De-normalization techniques, Kimball &Inmon Methodologies
Tools and Utilities	SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net,  Microsoft Management Console, Visual Source Safe 6.0, DTS, Crystal Reports, Power Pivot, ProClarity ,Microsoft Office, Excel Power Pivot, Excel  Data Explorer, Tableau, JIRA,SparkMlib

PROFESSIONAL EXPERIENCE:

 

Designation: Data Scientist,

Client:Bristol Myers Squibb, NY                                                                            July, 2016 – till date

 

Description: Bristol-Myers Squibb Company, incorporated on August 11, 1933, is engaged in the discovery, development, licensing, manufacturing, marketing, distribution and sale of biopharmaceutical products. The Company's pharmaceutical products include chemically synthesized drugs, or small molecules, and products produced from biological processes called biologics.

Responsibilities:

 

 

·       As an Architect design conceptual, logical and physical models using Erwin and build DataMart’s using hybrid Inmon and Kimball DW methodologies.

·       Worked closely with business, data governance, SMEs and vendors to define data requirements.

·       Designed and provisioned the platform architecture to execute Hadoop and machine learning use cases under Cloud infrastructure, AWS, EMR, and S3.

·       Selection of statistical algorithms - (Two Class Logistic Regression Boosted Decision Tree, Decision Forest Classifiers etc)

·       Used MLlib, Spark's Machine learning library to build and evaluate different models.

·       Executed ad-hoc data analysis for customer insights using SQL using Amazon AWS Hadoop Cluster. 

·       Worked on predictive and what-if analysis using R from HDFS and successfully loaded files to HDFS from Teradata, and loaded from HDFS to HIVE. 

·       Designed the schema, configured and deployed AWS Redshift for optimal storage and fast retrieval of data.

·       Worked in using Teradata14 tools like Fast Load, Multi Load, T Pump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ. 

·       Involved in creating Data Lake by extracting customer's Big Data from various data sources into Hadoop HDFS. This included data from Excel, Flat Files, Oracle, SQL Server, Mongo DB, Cassandra, HBase, Teradata, Netezzaand also log data from servers 

·       Used Spark Data frames, Spark-SQL, Spark MLLib extensively and developing and designing POC's using Scala, Spark SQL and MLlib libraries.

·       Created high level ETL design document and assisted ETL developers in the detail design and development of ETL maps using Informatica.

·       Used R, SQL to create Statistical algorithms involving Multivariate Regression, Linear Regression, Logistic Regression, PCA, Random forest models, Decision trees, Support Vector Machine for estimating the risks of welfare dependency. 

·       Helped in migration and conversion of data from the Sybase database into Oracle database, preparing mapping documents and developing partial SQL scripts as required.

·       Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.

·       Analyzed data and predicted end customer behaviors and product performance by applying machine learning algorithms using Spark MLlib. 

·       Performed data mining on data using very complex SQL queries and discovered pattern and Used extensive SQL for data profiling/analysis to provide guidance in building the data model 

 

Environment: R, Machine Learning, Teradata 14, Hadoop Map Reduce, Pyspark, Spark, R, Spark MLLib, Tableau, Informatica, SQL, Excel, VBA, BO, CSV, Erwin, SAS, AWS Redshift, Scala Nlp, Cassandra, Oracle, MongoDB, Informatica MDM, Cognos,SQL Server 2012, Teradata, DB2, SPSS, T-SQL, PL/SQL, Flat Files, XML, and Tableau

 

Designation:Data Scientist                                                                         

Client: Freddie Mac, VA                                                                                                                                               May, 2015 – June, 2016

 

Description:Freddie Mac is a shareholder-owned corporation whose people are dedicated to improving the quality of life by making the American dream of decent, accessible housing a reality. We accomplish this mission by linking Main Street to Wall Street--purchasing, securitizing and investing in home mortgages, and ultimately providing homeowners and renters with lower housing costs and better access to home financing.

 

Responsibilities:

·     Involved in data management including Data Modeling, Metadata, Data Analysis, Data mapping and Data Dictionaries, Erwin9.1 and involved in Data Modeling (Oracle/MySQL/Netezza), Data Characterization, Workflow design and implementation 

·     Used Erwin Data Modeler and Erwin Model Manager to create Conceptual, Logical and Physical data models and maintain the model versions in Model Manager for further enhancements. 

·     Worked on logical and physical modeling of various data marts as well as data warehouse using Taradata14. 

·     Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes and glossary terms in accordance with the Corporate Data Dictionary etc. 

·     Implemented Bulk Load Process by converting existing Triggers to Oracle11g packages to improve the Data loading process. 

·     Designed and Developed Oracle11g, PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions. 

·     Maintained warehousemetadata, naming standards and warehouse standards. 

·     Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports. 

·     Worked in using Teradata14.1 tools like Fast Load, Multi Load, T Pump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ. 

·     Designed the overall ETL solution including analyzing data, preparation of high level, detailed design documents, test plans and deployment strategy.

·     Strong knowledge of Entity-Relationship concept, Facts and dimensions tables,slowly changing dimensions and Dimensional Modeling(Star Schema and Snow Flake Schema).

·     Created Software Development Life Cycle (SDLC) document and excelled in the process of Change Management, Release management and Configuration processes. 

·     Prepared Data Visualization reports for the management using R 

·     Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas. 

·     Involved in Normalization and De-Normalization of existing tables for faster query retrieval. 

·     Create MDM base objects, Landing and Staging tables to follow the comprehensive data model in MDM. 

·     Used ETL methodology for supporting data extraction, transformations and loading processing, in a complex MDM using Informatica. 

·     Performed Data Validation and Data Cleaning using PROC SORT, PROC FREQ and through various SAS formats. 

·     Designed Data Staging Area and Data Warehouse to integrate the data from various sources including Flat Files to facilitate management to make more fact based decisions. 

·     Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.

·     Managed data in different locations using different data marts using Azure. 

·     Perform reverse engineering of physical data models from databases and SQL scripts. 

·     Involved in Normalization (3rd normal form), De-normalization (Star Schema for Data Warehousing. 

·     Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases to OLAP databases. 

·     Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference data changes. 

·     Extensively used SAS to query and subset data, summarize and present data, combine tables using joins and merges and created and modified tables. 

·     Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

·     Utilized SDLC and Agile methodologies such as SCRUM. 

·     Worked in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server2008 and UNIX shell scripting to perform job scheduling.

 

Environment : ERwin9.1, Teradata14, Oracle10g, PL/SQL, UNIX, Agile, Azure, TIDAL, MDM, ETL, BTEQ, SQL Server2008, Informatica MDM, Netezza, DB2, SAS, Tableau, UNIX, SSRS, SSIS, T-SQL, MDM, Informatica, SQL

 

Designation: Data/Business Analyst,

Client: Rabobank New York, NY                                                                                                             June, 2014 – Apr, 2015

 

Description:Cooperative Rabobank U.A., New York Branch is a debt issuing vehicle. The company is based in New York, New York. Cooperative Rabobank U.A., New York Branch operates as a subsidiary of Cooperative Rabobank U.A.

Responsibilities:

 

• Coded R functions to interface with CaffeDeepLearning Framework
• Working in AmazonWebServices cloud computing environment
• Worked with several R packages including knitr, dplyr, SparkR, CausalInfer, spacetime.
• Implemented end-to-end systems for DataAnalytics, DataAutomation and integrated with custom visualization tools using R,Mahout, Hadoop and MongoDB.
• Gathering all the data that is required from multiple data sources and creating datasets that will be used in analysis.
• Performed Exploratory DataAnalysis and DataVisualizations using R,  andTableau.
• Perform a proper EDA, Univariate and bi-variate analysis to understand the intrinsic effect/combined effects.
• Worked with Data governance, Data quality, data lineage, Data architect to design various models and processes. 
•  Independently coded new programs and designed Tables to load and test the program effectively for the given POC's using with Big Data/Hadoop. 
• Designed data models and data flow diagrams using Erwin and MSVisio. 
• Performed datacleaning and imputation of missing values using R.
•  Worked with Hadoop eco system covering HDFS, HBase, YARN and MapReduce 
• Take up ad-hoc requests based on different departments and locations
•  Used Hive to store the data and perform datacleaning steps for huge datasets.
• Created dash boards and visualization on regular basis using ggplot2 and Tableau
• Creating customized business reports and sharing insights to the management.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.

Interacted with the other departments to understand and identify dataneeds and requirements and work with other members of the ITorganization to deliver data visualization and reportingsolutions to address those needs.

 

Environment: Erwin r9.0, Informatica 9.0, ODS, OLTP, Oracle 10g, Hive, OLAP, DB2, Metadata, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, Hadoop, PL/SQL, etc

 

Designation: Data/Business Analyst,

Client:  Coventry Health Care, Minneapolis MN                                                                                               Sept, 2012 – Dec, 2013

Description: Coventry Health Care Management utilizes multiple software systems to support the intake and processing of authorization requests, the exchange of data between the payer and vendors contracted to perform services on our behalf, manage Case and Disease programs, provide robust reporting and decision support, and generally automate and facilitate their business processes.

Responsibilities:

·         Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.

·         Worked in Data warehousing methodologies/Dimensional Data modeling techniques such as Star/Snowflake schema using ERWIN9.1. 

·         Extensively used Aginity Netezza workbench to perform various DDL, DML etc. operations on Netezza database.

·         Involved in Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts. 

·         Used ER Studio Data/ Modeler for data modeling (data requirementsanalysis, database design etc.) of custom developed information systems, including databases of transactional systems and data marts.

·         Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.   

·         Generated DDL scripts using Forward Engineering technique to create objects and deploy them into the databases. 

·         Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer and PL/SQL Developer. 

·         Used Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, FastLoad, Multi Load, Fast Export, Tpump on UNIX/Windows environments and running the batch process for Teradata.

·         Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.

·         Worked on Data warehouse concepts like Data warehouse Architecture, Star schema, Snowflake schema, and Data Marts, Dimension and Fact tables.  

·         Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects. 

·         Wrote TSQL like Indexes, Views, Stored Procedures and Triggers in SSMS to fulfill Requirements. 

·         Involved in Database migrations from legacy systems, SQL server to Oracle and Netezza. 

·         Used SSIS to create ETL packages to validate, extract, transform and load data to pull data from Source servers to staging database and then to Netezza Database and DB2 Databases. 

·         Worked on SQL Server concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services). 

 

Environment: Windows XP , SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL-PLU, Java

 

Designation: Data/Business Analyst,

Client: People Tech Group, India                                                                                                                             Mar, 2011 – Sept, 2012

 

Responsibilities:

·      Writing and executing customized SQL code for ad hoc reporting duties and used other tools for routine

·      Developed stored procedures and complex packages extensively using PL/SQL and shell programs

·      Involved in customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC

·      Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy SQL Server database systems

·      Used existing UNIX shell scripts and modified them as needed to process SAS jobs, search strings, execute permissions over directories etc.

·      Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models

·      Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams

·      Worked on database features and objects such as partitioning, change data capture, indexes, views, indexed views to develop optimal physical data mode

·      Worked with SQL Server Integration Services in extracting data from several source systems and transforming the data and loading it into OD