PROFESSIONAL SUMMARY:

• Experienced IT Professional with 9+ years of experience in developing enterprise level Data solutions.
• Expertise in Design, Implementation, Data Analysis, Architecture, Testing and Documentation. Domain experience in Insurance, Financial Services, Manufacturing Industry, Telecom, Banking, Retail
• Extensive Experience in creating Informatica Mappings, Mapplets, Sessions and Workflows using Informatica 9.x,8.x and 7.x .
• Experience in working on OWB ETL
• Created Informatica Realtime jobs to capture realtime transaction data.
• Extensive experience using Parameter files
• Extensive experience with the sources - Oracle, DB2, Flat files, XML files, Greenplum, also used Secure FTP, SSH to fetch files.
• Extensive experience in designing star schema and snowflake and conformed dimensions
• Extensively worked on IDL(Initial data load)
• Designed junk, set and late arriving dimensions
• Dealt with Change Data Capture (CDC) using PowerExchange CDC option to distill updates from unchanged background data and to deliver them to multiple targets without intermediate queues or staging tables
• Worked on Incremental loading Target databases using SCD Type1/Type2 loads and level 1, 2 and 3 facts
• Extensive experience with various target loading strategies for ex: Insert only, Insert else update, Update else insert, Delete and Insert, Truncate and load, Constraint based loading etc.
• Provided hybrid solution involving Hadoop Hive and Informatica
• Provided the architectural solution to extract big data and transform it to business needs using Hadoop, Hive, Informatica and business objects.
• Extensive experience in working with special characters, UTF8 encoding xmls, clobs of huge sizes.
• Experience in creating rejection logic (Using Informatica’s rejection tables)
• Extensive experience in working on Guidewire policy center and billing center data structures.
• Extensive experience in Data analysis, profiling and data mining.
• Extensively worked on enterprise data using Informatica ETL, OWB ETL, Oracle 8i/9i/10g, greenplum
• Experience in Big data, Logical designs, Technical Design, ETL Process
• Experience in working with Hadoop, Hive and Pig
• Expertise in Insurance, Financial, Manufacturing, Telecom, Banking and Retail domain
• Strong understanding of Software Development Life Cycle
• Extensive experience leading offshore team and onsite team
• Expertise in working with business teams, stakeholders and customers
• Experience in creating Architectural Road Map, direction and work packets for ETL needs
• Experience in Data modelling, Data mart design and Staging design.
• Experience in using Erwin r8 to create logical and physical model.
• Reverse engineered Datawarehouse using Erwin r8.
• Experience working with Attunity tool to acquire data
• Provided a solution for updating targets which do not have primary keys defined on it, without having to change the table structure.
• Experienced in Installation and Configuration of Informatica PowerCenter 8.6/8.1/7.1
• Extensive Experience working with Informatica Metadata tables to record post mapping details and performance tracking such as
• OPB MAPPING
• OPB SUBJECT
• REP REPOSIT INFO
• REP TASK INST RUN
• OPB SESS TASK LOG
• Extensive experience in all phases of Software development life cycle (waterfall, Agile) of Data warehousing, including requirement gathering from business users, analysis, design, creation of business requirement documents, mapping documents, development, testing, and implementation
• Extensive experience moving code from Dev to Integration and to UAT and to Prod using Informatica Repository Manager and Unix Shell scripts.
• Extensive experience in creating CR(Change Request) Document to move or change the code in Production environment.
• Designed entire workflow logic using Unix scripts.
• Extensive experience using PMCMD commands and Pre and post session commands and Informatica Cache files.
• Extensive experience with slowly changing dimensions, rapidly changing dimensions.
• Extensive experience in strategizing data load schedule based on the business needs
• Designed various workflow logic across various loads for ex: Daily load, weekly, monthly etc.
• Extensively used Informatica user defined variables
• Extensive experience in using Custom transformations etc.
• Extensive experience on Performance Tuning Informatica Targets, Sources, mappings and sessions
• Extensive experience using Autosys scheduler.
• Worked as an Informatica Admin.
• Experience in creating Mappings, Packages, Processflows using OWB tool.
• Experience in creating PL/SQL code and proficient in Oracle Queries.
• Experience in handling over 15 members in team.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.6/9.1/8.6/8.1/7.1 , OWB, DT Studio, Pig, Hive

Reporting Tools: Cognos Trained, Microstrategy.

Data Replication Tools: Attunity

Databases / DB Tools: Oracle 8i/9g/10g/11g,DB2,AS400, SqlLoader, Toad, SQL plus, SQL Developer, Erwin r8, AQT, Hadoop, Sqoop

Scheduling: Autosys, Oozie

