SUMMARY:

• 4.8 years of IT experience in working with teams, involved in giving comprehensive IT solutions, which include Analysis, Design, Development, Implementation and E2E Testing.

• Experience in Ecommerce and credit card LOB in Banking.
• Expert skill levels in data warehouse and data mining technologies.
• Gained good team handling experiences while working as a Module lead at offshore and onsite. Coordinating and organizing team prioritizing and assigning work packets, providing technical solution and supports have been part of his role are the responsibilities taken up by him in this role.
• Practical understanding of all phases of SDLC with proven experience in successfully executing assignments of requirements gathering, estimation, design, development, testing and deployment of software systems, maintenance and production support.
• Proven experience in testing software applications including but not limited to creation of Test plans, Test execution, Defect tracking, Resolution, Documenting and Reporting.
• Possess strong interpersonal skills and positive attitude. Have excellent dedicated and conscientious work ethic, able to work independently or as participating member in a team environment.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.
• Excellent problem solving, communication, analytical, interpersonal skills, quick comprehension and problem solving skills.
• Experience in handling and setting up of successful transition of services for Live Support.
• Have good experience in Integration, Migration, Conversion and Data projects

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1x, Microsoft SSISInformatica Data Transformation, TeradataBTEQ,TPT,Mload,Fastload and Fast export

Scheduling Tools: Autosys

RDBMS: Oracle (11g/10g), Teradata, SQL Server 2008, DB2

RDBMS Load Tools: SQL*Loader (Oracle), TPT,Mload and Fast load,TPUMP

Languages: Unix, Linux, SQL and Shell Scripting

Operating System: MS Windows 7/Vista/XP/2000/98, UNIX and Linux

Packages: MS - Office 2007/2003/XP/2000,MS Word and Power Point etc.

SKILLS INVENTORY:

• Worked in SDLC (Waterfall), Agile and Iterative Methodologies

• Onsite and Offshore Coordination
• Impact analysis
• Application Design and Artifacts
• Development
• Test plans and test scripts review for System/System Integration and User Acceptance testing
• Defect Triage, Tracking & Management
• Implementation and Support
• Team Management and Status reporting

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte

Onshore Tech Lead

Responsibilities:

• Participated in requirement gathering sessions.

• Performed deep analysis on all applications hosted on MDP Platform and documented changes for the rationalization effort.
• Planned and conducted knowledge sharing sessions on each application for the benefit of new entrants to team.
• Preparation of design and test plan documents.
• Outlining parallel test approach plan specific to each application.
• Analysis and suggestions for rationalization wherever applicable.
• Coordinated the team and was involved in prioritizing and assigning work packets, providing technical solution and supports have been part of her role and are the responsibilities taken up by her in this role.
• Performed Impact analysis for fork lifting existing MDP applications to EDM.
• Involved in new data warehouse set up.
• Analysis and documentation of constraints on new EDM data mart compared to existing MDP data mart.
• Work around and solutions to fix stored procedures and user defined functions that were used in MDP but are not supported on EDM.
• Created Functional Specification and involved in design of new and complex high quality performance solutions to clients in response to varying business requirements.
• Collaborated with cross-functional application teams to come up with design options for the rationalization phase.
• Constructed program modules, reviewed them and implemented in test stages.
• Extensively worked on test data preparation, test case execution and bug reporting using parallel test approach.
• Implementing the software product developed and monitoring critical jobs.

Environment: Teradata Marketing Data Platform, Enterprise Data Mart,Informatica 9.1

Senior Developer/Module Lead

Confidential

Responsibilities:

• Understanding of Business Requirements and High Level Design

• Impact Analysis for the program changes and creation of High Level Design and Low Level Design.
• Being a base resource for CIM application worked on adhoc change requests for all CIM applications, that included report generation using new TPT file export jobs, conditional data cleansing and sync up etc.
• Development and testing of Teradata bteqs, TPT and shell scripts for TCLV application.
• Review and testing of SIOP LMM bteq and shellscript changes.
• Constructed program modules, reviewed them and implemented in test stages.
• Development and testing of DEDUP code to eliminate duplicates in incoming FOOD and SASI Full refresh files to increase performance.
• Creating JIL files to schedule jobs on Autosys.
• Being a module lead had additional responsibilities of timeline estimation for each work assigned, task set up for the team, task creation, team CM audit SPOC, regular knowledge sharing session coordinator and primary reviewer for all code changes in the project for any application in CIM.
• Extensively worked on test data preparation, test case execution and bug reporting using parallel test approach.
• Implementing the software product developed and monitoring critical jobs.

