SUMMARY

• 8+ years of IT experience with expertise in Business Analysis, Application Design, Development, Implementation for Banking and Financial Services.
• Strong experience in developing ETL mappings and scripts using Informatica Power Center 9.1/8.6/8.1
• Experience in Data Warehousing applications using Teradata utilities, UNIX, Teradata SQL Assistant 13.0, COBOL, JCL,CICS, DB2, VSAM, SQL, TSO/ISPF, and mainframe tools like ENDEVOR, File - AID, Xpeditor, Platinum, Easytrieve, SPUFI, QMF, NDM, SDSF, CA7, Control M.
• Proficient in developing strategies for extracting, transforming and loading using Informatica Power Center 9.1/8.6/8.1
• Implemented data strategies, build data flows and developed conceptual, logical and physical data models to support new and existing projects.
• Extensive experience on End-to-End implementation of Data warehouse and Strong understanding of Data warehouse concepts and methodologies.
• Strong hands on experience using Teradata utilities (BTEQ, Fast Load, MultiLoad, Fast Export, Tpump)
• Conducting code walk-through and reviewing internal and external quality assurance in the applications, debugging the defects identified and fixing them, comparing the test results with production results to make sure the changes are effective.
• Experience in designing and developing stored procedures, functions, constructing tables, views, indexes, triggers and user defined data types
• Proficient in the Integration of various data sources with multiple relational databases like Teradata, DB2, Oracle, MS SQL Server and Flat Files into the staging area, Data Warehouse and Data Mart.
• Worked extensively with slowly changing dimensions.
• Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.
• Proven track record in delivering effective design documents, code deliverables, test strategies and business value to the customer.
• Good knowledge on version control tool- Change man
• Worked for Onsite / Offshore Model and expert at handling multiple projects simultaneously
• Expertise in debugging tool Xpeditor.
• Expertise in Installing, Managing and configuring Informatica MDM Hub Server, Informatica MDM Hub Cleanse, Cleanse Adapters(Address Doctor), Informatica MDM Hub Resource Kit.
• Knowledge in importing ORS databases into HUB Console and Address Doctor installation.
• Have good exposure in creating Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages, query groups and custom functions in Informatica MDM.
• Good knowledge on File-AID and CA7 scheduler
• Experience in Autosys for creating JIL files and Monitoring jobs
• Having expertise knowledge in Teradata and has good exposure on other databases like Mainframe DB2.
• Has exposure to UNIX shell scripting.
• Possess excellent analytical and problem solving skills.
• Committed to continuous improvement, excellent communications, and project management skills. Self-disciplined, focused, solid teamwork and a team player.
• Good experience in technical documentation.
• Expertise in setting up testing environments, defining, creating, documenting, verifying and executing test cases, test scenarios and Test plans.
• Quick learner and keen observer, determining external & internal customer needs and well versed in internal & external relationship building. Good team worker and like to be part of a team, which always tries to explore out of box.

TECHNICAL SKILLS

Programming Languages: SQL, UNIX Shell Scripting, COBOL, JCL, REXX, JAVA, C, C++, Python

Databases: Teradata, Oracle 10g/9i/8i, DB2, SQL Server 2008

Operating Systems: Mainframes OS/390, WINDOWS, UNIX, Linux

ETL Tools: Informatica Power Center 9.1/8.6/8.1, SSIS

Tools: /Applications SQL Developer, PLSQL Developer, Teradata SQL Assistant, File-Aid, Xpeditor, DB2I, S SSH Tectia Client, QMF, CA7, CHANGEMAN, SPUFI, FILD, Autosys, Control M

Data Modeling tools: Erwin, MS Visio

Big Data Ecosystems: Hadoop, MapReduce, Hive, Pig

Domain Experience: Banking & Financial services

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, Florida

Sr Informatica Developer

Responsibilities:

• Interacted with the users, Business Analysts for collecting, understanding the business requirements.
• Prepared business requirement documents and reviewed with Clients, downstream application teams and users
• Create standard abbreviation documents for conceptual, logical, physical and dimensional data models.
• Prepared combine High level and Low level design document for all the applications
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Lookup, Joiner, Stored Procedure, and Union to develop the mappings in the Informatica Designer.
• Created mapping documents to outline data flow from sources to targets.
• Created Mapplets, reusable transformations and used them in different mappings.
• Developed mapping parameters and variables to support SQL override.
• Created sessions, configured workflows to extract data from various sources, transforming data, and loading into data warehouse.
• Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Trouble shooting of long running sessions and fixing the issues.
• Involved in writing SQL scripts, stored procedures and functions and debugging them.
• 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, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Used debugger to test the mappings and fixed the bugs.
• Prepare Unit test case document and perform Unit testing and Integration testing
• Deployed the components into production with the help of support team.

Environment: Informatica Power Center 9.6.1, Oracle, UNIX, SQL

Confidential, Manhattan, NY

Sr. Informatica Developer

Responsibilities:

