Data Warehouse specialist
Resume:
Jaimini Patel
Email: adhyl1@r.postjobfree.com
Los Angeles, CA, USA (H1b Work Permit)
Mobile: +1-323-***-**** Qualification: B.E (IT) Mumbai university
Professional overview
•Experience in Business Intelligence with a strong background in Analyzing, Designing, Developing, Testing and Implementation of Data warehousing/Data Hub applications in verticals such as Health Care, Insurance, Banking and Telecommunication.
•Experience as a Scrum Master role (Team of 5 members).
•Experience in defining project scope, requirements gathering from business users and system design (functional and technical specifications).
•Expert in understanding the data and designing/implementing the enterprise data hub.
•Experience in Data Quality, Data Modeling, Star/Snowflake schema modeling, Fact and Dimension Tables, Physical and Logical data modeling using Erwin Data modeling tool.
•Designed and Developed business rules to generate consolidated data using informatica data quality tool
•Extensive experience in using Informatica Power Center 10.1/9.6/9.1//8.6.1/8.5/8.1/, Informatica Cloud, Informatica B2B.
•Experience in designing/developing complex mapping using transformations Connected and Unconnected Lookup, Source Qualifier, Joiner, Expression, Filter, Sorter, Aggregator, Router, Update Strategy, Stored Procedure, Sequence generator, Re-usable transformations.
•Proficient in the integration of various data sources involving multiple relational databases like Oracle11g/10g/9i, MS SQL Server, DB2, XML Files, Flat Files (fixed width, delimited), Unstructured files into the staging area of Data Hub
•Experience in Scheduling tools like Control – M and Autosys.
•Experience in other tools like Git, Bitbucket, SQL * PLUS, TOAD, PL/SQL Developer and Putty, SVN (Configuration).
•Experience in identifying performance bottlenecks and tuning of Informatica sources, targets, mappings, Transformations, and sessions for better performance.
•Experience in providing 24/7 Production Support.
Technical Skills
Data Warehousing
Informatica Power Center 10.1/9.5/8.6.1/8.5/8.1, Informatica PowerExchange 9.5.1, 10.1, Informatica Cloud, Informatica B2B
Dimensional-Data Modeling
Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling
Databases
Oracle 11g/10g/9i/8i, Microsoft SQL Server
Shell Scripting
Unix Shell Scripting.
Other tools
SQL * PLUS, TOAD, PL/SQL Developed, Greenplum and Putty
Operating Systems
WINDOWS 95/98, WINDOWS- NT/2000/XP Professional, MS-DOS, UNIX
Project Experience
Farmers Insurance Aug ’19 – Till date
Datawarehouse Specialist
Projects Handled:
Project Title : Guidewire claim center
Competencies:
ETL Tools : Informatica 10.x
RDBMS : Oracle developer
Fair Knowledge: UNIX shell scripting
Scheduler tool: Autosys
Others: GIT,Bitbucket,Jira,Agile
Responsibilities:
End to End automation created for QA team to run the flow with just few clicks using Unix scripting.
Involved in gathering, analyzing and documenting business requirements and functional requirements and data specifications from users and transformed them into technical specifications.
Extensively written complex SQL’s to extract data from source’s and load into the target tables.
Experience in creating/maintaining scheduler tools like Autosys.
Troubleshooted the mappings using the Debugger and improved the data loading efficiency using Sql-overrides and Look-up Sql overrides.
Automated a process to connect to mainframe Db2 System.
Based on the requirements, used various transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator and Joiner in the mapping.
Working on Performance tuning of the code
Working with SME and Business, creating profiling reports to help business to understand the Data.
Involved in Code reviews.
Developed Unit test plans for every mapping developed and executed the test plans.
Effectively involved in onsite/offshore model.
Kaiser Permanente March ’19 – Aug’19
Sr. Informatica Developer/Lead
Projects Handled:
Project Title : SAM Reporting
Competencies:
ETL Tools : Informatica 10.x
RDBMS : Microsoft SQL server
Fair Knowledge: UNIX shell scripting
Scheduler tool: Informatica Monitor
Others: GIT,Bitbucket,Jira,Agile
Responsibilities:
Involved in gathering, analyzing and documenting business requirements and functional requirements and data specifications from users and transformed them into technical specifications.
Extensively written complex SQL’s to extract data from source’s and load into the target tables.
Experience in creating/maintaining scheduler tools.
Involved in migration of the mappings and sessions from development repository to production repository and provided 24/7 production support.
Practiced agile methodology while strategizing and implementing solutions
Involved in Code reviews.
Developed Unit test plans for every mapping developed and executed the test plans.
Extracted data from various sources like flat files, salesforce,Xml data.
Whole and sole responsible for whole project in terms of ETL duties.
JP Morgan & Chase July ’15 – Feb’19
Sr. Informatica Developer
Projects Handled:
Project Title :Paymentech
Competencies:
ETL Tools : Informatica 10.x,9.x.
RDBMS : SQL,PL/SQL,Toad.,Oracle 11g
Fair Knowledge: UNIX shell scripting
Scheduler tool: Control-M
Others: GIT,Bitbucket,Jira,Agile,Mks
Responsibilities:
Involved in gathering, analyzing and documenting business requirements and functional requirements and data specifications from users and transformed them in to technical specifications.
Working as a Scrum master in Agile team as well as a developer.
Worked on project of merchants on-boarding in which developed a system which was near real time in Powercenter.
Extracted data from various sources like flat files, XML files, oracle and loaded into tables.
Created Web Services mappings for consumer and provider, used web service consumer transformation, XML parser to parse the incoming data
Based on the requirements, used various transformations like Source Qualifier, Expression, Filter, B2B, Router, Update strategy, Sorter, Lookup, Aggregator and Joiner in the mapping.
Worked with Informatica B2b Data Exchange that allows to support the expanding diversity of customer and their partners and their data with capabilities that surpass the usual B2B solutions
Worked with B2B Operation Console to create the partners, configure the partner management, Event monitors and Event
Understanding and Working knowledge of Informatica PowerExchange CDC. Experienced with Informatica Sql Server CDC for retrieving data in real time.
Troubleshooted the mappings using the Debugger and improved the data loading efficiency using Sql-overrides and Look-up Sql overrides.
Developed SCD I and SCD type II mappings using MD5 logic. Implemented incremental loads, Change Data capture and Incremental Aggregation.
Identified performance bottlenecks and Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
Re-usable transformations and mapplets are built whenever necessary,
Created UNIX shell scripts to encrypt and decrypt the files, move the files, archive the files and split the files.
Developed UNIX Shell Scripts and SQLs to get data from Oracle tables.
Optimized query performance and populated test data.
Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
Extensively written complex SQL’s to extract data from source’s and load into the target tables.
Experience in creating/maintaining scheduler tools like control-M.
Involved in migration of the mappings and sessions from development repository to production repository and provided 24/7 production support.
Practiced agile methodology while strategizing and implementing solutions
Involved in Code reviews.
Developed Unit test plans for every mapping developed and executed the test plans.
Effectively involved in onsite/offshore model.
Accenture Systems Ltd. April ’13 – June’15
Sr. Informatica Developer
1) Projects Handled:
Project Title : Affinity
Client : WholesFood
Competencies:
ETL Tools : Informatica cloud.
RDBMS : SQL,PL/SQL.Oracle 8i
Fair Knowledge: UNIX shell scripting
Scheduler: Autosys – Jils
Others : WINDOWS 95/98, WINDOWS- NT/2000/XP Professional
Responsibilities:
Doing POC in the Informatics cloud as it is a new technology. Knowing the Architecture of the project and replace the existing application which is
Already running i.e. jitter bit with Informatica cloud. Doing real-time jobs for Customers. Working on webservices, Jason, xml files.
Development was done from scratch which Includes integration between Salesforce and smarbutton.
Extensively written complex SQL’s to extract data from source’s and load into the target tables.
Experience in creating/maintaining scheduler tools like autosys.
Involved in migration of the mappings and sessions from development repository to production
repository and provided 24/7 production support.
Extensive experience in using Informatica Power Center 10.1/9.6/9.1//8.6.1/8.5/8.1/ Power Exchange, Informatica Cloud, Informatica B2B.
Experience in designing/developing complex mapping using transformations Connected and Unconnected Lookup, Source Qualifier, Joiner, Expression, Filter, Sorter, Aggregator, Router, Update Strategy, Stored Procedure, Sequence generator, Re-usable transformations.
Created Database Tables and database views.
2) Projects Handled:
Project Title : GFA (COBRA)
Client : Nomura.
Competencies:
ETL Tools: Informatica 9.1.0,
RDBMS: DB Artisan
Scheduler: Autosys
Others : Unix Shell Scripting.
Responsibilities:
Developing full Pnl module for COBRA users. (This project was all about reconcillation of the data)
Work on detailed unit, integration testing, and regression testing and also
doing releasing of the object in production.
Extensively written complex SQL’s to extract data from source’s and load into the target tables.
Experience in creating/maintaining scheduler tools like autosys.
Involved in migration of the mappings and sessions from development repository to production repository and provided 24/7 production support.
Patni Computers May ’10 – March ‘13
1)Projects Handled:
Project Title : Batelco
Client : Bahrain Telecommunications Company
Competencies:
ETL Tools: Informatica 9.1.0,
RDBMS: DB Artisan,GreenPlum, SQL * PLUS
Others: Unix,
Description:
The Batelco Group, listed on the Bahrain Bourse {Bahrain Telecommunications Company (BATELCO)}, operates across seven markets in the Middle East, North Africa and India. The Batelco Group serves the consumer, corporate and wholesale markets in Bahrain and also delivers cutting-edge fixed and wireless telecommunication services to its customers.
Project is to create all the modules and generate Reports for all the account.
Roles and Responsibilities:
Develop Informatica Mappings, Sessions and Workflows and test them for their functionality.
Worked on the Data Transformation for unstructure File formate.
Do the detailed unit and integration testing.
Preparing ETL design doc,HLD,LLD,test cases,UTP and Data model doc.
Developed Stored Procedures, Triggers, and created indexes.
Created Database Tables and database views.
2)Projects Handled:
Project Title : Motorola EIM (Order Management)
Client : Motorola MFG
Competencies:
ETL Tools and DB : Informatica 9,Informatica 6.1 Oracle 9i, UNIX.
The Customer, Motorola is one of the leading Mobile handsets and other electronic equipment. Manufacturers. Motorola has an Order Management ERP application which maintains details of all the orders placed till its end delivery. The key objective of Order Management Datawarehouse Project was to extract data from these various data sources (ERP and COF) and load them into a unified database for reporting and other purposes. This database is an Oracle 9i Database.
Roles and Responsibilities:
Develop Informatica Mappings, Sessions and Workflows and test them for their functionality.
Schedule the workflows using Informatica Scheduler / UNIX Cron Scheduler.
Do the detailed unit and integration testing.
Monitoring the Daily ETL loads during the Testing Phases.
Testing individual modules of the software against the Unit test cases.
Doing System Integration testing of the software against System Integration Test Cases.
3)Projects Handled:
Project Title : PGS CSBI Project
Client : GE Energy
Competencies:
Environment : Informatica 8.6.1, Informatica 9.1,Oracle 10g, Oracle 9i,UNIX.
GE Energy Contractual Services is a leading provider of creative, maintenance, operation, and availability and performance services to create a business partnership that gives owners a competitive advantage. Contractual performance is a key influence in driving high plant operating output capability, high efficiency, high plant reliability and availability.
As part of the Contractual Services Data warehouse (CSDWH) project there is a requirement to maintain existing ETL/Reports and to work on enhancements of the existing ETL/Reports as well as creation of new ETL/Reports using Informatica as the ETL tool and Cognos as the reporting tool.
Role/Responsibilities :
Designer, Developer/Tester and CM(Configuration manager).
Design mappings sessions and workflows for extracting data from relational sources, flat files.
Preparing ETL design doc,HLD,LLD,test cases,UTP and Data model doc .
Unit test and fix the mappings for optimal results.
Developing & review of SQL scripts, mappings
Data analysis of Source, Target systems from ETL perspective as per Design docs.
Performance tuning in Informatica and Oracle.
Involved in code migration and deployment activities.
4)Projects Handled:
Project Title : Customer Reporting and Analytics Fixes
Client : GE Aviation
Competencies:
Environment: Informatica 8.1, Oracle 10g,UNIX.
Description:
The customer, GE - Aviation is the world's leading producer of large and small jet engines for commercial and military aircraft.GAMS stands for Global Application Maintenance and Support. This is a horizontal spanning across sub businesses of GE TI & GE EI to support different applications for these sub businesses.
Role/Responsibilities :
Developer/Tester.
Preparing LLD & test cases.
Unit testing.
Develop & review of SQL for the test cases.
Data analysis of Source, Target systems from ETL perspective as per Design docs.
Monitoring the loads.
Worked on GMR’s.
Creating test data, executing test cases.
Repeating the individual modules and integration testing cycles after bug fixes.
Contact this candidate