Desktop Tools: Microsoft Office, Microsoft Visio

Operating Systems: Windows 98/2000/XP/7,Linux

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

ETL Architect

Responsibilities:

• Created the design for Building new start schema solution for Customer360 data that is acquired from various different operational systems
• Created the design and etl process to pull the data from Customer transactional database to our new customer 360 data mart
• Pulled large amount of customer data from various data sources into HDFS using sqoop
• Analyzed and transformed large amount of data using Hive and pig.
• Provided the architectural solution to extract big data and transform it to business needs using Hadoop, Hive, Informatica and business objects.
• Created various technical spec and design document for each deliverable for offshore and onsite development team and ensured quality ETL deliverables
• Provided Architectural Road Map, direction and work packets for ETL needs.
• Created detail ETL Standards documents for Design, Development, Release Management and Production Support.
• Created workflows with Oozie
• Create, validate and maintain scripts to load data using sqoop
• Developed HIVEQL queries
• Improved the performance of data load and data read
• Designed Hive tables and schemas to load customer data of various formats
• Data profiling and mining using various tools.
• Created Test case and unit test documentation and ensured the developers followed the process to maintain the quality of the code
• Created detail ETL Migration Processes for acquiring data into Hadoop from various different systems involving databases like Oracle, DB2, Flatfiles, XML, Greenplum and to implement hybrid solution involving Hive, Informatica and Views
• Design Audit Balance and Control (ABC) for ETL process.
• Created various complex Informatica mappings, sessions, workflows to extract transform and load

Environment: Informatica 9.6, Hive, Hadoop, Pig, Sqoop, Oozie, Oracle11g, DB2, Greenplum, DT Studio, XML, BO, Rally

Confidential, Madison, WI

ETL Architect

Responsibilities:

• Created various technical spec and design document for each deliverable for offshore and onsite development team and ensured quality ETL deliverables
• Provided Architectural Road Map, direction and work packets for ETL needs.
• Created detail ETL Standards documents for Design, Development, Release Management and Production Support.
• Understood the data structure of guidewire and how the data is being populated into operational data store.
• Data profiling and mining using various tools.
• Analyze the data of new source system built for partner transaction
• Created the design to acquire the data from new source system (BPM) into BIC operational data store using the tool Attunity(Specialized tool for data replication)
• Was part of Building new start schema solution for Partner data that is acquired from ODS.
• Worked very closely with enterprise solution architect and data modeler to come up with the data warehouse design.
• Provide RCE for ETL deliverables and oversee the progress for quality ETL Deliverables.
• Developed the mappings to move the data into SCD type 1 and type 2 dimensions and level 1, 2 and 3 facts in analytic data layer from ODS
• Created Test case and unit test documentation and ensured the developers followed the process to maintain the quality of the code
• Created detail ETL Migration Processes for Informatica, Database, Data gathering sheet for Scheduling (Autosys) team.
• Design Audit Balance and Control (ABC) for ETL process.
• Created various complex Informatica mappings, sessions, workflows to extract transform and load
• Enhancing analytic capabilities already in place. All completed by a rich set of dimensional attributes and detailed transactional data.
• Meeting business partner demand and requirements for creating new reports for Mindi from Analytic data layer
• Support all the new data acquisition and reports after deployment

Environment: Informatica 9.6, Oracle 11g, Greenplum, DT Studio, XML, Attunity, BO

Confidential, Madison, WI

Informatica Lead

Responsibilities:

• Created various technical spec and design document for each deliverable.
• Understood the data structure of guidewire and how the data is being populated into operational data store.
• Setup environment to pull data for all the deliverables that’s in production currently to support regression testing.
• Worked with various teams for ex: DBAs, PC team, Billing Team to bring in the required data and sync up the database with new changes in pre prod environment.
• Created several mappings, workflows to migrate data efficiently.
• Setup Real time jobs to capture realtime data from Policy Center and Billing Center
• Along with my team, we successfully setup around 100 jobflows manually during our AIT phase to support regression testing.
• Reverse engineered on many mappings (Since the SME was no longer there) to understand the data flow and logic behind it to include South Dakota changes to these flows.
• I resolved many defects that was raised during AIT phase, by understanding the various reports, data flow, logic behind it with very less time
• Designed various complex mappings and was successful in making my teams understand.
• With resources frequently moving out of the project, and new resources filing in, the various challenges that came along because of this was handled very well, with great planning and documentation.
• Worked with IDAs and understood the requirements thoroughly which helped explain my team and getting the work done with very less confusion.

Environment: Informatica 9.6, Oracle 11g, Greenplum, DT Studio, XML, BO, Rally

Confidential, Madison, WI

Informatica Lead

