SUMMARY:

• 10+ years of software experience with specialization in the Data Warehousedevelopment life cycle project and support.
• Experience in Extraction, Transformation, and Loading (ETL) using Informatica PowerCenter 9.x/8.x/7.x
• Hands on experience in Optimizing Database querying, data manipulation and population using SQL and PL/SQL in Oracle, flatfilesand DB2 UDB and SQL Server databases.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and Data marts and Data warehouse.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling, process mapping using the top-down and bottom-up approaches, Fact and Dimension tables.
• Worked with Teradata loading utilities like Multi Load, Fast Load, TPUMP and BTEQ.
• 4 years of experience in Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, ROLAP, MOLAP, Fact andDimension tables using MS Visio & Erwin r8/7.5/4.0.
• 3 years of experience in designing and development of change data capture using Informatica PowerExchange 9.1/8.6.
• Experience in using UNIX shell scripts.
• Hands on experience on OBIEE 11g/10g to generate various reports.
• Worked on various components of OBIEE DAC, Interactive Dashboard, Answers, BI Publisher and Disconnected Analysis.
• Expert in SQL, PL/SQL, Procedures/FunctionsandTriggers.
• Experience in Data warehouse OLAP reporting using various BI tools OBIEE.
• Have good problem solving, time management skills, communication skills, self-motivated, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.5/9.1/8.6/8.1/7. x, Informatica PowerExchange 9.5/9.1/8.6

Data Modeling: Erwin r8/7.5/4.0, Visio

Databases: Oracle 11g/10g/9i,SQL Server 2007/2000, Teradata 13/V2R5, DB2 8

Big Data: Hadoop, HIVE, SQOOP

Languages: C++, C, Visual Basic, SQL, PL/SQL, .Net,UNIX Shell scripting

Operating Systems: LINUX, Sun Solaris, UNIX, Windows 95/98/2000/XP/7

Tools: Toad 11/9.1, SCM, Putty, WinScp, BaseCamp 4.1.1, Rally

BI/OLAP Tools: OBIEE 11g/10g, Business Object XI/6.5

PROFESSIONAL EXPERIENCE:

Confidential, Everett, WA

Sr. Informatica Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the different system owners / analysts and created specification document.
• Informatica up-gradation from the olderversion to the newerversion. (Informatica Power Center 9.1/9.5)
• Wrote oracle-storedprocedures to improve performances in the stagingarea.
• Tuning the oracle queries / processes to improveperformance.
• Prepared ETLdetaildesign and unittesting document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Worked on the datasynchronization and custom integration to create application task in InformaticaCloud data Integrationplatform.
• Worked with Type 1 and Type2 Dimensions and Data warehousing Change Data Capture (CDC)
• To design Profile, Endpoints, Partners, Accounts, Workflows using InformaticaB2BDataExchange.
• Involved in Information administration including creating new users, groups and folder.
• Created Informatica PowerExchangeregistration, datamap, configuringconnection, recovery and tokens.
• Extensively involved in performancetuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems, this led to a bettersessionperformance.
• Migrating the Informatica from the UNIX server to Linuxserver.
• Involved in creating the runbook and migration document (from Development to Production).
• Documented the process for further maintenance and production support.
• Coordinated the ChangeManagementprocess, which involved driving the QA and production deployments.
• Aided in migrating the code across various environments.
• Provided production support by running the jobs and fixing the bugs.
• Involved actively in Production system enhancement and documented the scope of new potential development projects.
• Involved in writing and modifying UNIX shell scripts.
• Worked with dataquality team to fix the production data issues and also provide solutions to the business.
• Coordinated with offshore team to support the existing ODS system jobs.
• Used Toad for query execution, SQL tuning, data quality verification and unit testing the data.
• Performing PeerReviews and participate in Knowledge Management activities
• Worked on productionsupport, Prioritization of Prodissues, Modification of code, proactively fixing issue and job monitoring
• Monitoring and reporting project and support metrics and service level agreements.
• To produce artifacts (technical specifications, architectural specifications, data models, Installation andconfigurationguides, and release notes) for the software development process.
• Experience working with agile development and task management (Rally)

