SUMMARY

• Confidential is an accomplished Senior Informatica Developer with close to 10 years of total IT experience in Application Design, Data Modeling, Development, Implementation & Testing of Data warehousing and Database business systems.
• She has recently completed her latest assignment and is eager to find her next project.
• Experience in the Data Analysis, Design, Development, Implementation and Testing of data Warehousing using Data Extraction, Data Transformation, Data Validation and Data Loading (ETL and Business Intelligence).
• Extensive Data Warehouse experience using Informatica Power Mart/ Power Center 7.x/8.x/9x (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer) as ETL tool on Oracle, IBM DB2, and SQL Server Databases.
• Involved in design, enhancement, and development of applications for OLTP and OLAP using dimension modeling with Oracle, DB2, and SQL server databases.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Comprehensive Knowledge of Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling.
• Strong knowledge and experience in interacting with Oracle, DB2, SQL Server databases with SQL/PL SQL programming.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, and XML into staging area.
• Expertise working on slowly changing dimension type1and type2.
• Experience in writing UNIX shell scripts.
• Extensive experience in performance tuning activities and performance optimization.
• Scheduled informatica job runs using tools such as autosys, tidal, and control M.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Experience in overall data warehouse, database, ETL and OLAP tuning for better performance.
• Experience in preparing FSD/TSD (Functional/Technical Specification Document) documents from BRD (Business Requirement Document) / Customer Requirements.
• Excellent communication and demonstrational skills for analyzing user requirements.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.

TECHNICAL SKILLS

• Informatica 9.6.1/9.1.0/8.6.1/7.1/6.2/5.1
• IDQ
• Power Center
• Designer
• Workflow Manager
• Workflow Monitor
• Server Manager
• Oracle 11g/10g/9i
• MS SQL Server 2008/2005/2000
• IBM DB2
• SQL
• PL/SQL
• TSQL
• Unix Shell Script
• Visual Basic
• Toad
• SQL* Loader
• SQL Developer
• Putty
• WinCVS
• WinSCP.
• Informatica Scheduler
• Tidal
• Autosys
• Control M
• Windows 7/XP/2003/2000
• AIX
• Sun Solaris
• Unix
• Linux

PROFESSIONAL EXPERIENCE

Confidential, Colorado Springs, CO

Sr. Informatica Developer

Responsibilities:

• Followed waterfall methodology
• Co - ordinated with the business analysts for requirements understanding, DBAs for database changes and issues, and other team members for determining optimized solutions for complex technical problems related to Business Intelligence.
• Worked on mapping specification documentations and ESS turnover documentations for the projects namely Fee Reporting Intermediary, Trust Certification Redesign, E2E prospectus and others
• Was heavily involved in informatica jobs development, unit testing, performance tuning, performance optimization, code reviews, migration from lower to higher environment etc. for the projects namely Fee Reporting Intermediary, Trust Certification Redesign and others
• Designed and developed Informatica Mappings based on the business requirements.
• Validated the data in the target tables once it was loaded.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Ran the workflows, scheduled the workflows and monitored them.
• Worked on bug fixes on existing mappings to produce correct output.
• Used the tool Application Lifecycle Management for tracking defects, resolved, and closed them after leaving comments.
• Deployed informatica code from lower to higher environment and vice versa using the web based tool called Raven
• Raised many DSA requests and other service now requests related to data and database changes.
• Participated in database modeling and in creating physical and logical data models.
• Raised many MER requests to informatica admin team and co-ordinated with them while resolving the issues related to the informatica connections, servers, and migration.
• Co-ordinated with the informatica admin team for configuring FTP connections and used them in the informatica jobs.
• Scheduled job run using autosys scheduler.
• Assisted the projects throughout all the phases from requirements gathering till go live.
• Provided Knowledge Transfer to the junior team members.

Environment: Informatica 9.6.1, DB Visualizer, ALM, DB2, WinSCP, putty, autosys

Confidential, Malvern, PA

Sr. Informatica Developer

Responsibilities:

