SUMMARY

• 8+ years of IT experience and technical proficiency in the business requirements analysis, application design, data modeling and data quality, development, testing and documentation.
• Experience in a variety of Business domains which include healthcare, pharmaceuticals, education, and medical devices, Travel and Finance
• Strong Data Warehousing/ETL experience using Informatica - PowerCenter Client tools, Developer (IDQ) and Analyst (IDE), BDE and Informatica Cloud.
• Extensive experience in creation of ETL mappings, CDC Concepts, mapplets and workflows using Informatica Power Center to move data from multiple sources into target area
• Experience in data quality profiling, plans and rules, standardization and Address Validation modules and good understanding of master data management (MDM).
• Good exposure to end-to-end Data Governance program implementation - scoping, structuring, communication plan and execution.
• Experience in working on implementation of Data warehouse and strong understanding of Data warehouse concepts, dimensional data modeling experience using star schema/snowflake modeling
• Expertise in working with relational databases like Oracle, MS SQL Server, Teradata, Greenplum and MS Access.
• Extensive experience in developing stored procedures, functions, triggers and joins, SQL Queries with T-SQL, PL/SQL and working with TOAD, SQL Developer, SQL*PLUS.
• Experience with production support roles which includes job monitoring and coordination of support teams necessary for issue resolution and managing Service Level agreements.
• Good knowledge on business intelligence area and understanding of reporting tools like Tableau, OBIEE and Cognos
• Experience in using Autosys, Opswise and Tivoli scheduling tools to organize and to schedule jobs
• Excellent analytical and problem solving skills and good team player with strong interpersonal and good communication skills.

TECHNICAL SKILLS

ETL and related Tools: Informatica PowerCenter 9.6.1/9.5/9.1/8. x, Informatica Developer(IDQ) 9.6/9.1 and Analyst(IDE), BDE, Informatica Cloud, Power Exchange for sales force, MDM 9.x, IDD, SSIS

BI & Reporting: OBIEE and DAC 10.1.3.4, Tableau 8.x, Cognos 8.x

Databases: Oracle 11g/10g/9i, Greenplum 3.0/4.3.x, MS SQL Server 2008/2005, Teradata 14, MS Access 2007, Hadoop 2.5.2

Job Scheduling & other tools: Autosys, Opswise 1.7, Toad 9/10/11, Force.com Explorer, Remedy ITSM, TFS 2012, Skybot, Hive 0.13, SVN

Environment: s: UNIX (Aix, Linux), Windows 2003/2000/XP, Windows server 2008

Languages: PL/SQL, T-SQL, XML, HTML, Postgre SQL

Office Applications: MS Office 2003/2007/2010 , MS Visio 2010

PROFESSIONAL EXPERIENCE

Confidential, Tampa

Informatica Consultant

Responsibilities:

• Worked closely with the users in understanding the Business requirements and preparation of technical design documents with the help of FSD
• Creation of Greenplum tables as per the technical requirements
• Developed standard mappings using various transformations like expression, aggregator, lookups and joiners as per the functionality.
• Developed Informatica BDE applications to process the raw data, populate Hadoop staging tables and store the refined data.
• Workflows are built using command task and reusable objects
• Control tables are built to handle the report start and end dates.
• Working with SAS development team in order to generate the excel worksheets as per the CMS requirements.
• Scheduling the workflows using Autosys scheduling through the CA workload center tool.
• Migration to other environments and code checking using TFS
• Working closely with QA team and resolving the issues as identified
• Participated in Code Review activity and ensure that all migration objects’ follows the Wellcare standards.
• Business critical changes and e-fixes are implemented for the defects/bugs identified in the production environment.
• Preparation of run book for the production support of the project.
• Actively participated in data Governance pilot program implementation - scoping, structuring, defining, execution and monitoring
• Working with different level of roles in organization such as data stewards, data owners, analysts and consumers
• Designed RACI models for the DG/DQ projects which define the roles and responsibilities at the enterprise level
• Developed profiles which include column level and join analysis on relational tables and flat files and generated scorecards.
• Building rules for domain definition cleansing and standardization and validation of the business requirements
• Building POC profiles/scorecards using various source systems such as Greenplum and Hadoop tables
• Demonstrated the process of Business glossaries, applications and monitoring capabilities in 9.6.1 for one of the pilot project
• Worked with various IDQ transformations such as Labeler, Case Converter, Parser, Match and human exception task
• Worked with different teams and infa admins to define the custom roles for developer and analyst tools

