PROFESSIONAL SUMMARY:

• Extensive work experience in Requirement Gathering, Data Warehousing and Data Analytics projects with INFORMATICA Power Center 9.X technology / Informatica Data Quality tool, Tableau and Spotfire visualization tool.
• Good experience with SQL Server, queries, business intelligence and working with end users.
• Worked in projects on Prediction, Regression and Machine Learning using R and Excel.
• Have good Knowledge of Data warehousing and Business Intelligence (DWBI) concepts.
• Worked on Report Generation on Spotfire and Tableau 10.X.
• Experience in translating Business and Functional requirements into logical and physical data models that follow industry best practices and company standards.
• Good knowledge on Oracle BI Analytics - Banking and Industrial Business domain.
• Excellent working experience in Data Warehouse applications, directly responsible for the Extraction, Transformation and Loading (ETL Informatica) of data from multiple sources into Data Warehouse.
• Experience in developing and troubleshooting of ETL mappings and Visualization by Data Visualization using Oracle DV .
• Followed Agile Methodology and familiarty with Jira and Rally .
• Expertise in designing and developing Slowly Changing Dimensions of all types.
• Excellent capability to explore, learn and understand newer business domains and technology.
• Experienced in environments requiring direct Customer interaction during specifications, development and project implementation phases like Design, Development, Testing, and Deployment

SKILL:

Informatica

Data Analysis

SQL

Oracle

TECHNICAL SKILLS:

INFORMATICA Power Center 9.x

INFORMATICA IDQ

Informatics DVO (Data Validation Option)

Oracle 10g

Data Mapping

Linux

Agile

GitHub

Cloud

ESP

Tableau 10 XX

Data Analysis

Data Quality

SQL Server

Spotfire

Google Analytics

My Sql

Unix

Data Analysis (with R and excel)

NLP (Natural language processing)

EXPERIENCE:

ETL Analyst

Confidential, Ohio

Responsibilities:

• Worked on Informatica Power Center / Data Quality 10.2 to find missing values, Data profiling and quality analysis of data.
• Experience in translating business and functional requirements into logical and physical data models that follow industry best practices and company standards using Erwin.
• Worked on Data Modelling using Erwin.
• Using Unix/Linux environment to put file which is required for processing.
• Experience on Data Profiling using IDQ Analyst.
• Prepared Business requirements documents and employs various business analysis techniques.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users.
• Extensively worked on Data Migration.
• Scheduled and facilitated requirements walk through meetings with Business.
• Created High level technical design documents.
• Oracle SQL query for data validation and also sanity check.
• Worked on Data Mapping
• Involve into Data Analysis and Data Profiling with Business user.
• Used Informatica Designer to create mappings using different transformations to move data to Oracle Data Warehouse.
• Developed complex mappings in Informatica to load the data from various sources into the Oracle Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Responsible for creating different workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.

Confidential, Ohio

Data Analyst

Resposiblities:

• Geting touch with Bussiness owner and understand their various requirment from their end and try to match with our requirment for batter result.
• Creating workflow for Data Ingetion.
• Understand the Functional requirement and fetch the required data from erp systems which can bring good Insight for bussiness decision’s.
• Creating Visualization in Tableau 10.X and helping team to create batter insight.
• Using Unix/Linux environment to put file which is required for processing.
• Used Confluence and Github page for documentation.

Confidential

Data Analyst

Responsibilities:

• Gather the requirements from the business, Data analysis and Reporting, Involved in Data profiling.
• Experience with creating the Data Sources, files, data blending, data joining sets, grouping and various table and aggregate calculations.
• Experience in Handling Multiple data tables in Analysis.
• Experience in Writing Complex SQL Queries.
• Oracle SQL query for data validation and also sanity check.
• Experience in enhancing the visualizations using Custom expressions.

Environment: Oracle SRM, ODI, Tableau, MySQL Database

Confidential

BI Analyst / ETL Analyst

Responsibilities:

• Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin.
• Worked on Informatica Data Quality to find missing values, Data profiling and quality analysis of data.
• Experience in translating business and functional requirements into logical and physical data models that follow industry best practices and company standards using Erwin.
• Worked on Data Modelling using Erwin.
• Experience on INFORMATICA Power Center 9.X technology.
• Worked on Data Mapping
• Prepared Business requirements documents and employs various business analysis techniques.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users.
• Extensively worked on Data Migration.
• Using Unix/Linux environment to put file which is required for processing.
• Used Confluence and Github page for documentation.
• Oracle SQL query for data validation and also sanity check.
• Scheduled and facilitated requirements walk through meetings with Business.
• Created High level technical design documents.
• Involve into Data Analysis and Data Profiling with Business user.
• Used Informatica Designer to create mappings using different transformations to move data to Oracle Data Warehouse.
• Developed complex mappings in Informatica to load the data from various sources into the Oracle Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.

Environment: Informatica 9.6, SQL SERVER

Confidential

Sr. Software Engineer

Environment: Informatica 9.6, Oracle 10g.

Responsibilities:

• Worked on Data Modelling using Erwin.
• Worked on Source to Target mapping using INFORMATICA Power Center 9.X technology
• Worked on Data Profiling.
• Confidential Healthcare data also needs to loaded and manipulation.
• Responsible for Requirement Gathering from Client, and Estimation and Analysis of requirement for development and Data analysis.
• Responsible for design & development.
• Responsible for QA testing and signoff from client.
• Responsible for development and review.
• Responsible for production deployment.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.

Confidential

Sr. Software Engineer

Responsibilities:

• Understand & analyze the business model and customer requirements.
• Worked on Source to Target mapping using INFORMATICA Power Center 9.X technology
• Responsible for preparing technical specifications from the business requirements.
• Involved with BA to from requirement gather to Report Development.
• End to End Report Generation using Spotfire using Database.
• Worked on Visualization creating Interactive dashboard with Spotfire.
• Responsible for design and development of simple and complex ETL Mappings using Informatica.
• Involved in basic performance tuning of the mappings.
• Designing, Modifying & Testing of Informatica mappings to meet the current data requirements.
• Fixing loading issues during the production load.
• Involved in unit and system testing and deployment of the code into Production.
• Prepared low-level design documents.
• Involved in testing and preparation of unit test cases.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.

Environment: Informatica 9.6, SQL SERVER

Confidential

Sr. Software Engineer

Responsibilities:

• Understand & Analyze the TDD (Technical Design Document)
• Analyzing design documents and feasibility checking for development
• Developed complex mappings
• Worked on Source to Target mapping using INFORMATICA Power Center 9.X technology .
• Using Unix/Linux environment to put file which is required for processing.
• Used Confluence and Github page for documentation.
• Created reusable transformations like Expression and Lookup
• Extensively used transformations like Lookup, Filter, Aggregator, Sorter, Joiner transformations etc.
• Prepared Unit Test Cases
• Provided a detailed documentation for the release
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.

Environment: Informatica 9.6, SQL SERVER