• Followed agile scrum methodology
• Created mapping document based on the user stories provided by the product owner for enhancing the manual override loader Informatica mapping
• Modified the existing manual override loader mapping to match the behavior with UI to cover for two PSIs
• Performed extensive unit testing of the Informatica mappings before migrating the ETL codes to QA environment.
• Executed several test cases, updated the results in rally and fixed bugs in the mappings accordingly
• Used and created shell scripts to schedule and run Informatica workflows.
• Used parameter files to parameterize different Informatica objects.
• Migrated the Informatica objects across different folders in the same environment and across different environments as well
• Used source tree tool to check in the ETL codes and maintain the versioning of the codes
• Resolved many Informatica related defects raised in the rally
• Did performance tuning activities and managed memory usage in Informatica environment
• Scheduled job run using control M.

Environment: Informatica 9.1 HF 6, SQL developer, Oracle 11g, rally, WinSCP, putty, control M

Confidential, Abbott Park, Illinois

Support Analyst/ Informatica Administrator

Responsibilities:

• The GIS Middleware Operations team, which sees operational functions in the US-CMS-IS department in the company, resolves incident as well as service request tickets related to Informatica, autosys, IP Switch and MQ FTE & works in close co-ordination with GIS middleware implementation and GIS middleware engineering team. Wide range of soft wares ranging from Informatica, MQ Explorer and autosys scheduler to BladeLogic are used to provide effective solutions for arising issues on a day to day basis.
• Experience in resolving issues related to file transfer processes taking place through accellion manager
• Analyzed queue managers and queues to find potential problems and worked towards fixing them
• Used MQ explorer to check the status of the queues, delete messages in the DLQs, browse messages in the queues just to name a few.
• Analyzed Informatica job failures & connection issues and worked with DBA and network teams to resolve them
• Experience in code migration and folder refreshes across different environments.
• Experience in analyzing the cause of long running jobs and implementing different performance tuning methods
• Analyzed file transfer error using MQ FTE logs
• Restarted agents and outboxes after analyzing the file transfer issues
• Used Active directory to check and modify the groups’ and users’ permission
• Analyzed autosys job failures and worked with autosys team to resolve the issues
• Used Blade Logic to check the status of services running on windows servers and checking the permissions of users and groups
• Used admin console to create and modify different Informatica services
• Experience in decommissioning the extra servers, removing servers from Informatica grid, and deleting nodes belonging to the decommissioned servers
• Worked with respective teams for the cleanup of the agents and outboxes in the decommissioned servers.

Environment: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Autosys Scheduler, Oracle 10g/11i,SQL, BladeLogic, UNIX, Websphere MQ Explorer 7.5

Confidential, Peoria, Illinois

Sr. Support Analyst

Responsibilities:

• Collaborated with Business users to gather business requirements.
• Installed PowerCenter software, administer repositories and provide Application Support.
• Provide production support for supply chain MRC Applications.
• Provide PowerCenter performance tuning and production support.
• Involved in Deployment of the facilities in the supply chain MRC Applications.
• Implement and support PowerCenter Development, Test, QA and Production environments including object migrations.
• Provide standards using Informatica velocity guidelines to application development teams.
• Upgraded PowerCenter to version 9.1 from 8.6.1 and 8.6.1 from 7.1.2.
• Configured Informatica domains, nodes and integration service and repository service.
• Created users and groups in admin console and assigned permissions to users.
• Created folders and assigned permissions, integration service to folders.
• Performed Backup Recovery and Restored on Informaticarepository.
• Performed code migrations using import and export, deployment groups between different environments.
• Proficient in using pmcmd and pmrep commands.
• Performed code-purging activities to improve the repository performance.
• Conducted Review sessions with SME’s and Business users for better understanding of the requirements.
• Scheduling the Jobs in Tidal to run on Daily Loads and Continuous Loads based on the requirements.

Environment: Informatica Power Center 9.6.1/8.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Informatica Dashboard, Data Flux, Informatica DVO, Tidal Scheduler, Oracle 10g/11i,SQL, PL/SQL, UNIX, DB2, Toad, MS Quality Center, MS Visio

Confidential, Bloomington, Illinois

Sr. ETL Developer

Responsibilities:

• Understanding the requirement stated in the Requirement specification document.
• Devise the design logic and preparation of the ETL design document
• Getting the design document discussed and approved
• Worked with Peoplesoft team to finalize the structure of the files
• Developed the ETL for various modules by implementing the business rules.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources
• Implementing business logic using various Informatica transformations like Normalizer, joiner, union, SQL transformation, Stored Procedure transformation, Aggregator, etc.
• Created reusable transformations and used them in mappings.
• Written SQL override queries in source qualifier and lookups to customize mappings.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Fine-tuned existing mappings for performance optimization.
• Used QMF and SQL developer for writing and validating the complex queries as per the business logic and requirements.
• Performed Unit testing and moved the data into QA.

