Summary:

• 9 years of IT experience in analysis, design, development, implementation and troubleshooting in the area of Data warehousing.
• Extensive experience in handling ETL using Informatica Power Center/Power Mart 9.x/8.x/7.x/6.x
• Expertise in building Enterprise Data Warehouses EDW , Operational Data Store ODS , Data Marts, and Decision Support Systems DSS using Multidimensional Model Kimball and Inmon , Star and Snowflake schema design addressing Slowly Changing Dimensions SCDs .
• Experienced with Data warehouse Project Life Cycle. Well versed with documenting all the phases of project SRS/FRD, DA specification, ETL specification, DMD, Unit Test Plan/Test cases.
• Good experience in designing and developing ETL Environment involving various Source and Target relational and non-relational databases such as Oracle, SQL server ,DB2 ,Teradata, Flat Files fixed width , delimited and XML
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Experienced in developing complex mappings using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Stored Procedure, Update Strategy and Re-usable transformations.
• Designed and developed Workflows, sessions and other tasks using Work flow manager tools Task Developer, Workflow Worklet Designer to handle different load scenarios.
• Created/Managed users, user groups, folders/shared folders using Informatica Repository Manager.
• Experienced in using the Informatica command line utilities like pmcmd to control workflows in non-windows environments
• Expert in Database development that includes DML, DDL and DCL , PL/SQL that includes, procedures, triggers, Bulking techniques, collections, partitioned tables, stored procedures, functions, triggers, packages, materialized views and performed query optimization, database performance
• Worked on coding/debugging complex BTEQ scripts for implementing various business rules and loading data marts from data warehouse.
• Worked in conjunction with reporting and Business Intelligence OLAP Tools such as Business Objects - Universe, Supervisor, BCA, and WebI and Cognos.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

Technical Skills:

Work Experience:

Confidential

ETL Designer/developer

• Understand the current Cetera BONUS, Smartworks and CAESAR system and perform the gap/impact analysis when the data from a new broker dealer will be migrated after acquisition.
• Interacted with the business personnel to analyze the business requirements and transform the business requirements into technical requirements
• Performed the data analysis, tested the new incoming sample data provided in the form of files and relational tables for quality check.
• Developed the ETL, rollback and data recovery process for the new systems.
• Designed and developed the mappings in the mapping designer using source qualifier, expression, lookup, router, filter, aggregator, sorter, rank, joiner and update override for loading the accounts, client, positions, transactions and Billing data.
• Developed the SCD type1, type2 and incremental aggregation based on the requirement to load in the datamart used for financial reporting.
• Developed the Linux scripts for the Account and hierarchy file processing and FTP on a daily basis before loading them into relational and file targets using Informatica powercenter
• Scheduled the jobs using Active Batch on daily, weekly and monthly basis
• Worked on various entities like branch, Advisor, representative, Group and entitlement data for generation of a PSV file to ENVESTNET on a daily basis.
• Developed the DDL's, DML's, PL/SQL stored procedures, indexes and for ETL operations on Oracle and SQL server databases.
• Generated the ACH and financial reports from the Xtiva database as per the business requirement.
• Worked along with the reporting team to facilitate the generation and distribution of reports using Business objects
• Unit tested the code before migrating it to the QA and UAT for further testing.
• Provided on call support in the production environment during weekends and after hours
• Lead the offshore team and worked on complex problems where analysis of situation requires in-depth fault analysis and trouble shooting skills.

Environment: Informatica power center 8.6.1, Oracle 11g, SQL Server 2005,Business Objects XI R3,Flat files, HP-UX 11i v3, SQL developer, TOAD, Windows 7 Professional, MS Excel, MS Outlook.

Confidential

ETL Designer/developer

Responsibilities:

• Worked and supported the design team in requirement gathering, data mapping and ETL specification design.
• Imported and analyzed the various file, relational sources and targets in source qualifier and target analyzer respectively.
• Analyzed the huge Omniture source feeds, live stream and VOD data for quality check and integrity of data.
• Designed and developed the mappings in the mapping designer using transformations source qualifier, expression, lookup and aggregator transformations as per the requirement.
• Developed the sessions around mappings, command tasks and worklets as per the requirement in task developer.
• Created the BTEQ scripts when the data is being loaded to target Teradata from a source Teradata database.
• Good experience with the Teradata Fast load and Mload utilities while loading the Teradata tables.
• Created the workflows by importing the required sessions and BTEQ scripts followed by scheduling of these workflows in ksh scripts.
• Transferred the files between various UNIX environments using ftp and sftp protocols.
• Worked on the scripts for creation and loading of the aggregate tables from the detail tables as per the customer requirement using aggregate database functions and these results are used to calculate the viewing time per session per customer.
• Performance tuned the ETL jobs and BTEQ scripts.
• Worked with the DBA for best performance practices in creation and dropping of indices on the right columns, stage tables and better query performance.
• Developed, tested and also reviewed the code with the team before migrating it to production.
• Provided BI On call support.

Environment: Informatica power center 9.1, Teradata 13.0, Oracle 10g, Flat files, Teradata SQL Assistant, HP-UX 11i v3, SAS 9.2, SQL developer, putty, MS Excel, MS Outlook.

Confidential

ETL Designer/developer

Responsibilities:

