SUMMARY

• Seven plus (7+) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Healthcare, Insurance, Financial and Telecom Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.5/9.1/8.6.1/8.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2012/2008/2005 , DB2 8.0/7.0 and Teradata. Have a clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Developed and used Informatica MDM Components for data governance projects and data integration projects and performed Dimensional modeling extracted reports using Cognos.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Active Batch and Redwood.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating Systems: Windows 10, 8, 7, XP, UNIX

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), SSIS, MDM.

Database Tools: SQL Server 2012/2008/2005 , Teradata, Oracle 11g, 10g.

Data Modeling Tools: Erwin, MS Visio

OLAP Tools: Cognos 8.0/8.1/8.2/8.4/7.0/ , Business Objects XI r2/6.x/5.x, OBIEE 10.1.3.4/ 10.1.3.3

Languages: Java, C++, Visual Basic.Net, JavaScript, HTML, SQL, HTML5, Adobe Illustrator, InDesign, SharePoint.

Web/Apps Servers: IBM Web Sphere, Sun iPlanetServer, IIS, Tomcat

Methodologies Tools: Waterfall, Agile and Scrum methodologies

Testing Tools: JIRA

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. Informatica Developer

Responsibilities:

• Involved in gathering and analysis business requirement and writing requirement specification documents and identified data sources and targets.
• Created Design Specification Documents including source to target mappings.
• Translated Business Requirements into Informatica mappings to build Data Warehouse by using Informatica Designer, which populated the data into the target.
• Extracted data from various source systems like Oracle, SQLServer, XML and flat files and loaded into relational data warehouse and flat files.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure and more.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Modified the existing worklets and workflows to accommodate for these new sessions and mappings. Created the break points in the designer and worked with debugger.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Debugged and resolved load failures by verifying the log files. Supported QA Testing in fixing the bugs and also helped to resolve various data issues.
• Maintained a very good interaction with analysts, Project Managers, architects and testers to have efficient and better results.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Partially involved in writing the UNIX Shell Scripts, which triggers the workflows to run in a particular order as a part of the daily loading into the Warehouse.
• Provided 24x7 production supports for business users and documented problems and solutions for running the workflows.

Environment: Informatica Power Center 9.5, Oracle 11g, MS SQL Server, TOAD, PL/SQL,SQL, Flat Files, XML, UNIX Shell Scripting, Windows 7/8, MS Office (Word, Excel, Powerpoint).

Confidential, Bloomington, IL

Sr. Informatica Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Responsibilities included designing and developing complex informatica mappings including Type-II slowly changing dimensions.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Extensively used TOAD to analyze data and fix errors and develop.
• Involved in the design, development and testing of the PL/SQL Analyzed the requirements and framed the business logic for the ETL process.
• Involved in the ETL design and its documentation.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system using ER-STUDIO.
• Followed Star Schema to design dimension and fact tables.
• Experienced in handling slowly changing dimensions.
• Collect and link metadata from diverse sources, including relational databases Oracle, XML and flat files.
• Responsible for the development, implementation and support of the databases.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Developed reusable Mapplets and Transformations.
• Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Scheduled the tasks using Autosys.
• Loaded the flat files data using Informatica to the staging area.
• Created SHELL SCRIPTS for generic use.
• Created high level design documents, technical specifications, coding, unit testing and resolved the defects using Quality Center 10.
• Developed unit/assembly test cases and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort.

Environment: InformaticaPowercenter 9.1, UNIX, Teradata V-14, Oracle 11g, SQL, PL/SQL, ER-win, Oracle Designer, MS VISIO, Autosys, Korn Shell, Quality Center 10,Windows 7/8, MS Office (Word, Excel, Powerpoint).

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using InformaticaPowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using InformaticaPowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql,router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: InformaticaPowerCenter Designer 8.6.1, Informatica Repository Manager, Oracle10g/9i,DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H,Unix- SunOS, PL/SQL,WindowsXP/7, MS Office (Word, Excel, Powerpoint).

Confidential

Informatica developer

Responsibilities:

• Providing technical solutions to different problems of clients by taking help of different tools.
• Experience in developing mapping in designer, workflow manager and monitor in Informatica 9.1.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Ensure that the call comments are properly arranged and suitable information is provided to clients.
• The standard of each call should be properly maintained in a comprehensive manner taking into view each aspect of attending the customer, listening to their problems and offer appropriate solutions to them.
• Technical support and responsible for working with computer hardware and software for resolving the troubles that may arise within an organization.

Environment: Informatica 8.1, Oracle 10g, SQL Server 2005, Windows XP/7, MS Office (Word, Excel, Powerpoint).