• Interacted with the users, Business Analysts for collecting, understanding the business requirements.
• Prepared business requirement documents and reviewed with Clients, downstream application teams and users
• Create standard abbreviation documents for conceptual, logical, physical and dimensional data models.
• Prepared combine High level and Low level design document for all the applications
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop the mappings in the Informatica Designer.
• Extensively used Teradata Utilities like Fast-Load, MultiLoad, BTEQ & Fast-Export.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Created mapping documents to outline data flow from sources to targets.
• Created Mapplets, reusable transformations and used them in different mappings.
• Developed mapping parameters and variables to support SQL override.
• Created sessions, configured workflows to extract data from various sources, transforming data, and loading into data warehouse.
• Used Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Trouble shooting of long running sessions and fixing the issues.
• Involved in writing SQL scripts, stored procedures and functions and debugging them.
• Involved in creating scripts and JILs as per the design documents.
• 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, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Used debugger to test the mappings and fixed the bugs.
• Involved creating the tables in Teradata and setting up the various environments like DEV, SIT, UAT and PROD.
• Prepare Unit test case document and perform Unit testing and Integration testing
• Involved joint working session with LOBs and reviewed the results after each level of testing
• Involved in CAB activities and release planning to move the components.
• Deployed the components into production with the help of support team.

Environment: Informatica Power Center 9.1, UNIX, Teradata, SQL

Confidential, Manhattan, NY

Informatica Developer

Responsibilities:

• Monitoring the Production system using the View Point tool.
• Keeping watch on the Heavy Hitter queries in production and work on performance tuning of them and thereby reducing the overheard on the Teradata Production Box.
• Space reclamation of the space more than over allocated and occupied due to skewness.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.
• Troubleshooting of long running sessions and fixing the issues related to it.
• Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export or load data from/to Teradata.
• Worked with the testing team to resolve bugs related to ETL mappings before production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.
• Designed andimplemented stored procedures and triggers for automating tasks in SQL.
• Tuning the high CPU consumed Queries to decrease the SUM CPU and IMPACT CPU.
• Analyzing the Collect Stats in the Production jobs and remediation.
• Analyzing the long running, highly Skewed and non-complaint Queries and tuning on the same.
• Deploy changed components into production using change man tool

Environment: Informatica Power center 9.1, Teradata, SQL, COBOL and JCL

Confidential, Manhattan, NY

Informatica Developer

Responsibilities:

• Interacted with the users, Business Analysts for collecting, understating the business requirements.
• Prepared High level and Low level design document as per the requirement design document.
• Involved in creating Jobs and scripts as per the design documents.
• Coordinate with downstream and up-stream application owner to process and make available require data for users reporting.
• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop the mappings in Informatica Designer.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by team mates before moving the code into QA.
• Modified existing mappings for enhancements of new business requirements.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Involved in testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in CAB activities and release planning to move the components

Environment: Informatica Power Center 8.6.1, Teradata, SQL, COBOL and JCL

Confidential, Omaha, NE

Informatica Developer

Responsibilities:

• Interacted with the Technical leads, Business Analysts for collecting, understating the business requirements
• Design, Development, and Enhancement of new functionalities
• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Designed and implemented ETL mappings to extract and transform data from various sources
• Extensively used different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Testing, Reviewing with Check List and Code Walk through
• Writing the Stored Procedures, checking the code for efficiency.
• Ensuring that the deliverables meet the Quality standards
• Ensure defect free implementations
• Responsibility for overall quality and timeliness of the deliverables
• Data validation after each level of testing
• Coordination with offshore team
• Reviewing the work done by team members
• Support for System testing/Implementation

Environment: Informatica Power Center 8.6/8.1, Teradata, SQL, COBOL and JCL

Confidential

Team Lead

Responsibilities:

• Interacted with the Technical leads, Business Analysts for collecting, understating the business requirements
• Design, Development, and Enhancement of new functionalities
• Developed COBOL programs and JCLs as per the design documents
• Used Changeman to compile COBOL and DB2 programs and maintained the different versions
• Testing, Reviewing with Check List and Code Walk through
• Ensuring that the deliverables meet the Quality standards
• Responsibility for overall quality and timeliness of the deliverables
• Data validation after each level of testing
• Coordination with onsite team
• Support for System testing/Implementation

Environment: Mainframes (JCL & COBOL), EASYTRIEVE, DB2

Confidential

Developer

Responsibilities:

• Interacted with the Technical leads, Business Analysts for collecting, understating the business requirements
• Involved in analyzing, design, coding and testing the modules
• Prepared High Level and Low-level design documents
• Responsible for unit testing,SystemIntegration Testing (SIT) and User Acceptance Testing (UAT) support
• Extensively worked on COBOL, JCL, and DB2 for development of programs
• Used Changeman to compile COBOL and DB2 programs and maintained the different versions
• Used FILEAID, Platinum, QMF, Xpeditor tools
• Reviewing the work done by team members

Environment: Mainframes (JCL & COBOL), EASYTRIEVE, DB2

Confidential

Responsibilities:

• Working on the tickets raised by the development team
• Allocating the space for DEV tables
• Deallocating the space from the DEV tables
• Sending email notification to the teams for reminding the table deletions or extensions
• Providing the different levels of access to DEV tables based on the requests
• Attending meetings with clients
• Loading the development environment space details into the database

Environment: Teradata