Environment: Informatica 9.6/9.1, BDE, IDQ 9.6.1, Oracle 11 g, Greenplum 4.3.5.x, TFS 2012, AIX 7.x, Hadoop 2.5.2, Hive 0.13, CA Workload Automation AE 11.3, Aginity 4.4.x

Confidential, NY

Informatica Consultant

Responsibilities:

• Worked closely with the users in understanding the Business requirements, data analysis and high level design documents are prepared as per the functionality.
• Created cloud data replication jobs to load the Veeva data into oracle staging area.
• Data extraction by informatica cloud is designed to support the delta changes.
• Tasks are created and cloud jobs are scheduled to run on daily basis in Dev and Prod environments.
• Worked with different Veeva objects such as call, call detail, sample, affiliation and medical event management
• Performed land process to load data into landing tables of MDM Hub using external ETL processing for data load in hub store
• Developed standard mappings and mapplets using various transformations like expression, aggregator, lookups, joiner and salesforce lookups
• Views are created in order to feed the data to the SAP BI data sources.
• Flight tables are designed to handle the invalid data and parameter values are process from control table.
• Wrote SQL Overrides and used filter conditions in source qualifier thereby improving the performance of the mappings.
• Developed various ETL workflows with event waits, conditional flow, email and command tasks.
• Used Power exchange for Salesforce to connect on premise systems to Salesforce
• Test cases are built to compare the Veeva data flow with the existing SAP CRM data and responsible for Unit testing and integration testing.
• Workflows are scheduled within the informatica on a daily basis.

Environment: Informatica PowerCenter 9.1, MDM 9.1, Cloud, Power exchange for salesforce, Oracle 11.2.0.2.0 , SQL Server 2008, SAP CRM 7.1, Linux

Confidential, Mansfield, MA

Informatica Consultant

Responsibilities:

• Interacted with the business users in order to understand the business and functional requirements.
• Designing the data base objects using SQL Server management studio as per the project specifications.
• Involved in building the database and created stored procedures, triggers to maintain the referential Integrity, functions, view to handle business logic and functionality of various modules.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, joiner, router, sql and lookups.
• Developed various ETL workflows with event waits, assignments, conditional flows, and email and command tasks.
• Wrote windows batch scripts for file checking, indirect file creation and archiving the source files.
• Scheduling of informatica jobs using Skybot tool according to the data flow.
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.
• Worked closely with OBIEE team for enhancement and customization of ETL mappings and workflows.
• Responsible for monitoring the informatica jobs in production environment and working closing with functional teams to fix the bugs on priority level.

Environment: Informatica Power center 9.1, MS SQL Server 2008 R2, Oracle 10g, Windows Server 2008, Toad 11.5, Flat files, T-SQL, Tableau 8.0 and Skybot Scheduler, OBIEE and DAC 10.1.3.4

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• Review the specification documents provided by the business users and preparing mapping documents accordingly.
• Worked with Oracle database and involved in building the data base objects.
• Developed mappings and mapplets accordingly to meet the business rules.
• Extensively worked with Transformations such as Filter, Aggregator, Lookup, Update Strategy, Sorter, Sequence generator for building the mappings.
• Wrote SQL queries in source qualifier while pulling the source data and hence increased the mapping performance.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• The target files (txt files) are generated as per the EDFacts Specifications.
• Created and configured sessions, command tasks and built workflows to generate the various data files for EDFacts.
• Workflows are scheduled with informatica scheduler with “run on demand” option.
• Deployment of informatica workflows and mappings to different environments.
• Worked on existing mappings for the performance tuning to reduce the total ETL process time
• Target flat files generated on the UNIX machines are accessed by Reflection Ftp client tool.
• Monitoring data load jobs in production boxes and providing the ad hoc solutions to meet the business needs in prod environment.
• Prepared technical and functional documents for the operations of EDFacts project.

