SUMMARY:

• Have ;7+ years ;of IT experience working in Database/Data Warehousing Technology, analysis, designing, development and implementation of business systems in various environments.
• 6+ ;years of experience in development and maintenance of ;SQL, PL/SQL, Stored procedures, functions, constraints, indexes ;and ;triggers.
• 6+ ;years of experience in using different versions of ;Oracle ;database like ;10g/9i/8i.
• Around ;4+ ;years of experience in ;UNIX Shell Scripting.
• Experience ;in creating ;batch scripts ;in ;DOS ;and ;Perl ;Scripting.
• Experience in ;ETL development ;process for ;Data Warehousing, ;Data migration ;and ;Production support.
• Extensive experience in Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in ;Pharmaceutical, ;Health Care, Insurance, Financial ;and ;Telecommunication ;industries.
• Involved in requirement gathering, design, development and implementation of data warehouse projects.
• Sound knowledge of ;Relational and Dimensional modeling ;techniques of Data warehouse ;(EDS/Data marts) ;concepts and principles ;(Kimball/Inmon) Star/Snowflake schema, SCD, Surrogate keys ;and ;Normalization/De-normalization.
• Data modeling experience ;in creating ;Conceptual, Logical ;and ;Physical Data Models ;using ;ERwin Data Modeler.
• Experience with ;TOAD ;to test, modify, analyze data, create indexes, and compare data from different schemas.
• Extensively worked on Development using ;SQL ;Developer, ;SQL*Loader ;and ;TOAD ;tools.
• Extensive experience in designing and creating data marts using ETL tool ;Informatica.
• Expertise in designing and developing ETL Informatica Mappings, Sessions and Workflows using ;Informatica 7.1, 8.1, 8.6 and 8.6.1 ;(Designer, Workflow Manager and Workflow Monitor).
• Extensive experience in developing Extracting, Transforming and Loading ;(ETL) ;processes using ;Informatica PowerCenter ;and full life cycle implementation of data ware house.
• Worked on ;Slowly Changing Dimensions (SCD\'s) ;Types -1, 2 ;and ;3 ;to keep track of historical data.
• Knowledge in ;Data Analyzer ;tools like Informatica ;Power Exchange (Power Connect) to capture the changed data.
• Proficiency in data warehousing techniques for data cleansing, ;surrogate key ;assignmentand ;Change data capture (CDC).
• Proficient with ;Informatica Data Quality ;(IDQ) ;for cleanup and massaging at staging area.
• Experience in integration of various data sources like ;Oracle, DB2, Flat Files ;and ;XML Files into ODS ;and good knowledge onTeradata 12.0/13.0, ;SQL Server 2000/2005/2008 ;and ;MS Access 2003/2007.
• Proficient in using Informatica tools like Informatica ;Designer, Repository Manager, Workflow Manager ;and ;Workflow Monitor.
• Expertise in implementing complex business rules by creating re-usable transformations, Mapplets and Mappings.
• Optimized the Solution using various performance tuning methods ;(SQL tuning, ETL tuning (i.e. optimal configuration of transformations, Targets, Sources, Mappings and Sessions), Database tuning using ;Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions).
• Extensively performed ;Performance ;Tuning ;of sources, targets, mappings and sessions.
• Experience in ;UNIX shell scripting ;and configuring ;Cron jobs ;for ;Informatica job ;scheduling, backup of repository and folder.
• Extensively used ;Autosys ;and ;Tidal ;for scheduling the ;UNIX ;shell scripts and Informatica workflows.
• Experience in using the Informatica command line utilities ;like pmcmd, pmrepserver ;and ;pmrepagent ;to execute or control sessions, tasks, workflows and deployment groups in non-windows environments.
• Extensive knowledge in ;reporting ;tools ;such as ;Cognos ;and ;BussinessObjects.
• Extensive knowledge in creating universes, Reports, Dashboard KPI’s and Adhoc reports using Business objects.
• Extensive knowledge in all areas of ;Project Life Cycle ;including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Strong ;analytical, verbal, written ;and ;interpersonal ;skills.
• Proactive in learning new technologies and ;updating ;my skills.

• Data Modeling Tools: ;ERwin, MS Visio.
• Data Management and Integration: ;VLTrader V4.2
• ETL Tools: ;Informatica PowerCenter 8.x/ 7.x/6.x, PowerExchange, IDE/IDQ.
• OLAP/Reporting Tools: ;Cognos 8.1, Business Objects XI/6.5.
• Databases: ;Oracle 10g/9i/8i, SQL Server 2000/2005/2008, Teradata 12.0/13.0, DB2 (UDB) 8.1.
• Database Utilities: ;WinSQL, Toad, SQL*Loader, SQL Developer, SQL*PLUS, WinSCP.
• Operating Systems: ;UNIX (Solaris 8/10), LINUX, Windows NT, 2000, XP, 2003, Win server 2008.
• Languages: ;T-SQL, SQL, PL/SQL, C, C++.
• Scheduling Tools: ;Tidal, Autosys, Crontab and Control-M.
• Methodologies: ;Data Modeling Logical/Physical/Dimensional, Star/Snowflake schemas, Fact and Dimension Tables, Software Development Life Cycle.

EXPERIENCE

Sr. Informatica ETL developer ;Jan 2012- Till Date
Confidential, Parsippany, NJ

Responsibilities:

• Analyzed the business requirement and designed the ETL process to ;generate ;and ;integrate ;the processed ;claims ;data ;for ;the Contract Rebate System Integration Project of ;DSI ;with ;a ;vendor.
• Source was CARS database on Oracle and targets were pipe-delimited flat files.
• Edited the views and created new views according to the business requirement.
• Designed ;the ;staging ;table’s ;structure and created the tables on Oracle database to ;minimize ;the ETL design ;mappings ;complexity.
• SQL Query override used in Source Qualifier transformation and lookup transformations to reduce the complexity of the mappings.
• Worked with ;Expression, ;lookup, ;filter ;transformations and ;flat file targets.
• Parameterized the whole process by using the ;parameter ;file ;for the variables.
• Used command task for the recreation of parameter files.
• Created the ;deployment groups ;in development environment.
• Tidal ;Scheduler was implemented for scheduling of Informatica workflows.
• Interact ;with the vendor and ;set up ;the SFTP connection to the vendor’s ftp site for transferring extracted files.
• MFT (managed file transfer) ;was used for the transmission of the extracted files to the vendor.
• Set up SFTP connections to various vendors for ;receiving ;and ;sending ;of ;encrypted ;data ;as part of MFT Integration team support.
• Involved in ;Unit ;testing and ;system integration testing ;(SIT) ;of Informatica and MFT projects.
• Created the ;mapping ;specification, ;workflow ;specification and ;operations ;guide for the Informatica projects and MFT run book as part of end user training.
• Involved in knowledge transfer sessions with off-shore team for the above mentioned projects.

Environment: ;Informatica PowerCenter8.6.1/ 8.1.1, Windows Server 2008, MS-SQL Server 2005, Batch Scripting, Oracle Database 10g, SQL Developer 3.0.04, Flat Files, MFT server (Managed File Transfer), VLTrader V4.2, Tidal 5.3.1.

Sr. Informatica Software developer ;Sep 2011-Dec 2011
Confidential, St. Louis, MO

Responsibilities:

• Developed the ;mapping specifications ;from the business requirements and the ;data model.
• Created Mappings to load data using various transformations like Source Qualifier, Sorter, Lookup, ;Expression, Router, Joiner, ;Filter, Update Strategy ;and ;Aggregator ;transformations.
• Worked specifically with the ;Normalizer Transformation ;by converting the incoming fixed-width files to ;COBOL workbooks ;and using the Normalizer transformation to normalize the data.
• Worked with Lookup Dynamic ;caches ;and Sequence Generator ;cache.
• Created ;Reusable Transformations ;and ;Mapplets ;to use in ;Multiple Mappings ;and also worked with ;shortcuts ;forvarious ;informatica repository objects.
• Enhancement ;of ;existing mappings ;and fixing and adding new ;transformations ;and ;new logic ;to them.
• Worked on all aspects of ;Teradata loading ;and ;query tuning activities.
• Used Teradata utilities like ;FastLoad, MultiLoad ;and ;Teradata SQL Assistant.
• Created ;DDL’s ;to ;create ;tables ;and ;views ;on Teradata.
• Split the source file using shell script and parse it to make independent files and load onto ;Teradata.
• Load data files coming from external vendors onto ;Teradata EDW ;using ;mload and fload ;utilities.
• Even used ;Teradata Parallel Transporter ;(TPT) for loading pipe delimited, comma delimited and fixed-width data files onto ;Teradata EDW.
• Created ;jobs ;and ;job variable files ;for Teradata TPT and load using ;tbuild ;command from command line.
• Worked with Informatica ;PowerExchange ;to pull the changed data in the form of ;Condense files ;and load into Teradata tables using Tpump import.
• Created ;Data Breakpoints ;and ;Error Breakpoints in ;InformaticaDesigner ;Debugger ;for debugging the ;maps ;and fix them.
• Converted ;workflows ;which used ;Relational ;connections to connect to Teradata with ;mload ;connections ;which ;drastically ;reduced ;the overall workflow ;run-time ;and ;improved performance.
• Created ;parameter files ;with ;Global, mapping, session ;and ;workflow ;variables.
• Extensively worked with ;Korn-Shell scripts ;for ;parsing ;and moving ;files ;and even for ;re-creating ;parameter ;files ;in post-session command tasks.
• Used ;sed, a UNIX utility in various shell scripts.
• Worked with ;Post-session on-success variable assignment ;in ;Informatica ;Workflow manager ;to assign variable values from the mapping to the workflow variables.
• Created re-usable, non-reusable ;sessions ;and ;Email tasks ;for ;on success/on failure ;mails.
• Analyzed the ;session logs, loader logs for Teradata mload and fload for errors ;and ;troubleshoot them.
• Scheduling ;of Informatica workflows using ;Tidal ;Scheduler.
• Migrate ;the code (workflows) from ;DEV ;to ;TEST ;Repositories in Informatica by creating deployment groups, folders, applying labels, creating queries in the ;Informatica Repository Manager.
• Maintenance ;and ;support ;for Informatica projects in Production.
• Team tag-up call in mornings with BO support ;to check on thelatest development on the projects in twice a month releases for Production.
• Available on call and ;provide ;assistance ;through ;VPN.

Environment: ;Informatica PowerCenter 8.6.0/8.6.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica PowerExchange, UNIX, Teradata13.0, Shell Scripting including ‘sed’, Pipe- delimited, CSV, Fixed-width Flat Files, Tidal 5.3.1.

Sr. Informatica ETL developer ;Feb 2011- Aug 2011
Confidential, Parsippany, NJ

Responsibilities:

• Analyzed the business requirement to generate the XML output for the Campaign Management project.
• Worked with XML targets for the data coming from SQL server source.
• Query tuning and SQL Query override used in Source Qualifier transformation to pull historical data from database not earlier than the given date.
• Worked with ;Expression, ;lookup, sequence generator, ;Normalizer, ;router ;transformations,

XML ;and ;flat file targets.

• Extensively used ;Perl scripts ;to edit the xml files and calculate line count according to the client\'s need.
• Worked with ;re-usable ;sessions, ;decision ;task, ;control ;task and ;Email ;tasks.
• Parameterized the whole process by using the ;parameter ;file ;for the variables.
• Used command task for the recreation of parameter files.
• Imported ;xsd file ;to create the xml target and create the ;Hierarchical ;Relationship and ;normalized ;views.
• Edited the views and created new views according to the business requirement.
• Designed and build a ;web services integration ;to download Forex currency data to flat files.
• Implemented the logic by using ;HTTP transformation ;to query the web server.
• Configure and setup a secure ;FTP connection ;to the vendor using the Informatica Managed File transfer software.
• Created complex ;Batch scripts ;for various set of actions in the MFT (managed file transfer) that would automate the process of executing the actions like validating the presence of indicator files and concurrently running the actions for successful transmission.
• Encrypting and compressing the xml and flat files using ;PGP Compression algorithm ;like ZIP and ;PGP Encryption algorithms ;like TripleDES, Blowfish, AES-256 and CAST5 using MFT.
• Pushing the compressed and encrypted xml files and flat files generated to the external vendor using MFT.
• Error solving in the mapping done by ;analyzing ;the ;session ;and ;workflow ;logs.
• Involved in ;Unit ;testing and ;system integration testing ;(SIT) ;of the projects.
• Created the ;deployment groups ;in development environment.
• Created jobs for automation of the Informatica Workflows and for DOS copy and moving of files using ;Tidal ;Scheduler.
• Created the ;mapping ;specification, ;workflow ;specification and ;operations ;guide for the Informatica projects as part of end user training.
• Maintenance ;and ;support ;for the above said projects in Production environment.

Environment: ;Informatica PowerCenter8.6.1/ 8.1.1, Windows Server 2008, MS-SQL Server 2005, Batch Scripting, Perl Scripting, XML Targets, Flat Files, MFT server (Managed File Transfer), VLTrader V4.2, Tidal 5.3.1.

Responsibilities:

• Analyze business requirements to build a data mart design for various business processes conformed to the business rules.
• Developed the ;mapping specifications ;from the business requirements and the ;data model.
• Proficient in writing ;SQL queries ;and ;creating PL/SQL stored procedures.
• Involved in Developing ;OLAP ;models like facts, measures and dimensions.
• Implemented change data capture(CDC) ;using ;Informatica PowerExchange ;to update tables in the oracle database.
• Used ;FTP ;services to retrieve ;Flat Files ;from the external sources and RDBMS sources ;Teradata ;and ;Oracle.
• Created Mappings to load data using various transformations like Source Qualifier, Sorter, Lookup, ;Expression, Router, Joiner, ;Filter, Update Strategy ;and ;Aggregator ;transformations.
• Created ;Data Breakpoints ;and ;Error Breakpoints ;for debugging the mappings.
• Created ;Reusable Transformations ;and ;Mapplets ;to use in ;Multiple Mappings ;and also worked with ;shortcuts.
• Implemented ;Type2 slowly ;changing dimensions ;(SCD).
• Designed complex mappings involving ;target load plan ;for ;pipeline loading ;and ;constraint based loading.
• Worked on all aspects of ;Teradata loading ;and ;query tuning activities.
• Used Teradata utilities like ;FastLoad, MultiLoad, FastExport ;and ;BTEQ.
• Extracted data from ;Teradata ;source systems to a ;flat file.
• Created ;parameter files ;and scheduled workflows.
• Worked with both serial and parallel loading and created re-usable, non-reusable ;sessions ;and ;Email tasks ;for ;on success/on failure ;mails.
• Worked with ;Workflow Manager ;for ;Creating, Validating, Testing ;and ;running the sequential ;and ;concurrent Batches ;and ;Sessions.
• Identified the errors by analyzing the ;session logs ;and ;solved them.
• Optimized mappings by performing ;Performance Tuning ;and informatica best practices.
• Maintenance ;and ;support ;for Informatica interfaces/projects in Production.
• Used ;pmcmd ;command to run workflows through shell scripts and command line.
• Created various UNIX ;Shell Scripts ;for pre/post session commands for automation of loads using ;Autosys.
• Involved in ;Unit testing ;and ;system integration testing ;(SIT).
• Created mapping ;documentation ;and ;user guides ;for ETL processes as part of end user training.
• Created and maintained ;Custom, Cross Tab ;and ;Drill Through reports ;for the client using ;Business Objects ;and generated reports using BO tools by querying the database.

Environment: ;Informatica PowerCenter 8.6, PowerExchange, Oracle 10g, Teradata 12.0 , SQL, PL/SQL, ERwin, Toad 9.6, WinSCP, UNIX (Solaris 10), Autosys, Business Objects XI/6.5.

Responsibilities:

• Created technical design specification documents for Extraction, Transformation and Loading Based on the business requirements.
• Developed ;logical ;data models and ;physical ;data modelswith experience in ;Forward ;and ;Reverse ;Engineering using ;ERwin.
• Designed and developed source to target data ;mappings. Effectively used informatica Best Practices / techniques for complex mapping designs.
• Experience in using ;FTP ;services to retrieve ;Flat Files ;from external sources.
• Worked with wide range of sources such as delimited ;flat files, ;XML sources, ;MS SQL server, DB2 ;and ;Oracle ;databases.
• Created ;complex mappings ;to transform the Business logic using ;Connected/Unconnected ;Lookups, Sorter, Aggregator, Update Strategy, Router ;and ;Dynamic lookup ;transformationsfor populating target tables in an efficient way.
• Used Power Center ;Workflow Manager ;to create ;workflows, ;sessions ;and also used various tasks like ;command, event wait, event raise, Email ;to run with the logic embedded in the mappings.
• Involved in creating and modifying ;UNIX shell scripts ;and scheduling through ;Crontab.
• Developed ;PL/SQL stored procedures ;for source pre load and target pre load.
• Developed sessions using Informatica Server Manager and was solely responsible for the daily loads and handling of the reject data.
• Created Shell Scripts to execute the sessions using ;pmcmd ;command line interface.
• Analyzed the ;session logs ;and ;solved ;the errorsfor successful completion of workflows.
• Troubleshoot mappings and ;performance ;tuning ;of mappings by identifying source, target and mapping bottlenecks.
• Used techniques like ;source ;query ;tuning, ;single pass reading ;and ;caching ;lookups ;to achieve effective performance in less time.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Involved in ;Unit testing ;and ;system integration testingand even conducted peer reviews.
• Provided support in creating ;List ;Reports, ;Cross Tab ;Reportsand ;Ad ;hoc ;reports using ;Cognos.

Environment: ;Informatica PowerCenter 8.6, Oracle 10g/9i, DB2 (UDB) 8.1, MS SQL Server 2008, PL/SQL, TOAD 7.6, XML, ERwin, WinSQL, WinSCP, Crontab, HP-UX 10.20, Windows NT 4.0/2000, Cognos 8.1.

Responsibilities:

• Understanding of the business requirements and enhancing the existing data warehouse architectural design for a better performance.
• Involved in High level design (HLD) and Low level design (LLD) documents.
• Used utility like ;SQL*Loader ;to load bulk data.
• Extensively used ;PL/SQL ;scripts for transformations.
• Developed new Mapplets and data transformation functions using Informatica PowerCenter to transform and populate data into data warehouse target tables from ;Oracle ;source tables as well as ;flat files ;and ;MS Access.
• Designed various mappings using transformations like ;Lookup (Connected and Unconnected), Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator and Expressiontransformations.
• Developed ;reusable ;transformations ;and ;mapplets.
• Designed complex mappings involving ;target load order ;and ;constraint based loading.
• Configured and ran the ;Debugger ;from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
• Created and fine tuned ;sessions ;by creating ;performance details ;on the ;Informatica ;server for a session and evaluated the performance details and identified the reason for ;slow performance ;in the source and the target databases.
• Extensively used various performance tuning techniques like ;pipeline partitioning ;to improve the session performance.
• Used ;pmcmd ;command to run workflows from command line interface.
• Set up batches and sessions to schedule the loads at the required frequency.
• Created ;UNIX Shell Scripts ;for pre/post session commands for automation of loads using ;Autosys.
• Actively involved in end user training and support.

Environment: ;Informatica PowerCenter 8.6, Oracle 10g, MS Access 2007, Toad, PL/SQL, ERwin, WinSQL, WinSCP, UNIX, Windows XP, Autosys.

Responsibilities:

• Extraction, Transformation and Load was performed using Informatica to build the data warehouse.
• Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Oracle Data warehouse.
• Source data was extracted from ;Oracle, SQL Server, flat files, COBOL sources ;and ;XML ;sources.
• Extensively worked with ;Informatica Designer, Workflow Manager ;and ;Workflow Monitor.
• Worked with ;Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence generator, Router, Update Strategy, Lookup ;and ;Normalizer ;transformations.
• Created complex ;joiners, transformations of all types as needed to smoothly pass data through ETL maps.
• Implemented ;Type1 ;and ;Type2 slowly changing dimensions (SCD) ;logic.
• Configured and ran the ;Debugger ;from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
• Design and development of PL/SQL Stored Procedures using dynamic SQL for checking existence of partitions and creating them with appropriate values in the case of their absence.
• Used ;TOAD ;to evaluate SQL execution.
• Performance Tuning ;of the target, source and mapping definitions was undertaken.
• Used ;Workflow Manager ;forCreating, ;Validating, ;Testingand ;running the sequential ;and ;concurrent Batches ;and ;Sessions.
• Extensively used SQL and PL/SQL Scripts and worked in both UNIX and Windows Environment.
• Performed ;Unit testing ;and ;Integration testing.
• Involved in creating and modifying ;UNIX Korn shell scripts ;and scheduling the UNIX scripts through ;Control-M.

Environment: ;Informatica PowerCenter 8.1, Oracle 10g, SQL Server 2005, COBOL, Flat files, Toad, SQL Developer, WinSCP, SQL, PL/SQL, Control-M, UNIX, Window XP, ERwin.

EDUCATION: ;Bachelor of Technology in Electronics and Communication Engineering