PROFESSIONAL ACUMEN:

• Around 9+ years of IT experience in Analysis, Design, Development, Implementation and Troubleshooting in the areas of Data warehousing Methodologies and ETL Tool Informatica.
• Expertise in Teradata, Oracle 8i/9i/10g/11g and knowledge on SQL Server 2000/2005.
• Extensive experience in Extraction, Transformation, Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center Tools (Repository Manager, Designer, Workflow manager and Workflow Monitor).
• Extensively worked on Informatica Designer Tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) and Workflow Manager Tools (Task Developer, Worklets and Workflow Designer).
• Good experience in Data Cleansing, Data profiling and Data Analysis.
• Strong knowledge in OLAP Systems, Kimball and Inmon methodology and models, Dimensional modeling using Star schema and Snowflake schema.
• Excellent knowledge and experience in Technical Design and Documentation.
• Extensively used Teradata and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Snapshot, Roles, Privileges, Tables, Constraints, Views, Indexes, Sequence, Synonyms, SQL*Loader in distributed environment.
• Excellent expertise with different types of data load strategies and scenarios like CDC, SCD, Snapshot and Event types.
• Extensively worked on Push down optimization for better performance.
• Extensively worked on Deployment groups for code migration to multiple environments
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Expertise in UNIX Shell Scripting and Informatica Metadata Manager Tool.
• Good knowledge on Hive, Cognos and TWS Scheduling Tool.
• Experienced in preparing the various documents like Requirement document, high level and low level design documents Business Mapping documents, Change request documents and Implementation documents.
• Expertise skills in Change, Incident, Problem and Order management methodologies based on ITIL procedures, MS - Office applications and MS-Visio for design flows.
• Experienced in working with Onsite-Offshore model and led a team of 13 members for multiple projects.
• Experience in leading a team and professional acumen towards achieving project timelines.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Proactively identify business problems that can be addressed with IT solutions and own delivery from concept to implementation and advising technical groups on Database and ETL best practices.
• Strong analytical skills with ability to quickly understand client’s business needs.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Good Working knowledge on Banking Domain "Credit Risks", “Mortgage Loans” and "Retirement Plan Services".

TECHNICAL SKILLS:

Databases: Teradata 14, Oracle 9i/10g/11g,MS SQL SERVER,DB2

ETL: Informatica 9.5

Languages: SQL, PL/SQL

Reporting: Cognos

Scripting: Unix Shell Scripting

Operating Systems: UNIX.

Tools: & Utilities: BTEQ, FASTLOAD, MULTILOAD and Fast ExportTeradata SQL Assistant, SQL Developer, Citrix, TOAD, Quality centerInformatica Metadata Manager, JIRA

Client/Server: Windows/Mainframes or Unix

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis

Technical Lead/Database Analyst

Client/Server: Windows/Unix

Database &Tools: Oracle 11g, MS Visio, UNIX Shell Script, OEM Tool, Informatica 9.6,PL/SQL

Responsibilities:

• Analyze the database design and backup strategy.
• Facilitate discussion with DBAs to understand the database design.
• Analyze the application code and design to reduce the storage.
• Discussion with business to understand the data retention requirements.
• Design the solution to meet the business requirements without any data loss.
• Converting legacy load components to Informatica mappings with change history pattern.
• Design the workflows and mappings to identify the change history records and move it into new change history table.
• Developing required mappings using Informatica power center.
• Create Metadata data lineage for the files which are redesigned.

Confidential, Denver

Team Lead/Developer

Client/Server: Windows/Unix

Database &Tools: Teradata 14, Informatica 9.5,Oracle 10g,Unix shell scripting

Responsibilities:

• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Working with Data Analysts to understand the functional requirements.
• Interact with Data Modelers to understand and finalize the conversion strategies.
• Responsible for leading a project team in delivering solution to our customer in the Financial sector
• Working closely with data population developers, multiple business units and a data solutions engineer to identify key information.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Utilize in-depth knowledge of functional and Technical experience in Data Warehousing and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Optimize and troubleshoot SQL Queries and Informatica mappings.
• Developed the artifact for the conversion of CDC to SCD history data by applying Adhoc SQL queries.
• Implemented re-usable code to handle FULL and DELTA loads.

