Candidates About

 

Chetan Naik

 

Sr. Data Modeler/ Data Analyst, Edison, NJ

·         8+ years of Industry experience as a Data Analyst with solid understanding of Data Modeling, Data Validation, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.

·         Expert in writing Complex SQL queries and optimizing the queries in Oracle, SQL Server 2008 and Teradata. Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.

• Worked with applications like R, SPSS and Python to develop neural network algorithms, cluster analysis.
• Worked with packages like ggplot2 and shiny in R to understand data and developing applications.
• Worked on Tableau, QuickView to create dashboards and visualizations.

·         Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

·         Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.

·         Excellent experience on Teradata SQL queries, Teradata Indexes, Utilities such as Multiload, Tpump, Fast load and Fast Export.

·         Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.

·         Excellent knowledge in Alteryx.

·         Excellent knowledge on Perl &UNIX.

·         Experienced working with Excel Pivot and VBA macros for various business scenarios.

·         Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Ab Initio and Informatica Power Center Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.

·         Excellent experience on using Teradata SQL Assistant, Teradata Administrator, PMON and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Exposure to T pump on UNIX/Windows environments and running the batch process for Teradata.

·         Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.

·         Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.

·         Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders

·         Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.

·         Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Tableau.

·         Extensive ETL testing experience using Informatica (Power Center/ Power Mart) (Designer, Workflow

·         Manager, Workflow Monitor and Server Manager)

·         Have good exposure on working in offshore/onsite model with ability to understand and/or create functional requirements working with client also have Good experience in requirement analysis and generating test artifacts from requirements docs.

·         Proficient in Microsoft business intelligence stack SSIS, SSRS, SSAS.

·         An excellent team player& technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

SKILLS:

BI Tools	Tableau (desktop and server), SSAS, SAS, Alteryx, SPSS, Looker
ETL	Microsoft SSIS
Programming Languages	R, Core Java, Python, JavaScript, HTML, CSS3.
Visualization packages	Tableau 9.1, 10+
Data Modeling tools	ERWIN, SQL Server Management Studio
Database	Oracle 10g,11g. PostgreSQL, MSSQL 2005
Software Methodologies	RUP, UML, Agile methodology, Waterfall methodology, Scrum, Iterative model, Spiral Model, V model.
Microsoft Tools	Microsoft Project, MS office Suite.
ERP Tools	SAP R/3 4.7EE and ECC 6.0. SAP CRM 7.1 EHP1, SAP BI 7.1-7.3
Operating Systems	Windows server 2003/2008, Mac OS, Ubuntu.

 

 

WORK EXPERIENCE

R Programmer / Data Scientist

Aetna - Hartford, CT - May 2016 to Present

Description:

Worked as a part of Analytical Group and worked on development and designing of statistical models for the client. Coordinated with end users on designing and implementing data solutions as per project requirements.

Responsibilities:

·         Conducted research on development and designing of sample methodologies, and analyzed data for pricing of client's products.

·         Investigated market sizing, competitive analysis and positioning for product feasibility.

·         Worked on Business forecasting, segmentation analysis and Data mining.

·         Automated Diagnosis of Blood Loss during Emergencies.

·         Developed Machine Learning algorithm to diagnose blood loss.

·         Generated graphs and reports using gplot package in R-Studio for analytical models.

·         Developed and implemented R and Shiny application which showcases machine learning for business forecasting.

·         Developed predictive models using Decision Tree, Random Forest and Naïve Bayes.

·         Performed time series analysis using Tableau.

·         Collaborating with dev-ops teams for production deployment.

·         Worked in Amazon Web Services cloud computing environment.

·         Worked with Caffe Deep Learning Framework.

·         Developed various workbooks in Tableau from multiple data sources.

·         Created dashboards and visualizations using Tableau desktop.

·         Created dashboards in QuickView to visualize data.

·         Worked on R packages to interface with Caffe Deep Learning Framework.

·         Later used Alteryx to blend the data.

·         Performed analysis using JMP.

·         Perform validation on machine learning output from R.

·         Written connectors to extract data from databases.

·         Environment: R, Python, R Studio, Shiny Excel 2013, Amazon Web Services, Machine Learning, Tableau, Quick View, JMP, Segmentation analysis

 

Sr. Data Modeler/ Data Analyst

Johnson and Johnson – New Brunswick, New Jersey-April 2015 to March 2016

Responsibilities:

·         Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks

·         Programmed utilities in Python that uses packages like scipy, numpy, pandas. Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.

·         Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

·         Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.

·         Worked on Troubleshooting of test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models. Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.

·         Perform data reconciliation between integrated systems.

·         Metrics reporting, data mining and trends in helpdesk environment using Access

·         Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2

·         Extensively used MS Access to pull the data from various data bases and integrate the data.

·         Worked on SAS for Data Analysis.