Environment: Teradata Marketing Data Platform, Informatica 9.1,Orcale, Unix, Autosys.

Module lead

Confidential

Responsibilities:

• Requirement gathering and analysis.

• Preparation of high level and low level design documents.
• Provided useful suggestions to change data model to suite our requirement best.
• Organized Informatica knowledge sharing session for the entire team for the benefit of freshers to Informatica.
• Development and testing of Informatica mappings and workflows to source data from tables and flat files and generate reports.
• Found out solution to implement to implement column to row logic using Informatica transformations.
• Worked deeply on researching better methods to generate customized excel reports using Informatica.
• Workflow parameter file set up for all Confidential worlflows.
• Debugging and end to end testing of all Informatica components.
• Creating JIL files to schedule jobs on Autosys
• Received best team and quality deliverable award from client
• Preparation of test plans and unit test case documents.
• Performing testing activities to ensure deliverables are defect free.
• Performance evaluation through collection of performance metrics.
• Performed query tuning and changes to transformations used in mappings to improve performance.
• Preparation of Implementation and Coverage plan for the release.
• Warranty support post implementation.

Environment: Teradata Marketing Data Platform, Informatica 9.1, Orcale, Linux, Unix .

Developer

Confidential

Responsibilities:

• Project involved making necessary changes to make all components hosted on the application to point to the new UNIX and Teradata servers .The etl servers on which Marketing Data applications were hosted had an license that was soon to expire, which posed the necessity to move to a new etl server.All scripts,bteqs,tpts,workflow param files,workflow wrapper scripts etc. Had to be moved to the new etl after making necessary changes to the connection strings wherever applicable to point to new etl server.The project involved considerable dive deep analysis and vigorous parallel testing.

• In-depth analysis of all 8 applications hosted on old etl server.
• Documentation and sign off for the changes captured from production support team of all applications.
• Preparation parallel test approach for all application jobs.
• Setting up parallel test environment with proper volume of data enough to capture performance as well.
• Knowledge sharing sessions to team members on all applications that are to be migrated to new etl server.
• Preparation of timeline and resources estimate for each application.
• Testing of all backend and frontend jobs on the new server based on comparison of results of parallel runs of jobs on new and old servers.
• Connection string changes to all scripts and wrapper scripts to point to new server.
• Parallel testing of all changed scripts taken care by running two versions of script in old and new etl servers.
• Comparison of results of parallel test at performance and data level to make sure there is no difference in final output nor any degradation in performance in new etl server.
• Testing of Informatica workflows of ODIN application on new Teradata server.
• Performance evaluation through collection of performance metrics for each job being moved to new etl Platform.

Environment: Teradata Marketing Data Platform, Informatica 9.1, Orcale, Linux, Unix .

Developer

Confidential

Responsibilities:

• Analysis of oracle source query functionalities to create equivalent Teradata queries or bteqs or tpts.

• Preparation of job analysis docent that was the basic referral document for alligration changes to job, as it had details such as functionality, scripts involved etc for a particular job in legacy Oracle.
• Preparation of high level and low level design documents.
• Preparation test plan and test cases documents.
• Test environment set up for migration from Oracle(Legacy) to Teradata DB of customer data mart.
• Development of Teradata BTEQs and shell scripts to read from tables and files and load into or alter tables and generate files.
• Developed jobs to read data from delimited files and load it into Teradata tables using TPT.
• Involved in review and testing of jobs created.
• Involved in code changes and testing of all the jobs that had custom views built on stage tables.
• Peer review and testing of corrected scripts.
• Knowledge sharing session on new Teradata equivalents for Oracle functionalities discovered.
• Support during prod parallel run of Confidential application.
• Played crucial role in query tuning for performance enhancement.
• Won best team player INSTA award at unit level.
• Involved in performance testing andetrkcs collection to create statistics to show performance boost when compared to using earlier database i.e. Oracle.
• Prepared document with all best practices to follow while writing a Teradata query for optimum query performance.

Environment: Teradata Marketing Data Platform, Informatica 9.1, Orcale, Linux, Unix .