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

Current Employer: Cognizant Technology Solutions - 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
Confidential, Phoenix, AZ
Confidential, Nov 2011 - till date

Client:

Confidential, is an American multinational financial services corporation headquartered in Three World Financial Center, Manhattan, New York City, New York, United States. The company is best known for its credit card, charge card, and traveler\'s cheque businesses. Amex cards account for approximately 24% of the total dollar volume of credit card transactions in the US, the highest of any card issuer.

Description:
Confidential, 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

Client:

Confidential, is an American global securities, investment banking and retail banking firm. It is a major provider of financial services, with assets of $2 trillion, and is the U.S. banking institution having the second largest market capitalization and third largest domestic deposit base (behind Wells Fargo and Bank of America).

Description:
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

Project Name: Cache Data Facility
Technology Lead
Confidential, Mar 2010 - Sep 2010

Client:

Confidential, is an American multinational diversified financial services company with operations around the world. Wells Fargo is the fourth largest bank in the US by assets and the second largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit card.
Description:
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

Client:

Confidential, incorporated in July 21, 1994, is a diversified banking company focused primarily on consumer and commercial lending and deposit origination. Its principal business segments are Local Banking and National Lending. Local Banking includes consumer, small business and commercial deposits, and lending conducted within its branch network. The National Lending segment consists of three sub-segments: the U.S. Card sub-segment, which consists of domestic consumer credit and debit card activities; the Auto Finance sub-segment, which includes automobile and other motor vehicle financing activities, and the Global Financial Services sub-segment consisting of international lending activities, small business lending, installment loans, home loans, healthcare financing and other diversified activities.

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
Confidential, June 2005 - Nov 2007
Onsite Location - Zurich, Switzerland

Client:

Confidential, a major international bank, is the consumer banking arm of financial services giant Citigroup. Citibank was founded in 1812 as the City Bank of New York, later First National City Bank of New York. As of March 2010[update], Citigroup is the third largest bank holding company in the United States by total assets, after Bank of America and JP Morgan Chase. In addition to the standard banking transactions, Citibank offers insurance, credit card and investment products. Their online services division is among the most successful in the field, claiming about 15 million users.

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

Project Name: Project One
Sr. Software Engineer/Programmer Analyst
Confidential, Mar 2003 - June 2009

Client:

Confidential, a major international bank, is the consumer banking arm of financial services giant Citigroup. Citibank was founded in 1812 as the City Bank of New York, later First National City Bank of New York. As of March 2010[update], Citigroup is the third largest bank holding company in the United States by total assets, after Bank of America and JP Morgan Chase. In addition to the standard banking transactions, Citibank offers insurance, credit card and investment products. Their online services division is among the most successful in the field, claiming about 15 million users.

Description:
Project one is an initiative to meet the objectives such as Collecting and reporting an integrated view of each customer's total wealth picture, Serving as a single consistent, easily accessible source of data for internal and external users, Supporting flexible, table-driven, methods for defining the ways in which financial reports can be categorized. We transform the data that we get from the client (in the form of feed files), by applying certain logical transformations and load the data into the database after verifying and validating maximum possible conditions we can. The data loaded by us in the database is the clean data which is ready to be used by the front end team in order to generate reports etc for the customers of the Client.

Key Responsibilities:

• Involved in analysis of the requirements
• Extensively used Ab Initio for ETL part, Used conditional components, Table Load components
• Created High level, Low level design documents in Visio
• Was responsible for client interaction and offshore coordination.
• Designed and Built the Ab Initio Graphs, Unix Wrappers, defined Job schedules.
• Helped team members in Finishing built activities

Environment: Ab Initio, Oracle, UNIX Tivoli and TOAD