Confidential, Denver

Team Lead/Developer

Client/Server: Windows/Unix

Database &Tools: Teradata 14, Informatica 9.5,Oracle 10g,Unix shell scripting

Responsibilities:

• Interaction with the Business Partners to understand the business of the application, gather requirements analyzed and put into technical design documents.
• Working with Data Analysts to understand the functional requirements.
• Interact with Data Modelers to understand and finalize the conversion strategies.
• Leading a team of 12 members
• Working closely with data population developers, multiple business units and a data solutions engineer to identify key information.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Involved in ETL design process to handle intraday transactions from the source and building an SCD in Teradata.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.
• Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.

Confidential, Denver

Module Lead

Client/Server: Windows/Unix

Database &Tools: Teradata 13, Informatica 9.5,Oracle 10g,Unix shell scripting

Responsibilities:

• Interaction with the Business Partners to understand the business of the existing billing systems, gather requirements analyzed and put into technical design documents.
• Interact with Data Modelers to understand and finalize the conversion and normalizing strategies.
• Involved in developing the technical documents from functional specs.
• Created a reusable component for a simple source to SCD type2 mappings.
• Created a reusable script to merge the similar kind of data coming from the 17 existing billing systems
• Conduct Design and Code reviews.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in writing UNIX shell scripts in KSH to Transfer the files between multiple systems and to load data from files to database.
• Involved in executing the Push Down Optimization (PDO) which boosted the performance by 60% on an average.
• Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.
• Performed data quality analysis to validate the input data based on the cleansing rules.
• Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through SQL queries.
• Prepare the run books for testing environments.

Confidential, Denver

Module Lead

Client/Server: Windows/Unix

Database &Tools: Teradata 13, Informatica 9.5,Oracle 10g,Unix shell scripting

Responsibilities:

• Scope study, requirement gathering, estimation, detail design and code reviews are primary responsibilities
• Conversion of HLD into Detailed Design documents to adhere to Bank’s warehouse standards.
• Performed impact analysis for systems and ETL and database modifications.
• Code Review and data validation activity.
• Played a key role in the mapping development tool, which automates the mapping development process in order to meet the business requirements.
• Developed the art craft for the conversion of SCD data to Snapshot data and conversion of CDC to SCD data by applying adhoc SQL queries.
• Taken complete bottom-line of the assigned tasks and projects and single point of contact for business users team and Business Analysts.
• Coordinating with team for ETL Development and keeping track of the Development process.
• Ensure Quality and On-time delivery.
• Worked closely with Onsite Coordinator and Production support team for Implementation and Post-Implementation Support.
• Conducted Technical and Functional Trainings for team members.

Confidential, Denver

Module Lead

Client/Server: Windows/Unix

Database &Tools: Teradata 13, Informatica 9.5,Oracle 10g,Unix shell scripting

Responsibilities:

• Involved and Implemented Technical Design by proper analyzing and mapping the Business Requirements.
• Involved in writing ad-hoc SQL queries to implement business requirements in Informatica mappings.
• Extensively used BTEQ scripts to handle the errors and to load the target tables.
• Extensively worked on query tuning to achieve better performance of the system
• Performed data reconciliation checks across the various source and target tables.
• Done error handling in Fast Load too.
• Creating Unit test cases and implemented unit test results.
• Prepared Impact Analysis document and Implementation Plan as part of enhancements

Confidential

Developer

Client/Server: Windows/Mainframes

Database: Teradata12/13

Responsibilities:

• Involved and Implemented Technical Design document
• Involved in writing ad-hoc SQL queries which involves complex business requirements.
• Extensively used BTEQ scripts to handle the errors and to load the target tables.
• Extensively worked on query tuning to achieve better performance.
• Worked with Fast Load scripts to the load the data.
• Eliminated spool space issues by creating proper indexes and statistics.
• Performed data reconciliation checks across the various source and target tables.
• Implemented error handling concepts in various aspects of the development
• Created and implemented Unit test cases and unit test results in accordance with business requirements.