SUMMARY:

• Informatica Certified: PowerCenter Data Integration 9.x:Developer Specialist
• Oracle Certified: OracleDatabase Administrator Certified Associate
• 15+ years of experience in software requirements, design, development, maintenance and Production Support
• 10+ years of experience in Data Warehousing and Business Intelligence using Informatica Power Center, InformaticaPowerExchange, SalesForce APIs, hands on experience with Microsoft SSIS
• Exposure to Bigdata, Hadoop, HDFS Architecture, MapReduce, Sqoop, Oozie, Hive, HBase, Pig
• Exposure toTalendstudio 6.3
• Extensively used SQL and PL/SQL to write stored procedures, functions, packages, triggersand CDC Implementations
• Experienced in developing PL/SQL packages, Procedures, Functions, SQL scripts and DatabaseTriggers
• Oracle Apps (R11) expertise (Oracle Incentive Compensation module)
• Managed and executed all phases of a data warehouse project life cycle that includes requirements gathering, architecting, design, development, Implementation, QA, end - to-end it solutions in DW,OLAP&BI space
• Experience in Agile,(Iterative Model), kanban, CMMI level standards andUNIX Shell scripting
• Experience in star, snow flake schema designand de-normalization techniques

TECHNICAL SKILLS:

ETL: InformaticaPowerCenter 10.2/10.1/9.6/9.1/8.6 , InformaticaPowerExchange for SalesForce, Apex Loader, Informatica Cloud Data Loader for Salesforce, Microsoft SSIS

Databases: HPE Vertica 8.1, Oracle 12c/11g, Exadata, Teradata 14.10, MongoDB 3.2, SQL Server2012

Operating Systems: LINUX, UNIX (SUN Solaris, SUN OS, HP9000, HPUX), Windows 8/7/XP, Open VMS

Languages: SQL, PL/SQL, Java2, UNIX Shell Scripting, HTML, XML, Perl, Java Script

Operating Systems: LINUX, UNIX (SUN Solaris, SUN OS, HP9000, HPUX), Windows 8/7/XP, Open VMS

Application Servers: Oracle iAS 10g/9i, Netscape iPlanet, BEA WebLogic Server 7.0

Data Modeling: ERWin 9.2, Oracle Designer

Methodologies: Star Schema, Snow Flake Schema, Fact and Dimension Tables

Tools: SQL Developer,SQL*Loader, SQL Navigator, Toad, Splunk, Oracle Warehouse Builder, Oracle Developer, Designer, Discoverer, Oracle BIS 11i, Oracle Express, PRO*C, SQL*Loader, Oracle AQ, Visio, CONTROL-M, Sentry, AUTOSYS, MOVEIT, Active Batch V9, SQL Server Agent Job Scheduler, Borland Star Team 2008, Python

WORK EXPERIENCE:

Confidential

Senior Data warehousing Consultant

Responsibilities:

• Map Confidential brokerage and managed portfolios to Schwab existing FC model of assignments
• Migrate Confidential member and wealth managers info into Retail Sales Force using CAT, O2 and Pogo interfaces
• Create generic framework to use for further migrations/acquisitions

Environment: Informatica Power Center 10.2, Oracle 12c, Sales Force, JIRA, Confluence and Unix.

Confidential

IT Lead

Responsibilities:

• Product enhancement and customizations
• Integration with other ordering and engineering systems for satellite
• Develop and maintain the interfacing xml based system connectors
• Created code for IFS Event handling
• Performance tuning of different interfaces

Environment: Oracle 12c, XML, IFS, Agile, Velocity (Aerospace softwares), SoapUI, ProSource and Unix

Confidential

Data warehousing Lead Consultant

Responsibilities:

• Understanding the existing Mule flows and business logic behind the implementation
• Data modelling and design of sources, intermediate tables and target tables
• Create design document in confluence for each flow with requirements and test conditions
• Implemented complex Informatica mappings, sessions, worklets and workflows for each Mule flow and associated data migrated from Teradata and Salesforce to target systems.
• Created worklets to implement failover strategy for lookup data extraction from SalesForce
• Extract data from Oracle and Teradata source and perform upserts to objects of different orgs in Sales Force
• Unix scripting
• Used Splunk to query and view Mule run logs
• Designed data flows and got coded with offshore developers to meet SLAs
• Performance tuning of workflows and source queries
• QA testing, support, production deployment and production support
• Requirements gathering with business
• Design and development of Informatica mappings, sessions and workflows to load from various financial feeds (moneymate, morningstar, pogo) into Confidential Investment Management (CSIM) data warehouse
• Design and development of Security Audit management to validate the vendor application management for different APMs, AD groups and Roles
• Developed Python scripts to convert Excel files into CSV files to load using Informatica.
• Created MS SQL Agent jobs to schedule import feeds and dependent exports
• Source control using TFS and Agile team work using Atlassian suite (JIRA, Confluence, Bit Bucket, Bamboo)
• Mentored team on performance enhancements, tuning, data warehouse development strategies

Environment: Informatica Power Center10.1, Python, Microsoft SQL Server suite, TFS, JIRA, Bit Bucket and Bamboo

Confidential

Data warehousing Consultant

Responsibilities:

• Design and development of Vertica objects, schemas, dimensions, facts, aggregates and publish tables
• Design and development of Informatica mappings, sessions and workflows to load from Oracle sources using direct load to Vertica objects on Amazon Web Services prod and non-prod platforms
• Design and development of loading the Aggregates and publish tables using Informatica
• Sourced data from MongoDB
• Creating Autosys jobs to schedule Vertica jobs using JIL scripts
• Used Splunk for Vertica log querying
• Create the workflow schedules using Autosys
• Designed and developed process to load daily flow ETF transactions from BNY to Oppenheimer with revised and excluded file processing.