Environment: Informatica Power Center 8.1/9.1/9.5, Informatica PowerExchange 8.1/9.1/9.6, Oracle 10g/11g, Teradata V2R5/12, Linux, Putty, Toad, Erwin 8, MQ Series, SCM, Jira, OBIEE 11g, Agile, Rally, Basecamp, TFS, SCM, Hive, HADOOP, Tidal.

Confidential, Agawam, MA

Informatica Lead Developer

Responsibilities:

• Involved in coordinating with business users, business analysts, DBA’s for requirement gathering and understand the needs and to implement the same in designing the data ware house.
• Prepared technical specifications based on the business requirements to develop Informatica mappings to load data into data warehouse confirming the business rules.
• Assisted with the data modelers in designing logical / physical data models using Erwin.
• Used Informatica for extraction, transformation and load the data into the data warehouse.
• Developed mapping using Informatica designer to load the data from various source systems like Oracle, Excel Spread Sheets, Delimited Flat files etc.
• Prepared SQL queries to validate the data in both the source and the target systems.
• Extensively worked in manipulating the data by using various Active and Passive transformations like source qualifier, expression, union, joiner, aggregator, sequence generator, lookup, router, update strategy etc.
• Tuned the existing mappings and sessions to perform better using different logics to provide maximum efficiency and overcome the bottlenecks at various level.
• Created the sessions and the workflows and scheduling them on daily and weekly basis.
• Submitted status reports to the concerned business managers on weekly basis.
• Used Teradata utility BTEQ to extract data from Sales Data warehouse.
• Used UNIX shell scripts to automate daily and weekly runs and execute Pre and Post session commands.
• Involved in database development by creating PL/SQL functions, procedures, triggers and packages to increase the performance.
• Responsible in migrating the mapping, workflows and Informatica objects in various environments and testing the process in each environments.
• Involved in Unit testing, integration testing and in User Acceptance testing at the client location testing with the users, interacting with the business users and handling the changes.
• Developed UNIX shell scripts, Perl scripts to format the session log files and to extract the information from error logs.
• Generating SQL scripts for database objects like creating tables, indexes, views, sequences in development and production environment.
• Worked with production support team in troubleshooting and load failure cases
• Interacted with end users and reporting team to ensure the correct data is presented in the reports.

Environment: Informatica 9.5, Oracle 11g, SQL, PL/SQL, Teradata 13R2, Erwin, UNIX, XML, TOAD.

Confidential, Seattle, WA

Informatica Developer

Responsibilities:

• Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings.
• Developed ETLDesignDocuments, UnitTestCase Documents and Namingconventions documents.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse
• Created various folders, users and assigned permissions to them accordingly in Repository Manager.
• Provided productionsupport and involved with root cause analysis, bugfixing and promptlyupdating the business users on day-to-day productionissues.
• Created MQSource, Target and created connection for MQsource and target.
• Extracted message in form of XML from MQ.
• Truncated MQ channel through Informatica once data extracted and loaded successfully.
• Used XMLparser and Generator.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Developed Mapplets to implement business rules that involved complex logic.
• Analyzed the session logs, badfiles and errortables for troubleshooting mappings and sessions.
• Implemented slowly changing dimension methodology- Type I & II for modifying and updating account information and accessing themin different mappings as per the requirements.
• Performing ETL & database code migrations across environments.
• Created MappingParameters, Sessionparameters, MappingVariables and SessionVariables.
• Created complex Informatica mappings and reusableobjects such as Mapplets and reusabletransformations.
• Designed, built and maintained Business Objects reports. Created Masterdetail, Charts and Cross-tabsreports using functionality of BOs like Breaks, Ranks, Alerter, insertedCalculations, Filters, Sorts and query prompts to view data in ananalyzed way.
• Created mapplets in place of mappings which were repeatedly used like formatting date or data type conversion.
• Created Unittestplans and did unittesting using different scenarios separately for every process.
• Created various mappings like UpdateStrategy, Lookup, SequenceGenerator, expression, Aggregator, XML,StoredProcedure and tested the mappings for data verification in Designer
• Involved in monitoring Informatica jobs/processes using Workflow Monitor
• Tuned performance of Informatica sessions for large data files by increasingblocksize, datacachesize,sequentialbufferlength, and target based commitinterval.
• Analyzed the sessionlogs, bad files and errortables for troubleshootingmappings and sessions
• Working with the Business Analysts and the testing team for any changes in the requirements and validating the mappings andworkflows.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.

