SUMMARY

• Over7yearsofprofessionalexperienceinITindustry with extensive experience in the field of Enterprise Data Warehousing(EDW) and Data Integration.
• WorkedonAgile,WaterfallandvariousotherSoftwareDevelopmentLifeCycle(SDLC)modelsand ExperienceinDevelopment,Design,TestingandMaintenancephase.
• Analyzed, designed and developed Extraction, Transformation and Load(ETL)process for Data Warehousing using Informatica Power Center 9.x/8.x/7.x/6.x including Designer, Repository Manager, Server Manager, WorkflowManager,WorkflowMonitor,SSISandOWB.
• ExpertiseinClient - ServerapplicationdevelopmentusingOracle11g/10g/9i/8i,PL/SQLand SQL*Plus.
• Experience in creating various transformations using Aggregator, Lookup, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, and Stored Procedure in Informatica Power Center Designer.
• Experience in extraction of data from multiple operational sources of loading staging area and data marts using SCD(Type1/Type2/Type3)loads in ETL tools like Informatica and AbInitio.
• Developed AbInitio graphs to extract Enterprise Data Warehouse to create Data marts
• ExperiencedinPerformanceofMappingOptimizationsinInformaticaandexpertiseinhandlingtypicaltechnical Issues for best performance to meet customer satisfaction.
• StrongexperienceonwritingUNIXShellScripting.Designed and developed numerous graphs using Ab Initio and written numerous wrapper scripts(korn shell) to automate jobs.
• Experiencedininteractingwithbusinessusers,businessanalysts.ITleadsanddevelopersinanalyzingbusiness Requirementsandtranslatingrequirementsintofunctionalandtechnicaldesignspecifications.
• UsedQualityCenter10.00asTestmanagementandDefectresolutiontool,includingloggingdefects,attaching Evidenceandretestingthedefect.
• Working in a Developmentprofile,creatingrules/mapplets,mappingsusingtransformations like standardizer, match,parser,labelerandSQL,profilesandscorecardsinIDQ9. X developerandAnalyst.
• ExperiencewithCMSreportingforMedicare/Medicaid.
• Coordinatedwithsourcesystemowners,day-to-dayETLprogressmonitoring,ETLTechnicaldocumentationand maintenance.
• Proficient in using Cloud era Manager, an end to end tool to manage Hadoop operations.
• WorkingknowledgeHDFS,MapReduceandHadoopframework.
• Experience in using Amazon Web Services that includes Redshift, EC2 and S3.
• Involvedinarchitecture,design,developmentandimplementation ofHadoop employment,backupandrecovery systems.
• InvolvedinloadingdatafromLINUXfilesystemtoHDFS.ImportingandexportingdataintoHDFSandHive.
• WrotePigScriptstogenerateMapReducejobsandperformedETLproceduresonthedatainHDFS.
• TookadditionalresponsibilityandworkedasBusinessObjectDeveloperusingtoolssuchasWebIntelligence,CentralManagementServer(CMS)andCentralManagementConsole(CMC).
• ExperienceinvarietyofindustriessuchasHealthcare,BankingandFinancialMarket.
• Project managementcapabilitywithability tomultitask, team-oriented approach andstronginterpersonal andcommunicationskills.

TECHNICAL SKILLS

ETL Tools: InformaticaPowerCenter9.x/8.x/7.x

Databases: Oracle 9i/10g/11g, SQL Server 2000/2005/2008, Sybase, IBM DB2, Teradata, MS Access2000

Business Intelligence: BusinessObjects6.5/6.0/5.1/4.1 (Web-Intelligence2.5, Designer5.0, and Developer Suite Tools SetAnalyzer2.0)Dimensional Data

Modeling: Dimensional Data Modeling, Erwin Modeling (Erwin 4.0/3.5.5/3.5.2,OracleDesigner) Star Join Schema/Snow flake modeling, FACT &Dimension stables, Physical &logical data modeling, Star &Snow flake schema Relational, dimensional and multidimensional modeling And De-normalization techniques

Programming: SQL, PL/SQL, Java, HTML, XML, UNIXShell Scripting

Tools: MS Project 2013, Quality Center, Toad, Win SCP, SQL Developer, Quality Center9.1, Putty

