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 Pharmaceuticals, education, healthcare devices, Travel, Finance, Insurance, and Banking.
• Strong Data Warehousing/ETL experience using Informatica - PowerCenter Client tools - Designer, Repository manager, Workflow manager, monitor, Informatica Power Exchange, Informatica Developer (IDQ) and Analyst (IDE) and Informatica Cloud and Informatica MDM.
• 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 MDM concepts and Data Director (IDD).
• Excellent knowledge in various components of the MDM Hub including the schema, staging and landing tables, configuring base objects, Look ups, Hierarchies, display queries, put queries, query groups and subject areas.
• Experience in working on implementation of Data warehouse and strong understanding of Data warehouse concepts, data modeling experience using star schema/snowflake modeling for OLAP systems, ER Diagrams, Dimensional Data modeling, Fact & Dimensions tables, physical & logical data modeling.
• Expertise in working with relational databases like Oracle, MS SQL Server, Teradata, Greenplum, DB2 and MS Access.
• Extensive experience in developing stored procedures, functions, triggers, cursors and joins, SQL Queries with PL/SQL, T-SQL and working with TOAD, SQL Developer, SQL*PLUS.
• Good knowledge on reporting tools like Tableau, OBIEE, Cognos series (Report studio, Framework Manager) and SSRS.
• Experience in using Control M, Opswise, Autosys and Robot scheduling tools to organize and to schedule jobs
• Excellent working knowledge on UNIX shell scripting, FTP connections and familiar with multiple platforms like windows server and various UNIX environments.
• 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.5/9.1/8.x/7.x, Power Exchange, Informatica Developer(IDQ) 9.1 and Analyst(IDE), Informatica Cloud, Power Exchange for sales force, Informatica MDM 9.1, Informatica Data Director, SSIS

BI & Reporting: Cognos 8/10.1.1, SSRS,OBIEE and DAC 10.1.3.4, Tableau 8.0/8.1

Data Modeling: ERWIN 4.X/3.5, Star Schema Modeling, Snowflake Modeling

Databases: Oracle 11g/10g/9i/8i, Greenplum 3.0, MS SQL Server 2008/2005, Teradata V2R6/V2R5, MS Access 2007, DB2 v.9.1/9.5

Job Scheduling & other tools: Opswise 1.7, Autosys 11.0, Control M 7, Toad 9/10/11,SQL Developer, PgAdmin 1.12.1, Teredata Sql assistant 7.1,Reflection 14.1, Filezilla 3.5,Force.com Explorer, Remedy ITSM, Skybot Scheduler

Environment: s: UNIX (Sun Solaris, AIX), Windows 2003/2000/XP, Windows server 2008

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

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

PROFESSIONAL EXPERIENCE

Confidential, Commack, 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.
• Defined the ETL strategy for from Salesforce CRM to Oracle stage and then further loaded to SAP BI
• 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, medical event management and etc.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, lookups, joiner and SalesForce lookups
• Database base objects such tables, triggers, sequences are designed as per the project requirements.
• 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, and 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.
• Supported the process flow in production environment and also working with the SAP BI team to fix the bugs.

Environment: Informatica PowerCenter 9.1,Informatica cloud, Powerexchange for SalesForce, Oracle 11.2.0.2.0 , SQL Server 2018, Linux, Flat files, Toad 11.

Confidential, Mansfield, MA

Informatica/BI 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.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Users provide the source data in flat files and loading into stage tables using ETL process.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, joiner, router, SQL and lookups.
• Wrote T-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, and email and command tasks.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows.
• Wrote windows batch scripts for file checking, indirect file creation and archiving the source files.
• Assisted in Website .NET development in stored procedures and code review process.
• Data validation from sources through the dashboards.
• Responsible for unit and integration testing.
• Skybot tool implementation in Dev and QA environments and testing.
• Scheduling of Informatica jobs using Skybot tool according to the data flow.
• Migration of Informatica objects to different environments.
• Closely working with reporting team to address the data requirements for dashboards.
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.
• Fast paced ETL component development for data availability in both Website UI and Tableau dashboard adhoc POC visualizations development due to parallel development project strategy.
• Involved in development and enhancement activity for the reports which are built using report studio.
• Involved in migration of Cognos reports to Tableau reports.
• Responsible for solving the ITSM Tickets for the business/end users.
• Worked closely with OBIEE team for enhancement and customization of ETL mappings and workflows.
• Monitoring the daily ETL jobs in DAC and responsible for Informatica on call rotation and 24*7 available for both PeopleSoft HR and Tableau projects.
• Responsible for monitoring the Informatica jobs in production environment and working closing with functional teams to fix the bugs on priority level.
• Involved in POC development activity for reading XML files as sources, web services and JD Edwards One world.

Environment: Informatica Power center 9.5/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, Cognos 10.1.1

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• Review the specification documents provided by the business users and preparing mapping documents accordingly.
• Worked with Oracle database involved in building the data base objects and required views and triggers.
• 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.
• Toad is utilized to load the source data into the data ware houses.
• 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, Mansfield, MA

Informatica/ Data Quality Developer

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 Configuring Character Labeler, Configuring a Rule Based Analyzer, Configuring Matching process and configuring a Weight Based Analyzer
• Worked extensively 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.