Environment: Informatica PowerCenter 7.1, Oracle 10g, DB2, Shell Scripting, TOAD, PL/SQL, UNIX, Informatica Scheduler, Business Objects 6, Sun Solaris.

Confidential, Greensburg, IN

ETL Developer

Responsibilities:

• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements
• Extensively used ETL to load data from different source systems like Oracle, Flat files and XML into the Staging table and load the data into the Target database.
• Developed complex mappings in Informatica to load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure and Router.
• Designed and developed Oracle PL/SQLprocedures, data conversions and data cleansing operations.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objectsand hierarchies.
• Worked with Shell scripts and pmcmd to interact with Informatica server from command mode.
• Scheduled the ETL jobs daily, weekly and monthly based on the business requirement.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Performed complexdefectfixes in various environments like UAT, SIT to ensure the proper delivery of the developed jobs into the productionenvironment.
• Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.
• Created restart token configured workflows and sessions for realtime Informatica objects.
• Attended productionimplementation calls and coordinated with the build engineers during migration of the code and was highly acknowledged.
• Promoted code across development, test, preproduction and production environment using Harvest.
• Co-ordinated with Offshore teams and Involved in different Team review meetings.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Wrote UNIX shell scripts to customize the server scheduling jobs.
• Participated in Technical and Codereview meetings as the mappings are developed and tested.
• Developed Mapplets to implement business rules that involved complexlogic.
• Created and scheduled Sessions and Workflows through the Informatica Workflow Manager.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performancetuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
• Implemented Performance tuning on various stages in workflow.
• Used TOAD as a front-end tool, to issue SQL commands against Oracle RDBMS.
• Tuned the mappings and sessions for better performance by eliminating various performancebottlenecks.

Environment: Informatica PowerCenter 6.5, ERwin 3.5, Oracle 10g, DB2 6.0, PL/SQL, Shell Scripting, UNIX, LINUX, Windows 2000, Win NT 4.0

Confidential, Greensburg, IN

Project / Process Engineer

Responsibilities:

• Established stable process for new trials and materials by using DOE and SPC principles
• Conducted mold trials and performed test runs according to established processes
• Actively involved in various part design and mold design projects
• Supervised two maintenance technicians and managed cleaning and preventive maintenance to significantly increase department productivity
• Planning and executing daily and monthly schedule for both molding and deflashing departments. Tightened control of molding and deflashing to meet monthly production requirements.
• Regulate and purchase all molding supplies and resins
• Responsible for conducting and recording quarterly inventories in order to in corporate and evaluate cost reduction projects.
• Manage and schedule an average of 5 to 7 mold changes per day.
• Scheduled orders, performed quality inspections, and tool maintenance
• Conducted project for validating entire stock of male/female core-pins to update the system drawings
• Using Moldflow simulations solved issues like venting and non-fill for a thin walled insulator part

Environment: Microsoft Office (Word, Excel, Project, PowerPoint), Share point, Microsoft Access, Visio, VB Script, Oracle 9i, PL/SQL, CAD systems (CATIA, Solid Works, ProE), and MoldFlow.