OBJECTIVE:

Aspiring to manage a team from every aspect to work dynamically towards the growth of an Organization, which set standards with a commitment as a team and to maintain a Good Client Relationship.

SUMMARY:

• 11+ years of Experience in IT industry.
• 1 year of Onsite Experience USA.
• Holding valid H1B visa through October 2017.
• 10+ years of Experience in Data warehousing Methodologies.
• Expertise in handling customer, Client interacting skills.
• Expertise in solving problems, identifying issues and providing quick turn arounds.
• Expertise in leading a team technically and managing as well.
• Expertise in Data Analysis, Data Mapping, Data Profiling, Data Architecture and Data Modelling.
• Experience in working with Teradata V2R5 - 14, Oracle 9i/8i.
• Expertise in SQL Query Writing, Teradata Utilities like FastLoad, MultiLoad, BTEQ, macros etc.
• Have clear understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including development, testing and implementation.
• Well Versed with Dimensional Modeling (Star and Snowflake) to build Data Warehouse.
• Expertise in ETL tool Informatica Power Center 7.1, 8.6.1 and 9.6.1.
• Involve in developing incremental load through CDC (Change Data Capture) technique like slowly changing dimension as well as full load based on the Business Requirement.
• Worked on different Source Systems like Oracle, Teradata and Flat files.
• Extensive experience in performing Reverse-Engineering from PL/SQL to Informatica Mappings.
• Extensive experience in developing Various Mappings using Lookup, Joiner, Filter, Expression, Source Qualifier, Update Strategy, Sequence Generator, Union, External Procedure, Stored Procedure and Router Transformations.
• Involved in Enhancement work, doing the functionality changes in Mapping and solving the issues raised during the promotions.
• Hands on Experience in PL/SQL programming. such as Cursors, Stored procedures, Functions and Triggers.
• Excellent communication and interpersonal skills with well-developed Team Interaction skills and multilingual being proficient in English, Urdu and Hindi .
• A systematic, organized, hardworking and dedicated team player with an analytical bent of mind determined to be a part of a growth-oriented organization.

TECHNICAL S KILLS:

ETL Tools: Informatica Power Center 9.6.1/8.6.1/7.1/6.1.

Data Quality Tools: Ataccama

Teradata Utilities: BTEQ, Multiload, Fastload, SQL Assistant.

Databases: Teradata V2R5, 7.1.0, 13.0 and Oracle 8i/9i.

Languages: SQL, PL/SQL.

Operating System: Windows OS Family, Unix.

Applications: MS Office.

Others: Toad, FTP.

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead

Environment: Informatica, Teradata, Oracle, SQL Server, Java and MS Office

Responsibilities:

• Involved in interacting with client and Business Users to understand the Requirements.
• Involved in interacting with Confidential Business users to get the Knowledge Transfer.
• Involved in the Discovery phase of Canadian Datawarehouse.
• Involved in validating the code of Confidential according to BMO.
• Involved in creating test plans in Data Quality Center with complex logics.
• Involved in designing high level flow plan to qualify and check the data.
• Involved in creating and implementing plans to correct the inaccurate data.
• Leading a team of 5 technically ensuring all the above tasks are accomplished.
• Generating reports/forecasting daily work done with respect to Targets assigned.
• Involved thorough understanding and preparing Unit Test Cases for all the Test plans created.

Confidential

Teradata Data Quality Lead

Environment: Ataccama, Oracle, Teradata 14, UNIX and MS Office.

Responsibilities:

• Involved in Analyzing and identify data inaccuracy.
• Involved in validating the code with the Business logic approved by Risk Business users.
• Involved in creating test plans in Data Quality Center with complex logics.
• Involved in designing high level flow plan to qualify and check the data using DQC.
• Involved in identifying the data issues using DQC.
• Involved in creating and implementing plans to correct the inaccurate data using DQC.
• Leading a team of 7 technically ensuring all the above tasks are accomplished.
• Generating reports/forecasting daily work done with respect to Targets assigned.
• Involved thorough understanding and preparing Unit Test Cases for all the Test plans created.

Confidential .

Data Lineage Analyst

Environment: Informatica, Teradata 14, UNIX.

Responsibilities:

• Conduct kick off meetings with Business Users to understand the Business requirements from technical and Functional prospective.
• Co-ordinate with different client teams (Business and IT) in understanding the systems requirements, business flow and providing Lineage thereafter.
• Conduct meetings with DA (Data Architect) team, Reporting team and Front end and Application teams to understand the data flow overview and to discuss if any other source is involved in loading the data.
• Work with Business Analyst to prepare Functional specification during the project requirements stage.
• Understanding the ETL Coding and Teradata Utilities.
• Understanding the Complex Business Logics involved in loading the data and coding it to a user understandable Language.
• Found Lineage for many attributes whose mapping was not documented/available.
• Coordinating with the offshore team and supporting them in the project issues.

Confidential

Macro Developer Lead

Environment: Teradata 14,UNIX, Java.

Responsibilities:

• Conduct kick off meetings with Business Users to understand the Business requirements from technical and Functional prospective.
• Co-ordinate with different client teams (Business and IT) in understanding the systems requirements, business flow and provides business model solutions.
• Conduct meetings with DA (Data Architect) team, Reporting team and Front end and Application teams to provide the design overview and to discuss if any impacts from technical point of view.
• Work with Business Analyst to prepare Functional specification during the project requirements stage.
• Conduct meetings with the Business Users in the Confidential commercial Finance to conclude the proposed future time.
• Coding the ETL's and Teradata Utilities as per requirements.
• Coordinating with Front end Java Application team in order to provide macros as per requirement for IRIS application.
• Moving code to UAT, production after all Business sign-offs and coordinating with the DBA's for implementing the code move to production environment.
• Supporting during the IRIS Close period and Production issues during that period

  Coordinating with the offshore team and supporting them in the project issues.

Confidential

Macro Developer Team Lead

Environment: Teradata 14,UNIX, Java.

Responsibilities:

• Conduct kick off meetings with Business Users to understand the Business requirements from technical and Functional prospective.
• Co-ordinate with different client teams (Business and IT) in understanding the systems requirements, business flow and provides business model solution programs.
• Conduct meetings with DA (Data Architect) team, Reporting team and Front end and Application teams to provide the design overview and to discuss if any impacts from technical point of view.
• Work with Business Analyst to prepare Functional specification during the project requirements stage.
• Conduct meetings with the Business Users in the Confidential commercial Finance to conclude the proposed future time.
• Coding the ETL's and Teradata Utilities as per requirements.
• Coordinating with Front end Java Application team in order to provide macros as per requirement for IRIS application.
• Moving code to UAT, production after all Business sign-offs and coordinating with the DBA's for implementing the code move to production environment.
• Supporting during the IRIS Close period and Production issues during that period.

  Coordinating with the offshore team and supporting them in the project issues.

Confidential

ETL Developer

Environment: Informatica Power Center 9.1.6, Oracle,UNIX, SQL Server.

Responsibilities:

• Involved thorough Understanding and analyzing the requirements of the current system and Business Model.
• Involved in preparing the ETL specs.
• Designing the ETL Load Strategies from SQL Server to Oracle.
• Involved in creating Procedures to truncate data from the target tables using UNIX script through informatica.
• Generating reports/forecasting daily work done with respect to Targets assigned.
• Involved thorough understanding and preparing Unit Test Cases for all the Mappings Created.
• Involved thorough in moving the code to Production without any issues.

Confidential .

ETL Developer

Environment: Informatica Power Center 8.6.1, Teradata 7.1.0, Unix and Windows 2000.

Responsibilities:

• Involved thorough Understanding and analyzing the requirements of the current system and Business Model.
• Designing the ETL Load Strategies from Flat File to Teradata.
• Involved in supporting business in loading the Monthly and Quarterly data.
• Involved in creating MDB’s every month for the Business Users.
• Identifying issues in the Business Submitted data and reporting to the Business Users for appropriate changes.
• Generating reports/forecasting daily work done with respect to Targets assigned.
• Involved thorough understanding and preparing Unit Test Cases for all the Mappings Created.

Confidential

ETL Developer

Environment: Informatica Power Center 7.1, Teradata V2R5, Unix and Windows 2000.

Responsibilities:

• Involved in maintenance, Enhancement and Support.
• Involved thorough Understanding and analyzing the requirements of the current system and Business Model.
• Designing the ETL Load Strategies from Flat Files to Teradata.
• Involved in creating Teradata Procedures.
• Involved in analyzing the current UNIX scripts and re-platforming them into Stored Procedures and Informatica Workflows.
• Generating reports/forecasting daily work done with respect to Targets assigned.
• Involved thorough understanding and preparing Unit Test Cases for all the Mappings Created.

Confidential

ETL Developer

Environment: Informatica Power Center 7.1, Teradata V2R5.

Responsibilities:

• Involved thorough Understanding and analyzing the requirements of the current system and Business Model.
• Performing reverse Engineering activity design to prepare the ETL specs.
• Designing the ETL Load Strategies from Flat-Files to Teradata.
• Derived solutions for implementation of CDC logic for incremental load to avoid full refresh.
• Involved in Designing Mappings to perform Change Data Capture.
• Involved in creating Teradata Procedures.
• Generating reports/forecasting daily work done with respect to Targets assigned.
• Involved thorough understanding and preparing Unit Test Cases for all the Mappings Created.

Confidential

ETL Developer

Environment: Informatica Power Center 7.1, Oracle 9i, PL/SQL, TOAD and Windows OS Family.

Responsibilities:

• Assisted in the development of source definitions for relational and flat file sources
• Created and implemented target definitions based on star schema design and developed aggregate tables to accommodate storage of summarized data
• Translation of business processes into Informatica mappings for building data marts
• Customized the data by adding filters, calculations, formulation of joins strategy, summaries and functions
• Queried data from different database tables as per the requirement by using join queries
• Used workflow manager for session management, database connection management and scheduling of jobs
• Responsible for mentoring other developers in the team in the design and development of mappings and debugging failed sessions
• Generating reports/forecasting daily work done with respect to Targets assigned.

Confidential

Software Engineer

Responsibilities:

• Designing the ETL Load Strategies from Flat-Files to Oracle.
• Involved in Designing Mappings to perform Change Data Capture.
• Generating reports/forecasting daily work done with respect to Targets assigned.
• Involved thorough understanding and preparing Unit Test Cases for all the Mappings Created.