SUMMARY:

• Over 9 years of IT experience in System Development Life Cycle - Data Analysis, Design, Modeling, Development, Testing, Implementation and Support with extensive exposure in Database, Data warehouse and ETL process.
• Expertise with development of conceptual, logical, and physical data models; data quality; SQL, extract, transform, and load (ETL) strategies; tuning; replication; and solving object-relational mapping challenges; analysis of business and technical requirements, and mapping them to implementation strategies and design of EDW systems architecture.
• 9+ years of Hands on experience in diverse fields like Banking, Telecom and Healthcare relational for Databases and Data marts for various verticals in Teradata, Oracle, DB2 with an extensive use of ETL techniques, Dimensional Modeling Design techniques, Data Management.
• 4+ years of ETL expertise with Informatica Power center tools for data warehousing projects from inception to implementation and delivered high quality solutions in a timely manner meeting and exceeding the business requirements in the implementation of a Data Cleansing and Customer De-Duplication and Standardization efforts.
• 4+ years of hands-on experience using Teradata and extensively used the Utilities (SQL, BTEQ / BTEQ, MultiLoad, Fast Load, Fast Export).
• Expertise in identification of Facts, Measures, Dimensions and Hierarchies for OLAP models, Schema design, Metadata and gathering business requirements and documentation.
• Excellent Documentation skills in producing Solution Designs, Technical Design Documents, HDDs and LDDs after translating BRDs, FRDs and creating mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimension using Data Modeling tools like Erwin.
• Expertise in performance tuning techniques at system, session, mapping, transformation, source and target levels to optimize the batch time for ETLs effectively Tune and Monitor RDBMS both at application and database level for better performance.
• Extensive experience in preparing efficient UNIX Scripts, well-tuned SQL Queries to load, transform and validate data on Teradata.
• Provided extensive Production Support for Data Warehouse for internal and external data flows to Teradata, Oracle DBMS from ETL servers via remote servers.
• Very strong SQL skills, under Windows and Unix shell script environment including use of nested table expressions, unions, multi-table joins, scalar functions, outer joins, derived columns and creative use of the EXISTS operator.
• Excellent communication skills, Business interaction skills and strong interpersonal skills to deal effectively with customer groups and clients to the top management.
• Provided 24/7 Active Data Warehouse Production Support as part of on-call rotation for both Incremental and Complete refresh.
• Lead and provided guidance to both on-site and off-shore teams for various EDW initiatives with design and coding standards and best ETL practices for using normalized data structures, de-normalized structures, and dimensional structures, best practices for the design, development, deployment, change management, support and successfully present the ETL Data Integration efforts to external departments to influence, appreciate and gain support for the projects from client departments.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter8.6/9.1

Scripting tools: UNIX Shell scripts

Databases: Teradata (v2R7 and TD12), Oracle (9i, 10g), DB2, MS Access.

Tools/Utilities: Toad for Oracle,Teradata (BTEQ, Fast load, Multi-Load, Fast Export), SQL Assistant, TOAD IBM Tivoli scheduler, JCL, Control M, MS office, Visio, SQL*Loader, WLM, REMEDY, ESP, MPP, QC (Quality Center)

Operating Systems: UNIX, MS-DOS and Windows NT/95/98/2000/8

PROFESSIONAL EXPERIENCE:

Technical Lead 

Confidential, NC 

Responsibilities:

• Involved in requirement analysis.
• Involved in creating HLD and LLD document.
• Involved in design framework for Payments system for Credit and Debit Accounts
• Implemented near to Real time Payment system.
• Involved in troubleshooting performance issue which was causing deploy to meet SLA. Have been implemented tuned SWL query and Push down optimization
• Involved in Integration testing such as pushed data from various source system and process in DB after applying ETL logic. Trace down end to time taken to process the single payment and identify and fix the issue encounter during testing.
• Have been implemented many Production releases.
• Was involved in Production migration activates and support after migration.
• Onsite- Offshore co - ordination.

Technical Lead 

Confidential 

• Design, Develop and Deploy integrated DW applications from various source systems like Customer system, saving Account, Mortgage account etc. and Data marts in the ING Data warehouse to consolidated/integrate all migrated accounts and mapped those accounts (ING) with the Confidential accounts & Customers.
• Building road maps develop solution decks to conceptualize the business use cases with technologies like Informatica, Teradata
• Designed, Developed, optmized various medium to complex ETL processes with ETL Jobs, mappings with Workflows/ Sequence Jobs for BI solutions sourcing data from various types of source data from RDBMS, Flatfiles, XMLs etc into the data mart.
• Tested the ETLs developed to confirm the data quality, quantity, accuracy and efficacy of the ETL transformations designed and developed. SQL queries to optimize the load process besides the designing the mappings.
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions and Designed the ETL processes using Informatica Power Center 9.1 to extract, transform and load data from multiple input sources like database, flat files to the Teradata Data marts.
• Provide architectural support for Conceptual/Logical/Physical data modeling Data governance and review of solution designs for best practices and participate in architectural reviews of the HLD and LLD for the new initiatives.

Environment: Informatica Power Center 9.1, Teradata TD12, UNIX, Putty AIX 5.3, Excel, Win SCP (ftp), Windows XP, MS Share point,Tivoli

Confidential

Technical Lead 