Confidential

Responsibilities:

• 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.
• Developed the Dashboard reports using Cognos Report Studio.

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, UNIX, Flat files, Postgre SQL, SAS 9.2, PgAdmin 1.12.1, MS Access 2007, Teradata SQl Assistant 7.1,Opswise 1.7, Filezilla 3.5, Remedy ITSM

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data.
• Extensively worked with the sources which are extracted from Oracle, Flat files and XML files.
• Star Schema was used to design the warehouse.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer and Transformation Developer.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Extensively used almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sorter, Sequence generator transformations for developing the mappings to apply the business logic.
• Designed, developed and deployed new data marts along with modifying existing marts to support additional business requirements.
• Configured and used FTP connection on workflow manger to access source and target files.
• Schedule, Run and Monitor sessions by using Informatica Scheduler.
• Used PL/SQL whenever necessary inside and outside the mappings.
• Created, launched & scheduled sessions and tasks. Involved in the performance tuning of Informatica mappings.
• Wrote PL/SQL Packages and stored procedures to implement business rules and validations.
• Utilized UNIX scripts to schedule the Informatica workflows, which were in turn used by the scheduling team to schedule the workflows using the Control M.
• Migration of Informatica objects from Development to QA and from QA to production and setting up the UNIX directories for Parameter files and Logs.
• Created Repository folders, User accounts and assigned privileges using Repository Manager.
• Closely interacted with the reporting team which uses Cognos for generation of reports.
• Developed the Dashboard reports using Cognos Report Studio.

Environment: Informatica 8.6.1/8.1, ORACLE 10g, UNIX, XML, Flat files, PL/SQL, TOAD, Cognos 8 BI (Report studio, Framework Manager), Control M.

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, Teradata 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.
• Designed and developed Star Schema and created Fact and Dimension Tables for the Warehouse using Erwin.
• Dealt with SSIS Import/Export wizard to move data in and out of SQL Server.
• 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.
• Worked with Teradata stand-alone load and unload utilities Mload and Fastload.
• Scheduled the Informatica workflows using the scheduler tool Autosys.
• Identified the Bottlenecks and resolved performance the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• 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, Teradata V2R5, UNIX, Erwin 4.0, Toad, SQL Server 2005, SQL*Loader, Autosys, Cognos 8 BI.

Confidential, San Francisco, CA

Informatica Developer

Responsibilities:

• Involved in Business Analysis and Requirements gathering.
• Responsible for developing, support and maintenance for the ETL processes using Informatica Power Center.
• Designed Sources to Targets mappings primarily for XML, Oracle to SQL server using Informatica Power Center.
• Various kinds of Transformations were used to implement simple and complex business logic.
• Created mappings using Lookup, Aggregator, Expression, Router and Joiner transformations for populating target data in efficient manner.
• Created reusable transformations, Mapplets and used them in Mappings.
• Fine-tuned Transformations and mappings for better performance.
• Atomized Worklets and Session schedule using Unix Shell scripts.
• Pre-session shell scripts are utilized to check session model before running/scheduling batches and scheduled the workflows using scheduler.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the data
• Troubleshoot problems by checking Sessions and Error Logs.
• Generated Unit Test Plans and documents.
• Involved in developing different Dashboards/Reports with different views using Siebel/ Oracle BI presentation services.
• Responsible for on-call support during the month-end OLTP reporting of financials.

Environment: Informatica Power Center 6.1, ERWIN 3.5, Oracle 9i, SQL*PLUS, UNIX, SQL SERVER 2005, OBIEE/Siebel Analytics 10.1.3.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Understood the source systems and collected requirements from business users.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Analyzed the source data coming from different sources (Oracle, Flat files).
• Created mappings for cleansing, transforming and loading data into warehouse.
• Used various transformations like Source Qualifier, Expressions, Aggregator, Update Strategy, Sequence Generator, Router and Lookups.
• Involved in writing PL/SQL stored procedures and functions.
• Created Mapplets to facilitate ease and reuse of common mapping logic.
• Created sessions for mappings and utilized workflow manager & monitor to create, schedule and monitor workflows.
• Involved in Unit Testing for Created mappings.
• Involved in code review of Informatica mappings and sessions.
• Worked with UNIX shell scripts to run Informatica workflows.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.

Environment: Informatica PowerCenter 6.1, Oracle 8i, PL/SQL, Toad, Flat files, UNIX,MS Visio, Control M and Windows 2000.

Confidential

ETL Developer

Responsibilities:

• Interacted with different group of users for analysis of the system.
• Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, etc.
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel files, MS Access to target database.
• Loaded various FACT tables and multiple dimension tables using Informatica.
• Used the debugger to validate the Transformations by creating break points and analyzing the debug monitor.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Responsible to tune ETL procedures, STAR schemas optimizing, load and query performance.
• Involved in writing stored procedure and functions using PL/SQL.
• UNIX Shell scripts are used to automate the execution the workflows.

Environment: Informatica 5.1, Oracle 8i, MS SQL Server 2000, PL/SQL, MS Access, Excel Files, UNIX