Sign in

Data Analyst Manager

Kansas City, MO
February 19, 2020

Contact this candidate



To work in a stimulating and challenging milieu that would facilitate the maximum utilization and application of my broad skills and expertise in making a positive difference to the organization


Around 8 years of Business Discovery, Data Discovery & Analysis, Data Modeling, ETL Design, Development, Testing, Implementation and Troubleshooting in the field of Data warehousing and Application Development.

8 Years of strong Datawarehousing experience specializing in RDBMS, ETL Concepts, Strategy, Design & Architecting, Informatica Administration, Development & Testing.

An expert in the ETL Tool Informatica which includes components like PowerCenter, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administration Console, PowerExchange CDC, Informatica Intelligent cloud Services.

Considerable knowledge in Informatica Intelligent Cloud Services includes component like Data Integration, Administrator, Application Integration and Monitor.

Have had extensive experience in working with various PowerCenter Transformations using Designer Tool. Have handled various Data Sources like DB2, Oracle, SQL Server, MS Access, MS Excel including MF COBOL EBCDIC Files, Flat Files and XML Files.

Have had extensive experience working with SQL Server Integration Services (SSIS) and databases like IBM UDB DB2, Oracle and MS SQL Server, mainframe IMS and mainframe VSAM

Was involved in the complete life cycle of quite a few Datawarehouse implementations which include System Architecture, Functional/Technical Design, Development - Coding and Testing (Unit Testing, System Integration Testing and User Acceptance Testing) and Implementation.

Good experience in Unix Shell Scripting and ETL Process Automation using Shell Programming and Informatica. Also have had quite good experience in Performance Tuning at both Database Level and Informatica.

Good experience in physical/logical data modelling using Erwin

Good experience in various Industry verticals like Finance, Insurance, Railroad Transportation with appropriate DW/ETL Implementations.

Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.

Strong Team building and mentoring skills and excellent Team leadership capability.

Very good knowledge in working with Windows and UNIX operating systems.

Experience in ORACLE/SQL Server/Informatica performance tuning techniques.

Designing multi-dimensional modeling for data warehouse applications.

Proficiency in Oracle PL/SQL. Hands-on in creation of stored procedures and custom SQL to define ETL processes

Played various roles like Data Analyst, BI Data Integration Specialist - Products, Defect prevention Representative, Software quality Analyst and Team lead.

Played various roles on Projects that required Datawarehouse Consulting which include Datawarehouse ETL Architect, Program Technical Lead, and Project/Team Lead/Managerial roles with a maximum project team size of 10 Consultants.


Data Warehousing Technologies

Extract Transform Load & Reporting

ETL Tools

Informatica Power Center 10.x/ 9.x/8.6

Informatica Intelligent Cloud Services

SQL Server Integration Services

Reporting Tools

Power BI, SQL Server Analysis Services,

MS Excel

Programming Language


Scripting Language

Unix Shell Scripting, Python


Oracle, SQL Server, SQL Azure

Operating System

MS-DOS, Linux, UNIX, Windows

Current Employer-

Company Name:

CloudMoyo Pvt. Ltd


Team Lead/ Data Analyst/ BI Data Integration Specialist

Start Date:

3rd April 2017

End Date:

Currently Working

Roles & Responsibilities:

As a Team Lead/ Data Analyst:

Played the role of a Program Team Lead/Data Analyst and was responsible for designing the ETL Strategy & Technical Design of the Project.

Was responsible in managing tasks and deadlines for the ETL teams.

Was the point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues.

To get the Functional Requirement Specifications from customer, creating Technical specifications and understand the same.

Understand the RailRoad Transportation and Financial Domain functionality.

Was involved in training the customer and Offshore Team on Cloud technology tool- Informatica Intelligent Cloud Services.

Break up the work into task list and estimate based on simple, medium and complex methodology

Interaction with business users and requirement gathering.

High level & low-level ETL flow design

Involved in detailed technical design

Give functional KT to the QA team.

Was involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.

Organize daily technical discussions with the Onsite team also including the individual offshore workstream leads and set expectations for Offshore delivery.

As a BI Data Integration Specialist:

Create mappings employing various transformations, filters, joiners, lookup, SQL overrides, normalizers etc. to load data from multiple databases/source systems into Warehouses.

Maintaining slowly changing dimensions for all three types in the ETL for historical and incremental data set.

Creation of Sessions and Workflows to schedule these mappings.

Set-up Integration of Informatica Power Center and SQL Server Integration Services.

Creation of Unit Test cases and Integration test cases

Perform unit testing of these Workflows from source to staging and staging to Warehouse of data warehouse

Reconciliation and evidence creation.

Analysis & fix on QA defects made by QA team.

Involved in Unit testing and UAT defect fixing.

Was involved in SFTP connection set-up and shell script testing.

Was involved in coordinating with the Networking & Business Firewall teams in resolving connectivity issues with the Source Systems.

Involved in sessions partitioning and mappings performance tuning.

QA & Production deployment.

Creation of stored procedures to associate SSIS package integrations.

Previous Employer-

Company Name:

Saama Technologies Pvt. Ltd.


Consultant/Acting Lead/ETL Developer

Start Date:

23rd January 2012

End Date:

31st March 2017

Roles & Responsibilities:

As a Acting Lead/Consultant-

Interacting with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

Requirement gathering and requirement Analysis.

Giving the inputs & sharing the knowledge with other team members.

Played the role of a Project coordinator between various work streams within the project and create Unit Test and Integration Test Plans.

Organize daily technical discussions with the Onsite team also including the individual offshore work stream leads and set expectations for offshore delivery.

Provide Daily and Weekly Status Updates to the Project Manager and the Engagement Manager.

Was responsible in performing Integrating Migrated code and performing Integration Tests from Offshore and publish Test results to the onsite team.

As a ETL Developer-

High level and low level ETL design.

Interacting with the client on various forums to clarify any queries regarding the functionality and appropriate access required etc.

Had used IDE - Informatica Data Explorer to profile Customer, Policy & Claim information for faster data analysis.

Understand the Insurance domain functionality.

Was responsible for the Configuration Management and Code Migration between various environments using Informatica with Release Management and Versioning.

Was involved in coordinating with the Networking & Business Firewall teams in resolving connectivity issues with the Source Systems.

Had implemented Fraud Claim Identifier - FCI logic to uniquely identify people and be able to obtain a 360 degree view of every person who’s claim falling in the Fraud category with historical data sets and legal details.

Was involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.

Was involved in loading data to Oracle by using informatica external load.

Create reconciliation reports using Unix Shell scripting and integrated same to Informatica Power Center.

Extracted COBOL source definitions.

Validated user ID\'s for both FTP & UNIX in all 3 environments and created appropriate folders. Ftp’d source files into appropriate folder.


B.E with specialization in Computer Science from RGPV University in 2011 with 70%

Intermediate (12th) in PCM from CBSE in 2006 with 62%

High School (10th) from CBSE in 2004 with 67%


I, hereby declare that all the information furnished here is correct to the best of my knowledge and belief.

(Lav Khare)


Mobile: +1-571-***-****


Contact this candidate