Responsibilities:

• Created various technical spec and design document for each state that we will be migrating data from.
• United various teams into one single team spread across multiple locations and was successful in making them work together
• Created several mappings, workflows to migrate data efficiently.
• Implemented various solutions to handle special characters, as the agents might enter data in various languages depending upon their location.
• Created design documents to implement various business rules by engaging the business partners and business analyst enthusiastically.
• Crated a fool proof checkout mechanism to make sure the migrated data is free of defects and we didn’t miss any records.
• Tuned lot of Informatica mappings and brought down the migration time from 18 hrs to 4 hrs for a state.
• Under my leadership of the ETL team, we successfully migrated 19 states (ID, GA, OR, UT etc..).
• Saved lot of company’s time and money by reducing the time to migrate the data.
• Single handedly executed the project to migrate a state when most of the team members were on vacation for a month.
• Fixed lot of defects of the code which was previously developed by third party, which helped in saving lot of overhead and efforts in cleaning and fixing up data after the migration
• Created very effective and efficient process to migrate data into centralized Database, this helped in reducing lot of unwanted steps and made use of Informatica and oracle resources very efficiently
• Received various awards from AFAM for building a strong process for migrating data.
• Built a cross functional team, so that there won’t be dependency on a single person, everyone in the team knows what each individual is working on and how to take up his/her work in their absence.

Environment: Informatica 9.1, Oracle 11g, Apex, DT Studio, XML, Paradox

Confidential, Framingham, MA

Informatica Lead

Responsibilities:

• Analyzed various Confidential website and laid down Impacts and challenges that might occur when SSO is implemented.
• Analyzed the data across Confidential websites, as it uses multiple Datawarehouse and listed down the new tables and columns which might be required to be created in Confidential .com Datawarehouse.
• Discussed with various teams and understood the underlying tables that were used by various Confidential websites.
• Designed the technical document, which contains the logical and technical implementation.
• Compared the Business rules that are implemented across various Confidential website to that of Confidential .com Business Rules.
• Discussed with my team frequently and came up with an implementation plan.
• Handled a team of 4 resources in offshore by overcoming the challenge of time difference.
• Created mapping document from various sources to target.
• Created workflow design document.
• Created several mappings, sessions and workflows.

Environment: Informatica 9.1, Oracle 11g, DB2, SAML, Web methods, Https Delivery, App server

Confidential, Framingham, MA

Senior Informatica Lead/System Analyst

Responsibilities:

• Analyzed the source system completely and understood the architecture and the hierarchy
• Documented the data elements and the way it’s stored in the source Database.
• Analyzed the target system ( Confidential side) and understood the architecture and the hierarchy
• Documented the differences in design between Source and Target systems
• Gathered the Business requirement on adding the missing elements in the Target.
• Gathered the business requirement on migrating the source reports.
• Designed the SQL for all the source reports to have it run using Target data elements.
• Created Business Rules document for all the reports that had to be migrated.
• Coordinated with multiple teams such as Source team, Reporting Team, Business.
• Created Source to Target mapping document.
• Created Technical Design Document and discussed with my team.
• Designed Workflow logic.
• Created complex Informatica mapping which uses multiple sources from different databases.
• Usage of DB connection variables via parameter files as each source was coming from different databases.
• Usage of SQL transformation to act as a temporary intermediate table.
• Created over 50 mappings, sessions, workflows.
• Used Informatica Metadata tables to track performance and to capture mapping details.
• Designed post mapping activities to send email to support department using Informatica metadata tables, such as Source record counts, target counts, mapping name etc.

Environment: Informaica 9.1, DB2, Oracle, Microstrategy.

Confidential, SFO, CA

Informatica support engineer/Informatica Administrator

Responsibilities:

• Providing Support for more than 15 applications
• Prepared the steps and plan each time a conversion happened.
• Resolved the problem tickets within the SLA/opened an emergency line (eaco) in case of data problem from the source, helped them identify the issue quickly.
• Resolved Production related issues quickly.
• Resolved Informatica code defects quickly.
• Extensively analyzed source data and provided solution whenever there was a data problem.
• Understood how Informatica works for very big Integers and provided solution to properly load very big Integers.
• Created CRs(Change Request) for modifying production tables.
• Involved in performance tuning.
• Automated Jobs to look for dependent jobs and kick off without manual intervention
• Automated Post validation of jobs after it completes, Reports if there are more variance.
• Proactively identified issues which reduced business impacts.
• Worked as Informatica Administrator
• Created Repository Service, Integration Service using admin console
• Involved in Informatica administration to take Repository backup, restore across different Informatica environments
• Created user access, security roles for new developers and projects
• Worked on migration of Informatica objects across Dev, Test and Prod environments using Deployment folders
• Worked on migration of files, scripts across different environments in Linux
• Worked with Linux administrators, Oracle/SQL Server DBA’s on OS and Database related issues

