SUMMARY

• 15+ years of overall IT Experience, including 10+ years of analysis, design, development, and implementation and troubleshooting of Data Warehouse applications.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts especially with large data sets.
• Experience in integration of various data sources including Oracle, SQL server, DB2, Sybase, and MS access and non - relational sources like flat files into staging area.
• Experience in writing, testing and implementation of PL/SQL stored procedures, triggers, functions, packages using Oracle and stored procedures and triggers using SQL Server and T-SQL.
• Strong knowledge in writing BTEQ scripts, and other load utility scripts in Teradata 13.10 and 14.10.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Experienced in working with scheduling tools such as CA Unicenter Scheduler, Informatica Scheduler and Unix crontab.
• Created UNIX shell scripts to automate and implement workflows, sessions and dynamic source/target databases.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various aspects of the data warehouse infrastructure including but not limited to sources, targets, mappings and sessions.
• Excellent analytical/communication skills and good team player.
• Excellent leadership skills with experience in mentoring and managing a team of developers.

TECHNICAL SKILLS

ETL Tools: Informatica Powercenter 9.x, 8.x, 7.x (Repository Manager, Designer, Workflow Manager, Admin console, Unicenter Workload Manager)

Databases: Oracle 8.x/9x/10g/11g, SQL Server 2000/2005/2008 , Teradata 12/13.10/ 14, DB2 UDB 7.2, MS-Access

Database Tools: Oracle PL/SQL Stored procedures,triggers and packages;Teradata BTEQ, Teradata load utilities - MLOAD, FLOAD, TPUMP, Oracle Enterprise Manager, SQL Navigator, Toad, Oracle SQL*Loader, SQL*PLUSMS SQL Server Management Studio, SQL Server Cli config Util, bulk copy utils, SSIS packages using SSIS designer.

Operating Systems: UNIX, Windows, Chrome OS

Programming Skills: UNIX Shell scripting, Microsoft C#.net, .net Framework,, SQL, PL/SQL, T-SQL, stored procs and triggers, Windows PowerShell 2.0

PROFESSIONAL EXPERIENCE

Confidential - Philadelphia

Sr. Informatica/Teradata Developer

Responsibilities:

• Technical and Functional requirement analysis, design and implementation of solution
• Designed the critical parts of the data warehouse that manages customer revenue in relation to the agents' performance.
• Prepared detailed technical specifications of the data warehouse and the ETL codebase.
• Designed and developed both the Informatica portion and the Teradata BTEQ parts of the solution in a time/cost-sensitive atmosphere.
• Created, tested and debugged PL/SQL stored procedures, triggers, packages and SQL queries and embedded SQL in Unix shell scripts.
• Created complex mapping in Informatica that integrate, transform, standardize, format, aggregate data from all the source systems.
• Created, tested and debugged BTEQ scripts, Teradata SQL queries
• Extensive code analysis of the team's BTEQ code and Informatica code to determine the efficiency and accuracy of the code.
• Worked with Data Modelers extensively to suggest and implement database guidelines and structure.
• Created ETL schedule workflow with job dependencies using UC4 Automation Engine.
• Worked with the DBA and Tier2 team for solution implementation and guidance for production processes.
• Debugged, corrected and successfully implemented several bug-fixes and performance improvement measures.

Confidential - Richmond, VA

Sr. Informatica Developer

Responsibilities:

• Gathered requirements from users / Functional Team for Design, Development, Testing and Deployment stages.
• Designed the architecture of the data warehouse which involves thorough understanding of the sources staging areas, operating data stores (ODS) and the warehouse.
• Prepared technical specification document for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with the business users to understand and document the use cases and expectations of the Data Mart.
• Define and implement ETL development standards and procedures(coding guidelines, best-practices, naming convention)
• Created high level and low level design documents in coordination with the DEV lead for the ETL transformation and load processes.
• Created complex mapping in Informatica that integrate, transform, standardize, format, aggregate data from all the source systems.
• Created, tested and debugged BTEQ scripts, Teradata SQL queries and Teradata macros.
• Created, tested and debugged PL/SQL stored procedures, triggers, packages and SQL queries and embedded SQL in unix shell scripts.
• Designed ETL workflow with job dependencies and scheduling/sequencing using Unicenter WLM tools.
• Analyzed and removed/reworked the bottlenecks in sources, targets, mappings and sessions.
• Coordinated the technical work of multiple project teams who are responsible for the development, integration, administration, and evolution of the data warehouse.
• Kept in-line with introduction of new practices, methods, and emerging technologies and how they can be applied to the ETL environment
• Efficiently co-ordinated with Off-Shore team in INDIA for on-shore-off-shore hand-off and continuation of tasks.