• Identified gaps between the data available in the transaction systems and the requirements
• Monitored incoming source files from the OLTP Siebel system.
• Designed and developed ETL mappings in Informatica designer using Source qualifier, expression, lookup and update strategy transformations based on the requirement.
• Performance tuned the ETL jobs and Created shortcuts for source and target and also created Reusable Transformations, mapplets in Shared folder.
• Generated daily trip report from the target ODS in order to determine the missing records from the source Siebel system.
• Optimized and analyzed the target ODS objects periodically to enhance the performance.
• Created user accounts in order to provide access for the clients in production and testing environments.
• Worked and assisted the users with SQL queries in accessing the information from the target ODS on a daily basis.
• Primarily responsible for application design and development using Teradata utilities -BTEQ, Fastload, Multiload and Fast Export data model changes, Query Tuning, changing the Primary Index Secondary Index, creating Joins.
• Created BTEQ scripts and load jobs with MLOAD, FLoad and Exports using Fast Export to develop the ETL jobs.
• Maintained the target ODS database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Maintained the batch processes using Unix shell scripts and Scheduled the workflows for daily loads and weekly loads
• Lead and coordinated the offshore development team and onshore business team.
• Provided on call support for the Informatica processes daily and weekly and ODS database related acivities.

Environment: Informatica power center 9.1, Oracle 10g, Siebel 8.0, Toad, webmethods 8.0, UNIX, Actuate 8.0 Reports, MS Excel.

Confidential

Informatica designer/developer

Responsibilities:

• Analyzed the interface agreements existing between billing systems and notification engines.
• Defined the file format and file details of the data files to be received from the source system.
• Architect the file watch, file error handling, and file archive process and strategies.
• Extensively worked with business users to understand the requirements and architect the most efficient solution.
• Worked along with Data modeler, DBA and Source systems in resolving the Issues.
• Drafted ETL strategies and Meta Data integration
• Developed technical design specification to load the data into the data mart tables confirming to the business rules.
• Designed Systems Solution Approach and Technical design document to integrate the data received from multiple billing system and notification engines.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router and Lookup transformations as per the requirement.
• Created BTEQ scripts and load jobs with MLOAD, FLoad and Exports using Fast Export to develop the ETL job to load the data to the audit datamart.
• Worked with Teradata DBA team to create secondary indexes required for performance tuning of Data mart loads and reports
• Coordinated with report analysts to integrate the data mart and Business objects reporting universe.
• Developed UNIX scripts for performing daily batch jobs and involved in the design and development of logical and physical data model.
• Identified the data cleansing elements and prepare the specifications for data cleansing.
• Identified the data profiling aspects of the project, interacted with users to identify the requirements and architect and implement the data profiling strategies.
• Coordinated the offshore development team and onshore business team.
• Documented functional and technical specifications.

Environment: Informatica Power center 8.6.1, Oracle 10g, XML, PL/SQL, SQL Loader, UNIX, Erwin 7.0, and Business Objects 3.1.

Confidential

Sr. ETL Developer

Responsibilities:

• Interacted with the business personnel to analyze the business requirements and transform the business requirements into the technical requirements.
• Developed logical and physical data models using ERWIN.
• Defined ETL standards for ease of debugging and maintenance.
• Worked with various Informatica client tools such as Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Implemented weekly error tracking and correction process using informatica.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL.
• Worked on Teradata Global temporary and volatile tables.
• Worked with Teradata DBA team to create secondary indexes required for performance tuning of Data mart loads and reports.
• Identified tangible gaps in the source models to make the models more flexible and to link sources. All gaps are documented and their risk level to the systems was identified.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in unit testing, user acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Involved in developing test data/cases to verify accuracy and completeness of ETL process.
• Actively involved in the production support and also transferred knowledge to the other team members and created business objects functionality from analytical database to transactional data warehouse.

Environment: Informatica Power Center 8.5,Power Exchange 8.1, Oracle 10g, TeradataV2R5, Web methods, Mainframes, Solaris, Erwin, Business objects 6.5.

Confidential

ETL Developer

Responsibilities:

• Prepared technical specification for the development of Informatica Extraction, Transformation and Loading ETL mappings to load data into various tables in Data Marts and defining ETL standards.
• Designed and developed ETL routines, using Informatica Power Center 7.1. Within the Informatica Mappings, usage of Lookups, Aggregator, Update Strategy, Ranking, connected and unconnected Lookups, and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Designed and developed pre-session, post-session tasks for the workflows.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Developed Session Parameter files for the workflows.
• Used the Informatica command line utility pmcmd to start and schedule the workflows by setting a cronjobs and wrote UNIX Shell scripts to create pre and post session commands.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Extensively Wrote Stored procedures and anonymous PL/SQL Scripts.
• Developed Teradata Fast Export script to generate feeds from Teradata data warehouse and FTP the same to downstream systems.
• Documented Design Documents and Unit Test plan for Informatica mappings, design and validation rules. Word company template .

Environment: Informatica Power Center 7.1.4, Oracle 10g/9i, TOAD, SQL, PL/SQL, XML, Business Objects 6.5, Windows XP, HP UNIX.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL mappings, transformations using Informatica Power Center 6.2.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Worked on various transformations including Source qualifier, Expression, Filter, Aggregator, Router, Update strategy, Lookup, Normalizer, Rank and Sequence generator.
• Involved in setting up batches and sessions to schedule the loads at required frequency using Workflow Manager.
• Developed reusable Mapplets and Transformations.
• Involved in performance tuning of mappings.
• Maintained documentation to describe mapping design specifications and process flow diagrams.
• Generated completion messages and error status reports using Server manager/Workflow Manager.

Environment: Informatica Power Center 6.2, SQL Server 2000, SQL/PLSQL, UNIX Shell Programming, Erwin 4.0, Sun Solaris, and Windows 2000.

Confidential

Programmer/Analyst

Responsibilities:

• Studied the project requirement and designed the project.
• Created tables, views, synonyms and sequences.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Optimized queries using rule based cost based approach.
• Used SQL Loader for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.
• Tested all the new and modified program units.

Environment: Oracle 8i, Windows.