Rational Products: RPM, RQM and Rational Rose.

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential

Responsibilities:

• Developed, documented and executed unit test plans for the components.
• Worked with Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filters, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Documented the developed code, run the sessions and workflows, while keeping track of source and target row count.
• Created mapping sheet for all the ETLs.
• Used performance tuning techniques to minimize the run time and create pre-session caches with good load being balanced on server.
• Created workflows containing command, email, session, decision and a wide variety of tasks.
• Used Autosys to schedule the workflow.
• Performed batch job entries and batch job tests.
• Reviewed the design and requirements documents with architects and business analysts to finalize the design.

Environment: Informatica Power Center 9.6.1/ 9.5.1, Oracle 11g, XML files, PL/SQL, IBM DB2 Client, Unix.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Interacted Participated in the Design Team and user requirement gathering meetings.
• Performed business analysis and requirements per high end users and managers and performed requirement gathering.
• Developed Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, merge etc
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
• Used Star Schema approach for designing of database for the data warehouse.
• Developed a standard ETL framework to enable the reusability of similar logic across the board.
• Created different target definitions using warehouse designer of Informatica Power Center.
• Used mapping designer to generate different mappings for different loads.
• Created different transformations such as Joiner Transformations,Look-up Transformations, Rank Transformations, Expressions, Aggregators andSequence Generator.
• Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.
• Extracted source data from Oracle, Flat files, XML files using Informatica, and loaded into target Database.
• Created medium to complex PL/SQL stored procedure for Integration with Informatica using Oracle 10g.
• Developed complex mapping also involving SCD Type-I, Type-II, Type-III mapping in Informatica to load the data from various sources.
• Extensively transformed the existing PL/SQL scripts into stored procedures to be used by Informatica
• Mappings with the help of Stored Procedure Transformations.
• Involved in extensive Performance Tuning by determining bottlenecks in sources, mappings and sessions.
• Created Models based on the dimensions, levels and measures required for the analysis.
• Extensively used Amazon Web Services like Redshift, EC2 and S3
• Developed graphs using Ab Initio's Graphical Development Environment (GDE) for client requirement
• Experience with various Ab initio components such as Rollup, Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, Join.
• Validate the data in warehouse and data marts after loading process balancing with source data.
• Worked closely with the business analyst's team in order to solve the Problem Tickets, Service Requests.
• Helped the 24/7 Production Support team.

Environment:InformaticaPowerCenter9.1,Ab Initio GDE 1.15, Co>OS 2.15,Oracle11g/10g,MSSQLServer,TWS,UNIX

Confidential, Los Angeles, CA

Informatica Developer

Responsibilities:

• Gathered report requirements with Business Users and converted them into project documentation.
• Arrived at the dimension model of the OLAP data marts in Erwin.
• Optimized/Tuned mappings for better performance and efficiency.Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
• Maintain Development, Test and Production mapping migration using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Worked on System Analysis & Design of process/data flow.
• Worked on Teradata SQL and Utilities like MLOAD, FASTLOAD.
• Populatingthe business rules using mappings into the target tables.
• Translated the PL/SQL logic into Informatica mappings. Extensively worked on Database storedprocedures and views.
• Configured Informatica Real time workflows to capture CDC.
• Locate data rapidly with flexible object filtering techniques to reduce errors and speed development with a point-and-click interface using PowerExchange.
• Created Informatica Power Exchange Data Map and Registration on Mainframe source files and tablesand importing them to Informatica shared folder.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures. Performed testing as per UTC.
• Implemented optimization techniques for performance tuning and wrote Pre & Post session shell scripts.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improveperformance.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked on Data Extraction, Transformations, Loading, Data Conversions and Data Analysis.

Environment:InformaticaPowerCenter9.5/9.1,PowerExchange9.5/9.1,Teradata13,Oracle11g,Erwin8,Putty,SunSolaris,Rally,Basecamp,WinSCPandSCM.

Confidential, Wakefield, MA

ETL Developer

Responsibilities:

