SUMMARY:

• Around 15 Years of Total IT experience with hands - on in DB2, Unix/AIX/Linux with cross platform and multiple database environments - ORACLE, SQL SERVER, SYBASE.
• Expertise in writing DB2 Complex SQL queries, Stored Procedures (SQL/PL), Functions and performance tuning.
• Engaged in data modeling activities, ER modeling (PDM & LDM) for OLAP OLTP systems.
• Expertise in writing Unix/AIX/Linux shell scripting.
• Engaged in data replication within RDBMS and RDBMS to Hadoop using Attunity replicator.
• Reports generation using BI tools Cognos and Tableau
• Good domain knowledge in Insurance and Banking.
• Experience in all phases of SDLC, Project Management, Software Practices and Standards.
• Involved in designing and reviewing the Business and the Functional Requirements.
• Participation in the Business analysis/walk through of user requirements by interacting with the SME’s and the Business Users.
• Experience in development, maintenance and production support activities.
• Extensive experience in analysis, development and implementation of applications in Web-based environments.
• Expertise in version control management tools - PVCS, SVN
• Worked on Team tracker & ServiceNow (Amplify) tools that tracks the tasks at all phases.
• Received Confidential service excellence
• Quick learner and proven to be an excellent team player.
• Adaptable for any new technology and Industrious.

SKILLS:

Relational Databases: DB 2 7.2/8.0/9.0/9.5/9.7/10.5 , Oracle, Sybase, Sql server, Ingres

Scripting Language: Unix, AIX and Linux, Perl, Python

Big Data Hadoop: Cloudera Hive, Impala, Pig and Sqoop

Programming Languages: C, C++, COBOL

BI Reporting Tools: Cognos, Tableau

DB Languages: SQL, DB2 SQL/PL and PL/SQL

Database Tools: SQL Query Analyzer, SqlDbx, SQL profiler

Version Control: PVCS Serena Library Management, SVN

Operating Systems: Windows 7/Vista/XP/2000/NT/98, UNIX, Linux, AIX

Browsers: IE 6-8, Mozilla Firefox 3.6.3, Safari 4.0.4, Chrome 5.0

Work Flow Tools: MSOffice suite, Informatica PowerCenter 11.0

PROFESSIONAL EXPERIENCE:

Senior ETL Developer

Confidential, Roseland, New Jersey

Responsibilities:

• Onshore/Offshore coordination.
• Creating Entity- Relationship (ER) and dimensional data models using Erwin Designer.
• Designing data marts Star and Snow-flake schemas.
• Design and Develop Data architecture framework.
• Design and Develop Data Integration framework (Real-time and Batch).
• Design and Develop Source to Target Data Mapping with data validation and cleansing rules.
• Developing Data Mappings using Informatica PowerCenter, Power Exchange CDC, B2B Data Exchange, B2B Data Studio.
• Perform data profiling on the source and target systems to assess data quality in EDH and GIDW using Data Quality and Analyst software.
• Fix data quality issues identified in profiling with Informatica Data Quality software.
• Coding, unit testing, moving components to Production, Rollout and Back out Plans.
• Storing the raw data from HDFS to Hive tables.
• Creating Pig Latin scripts to perform sequential data store operations.
• Creating shell scripts for Hive and Pig statement execution.
• Transferring bulk data between Hadoop and Structural data store like RDBMS using Sqoop
• Reports generation using BI tools Cognos and Tableau

Environment: DB2 10.5, SQL, Stored Procedures, Functions, Unix/AIX shell scripting, Attunity Data Replicate tool, Cognos BI, Tableau, Impala, Hive and Sqoop, Informatica PowerCenter 11.0 & B2B DX, Oracle 12c

Senior DB Developer

Confidential

Responsibilities:

• Onshore/Offshore coordination.
• Analyzing the requirements after discussion with client on conference call and through email.
• Involving in Business requirement walk through and System requirement document walk through.
• Communicating with Business and User teams to resolve any issues.
• Prepared High/low level design documents. (System Requirements Documents)
• Coding and Unit Testing using AIX/Linux, DB2 and Sybase.
• Maintaining version control for the components through PVCS.
• Debugging and diagnostic skills in batch processing.
• Coding, unit testing, moving components to Production, Rollout and Back out Plans.
• Prepared Unit test plan document for all the projects and enhancements.
• Worked with SQL Database migration projects from Sybase to DB2.
• Tools used are PVCS, Team track and cyberfusion.
• Reports generation using BI tools Cognos and Tableau

Environment: Sybase, DB2 10.5, SQL, Stored Procedures, Functions, AIX/Solaris shell scripting, Cognos BI

Confidential

Senior Database Developer

Responsibilities:

• Tracking Incentives, goals, geography, and reporting hierarchy for the Confidential Global Commercial Card Sales force that are participating in various incentive compensation plans.
• Import of data from sources that will perform automated integration with other integrated Amex systems (IRI, My Pipeline, Client profile, Instream, PeopleSoft, Walker) that GLOBIS requires to perform incentive computations.
• Perform upload of the incentive plan in XML format through GLOBIS user interface, and, perform processing of the plans by integrating with third party component called Dynamic Calculation Engine (DCE)
• Manage and Perform computation of incentive payments accordance with the defined incentive plan rules.
• Management of the tracking and payment Business plans through the capabilities that will be built by GLOBIS system.
• Ability to perform incentive calculation utilizing most up-to-date source data of charge volumes
• Ability to comply with audit the system with no control gaps.
• Actively involved in Coding and Unit Testing using DB2 SQL/PL with Stored procedures, Functions and Triggers.
• Coding, Unit Testing and Implementation.
• Prepared Low-Level Design Doc, High level Design Doc.
• Developed Test Cases and Test Scripts.
• Support various testing (Regression testing, Assembly testing, UAT, etc.,)
• Tested the Integration of different modules.
• Installation of the changes, Production Support.
• Performance monitoring & optimizing

Environment: DB2 9.5 SQL, Stored Procedures, Functions, Triggers and AIX scripting

Senior Software Engineer

Confidential

Responsibilities:

• Actively Coded and Unit Testing using DB2 SQL/PL with Stored procedures, Functions and Triggers
• Prepare Small Project Report, RDD (Requirement Definition Document).
• Preparation & review of the test cases for unit testing, integration and system testing and User Acceptance Testing.
• Source code walkthrough and review of components.
• Interacting with the onshore to fulfill the requirements.
• Prepared High/Low level design documents.
• Support various testing (Regression testing, Assembly testing, UAT, etc.,)
• Tested the Integration of different modules.
• Installation of the changes, Production Support.
• Involved in DB2 database administration activities and servers maintenance.

Environment: DB2 8.0/9.5 SQL, Stored procedures, Functions, Triggers and Linux shell scripting

Senior Software Engineer

Confidential

Responsibilities:

• Preparation of Functional and Technical Specification documents as deliverables to the client
• Actively Coded and Unit Testing using DB2 SQL, C and AIX.
• Preparation & review of the test cases for unit testing, integration and system testing and User Acceptance Testing.
• Source code walkthrough and review of components.
• Being complete responsible for delivering the quality deliverables, I have to communicate the clarifications or issues to the onsite counterpart to deliver the quality items within the given time frame.
• Tested the Integration of different modules using QTP and Test director.
• Developed Test Cases and Test Scripts.

Environment: DB2 SQL, C, Stored procedures and AIX shell scripting

Programmer

Confidential

Responsibilities:

• Analysis of specifications received through the task Manager Sheet and preparing the High level Analysis sheet with the co-ordination of Project Lead.
• Estimation of the time: Responsible for estimating the time for the given tasks.
• Coding, Peer Review and testing: Responsible for coding, peer reviews and testing of the programs to deliver the quality deliverables.
• Being complete responsible for delivering the quality deliverables, I have to communicate the clarifications or issues to the Knowledge Acquisition.
• Reviewing code & Test Cases

Environment: DB2 SQL, Stored procedures and Linux scripting