SUMMARY:

• 8+ years of ETL development experience, providing solutions towards automation, reporting and data migration.
• Experience in developing complex Ab Initio graphs and reusable transformations.
• Experience in developing Ab Initio continuous graphs and webservices.
• Proficient in solving dependency analysis issues and establishing data lineage.
• Good at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary documents.
• Experience in Data Modeling (Star and Snowflake Schema) for large data warehousing projects.
• Experience in using Ralph Kimball data warehouse design and implementation methodologies
• Expert in writing superior SQL queries and optimizing the queries in Teradata
• Expertise in Teradata utilities like Multi Load, Fast Load, Fast Export, BTEQ, TPUMP, TPT and tools like SQL Assistant.
• Well - versed in tuning Teradata ETL queries, applying compression for space reclamation etc.
• Good understanding of query execution, explain plans, join strategies
• Good at shell scripting.
• Have worked in data migration and in data conversion projects.
• Domain knowledge on investment banking and credit cards
• Experience working in agile methodology.
• Good communication and presentation skills, works well as a leader, as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

KEY SKILLS:

Line of Business: Pharmacy Benefit Management(PBM) Capital Markets (PWM), Credit cards, Confidential

Operating System: Windows, Unix

Database: Teradata 14, Oracle 10g

Scripting: Shell scripting

Tools: Ab initio GDE 3.3, Autosys scheduling tool, Informatica Power Centre 8.6.1, ESP work station, Teradata SQL assistant, Visual Studio 2008, SQL server Management studio 2005, PL/SQL developer.

PROFESSIONAL EXPERIENCE:

Confidential, Franklin Lakes, NJ

Developer

Skills: Ab-Initio, Unix, SQL server.

Responsibilities:

• Get the Business Requirements from BPO and attend walk through meetings to understand the requirement.
• Create Technical design document for ETL design which includes source and target mapping details with transformations as applicable.
• Develop and review Ab Initio graphs and web services for scanner.
• Prepare unit test plan, test results and SQL scripts that ensures the code and functionality coverage.
• Move the code to SIT environment (System integration testing). Rectify the defects if any. Upon rectifying the defects, ensure the code undergo another round of testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.
• Move the code to QA (Quality Assurance) environment for the final round of testing. Perform Rectify the defects if any. Upon rectifying the defects, ensure the code undergo another round of user acceptance testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.

Confidential, Franklin Lakes, NJ

Developer

Skills: Ab-Initio, Unix, Db2.

Responsibilities:

• Get the Business Requirements from BPO and attend walk through meetings to understand the requirement.
• Create Technical design document for ETL design which includes source and target mapping details with transformations as applicable.
• Develop and review Ab Initio graphs.
• Prepare unit test plan, test results and SQL scripts that ensures the code and functionality coverage.
• Move the code to SIT environment (System integration testing). Rectify the defects if any. Upon rectifying the defects, ensure the code undergo another round of testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.
• Move the code to QA (Quality Assurance) environment for the final round of testing. Perform Rectify the defects if any. Upon rectifying the defects, ensure the code undergo another round of user acceptance testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.
• Send implementation plan to the Production team and provide Ad-hoc support to Production Support Teams while code is deployed. Provide warranty period support for any issues found post production.

Confidential

Senior Developer

Skills: Ab-Initio, Unix, SQL Server, Tivoli.

Responsibilities:

• Get the Business Requirements Document from the Client and attend walk through meetings to understand the requirement.
• Get the mapping document from the Business analysts. Attend meeting with business analyst to discuss about the mappings.
• Create Technical design document for ETL design which includes source and target mapping details with transformations as applicable.
• Develop and review Ab Initio graphs. Develop and review the jobs to schedule in Tivoli as per the defined frequency.
• Resolve dependency analysis issues in the developed graph and establish lineage.
• Prepare unit test plan, test results and SQL scripts that ensures the code and functionality coverage.
• Move the code to SIT environment (System integration testing). Rectify the defects if any, logged in ALM by the testing team. Upon rectifying the defects, ensure the reports undergo another round of testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.
• Move the code to QA (Quality Assurance) environment for the final round of testing. Perform quality assurance checks to see if the code has been developed as per Key bank Standards. Rectify the defects if any, logged in ALM by the testing team. Upon rectifying the defects, ensure the reports undergo another round of user acceptance testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.
• Send implementation plan to the Production team and provide Ad-hoc support to Production Support Teams while code is deployed. Provide warranty period support for any issues found post production.

Confidential

Senior Developer