Environment: Informatica Power Center 9.1/8.6, UNIX, Unicenter WLM, Teradata db, Teradata BTEQ scripts, Unix Shell scripts, Flat Files, mainframe data set files

Confidential, Fort Lee, NJ

Sr. Informatica Developer

Responsibilities:

• Gathered requirements from users / Functional Team for Design, Development, Testing and Deployment stages.
• Designed the architecture of the data warehouse which involves thorough understanding of the sources, staging areas, operating data stores (ODS) and the warehouse.
• Prepared technical specification document for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Worked with scrum master in creating and understanding user stories.
• Created the design of the Fact and Dimension tables using ERWin, working together with the ETL data architect.
• Worked with BI Developers to design various types of reports like pie chart, bar, slice and dice and KPIs and web reports.
• Contributed functionally and technically to Business Intelligence Strategy development using Business Objects
• Worked with the business users to understand and document the use cases and expectations of the Data Mart.
• Developed data quality reconciliation methods and policies in association with the data architect and DBA.
• Define and implement ETL development standards and procedures(coding guidelines, best-practices, naming convention)
• Created high level and low level design documents in coordination with the DEV lead for the ETL transformation and load processes.
• Created complex mapping in Informatica those integrate, transform, standardize, format, aggregate data from all the source systems.
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL and T-SQL .
• Designed ETL workflow with job dependencies and scheduling/sequencing.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features such as round robin/key-range partitions, data/index cache and parameter files to manage very large volume of data.
• Analyzed and removed/reworked the bottlenecks in sources, targets, mappings and sessions.
• Used slowly changing Dimension techniques to load and keep track of dimension data.
• Promoted repository objects, services and scripts from development environment to production environment
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information required for the Maintenance and Operation of the application.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Coordinated the technical work of multiple project teams who are responsible for the development, integration, administration, and evolution of the data warehouse
• Kept in-line with introduction of new practices, methods, and emerging technologies and how they can be applied to the ETL environment
• Co-ordinated with Off-Shore team in INDIA.

Environment: Informatica Power Center 9.1/8.6, Informatica Admin Console, Informatica Power Exchange, CDC,Salesforce.com,Oracle11g/10g,SQL Server 2005/2008, Business Objects XI R2, Flat Files, Toad9.0, UNIX, Autosys, Erwin Designer4.1.

Confidential, Providence, RI

Sr. ETL Developer/Designer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards
• Used slowly changing Dimensions techniques to load the dimensions.
• Worked with various Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Removed Duplicate records, rejected invalid Data using Informatica.
• Developed standard and re-usable Mappings and Mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup (connected/unconnected), filter.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Involved in Unit testing, System testing to check whether the data loaded into target is accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services& scripts from development to production environment.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 8.6, Informatica Admin Console, Oracle11g/10g,SQL Server 2005/2008, Business Objects XI R2, Flat Files, Toad9.0, UNIX, Autosys, Erwin Designer4.1.

Confidential, NEW YORK, NY

Informatica Developer

Responsibilities:

• Actively Participated in collecting user requirements.
• Involved in drafting Software Requirement Specification for the project.
• Developed High Level Technical Design specification and Low-level Design based on business requirements.
• Drove the development of the logical and physical data models, ETL programs/scripts, metadata definitions, schedules, work processes, and maintenance procedures
• Prepared database DDL scripts for create, delete, alter table.
• Created ETL specifications describing the mapping logic for developers.
• Identified bottlenecks in source, target, mapping, session and resolved them by implementing better logic and/or database object/query optimization.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumes of data.
• Monitoring Production system, performed complex defect fixes in various environments like UAT, SIT etc to ensure the proper delivery of the developed mapping into the production environment.
• Oversaw the design of the data and technical architecture for the data warehouse.
• Evaluate the Change Data Design, including slowly changing dimensions and Operational Data Store Design.
• Prepared time estimates and tracked each task against the estimated task and assisted in keeping project delivery deadline.