Environment: SqlLoader, Informatica 8.6, Informatica Repository manager, Admin Console, Plsql, Shell Scripts, Autosys, CR tool.

Confidential, SFO, CA

Senior Informatica Developer

Responsibilities:

• Designed the Logical model to achieve the conversion
• Created Low level Design document.
• Designed Staging Area for adding its list of accounts and mapping IDs to a staging table
• Involved in designing the aggregation of results of accounts from the master table in staging area
• Extensive use of multi connected and unconnected lookups using persistent cache and Dynamic Cache.
• Created complex mappings which made use of Constraint based loading and Incremental Aggregation logic.
• Provided a solution for updating targets which do not have primary keys defined on it, without having to change the table structure.
• Designed Auditing tables and created entire logic to capture post mapping details into these tables.
• Created Parameter control table to store parameter values which will be later written to file and eventually used by Informatica to substitute the user defined variables and parameters.
• Created more than 50 mappings, session, workflows using Informatica to pull the data from source to staging and from staging to target.
• Created Test case documents.
• Created Project manual for the end user to understand the complete architecture of the project.
• Provided support during warranty period.

Environment: Informatica 8.6, Plsql, Oracle10g, Shell Scripts, Autosys, CR tool.

Confidential, CA

Senior Informatica Developer

Responsibilities:

• To understand and review the Requirements/ Functional Specification and User Interaction.
• Creating and Reviewing Mappings, Sessions and Workflows and Scheduling of Workflows using Informatica.
• Designed complex logic to join multiple tables of as many as 20+ reports to make Informatica access the database only once to increase performance.
• Designed complex logic to make the multiple source records split according to the business rules and load it to the same target and multiple target tables.
• Created complex Informatica mapping to simultaneously insert else update and delete. Check if the source record already exist in the target table, if so delete that data and load deleted record into auditing tables, if the record is just update then update in the target table else if its new then insert to target table. All these were happening simultaneously.
• Extensively used router, rejected data of router transformation, Custom built transformations, user defined variables and session variables, sql transformation, parameter file.
• Designed Exception or Rejection logic to generate exception reports for analysis using Informatica.
• Generated files using Informatica in such a way that third party mail application would accept it for further usage.
• Performance Tuning.
• Designed FSD Functional design document and Technical Design Document.

Environment: Informatica 8.6, Plsql, Oracle10g, Shell Scripts, Autosys, CR tool.

Confidential, NY

Informatica Developer

Responsibilities:

• To understand and review the Requirements/ Functional Specification and User Interaction.
• Creating and Reviewing Mappings, Sessions and Workflows and Scheduling of Workflows using Informatica.
• Creating System Test Case and Plan.
• Performance Tuning.
• Creating Unix Shell Scripts to Read Informatica log files and to Insert and Update Control tables.
• Designed Rejection Logic using Informatica’s Rejection method and Modification of the same.
• Usage of Dynamic cache and Persistent cache.
• High Level Design and Implementation of Project.
• Designing the Intermediate Staging Area and modifying the Target Data Model.

Environment: Informatica 8.6, Plsql, Shell Scripts, Oracle 10g.

Confidential

OWB Developer

Responsibilities:

• Creating and Modifying Mappings, Deploying and Running Processflows.
• Understood the Impact, relationship between the tables so that modification to the existing model didn’t impact much.
• Extensive usage of Erwin tool to Reverse Engineer the oracle database.
• Modification to existing datamart, ODS and EDW.
• Created logical and physical data model which can integrate with existing data model in production.
• Created Impact analysis document.
• Involved in risk management process.
• Creating System Test Case and Test Plan.
• Performance Tuning.

Environment: OWB, Oracle 9i, PL/SQL, Packages, Erwin.

Confidential, NY

Informatica Developer

Responsibilities:

• To understand and review the Requirements/ Functional Specification and User Interaction.
• Creating and Reviewing Mappings, Sessions and Workflows and Scheduling of Workflows using Informatica.
• Creating System Test Case and Plan.
• Performance Tuning.
• Creating Unix Shell Scripts to Read Informatica log files and to Insert and Update Control tables.
• Designed Rejection Logic using Informatica’s Rejection method and Modification of the same.
• Usage of Dynamic cache and Persistent cache.
• High Level Design and Implementation of Project.
• Designing the Intermediate Staging Area and modifying the Target Data Model.

Environment: Informatica 8.1, Oracle 9i, PL/SQL, Sun Solaris, Agile Methodology.