Environment: Informatica Power Center10.1, HPE Vertica 8.1, Oracle 12c, MongoDB 3.2, AutosysMoveIT, AWS, JIRA

Confidential, Denver, CO

Data Warehousing Consultant

Responsibilities:

• Requirements gathering with business at BPCS Central, Europe
• Develop Informatica mappings, sessions and workflows as per business requirements using various transformations to implement simple and complex business logic
• Performance tuning ofInformatica sessions jobs and several SQL queries to meet SLAs of existing data warehouse ETLs
• Worked with Teradata and Informatica support to move the existing instances to cloud solutions as Teradata servers are approaching end of life and rest of servers has to move to a different data center
• Worked on BI solution for PO supplier data analysis using Tableau
• Worked on workflow schedules using Informatica scheduler using file watch events

Environment: Teradata 14.10,Informatica Power Center 9.6.1, Oracle 11g, Tableau 10.1

Confidential, Denver, CO

Senior Informatica Consultant

Responsibilities:

• Requirement gathering sessions with the business
• Lead team on design and development of ETL process to extract the code from Access macros and created SQL to convert into Informatica
• Lead and designed, developed and mentored other developers, Informaticaobject for Confidential patient data conversion
• Extensively used connected/unconnected Lookups, Filter, Router, Aggregator, Joiner, Expression, Update strategy, Normalizer, union and Rank Transformation
• Mentored team on performance tuning of Informatica sessions jobs and several SQL queries
• Converted complex SQL queries, analytical functions and inline views into Informatica mappings like dense rank, row number, count distinct etc
• Used Java transformation to generate parameter files and automated parameter file generation process based on the checked in sessions and partitioned sessions to achieve optimal performance
• Created the workflow schedules using Active Batch
• Sourced data from Oracle and Netezza

Environment: Oracle 11g,MS SQL Server 2012,NetezzaAginity Pure Data System for Analytics, Informatica Power Center 9.6, Toad, Active Batch V9. Borland StarTeam 2008

Confidential

Data warehousing Consultant

Responsibilities:

• Worked on design and development of ETL process to send sales transaction, broker dealer and office data to share request data vendors like Market Metrics, Bright Scope etc.
• Worked on several T&P (Teams & Partnerships) data validations using dynamic SQL and critical data validation and reported using Informatica mappings and workflows
• Created ETL end to end process to send Ownership information with Callidus sales compensation files to finance
• Created Autosysjobs with JIL scripts to schedule workflows with conditions and dependency
• Wrote complex SQL queries, analytical functions and inline views
• Involved in design and development for type1, type2 and type 6 (hybrid SCD) mappings
• Worked on other objectives like Siebel Liftoff and other BAU stories
• Configured several MoveIT jobs to transfer files to vendors
• Created Linux scripts and scheduled the workflows using Autosys scheduler

Environment: Oracle 11gExadata, Informatica Power Center 9.1, Toad, Autosys, MoveIT. Dynamic SQL, JIRA

Confidential

Data warehousing Consultant

Responsibilities:

• Designed, developed Informatica mappings, sessions and workflows as per business requirements
• Created mappings for Derivatives, Essbase, Intrader, LoanFacts and Investment debts
• Created XML extract from the WichitaFact to load into eReview that creates an xml file for each association
• Developed mappings that incorporated logic for CDC (change data capture) needed to handle inserts, updates and deletes to the existing targets using MD5
• Created mappings to load data from XML files into CoStar database for Cognos reporting
• Worked on ETLs that consolidate data from AgBank and Confidential merger into Loans2 combined application
• Used Oracle, SQL server, XML and flat file sources and targets like Oracle, XML, Excel, Flat files
• Coordinated on Informatica upgrade from 9.1 to 9.6 to facilitate Congos 11 connectivity
• Mentored team on performance tuning of Informatica sessions jobs and several SQL queries
• Created control-M jobs to schedule workflows with conditions and dependency
• Used Microsoft TFS for version control
• Facilitated and supported unit test, system test, UAT testing and Production deployment

Environment: Oracle 11g, MS SQL Server 2012, Informatica Power Center 9.6.1, Microsoft SSIS, ToadControl-M, ERWin 9.2, Windows Server 2008 R2. Team Foundation Server(TFS).

Confidential

Lead Software Development Engineer

Responsibilities:

• Actively lead data modeling with Fact and Dimension tables, designing, development, deployment and support integration
• Create PL/SQL packages, stand-alone procedures, and stand-alone functions
• Designed, developed and mentored other developers, Informatica Mappings as per business requirements using various transformations to implement simple and complex business logic
• Designed schema tables and related DDL scripts using ERWin, developed PL/SQL programs
• Extensively worked with SQL, PL/SQL (cursors, procedures and packages) and query performance tuning, created database objects like tables, indexes
• Created ETL architectureto track execution times of processes and process control totals
• Used Power Exchange for SalesForce and web services for Integration to the Salesforce.com
• Developed the Shell scripts to preprocess and archive the flat files
• Performance tuning of mappings and SQLs and other database objects
• Created shell scripts and FTP scripts in Linux, and scheduled the workflows using Control-M scheduler
• Facilitated and supported unit test, system test, UAT cycles 1,2 and 3

Environment: Oracle 11g, Informatica Power Center 9.1, Informatica Power Exchange for SalesForce, Toad 9.6.1, Linux, Caliber, Serena Dimensions, Control-M, ERWin 9.2, Windows7, HP Quality center/ HP Application life cycle management.