Professional Summary:

• 9.8 years of IT progressive experience, working with Cognizant Technology Solutions.
• Strong functional exposure in Banking and Financial Services Industry.
• A solution-oriented team leader with strong leadership skills, demonstration ability in managing complex large scale development (multi-site, multi-vendor), package and maintenance projects implementation in end-end software development life-cycle (SDLC).
• Excellent hands-on, designing, defect fixing, optimizing, troubleshooting skills in Ab-Initio ETL tool.
• Proficiency in data migration development from various environments using Ab Initio.
• Distinctive ideas generator with problem solving, business analysis, design and process acumen.
• Well versed in project and change management, managing stakeholders, interdependencies, risks, quality assurance and financial management of large software projects.
• Demonstrating ability in cutting IT maintenance cost, providing workable strategies, building teams for maximum effectiveness.
• An effective leader and communicator with strong interpersonal, leadership, analytical and relationship management skills with constant strive for improving and automating the processes.

Expertise in

• Software Development Methodology/SDLC (Waterfall, Agile) Models
• Designing ETL Artifacts using Ab Initio, development and Implementation.
• Team mentoring and Management.
• Project Planning - Scope, Estimation, Risk, Quality and Communication Management.
• Project Financial Management, Risk Management, Capacity & Release Planning.
• Fixed Bid / Time & Material type projects with End-to-end Global delivery model

Technical Proficiency:

Strengths : Ab Initio, UNIX & Oracle 9i
Programming Technologies/Languages: C, C++, PL/SQL, UNIX Shell Scripting
Tools : Microsoft Visio, MPP
Operating Systems : Windows XP/Vista
Databases : DB2, Oracle 9i, Teradata
Job Scheduling Tools : Tivoli, Autosys
Source Control : VSS, VCS, EME
Other Tools : Business Objects
Education Qualifications:

Bachelor of Technology (B.Tech) in Computer Science and Engineering .
Work Authorization: H1B Valid till July-2015

Confidential,Employer since Mar’10
Designation – Technology Lead

Rewards/Certifications:

Honored with “BCM Star Performer” award in 2007 for optimizing the Project One application batch jobs time of execution. Tuned SQL queries/tables used by the batch jobs, which resulted in reducing the job execution time from 2 Hrs to 20 minutes for each job.

• Honored with “Highly Performed Associate(HPA)” award in 2010 for handling the Cache Data Facility Project Development and quality related activities with ‘NO’ or 0% deviations without compromising on the challenging time lines.

Completed “CMMI High Maturity Course” (Cognizant Internal) in 2010
Completed “T100-Oracle PL/SQL Dvlpr Certified Associate-L1” in 2008
Completed T100-Oracle PL/SQL Dvlpr Certified Associate-L2” in 2008
Completed “FDN-BN101-DB - Foundation Course in Banking” in 2007
Completed “FDN-BN102-DB - Foundation Course in Banking” in 2007
Completed “FDN-CM101-DB - Securities- Overview” in 2005
Completed “Ab Initio Foundation Course” (Infosys Internal) in 2004
Infosys Certified Software Engineer (Considered one of the best in the industry) in 2003

Professional Experience:

• Project Name: AMEX-IDN Support.

Technology Lead
AMEX, Phoenix, AZ
Confidential,Nov 2011 – till date

Description:
AMEX-IDN is a support application exists to address internal/external user queries
Also acts as source system for couple of IDN-downstream systems. This application constitutes of three components. And these are Source (External/Internal), DM, WH.
Source (External/Internal) – Data providers or Up streams, which sends data to IDN application to process it.
DM (Data Management) – ETL part, where we perform transformation logic and create load ready files for the next WH process.
WH (Ware House) – Sybase Data base part, where we take the load ready files created by DM process and pushes them to respective tables after performing data quality checks.
Key Responsibilities:

Client Interaction.
Project Weekly Status Reporting to Senior Management
Help the team in closing the issues/tickets in timely manner
Team Management

• Provide solutions to the client on optimization of the application.
  

Environment: Oracle 9i, Ab Initio, UNIX, Sybase, Tivoli

• Project Name: Automated Scoring Engine