Skills: Ab-Initio, Unix, Hadoop-HDFS, Big SQL (IBM Data Studio), Tivoli.

Responsibilities:

• Get the Business Requirements Document from the Client and attend walk through meetings to understand the requirement.
• Analyse the existing graphs that were used to load data into NAS environment.
• Create Technical design document for ETL design which includes source and target mapping details with transformations as applicable.
• Develop sourcing and consumption graphs/psets to load data into HDFS (Hadoop Distributed File System).
• Create external tables for the loaded files in hadoop using Big SQL.
• Resolve dependency analysis issues in the developed graph and establish lineage.
• Develop and review the jobs to schedule in Tivoli as per the defined frequency.
• Prepare unit test plan, test results and SQL scripts that ensures the code and functionality coverage.
• Move the code to SIT environment (System integration testing). Rectify the defects if any, logged in ALM by the testing team. Upon rectifying the defects, ensure the reports undergo another round of testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.
• Move the code to QA (Quality Assurance) environment for the final round of testing. Perform quality assurance checks to see if the code has been developed as per Key bank Standards. Rectify the defects if any, logged in ALM by the testing team. Upon rectifying the defects, ensure the reports undergo another round of user acceptance testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.
• Send implementation plan to the Production team and provide Ad-hoc support to Production Support Teams while code is deployed. Provide warranty period support for any issues found post production.

Confidential

Developer

Skills: Teradata, Ab Initio, Unix, Tivoli.

Responsibilities:

• Identify the business/technical requirements from Data Element Mapping document.
• Feasibility of the logic are analyzed and discussed with business analyst before developing the code.
• Prepare technical specification document.
• Develop and review the BTEQ ETL scripts based on the mapping document. Create Semantic layer using Views in Teradata. Develop and review the jobs to schedule in Tivoli as per the defined frequency.
• Prepare unit test plan, test results and SQL scripts that ensures the code and functionality coverage.
• Perform quality assurance checks to see if the code has been developed as per Confidential Standards. Move the code to higher environments like QA and User Acceptance Test portal for the users to test the functionality and accuracy of the reports.
• Log the Defects and track the same in ALM. Upon rectifying the defects, ensure the reports undergo another round of User Acceptance testing to check for data accuracy. Perform root cause analysis of the issues to prevent it from occurring in future.
• Send implementation plan to the Production team and provide Ad-hoc support to Production Support Teams while code is deployed. Provide warranty period support for any issues found post production.

Confidential

Developer

Skills: Ab-Initio, Unix, Db2, AutoSys, Erwin.

Responsibilities:

• Get the Business Requirements Document from the Client and attend walk through meetings to understand the requirement.
• Create Functional specifications document with the help of Business analysts to give the business definitions of Key Performance Indicators and the Dimensions across which it will be viewed.
• Create Technical design document for the Conceptual, Logical and Physical data model which includes the business entities and their relationships, Tables, Data Elements and Keys. Create Technical design document for ETL design which includes source and target mapping details with transformations as applicable.
• Develop and review the Ab Initio graphs using Ab-initio 1.15.9, UNIX. Develop and review the jobs to schedule in Autosys as per the defined frequency.
• Prepare unit test plan, test results and SQL scripts that ensures the code and functionality coverage.
• Perform quality assurance checks to see if the code has been developed as per CITI Standards. Move the code to User Acceptance Test portal for the users to test the functionality and accuracy of the reports.
• Log the Defects and track the same in IPMS. Upon rectifying the defects, ensure the reports undergo another round of User Acceptance testing to check for data accuracy. Perform root cause analysis of the issue to prevent it from occurring in future.
• Send implementation request to the Production team and provide Ad-hoc support to Production Support Teams while code is deployed. Provide warranty period support for any issues found post production.

Confidential

Operations and Production Support Executive

Skills: .Net 1.1, .Net 3.5, ASP.Net, PLSQL, Informatica power center client, UNIX, Remedy.

Responsibilities:

• Enhancement and Support of Supply Chain Systems.
• Analyze existing processes and support practices, recommend and implement automation / efficiency efforts to improve the support and technical environment.
• Get KT on existing applications and prepare DOU (Document of Understanding).
• Involves good understanding of Retail domain and Supply Chain Management, and leverage this understanding to implement continuous improvement efforts.
• Deploy Work requests/Change Requests to customer’s test and production environments.
• Provide permanent fixes to recurring issues in .NET web applications.
• Worked in creating workflows in Informatica and provided permanent fix to recurring Informatica job failures.
• Achieved 99.9% SLA in production support
• Provide 24x7 support