Environment: Oracle 11g, Informatica 9.1 hotfix 6, QMF,db2, Peoplesoft, SQL developer, Flat Files, Windows server 2012, WinSCP

Confidential, Colorado Springs, CO

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements.
• Involved in developing the logical andphysical data models using Erwin.
• Involved in staging the data from external sources and was responsible for moving the data into the Warehouse using ETL Informatica.
• Used SCD2 to populate the data in a generic way. Single mapping is used to load multiple tables’ data.
• The scope of this design includes a generic design for implementing tables whose content will be managed in part by end-users of the Data Warehouse. The content changes can be made via the standard production change request process.
• Created mappings using flat files and relational databases as sources to build update Mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Written SQL override queries in source analyzer to customize mappings.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• As the requirement is to maintain the history of every change for all columns, have implemented the slowly changing dimension type 2 with effective start and end date of the record.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.

Environment: Informatica Power Center 9.5/9.0/8.6.1 , Power Exchange 8.6.1, MS SQL server2005/2008, Oracle 11g, PL/SQL,SSIS,TOAD, Flat Files, Windows XP, Unix.

Confidential, Grand Rapids, MI

Sr. Informatica Developer

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked with PeopleSoft database as source
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with all phases of the Software Development Life Cycle (SDLC).
• Extracted the data from Flat files and loaded the data into Data warehouse using Informatica PowerCenter.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Created shortcuts for source and target.
• Created Reusable Transformations in Shared folder.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Various kinds of the transformations were used to implement simple and complex business logic.
• Transformations used are: Procedure, connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Developed application support documentation accepted by systems changes into production.
• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Working with Business Analyst, translating business requirements into functional requirements.

Environment: Informatica (Power center 8.6.1/9.0.1 , ), Workflow Manager, Informatica Designer, Oracle, SQL server, Teradata, Guidewire DataHub, SQL, BO, Windows XP.

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange to develop the marketing data mart.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with Data modeler to restructure the data mart according to changes in the model worked on changes in the Informatica.
• Extensively worked with Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed mappings in Informatica PowerCenter to load the data from various sources using transformations
• Extracted data from fixed width flat files to load into the Oracle staging area and then to the data mart.
• Strong understanding in analyzing insurance services and meet OLAP requirements through necessary architecture.
• Created views, triggers, stored procedures and functions for analyzing data.
• Created and configured the sessions for work flow. Created and maintained parameter files for workflows in UNIX.
• Worked on Joiner, Aggregator, Update Strategy, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Implemented slowly changing dimensions - Type I, II & in different mappings as per the requirements.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts and conducted data masking on testing environment to protect sensitive data.

Environment: Informatica Power Center 9.1, Oracle 11g, Flat files, UNIX, Shell scripting, SQL Developer, BO, Windows.

Confidential, FL

Informatica Developer

Responsibilities:

• Involved in extraction of data from various sources like flat files, Oracle and SQL Server.
• Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Created Entity relationship diagrams, function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Created SQL tables with referential integrity and developed queries using SQL.
• Created complex mappings involving Filter, Router, Expression, Lookup, Update Strategy, Sequence generator, Joiner and Aggregator transformations.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Extensively used all the features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Implemented various workflows using transformations such as Filters, update strategy, look up, aggregator, stored procedure and scheduled jobs for different sessions.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Used PMCMD command to automate the PowerCenter sessions and workflows through UNIX.
• Documented ETL development standards as per client requirement.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.

Environment: Informatica Power Center 8.3, Oracle 10g, SQL, PL/SQL, TOAD, Shell Scripts, UNIX (AIX), Erwin.

Confidential

Software Engineer

Responsibilities:

• Created the mappings according to the design documents.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
• Created workflows.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented Error handling logic to capture the invalid data.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Performance tuning of Oracle PL/SQL Scripts.
• Designed and developed UNIX shell scripts.

Environment: Informatica Power Center 8.3, flat files, Oracle 10g, SQL, PL/SQL, TOAD