Technology Lead/ETL Architect
Confidential,Oct 2010 – Oct 2011
ASE exists to deliver key quantitative indicators (scores) to the business for use as inputs to the decisioning process in customer and account level strategies and as inputs into developing other scores and segmentations. These risk, valuation, and behavior scores provide business critical value for credit risk, marketing and other Chase Card Services operations. Historical information is gathered on cardholders and their accounts, behaviors, and credit and includes large quantities of information currently supplied by TSYS and internal systems. All of this related information is provided to specialized analytical models that create scores. Thus, the ASE can create multiple scores and variables from a single analytic model.

Key Responsibilities:

Team Management.
Worked on proposals; project planning, project scoping, estimation, resource planning, quality & risk management and client management
Conducts Weekly Capacity Planning Meetings – Assess the capacity of the team (Onsite/Offshore) and slot projects/enhancement requests into a release
Project Weekly Status Reporting to Senior Management
Anchors Release Management for multiple releases in the unit

Environment: Oracle 9i, Ab Initio, UNIX, SQL Developer, Tivoli

3. Project Name: Cache Data Facility
Technology Lead
Confidential,Mar 2010 – Sep 2010

CDF (Cache Data Facility) is an application which populates a high availability database with copies of customer and account data from the Systems of Record. It supports Inquiry business services only. And this application is encapsulated within the business services of APS and ECPR (Downstream systems). Data in CDF remains current through Weekly/Daily batch extracts and intraday change notifications (via MQ). The Current consumers are Internet and IVRU. Business processes and channels are carefully chosen to reduce risk of using ‘slightly stale’ data i.e. due to the latency in updating CDF from the SORs. It enables new features/functionality: 18 month extended transaction history for DDA accounts
Key Responsibilities:

• Responsible for Leading the team and helping them in Build activities such as creating the dmls from the Cobol copybooks
• Helped QA team by providing the SQL queries required for data validations
• Conducted code walkthroughs and reviewed peer code and documentation
• Conducted the Defect Prevention activities with a process driven approach
• Interaction with Client and coordination of Onsite and offshore project activities.
• Received, analyzed and responded to user enquiries on ETL applications
• Extensively used Performance Tuning Techniques wherever applicable
• Excelled in writing SQL queries for Oracle Database using Toad.
• Involved in preparing Implementation Plan and providing Implementation Support
• Imparting domain and technical knowledge to the team members.
• Responsible to perform impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities.
• Involved in Requirements Gathering, performing analysis on the business requirements and development of high level and detailed system design, test environment set-up, system testing, QA support, Implementation Support.

Environment: Oracle 9i, Ab Initio, UNIX, Toad, Autosys

• Project Name: Integrated Fulfillment Manager

Technology Lead
Confidential,Jul 2009 – Feb 2010
Description:
The IFM platform exists to queue, deliver, and reconcilefulfillment actions to downstream systems, and to publish and maintain a history of the status of submitted fulfillment requests. It provides a Common Interface – for both the DA Community and Upstream Developers.
The subsystems in IFM include, IFM User Interface (WLI), Orchestration Services, RTM Services, Control Tables, Data Management Systems and User Stage Tables. The ETL (Ab Initio) executes the action types and delivers the outbound files.

Key Responsibilities:

• Involved in analysis of the requirements
• Trained the new team members in understanding the Meta data tables such as job status, Job summary which will be used to track the status of a ETL application runs.
• Was responsible for client interaction and offshore coordination.
• Given the data fixes in Ab Initio, Oracle for fixing any data issues.
• Helped team members in Finishing built activities
• Responsible for successful end to end delivery of entire project to the client.

Environment:Ab Initio, UNIX, Teradata, DB2, Toad, Tivoli

• Project Name: Reporting Data Base

Software Engineer
Infosys Technologies Ltd., June 2005 – Nov 2007
Confidential,Switzerland
Description:
RDB is a Reporting Data Base of BI application which has web-based analytical reporting capabilities for Citigroup Private Bank. The system makes information accessible via web interface ensuring convenience and flexibility to different categories of users like bankers, financial controllers, and front Office staff and Marketing staff. It captures financial and non-financial data from different sources to support planning and analysis functions by reporting revenues and expense at a market region level. Business Objects (BO) tool is used in this project for report generation.

Key Responsibilities

• Involved in analysis of the requirements
• Designed and built reports in Business Objects.
• Was responsible for client interaction and offshore coordination.
• Designed and Built the Ab Initio Graphs.
• Helped team members in Finishing built activities
• Provide on-call support to production system to resolve any issues

Environment:Ab Initio, Oracle, Business Objects, UNIX