SUMMARY

• An Informatica Consultant having more than 13 years of experience in Design, Development and Implementation of Database Architecture. Extensive experience in integration between different systems for Data warehouses and Reporting needs using ETL application packages. Experience using informatica client and Power BI and architecting the solutions related to the Data integrations and Reporting needs
• Extensive experience in Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation
• Experience in Data Warehouse development working with Data Conversion, and Extraction/ Transformation/ Loading ( ETL) using Informatica PowerCenter with Oracle, SQL Server,DB2,TeraData and Flat files.
• Worked with various Power Center/Power Mart components like Informatica Server and Client tools like Designer, Workflow Manager, and Repository Manager & Workflow Monitor
• Experience creating the reports/dashboards, report models, using DAX queries in Power BI Desktop
• Experience setting up security roles and Power BI apps for a collaborative workspace in Power BI web
• Experience working with the Power BI Gateway services
• Experience in Forward/Reverse engineering using Erwin
• Experience in integration of various data sources like Oracle, SQL Server and DB2 into the Staging Area
• Strong experience with star and snowflake schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions
• Involved in Informatica Performance tuning of the ETL process
• Extensive experience in designing the architecture for Extract, Transform, Load environment and development of mappings and process using Informatica Power Center
• Experience in Trouble shooting mappings and Workflows
• Extensive experience in technical architecture, data modeling, proof of concept, requirement gathering, system analysis, testing and development of decision support systems
• Strong Analytical and problem solving abilities
• Experience in working with Tableau to create reports and dashboards

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.0.1/8.6.1/7.1 , SSIS,DataStage

Informatica Tools: Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor

Languages: SQL, PL/SQL,VB, Java, C, C++, COBOL,HTML

OLAP Tools: Business Objects XI 3.1, Hyperion, Cognos Power Play, Actuate

Visualization Tools: Power BI/Tableau

Database Modeling: Erwin 3.5/4.0

RDBMS: DB2, MS - Access, Oracle8i/9i/10g, Essbase, SQL Server 6.0/7.0

Operating Systems: Windows'98/NT, MS-DOS, UNIX, Windows 2000, 2003, XP,Windows 7, HP-UX-11i

Big Data: Hadoop frame work, Hive, MapR

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL consultant/Architect

Responsibilities:

• Created a mapping document, depicting the data load strategy, schedules and type of loads
• Responsible to remediate the Informatica code that loaded the data to Netezza to comply with Oracle database data types and procedures
• Created / modified the Unix and Python scripts
• Enhanced the data load model by creating oracle tables to generate the parameter files dynamically
• Created Informatica Mappings and Workflows for the one time data loads from Netezza to Oracle
• Created procedure to snapshot the tables between schemas for the downstream access
• Worked closely with the upstream and downstream dependent apps to cutover smoothly
• Configured Unix SSH keys between the servers for SFTP
• Was responsible to create Jira Epics and stories and assign them to the resources
• Was part of several Program Increments to help size the stories and create epics for the PI planning and also sprint planning

Environment: Informatica PowerCenter 10.2,Netezza, Oracle 12c, Exadata, Unix, Python, HDFS, SQL Loader, Flat files, Oracle Developer, PL/SQL .

Confidential, Charlotte, NC

Technology Lead/Architect

Responsibilities:

• Working closely with the architecture team to understand the data model and the associated attributes and dependencies
• Responsible for Data Analysis and grouping the attributes to various subject areas
• Developed data mapping spreadsheet/specification to present the transformation process that needs to be converted to Informatica Mappings
• Manage a team of 8 and also be a part of the development and Testing activities to validate the Data Quality and Data Consistency
• Involved in the development/ optimization of the Informatica mappings and the workflows
• Created various curated views for the Business to test the data while the development is in progress

Environment: Informatica PowerCenter 9.5.1,Hive,MapR,HDFS(Big Data),Oracle 10g,SQL Server, Flat files, Unix.

Confidential

Technology Lead/Architect

Responsibilities:

• Working closely with the business to architect the data model and develop the data model for a high performance data integration
• Worked on Integrating the complex organization source systems to Oracle/SQL server using Informatica Power Center
• Created Power BI reports for the Users and Trained users on how to create vizualizations
• Created Power BI apps and set up the workspaces for a collaborative work in each business arena
• Re-written the COGNOS cubes to the power BI reports and architected the solution for the same
• Working with the Informatica PowerCenter Client tools to create complex Transformations, mappings and workflows and schedule them accordingly
• Duties include coordination, attending meetings, and the review of requirements,task assignments and code reviews
• Developed data mapping spreadsheet/specification to present the transformation process
• As a technology lead responsible for the deliveries and time management of 4 resources under me
• Developed Data Models/ ETL Specification documents, Unit test documents and mapping documents to implement the extract, transform and load the data using Informatica transformations.

Environment: Microsoft Power BI, Informatica PowerCenter 9.5.1,TOAD for Oracle, Oracle 11g/12c, SQL Server,Flat files, DB2 Windows 7, Azure cloud

Confidential

Technology Lead

Responsibilities:

• Working closely with the architects to understand and develop the data model for a high performance data integration
• Working as a Lead/Offshore coordinator to collate the tasks and updates from the business and deliver the tasks with high quality
• Integrated a sample POC to be used for rest of the Informatica objects to capture the audit data to an Oracle table and also to schedule the flow using Informatica scheduler
• Responsible for on-time deliveries for the tasks assigned to off shore team
• Working with the Informatica Power Center Client tools to create complex Transformations, mappings and workflows and schedule them accordingly
• Duties include coordination, attending meetings, and the review of requirements, task assignments and code reviews
• Developed data mapping spreadsheet/specification to present the transformation process
• Analyze the Existing mappings of SSIS and convert them to the Informatica equalent logic/mapping
• As a technology lead responsible for the deliveries and time management of 4 resources under me
• Developed ETL Specification documents, Unit test documents and mapping documents to implement the extract, transform and load the data using Informatica transformations.
• Responsible for documenting and completing unit test cases and check lists also maintain migration checklists to ensure complete and accurate migration to various environments
• Creating reports and dashboards in Tableau

Environment: Informatica PowerCenter 9.5.1, Tableau, SSIS,OBIEE 11g, TOAD for Oracle, Oracle 10g, Windows NT v 6.1.

Confidential

Technology Lead

Responsibilities:

• Worked as a Lead/Offshore coordinator to collate the tasks and updates from the business and delivered the tasks with high quality
• Lead a team of 4 people by helping them technically in their tasks and also been an individual contributor
• Duties included coordination, attending meetings, and the review of requirements, infrastructure setup, task assignments and code reviews
• Development of mappings to integrate the customer related data and populate to the database
• Applied performance tuning on mappings to improve system performance. Tuned performance of Informatica sessions for large data files by increasing Index Cache size, data cache size
• Applied partitions and hints on the complex SQL queries to enhance the execution time

Environment: Informatica PowerCenter 9,TOAD for Oracle,Flat files, Oracle 10g, Windows 7