• Participated in requirements gathering. Understanding business needs and implement the same into a functional database design.
• Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
• Worked with various file formats like fixed length and delimited. Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
• Extensively used Informatica to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto DataWarehouse.
• Developed number of complex Informatica mappings, mapplets and reusable transformations to implement the business logic and load the data incrementally.
• Used Debugger to track the path of the source data and to check the errors in mapping.
• Handled slowly changing dimensions of Type 1 and Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter and source qualifier and data flow management into multiple targets using router transformations.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better sessionperformance.
• Document the process for further maintenance and support. Worked on test cases and use cases.

Environment: InformaticaPowerCenter8.6,SQLServer2008,Oracle11g,UNIX,SunSolaris,Harvest,Remedy, Jira, Putty,Winscp,BaseCamp,Erwin8.5,Toad.

Confidential, Seattle, WA

Informatica Developer

Responsibilities:

• Extensively interacted with the user and involved in determining the data needed to address business users analytical requirements and design data mart to support these analysis.
• Involved in handling and selecting heterogeneous data source like Oracle, DB2, SQL Server and Flat files.
• Worked with Unified Modelling Design concept to design platform independent modelling.
• Worked extensively in translation of business requirement into data warehouse design and developed ETL logic based on the requirement using Informatica Power Center 8.1
• Contributed in logical and physical design of dimensional modelling and created 3rd Normal Snowflake Schema.
• Extensively worked with all the client components of Informatica like RepositoryManager, Designer, Workflow Manager, Work flow Monitor.
• Developed complex mappings to populate and incrementally load the source data to the staging area using Joiner, Sorter, Connected Lookup, Router, Filter, Update Strategy, Expression using Informatica Designer taking into consideration of maximize performance.
• Developed ETL design using various transformations like Source Qualifier, Aggregator, Sorter, Joiner, Lookup, Stored Procedure, Router, Filter, Transaction Control, Sequence Generator, Expression, JAVA and XML as per necessity for source to target data mappings and to load the target table.
• Worked extensively with variables and parameters files in the mapping and in the session to pass the value and to control the environment and source, target information.
• Contributed in performance tuning of the existing project from source to target level and debugged invalid mappings using break points, testing the stored procedure, functions, sessions, and batches and checking the target data.
• Used shell script to handle flat files in the source level.
• Worked with stored procedure and packages in PL/SQL and Unix Shell Scripting for automated execution of the job in the production environment.
• Wrote complex queries in SQL and PL/SQL.
• Used pm cmd commands to execute the tasks, populate parameter files, and Unix Shell Scripts for the automation of the design.
• Involved in various level of performance tuning in Informatica from mapping level to sessionand parallel processing.
• Involved in designing the complete Decision Support System using Micro Strategy by creating different types of reports for trend analysis using filter, conditions and calculations.

Environment:InformaticaPowerCenter8.6,PowerExchange,Metadata,SSIS,Teradata,UNIX,Oracle,Mainframes, FlatFiles,XML,VSAMFiles,SequentialFiles.

Confidential, St. Louis, MO

ETL Developer

Responsibilities:

• Worked extensively on transition project and onshore-offshore delivery model.
• Gathered the system requirements and created mapping document which gives detailed information about source to target mapping and business rule implementation.
• Designed, developed and debugged ETL mappings using Informatica designer tool.
• Created complex mappings using aggregator, expression, joiner, filter, sequence, procedure, connected and unconnected lookup, filter and update strategy transformations using informatics power center designer.
• Extensively used ETL to load data from different sources such as flat files, XML to Oracle.
• Worked on mapping panel meters and variables for the calculations done in aggregator transformation.
• Implemented slowly changing dimension for accessing the full history of accounts and transaction information.
• Tuned and monitored Informatica workflows using Informatica of workflow manager.
• Scheduled the jobs using third-party scheduler tool Autosys.
• Implemented the National City standard data population method loading the data into new set of tables after successful completion of the data loading, rolled over to original tables. This concept used to high-level ability of the data to users at the time of the data loading instead of users to wait to run their reports.
• Designed and developed universes for report generation from warehouse database using business objects.
• Resolved loops by creating aliases and contexts.
• Created different types of reports like list, cross tab and etc.

Environment:InformaticaPowerCenter8.6,SAPBusinessObjects,XIR3,Oracle11g/10g,MSSQLserver,TOAD, Erwin,UNIXandWindows.