·         Assisted in the oversight for compliance to the Enterprise Data Standards

·         Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data

·         Worked with Excel Pivot tables.

·         Created and Monitored workflows using workflow designer and workflow monitor.

·         Performed data management projects and fulfilling ad-hoc requests per user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL. Worked on Salesforce CRM tool to analyze the requirements of the customers.

·         Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.

·         Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

·         Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs

·         Analysis on Mainframe data to generate reports for business users.

·         Identify & record defects with required information for issue to be reproduced by development team.

Environment: PL/SQL, Business Objects XIR2, ETL Tools Informatica9.5/8.6/9.1 Oracle 11G, Teradata

V2R12/R13.10, Teradata SQL Assistant 12.0

Sr. Data Analyst/Data Modeler

WELLS FARGO - Charlotte, NC - January 2014 to March 2015

Responsibilities:

·         Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks

·         Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.

·         Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

·         Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.

·         Worked on Troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.

·         Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.

·         Perform data reconciliation between integrated systems.

·         Metrics reporting, data mining and trends in helpdesk environment using Access

·         Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2

·         Extensively used MS Access to pull the data from various data bases and integrate the data.

·         Worked on SAS for Data Analysis.

• Worked with the business in gathering requirements from the existing reporting tool.
• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• Working closely with business in creating dashboards based on the data from various Data sources.
• Worked as Tableau SME in migrating the dashboards from Excel reports and Business objects to Tableau Dashboards
• Created Tableau wireframes for various lines of business.
• Lead team of 3 tableau developers in assigning and coordinating the work to meet the quality and deadlines.
• Utilizing Tableau server to publish and share the reports with the business users.

·         Developing Tableau data visualization using Donut charts, Waterfall, Cross Map, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Dual axis, Triple axis, scorecards, dashboards using stack bars, scattered plots, Gantt charts and various other charts based on the business desired

·         Assisted in the oversight for compliance to the Enterprise Data Standards

·         Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server

·         2005 with high volume data

·         Worked with Excel Pivot tables.

·         Created and Monitored workflows using workflow designer and workflow monitor.

·         Performed data management projects and fulfilling ad-hoc requests per user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL. Worked on Salesforce CRM tool to analyze the requirements of the customers.

·         Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.

·         Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

·         Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs

·         Analysis on Mainframe data to generate reports for business users.

·         Identified & recorded defects with required information for issue to be reproduced by development team.

Environment: Tableau, SQL, Business Objects XIR2, ETL Tools Informatica 8.6/9.1 Oracle 11G, Teradata V2R12/ R13.10, Teradata SQL Assistant 12.0

 

Sr. Data Analyst /Data Modeler

PNC Bank - Pittsburgh, PA - January 2012 to December 2013

Responsibilities:

·         Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.

·         Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.

·         Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.

·         Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

·         Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.

·         Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.

·         Worked on Troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.

·         Responsible for different Data mapping activities from Source systems to Teradata

·         Created the test environment for Staging area, loading the Staging area with data from multiple sources. Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.

·         Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)

·         Executed campaign based on customer requirements

·         Followed company code standardization rule

·         Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed

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

·         Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases * Experience in creating UNIX scripts for file transfer and file manipulation.

·         Provide support to client with assessing how many virtual user licenses would be needed for performance testing.

·         Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.

·         Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Informatica 8.1, Data Flux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files,

Teradata

Jr Data Analyst

ICICI Bank - August 2010 to November 2011

Description:

ICICI Bank is a major banking and financial services organization in India. It is the 4th largest bank in India and the largest private sector bank in India by market capitalization. ICICI Bank is also the largest issuer of credit cards in India. ICICI Bank offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life and non-life insurance, venture capital and asset management.

Responsibilities:

·         Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).

·         Involved in extensive DATA validation using SQL queries and back-end testing

·         Used SQL for Querying the database in UNIX environment

·         Developed separate test cases for ETL process (Inbound & Outbound) and reporting* Involved with Design and Development team to implement the requirements.

·         Developed and Performed execution of Test Scripts manually to verify the expected results

·         Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation, Involved in Manual and Automated testing using QTP and Quality Center.

·         Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).

·         Defects tracking, review, analyzes and compares results using Quality Center.

·         Participated in the MR/CR review meetings to resolve the issues.

Jr SQL Developer

Conserve InfoTech - Pune, Maharashtra - August 2008 to July 2010

Roles and Responsibilities:

·         Studying the Business Requirements Design (BRD) for the enhancements/Physical Data Model changes raised by the business.

·         Performance tuning, SQL query enhancements, code enhancements to achieve performance targets using Explain Plans.

·         Graphical representation of the reports using MS Power Point Presentation and MS Excel Charts.

·         Allocation and monitoring of work to the project team members.

·         Unit, Integration and User Acceptance testing.

·         Aiding the Extraction and Reporting team.

Environment: Oracle, Toad, MS Excel, PowerPoint