• Provide strategy and architecture for consumer marketing technology and various other teams to develop, present and optimize various initiatives in business intelligence and enterprise data initiatives across multiple lines of businesses.
• Designed, Developed, optmized various medium to complex ETL processes with ETL Jobs, mappings with Workflows/ Sequence Jobs for BI solutions sourcing data from various types of source data from RDBMS, Flatfiles, XMLs etc into the data mart(KBM).
• Created, modified Jobs, Sequence Jobs, Mappings, re-usable components like Mapplets, sessions, Worklets, Workflows, XML source definitions for the data to be loaded.
• Tested the ETLs developed to confirm the data quality, quantity, accuracy and efficacy of the ETL transformations designed and developed, and expertise in designing and tuning DB2 and Oracle SQL queries to optimize the load process besides the designing the mappings.
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions and Designed the ETL processes using Informatica Power Center 8.6 to extract, transform and load data from multiple input sources like Oracle, flat files, DB2 to the Teradata Data marts.
• Worked extensively with various ETL stages / transformations like Transformer/ SCD, Aggregator, Expression, Filter, Source Qualifier, Rank, Joiner, Expression, Joiner, Union, Sequence Generator, Update Strategy, Lookups and Stored Procedure etc. to develop complex ETL processes and tune and optimize the existing processes to develop data solutions to transform business rules into the ETL data deliverables.
• Worked with EDW teams to accomplish various EDW initiatives, objectives, Design and implement data models according to the project requirements, Participate in data architecture strategy, review, data provisioning, and policy making initiatives.
• Designed and implemented Data Quality plans for the data being loaded to the back end of the search engine to make sure that it adheres and publish the correct product, plan information for the customers and employees alike.
• Interacted with various business users to gather the business requirements and translated them into technical specifications for Solution Design documents, Technical Design Documents, HDDs and LLDs to propose the BI solutions to the business with Data models, ER Diagrams, Mapping Documents etc.

Environment: Informatica Power Center 8.6, Teradata TD12, UNIX, Putty AIX 5.3, Excel, Win SCP (ftp), Windows XP, WLM, MS Share point, QC

Confidential

Technical Lead

• Analyzed the end-to-end scope of work and design architectural solutions accordingly, integrate all data in the data management platform enabling accessibility and ensure that the database base is secured and updated on cross-environmental Database platforms.
• Developed application to screen customer data. Customer’s data will be screen against sanctions lists such as the OFAC SDN and the PEP lists. This system will also allow the Group Sanctions Policy to be followed. Customer will be screen based on customer/account holder’s name, key account parties, signatories, trustees, etc.; variations of names (e.g. surname + initial; etc.); new customers before opening an account.
• Generated List of Customer in excel using Unix shell scripting and list will be sent in XML output of the Hits Cases for PEGA and any suspicious cases requiring investigation have been referred to a bank user for further investigation
• Deployed, administered and ensured the Change management process for various ETL processes developed and supervised for Test (ST, FT) and Production environments.
• Developed shared containers in Quality and DataStage jobs to increase reusability which saved testing and designing time and can bring down the Total Project Time
• Created UNIX scripts for various purposes like FTP, Archive files and creating parameter files.
• Performed Unit Testing and Integration Testing of Mappings and Workflows and involved in 24x7 production support on a rotation basis within the ETL team.

Environment: Microsoft Visio, AIX, Putty AIX 5.3, Informatica 8.6,TERADATA v2R7, FFF Classic, Excel, Win SCP (ftp), Windows XP, MS Share point,Tivoli(Scheduling tool)

Confidential

Team Lead

• Worked as a Team Lead EDW HSBC bank .My role’s core responsibilities are:
• Deployed, administered and ensured the Change management process for various ETL processes developed and supervised for Test (ST, FT) and Production environments.
• Optimized and tuned the existing ETL load processes to fine-tune the data loads and removing bottlenecks in Oracle, DB2, XML source data to Data mart.
• Optimized and tuned the existing ETL load processes to fine-tune the data loads and removing bottlenecks in Oracle, DB2, XML source data to Teradata Data mart and transformation levels to quick retrievals
• Preparation of Pre- and Post- Implementation documentation for Production Implementation.
• Creation of Financial reports for business users as per the business requirements.
• Perform the Analysis of Production Control-m Scheduler to update the production job flow in case of addition, deletion and/or updating of any production job.
• Perform the maintenance of the production jobs scheduled by control-m.
• Provide architectural support for Conceptual/Logical/Physical data modeling Data governance and review of solution designs for best practices and participate in architectural reviews of the HLD and LLD for the new initiatives.

Environment: DB2, Control-m, Shell scripting, XML, SAS, UNIX, Putty AIX 5.3, Excel, Win SCP (ftp), Windows XP, MS Share point

Confidential 

Software Developer

• Worked as developer for telecommuniation group in Telstra . My role’s core responsibilities are:
• Contributed to Design, Develop, Test, Deploy and support applications to detect fraud data
• Designed and implemented Data Quality plans for the data being loaded to the back end of the search engine to make sure that it adheres and publish the correct product, plan information for the customers and employees alike.
• Provided Technical Design and Solution Design Documents for the implementations lead and took part.
• Deployed, administered and ensured the Change management process for various ETL processes developed and supervised for Test (ST, FT) and Production environments.
• Deployed and scheduled scripts and jobs into production with Control M.
• Scheduling jobs in Information Analyzer for profiling data from different sources which involved identifying the key fields for consumer, product details, table constraints, primary, foreign key relations.
• Created UNIX scripts for various purposes like FTP, Archive files and creating parameter files.
• Responsible for trouble shooting, identifying and resolving data problems, Worked with analysts to determine data requirements and identify data sources, provide estimates for task duration.

Environment: Oracle 10g,Control M, SM UNIX, Putty AIX 5.3,, Excel, Win SCP (ftp), Windows XP, PERL scripting, TOAD, MS Share point,Cr-x