Environment: Informatica 8.6.1, Oracle 11g (11.2.0.2), Toad 11.5.0, Excel and flat files, Reflection FTP client 14.1.70, UNIX AIX 5.3

Confidential, MA

Informatica/ IDQ Consultant

Responsibilities:

• Interacted with subject matter experts and data management team to get information about the business rules for data cleansing.
• Worked with various developer modules like profiling, standardization and matching.
• Building the rules for all attributes and creating score cards and dash boards and drill down the results to the excel sheet.
• Designed various mappings and mapplets using different transformations such as key generator, match, labeler, case converter, standardizer and lookup.
• Worked with address validator to cleanse the address elements. Created input and output templates.
• Experience with audit trail both duplicate and bad records in analyst by manually and automatic consolidation
• Exported the IDQ Mappings and Mapplets to power center and automated the scheduling process.
• Worked extensively with CSV (flat-file) and Oracle systems.
• The target data are extensively tested by various test cases.
• Prepared micro and macro level documents for the ETL process, test cases and also the operational documents.
• Interacted with the business users in order to understand the business and functional requirements.
• Source data comes in the form of flat files and target systems are built in Oracle.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, joiner, router and lookups
• Involved in data modeling and also created views, triggers and stored procedures for implementing the business logic.
• Wrote SQL Overrides and used filter conditions in source qualifier thereby improving the performance of the mappings.
• Developed various ETL workflows with event waits, assignments, conditional flows, email and command tasks
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.
• Closely interacted with the reporting team which uses Cognos for generation of reports.

Environment: Informatica Power center 9.1, Informatica Developer (IDQ), Analyst (IDE), ORACLE 11.2.0.3, Windows Server 2008, Flat files, PL/SQL, TOAD 9.7 and Robot Scheduler, Cognos 8.4.1

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for Data warehouse and documented business needs for decision support data.
• Agile approach is followed including Programming, Test-Driven Development and daily Scrum.
• Extensively worked with the sources which are extracted from Greenplum tables and Flat files.
• Involved in developing the data model and the tables required for the design.
• SAS programs are analyzed and the business logic is developed to replace SAS environment.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer and Transformation Developer.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Configured and used FTP connection on workflow manger to access source file.
• The ETL jobs are scheduled daily and monthly by Opswise scheduling tool.
• Written Postgre SQL override queries in source analyzer to customize mappings.
• Created, scheduled sessions and tasks. Involved in the performance tuning of Informatica mappings.
• Migration of Informatica objects from Development to testing and then to production and setting up the UNIX directories for Parameter files and Logs.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.

Environment: Informatica 8.1, Greenplum 3.0, Postgre SQL, SAS 9.2, PgAdmin 1.12.1, MS Access 2007, Teradata Sql Assistant 7.1, Opswise 1.7, Remedy ITSM

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Participated in reviews and meetings to evaluate documents, plans, code, requirements and specifications.
• Analyzed the source data coming from Oracle and Excel files. Worked with Data Warehouse team in developing Dimensional Model.
• Worked closely with the user decision makers to develop the transformation logic to be used in Informatica.
• Used Informatica Designer to create mappings using different transformations to move data to Data marts and Data Warehouse.
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Union, Joiner, Rank and stored procedure.
• Implemented Slowly Changing dimension (SCD) methodology for accessing the full history of accounts and transaction information.
• Scheduled the informatica workflows using the scheduler tool Autosys.
• Worked on Prompts to build Interactive Dashboards/reports with drill-down capabilities.
• Developed Analysis Studio views of analysis from dimensional modeled packages.
• Provided 24/7 Support for the Production that has Daily, Weekly and monthly refresh for production OLTP instance.

Environment: Informatica Power Center 8.1/7.1, Oracle 10g, UNIX, Erwin 4.0, Toad, SQL Server 2005, SQL*Loader, Autosys, Cognos 8 BI