CAREER SUMMARY :

Seeking a challenging and growth oriented position as a Software Analyst in developing business applications and, Data Warehousing to be a part of a team that dynamically works towards the growth of organization.

PROFESSIONAL SUMMARY:

• 12 years plus of IT experience in software development, designing and implementing high quality business solutions, with major focus on Data Warehousing and Business Intelligence.
• Extensively worked in designing, developing, implementing and maintaining applications in Banking,Insurance and Utility industry.
• More than year strong experience in Plan >It and Conduct >It and data Profiler.
• Extensively worked in Extract, Transform and Load process for ODS and DSS Database instances.
• Responsible for Managing 10 resources and project costs for about 2 million per year.
• Implementation of various projects in large Data Warehouse Applications that includes design, development, systems integration, data analytics, application architecture and project management.
• Proven experience in building/working with Global Teams in a shared service delivery model.
• ProvenExperience in creating, maturing and maintaining a successful onsite/offshore vendor relationships.
• Enjoys developing and leading High Performing Teams of application developers in a shared services model spread across multiple geographic locations.
• Strong experience in managing the development and implementation of complex Data Warehouse functions for finance projects.
• The ability to set priorities, plan/organize, and carries out assigned tasks in an efficient manner.
• Good at Building Team and has experience in all phases of the project Life Cycle including project definition, analysis, design, coding, testing, implementation and support.

Technical Skills:

• Languages : C, COBOL, SQL, PL/SQL, Transact SQL, UNIX Korn Shell Scripting
• ETL Tools :Ab-InitioCo>op3.1.5.0/2.8/2.11/2.12/2.14/2.15.7.2,DataStage7.5,DS Designer, DS Director, DS Manager,Informatica8.1/8.3
• BI Tools : Business Objects BODI 6.5/Xi R2/,Cognos
• Database : Oracle 10g/9i/8i/7.x,UDB/DB2,TeradataR2V5,SQL Server 6.5/7.0
• Apps Servers : Oracle Application server, Web logic 5.1/6.0, Net Dynamics 5.0
• O/S : SUN Solaris 8x, HP 11i, Linux,MVS,TSO/ISPF, WindowsXP/2000/NT

Professional Experience:

Confidential

AbInitioLead/Architect

Confidential is a Confidential in-house product line for authorizing and capturing payment transactions in real time round the clock, Merchants benefit from fast, secure and compliant payment processing. Confidential Real-time Authorizations enables you to work with a single source system which provides you cost efficient transaction processing engines.

Roles:

• Creating and submitting the JCL's to make sure the data originating from source is making into target properly in the right format.
• Involved in creating andmaintaining the health check monitor backup log and error scripts in Unix for all the Environment as well as all the Unix servers.
• Creating the Repository's for the new projects and its new directory structure based common standards.
• Creating the functional id's as well as Validating the id'sto make sure they get created and associated with right primary and secondary groups added.
• Responsible to new software upgrades as well as coordinate the releases in all the upper environments.
• Expertise in building transformations and jobs for data mapping, data warehousing,
• data manipulation and data consistency.
• Created groups in the repository and added users to the groups and granted privilegesexplicitly and through group inheritance.
• Monitor and troubleshoot the performance issues and suggest the bottle necks and peak skew area'swithin the ETL processes.
• Creating and maintaining the Sudo list for all the functional id's accesses and its USS security with the OMVS segments.

Environment:Ab-Initio 3.1.5.0/2-11-7-e11-1, Gde2.1.5.0/2-11-17-2, ERWIN 3.5, Teradata V2R4/V2R5, Teradata Utilities Query man, BTEQ, FastLoad, Multiload ,Netezza,IMS/DB2, Unix shell scripting, Z/OS UNIX, TSO/ISPF , JCL, Change man 7.1 .

Confidential

Sr. DW Lead Analyst

Confidential The Customer Profitability system of record for Confidential, bringing transactional data from functional area systems of record and applying strategic rates to get the derived values into customer level profitability.

Roles:

• Responsible for leading 6 resources and project costs for about 1.2 million per year.
• Involved in defining the Extract, Transform and Load process, using Ab Initio for ODS and DSS instance by reviewing the business requirement from the business users.
• Responsible for designing Parallel Partitions CPU bound Ab-Initio Graphs for high volume data warehouse.
• Analyzed the existing process for the impact analysis for various changes and suggested multiple options for improving the process and easy maintenance.
• Involved in CNE company number expansion from three digit format to fivedigit number expansion of existing extracts.
• Designed and developed the ETL enhancements to CLPR extracts for the DFS project for the commercial loans and consumer loans.
• Creating and Maintaining the repository's for the new projects and its new directory structure based common standards.
• Implemented the Dealer financial services for commercial loans as well as consumer loans to make sure the profitability of the CLPR process is originating from the source to target properly.
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process
• Created test cases to make sure the data originating from source is making into target properly in the right format.
• Created the parameter driven generic load processes andETL routines to make sure that they don't break on heavy loads.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.

Environment: Ab-Initio GDE 1.15.7.2, CO>OP 2.15.7.2, Oracle 10G, Teradata V2R6/V2R5, Teradata Utilities Query man, BTEQ, FastLoad, Multiload ,Unix shell scripting, Test Director, AIX UNIX.

Confidential

Sr. DW Analyst

Confidential has Priority One applications GLW, FINS, CGL. Development, testing support with offshore, from onsite Columbus. Managed various applications along with the team on a day-to-day basis and provided technical support to meet all SLAs. These applications include P1S3, P2 and P3 priority applications. Complete support including yearly, monthly, daily and weekend.

Roles:

• Designed Mass reversal process in Robust ETL Framework with common projects integration.
• Preparation of Detailed Design Specification and Technical Design.
• Co-coordinating with the Offshore team and leading the onsite team.
• Testing on Pre-pod environments.
• Developed Deployed ETL processes , tested and reviewed the team efforts.
• Managing Mentoring Integration for offshore deliveries.
• Performance testing and tuning of processes.
• Participated mocking test data to satisfy test scenarios.
• Responsible for Application Delivery Issue Management.
• Responsible for production support and Team management.
• Participated in Integration testing, Performance testing and supported User acceptance testing.
• Provide the resolution for any kind critical error in Production system especially for Severity 1 and Severity 2 tickets .

Environment: DataStage 7.5,DataStage Designer, DataStage Director, DataStage Manager, Oracle 9i, UNIX Shell Scripts, Windows 2003/NT 4.0, ERWIN 7.3, Meta Stage and Integrity. Unix shell scripting, Oracle 10g , ECMS, Contol M , Peregrine.

Confidential

Sr. DW Analyst

The Confidential contains transactions done by bankers at Banking Centers, Call Centers, or Back Offices. Confidential and non-monetary transactions are captured on a daily basis, Daily Platform Account Close Measure contains data about the function that allows the banker to close a checking or savings account. The function enables Bankers to change the account status in the System of Record to In Process of Closing, automate the transfer of funds to another account and assess a closing fee, if applicable, this table contains CD closures redemptions ..

Roles:

• Created DML's and XFR for validation and cleansing also formatting into DB2 expected format.
• Scheduled the etl table loads for the RSI landings and also scheduled the jobs using maestro scheduler.
• Did the source balancing for all multiple sources and compared with the data loaded into the tables.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Created Ab Initio transformations xfr's to transform the data as per the Technical Specifications document TSD based on the XML parser event types.
• Created the rolling tables using XPIO based on event types.
• Involved in production support on rotation basis.

Environment: Ab-Initio 2.13.10 GDE 1.13.10, Unix shell scripting, Enterprise Change Management, pvcs, Xpio chase home grown toll for metadata repository ,Tivoli work station TWS .

Confidential

DW Analyst

Confidential has various divisions like credit card services, personal loans, home loans, Brokerage, checking and Savings. This project involved the implementation of a consolidated data mart solution for the credit card division, which enabled a consistent view of customer information, This consistent view of data enabled to generate reports on various aspects of a customer which finally are used in the decision making process. The required data was extracted from different sources like Legacy Systems and Oracle. The extracted data was transferred and then loaded into the target database using Confidential.

Roles:

• Participated in analyzing the business rules and involved in the logical physical design of the data warehouse.
• Created Ab Initio transformations xfr's to transform the data as per the Technical Specifications document TSD .
• Involved in creating High Level Design HLD and Detail level design DLD of Ab Initio Graphs.
• Familiar with most Ab Initio predefined components to develop the Ab Initio graphs.
• Design and develop data validation, mapping load programs using ETL Ab Initio tool.
• Modified Ab Initio components parameters and utilized data parallelism there by improving the overall performance to fine-tune the execution times.
• Developed generic graphs for loading and extracting data from legacy databases
• Used EME and Sandbox to check-in and check out the common and private for projects.
• Developing Ab Initio graphs as daily and monthly cycle for loading, partitioning, cleaning and populating the data based on business requirements.
• Worked with Partition and Departition components in order to control the execution of the graph in parallel serial to optimize resources.

Environment: Ab-Initio 2.13.10 GDE 1.13.10, Unix shell scripting, AIX UNIX, Business Objects Data Integrator BODI , Harvest, Enterprise Change Management, Tivoli work station TWS , Test Director.

Confidential

Data Warehouse Developer

Roles:

• Alter schedule parameters of production jobs as necessary.
• Creating Ab-Initio graphs for click stream analysis of data.
• Created different Generic Graphs using the Ab Initio components for ODS and DSS environment.
• Configure the db configuration file to connect to the ODS and DSS to Load the Data.
• Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the Ab-Initio partition components to segment Data.
• Review the graphs and entire code walk through and also analyzing the business requirements, before transition the application to IPS DSS.
• Perform code reviews and made design documentation to help enforce standards and enhance maintainability and performance of applications.
• Field inquiries from business units, end users, and other support teams pertaining to daily operation of production data warehouse applications.

Environment: Ab-Initio 2-11-7-e11-1, Gde1-11-17-2, PL/SQL, ERWIN 3.5, Business Objects Data Integrator BODI ,Teradata V2R4/V2R5, Teradata Utilities Query man, BTEQ, FastLoad, Multiload , Unix shell scripting, AIX UNIX, Testdirector , Clarify , ClearQuest, Morpheus, Centralized Change Control, ControlM.

Confidential

Data Warehouse Developer

Confidential Division has the Customer2Touchpoint Next Generation database enhancement project Confidential to expand the depth and breadth of information available about Confidential across channels, products and locations as well as to make that information more easily accessible for all the database's users and stakeholders. Confidential database accumulates data on customers and their accounts from various systems of record Confidential across the Bank. Because much of the information is maintained at a customer level, this enables users to develop insights into customer purchase patterns, retention, value creation, channel preference, and other drivers of banking decision engines.

Roles:

• Running the shell scripts prior to weekly or monthly to update load process dates in the effective date formats of the graphs.
• Enterprise Meta Environment to check out the status of the graphs and estimating the time factors depending upon the data volume size.
• Designed and deployed the Extract, Transform and Load process, using Ab Initio for ODS and DSS instance by studying the business requirement from the business users.
• Creating the Multifile which gives the user the ability of central control of distributed data files, and they provide the scalability and access patterns that parallel applications require.
• Implemented a 16 way multifile system that is composed of individual files on different nodes that are partitioned and stored in distributed directories.
• Involved in Ab-Initio existing Graph modifications adding the new functionality to improve the performance in Load graph process.
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process.

Environment: Ab-Initio 2-11-7-e11-1, Gde1-11-17-2, PL/SQL, ERWIN 3.5, Teradata V2R4/V2R5, Teradata Utilities Query man, BTEQ, FastLoad, Multiload , Unix shell scripting, AIX UNIX, Windows NT/2000, Autosys 5.0.

Confidential

Data Warehouse Developer

The Confidential businesses comprise of the diverse consumer product offerings like medical supplies, for the corporate wide, This system provides investment health management and related services to a broad spectrum of clients around the world, from beginning corporate to wealthy individuals and large institutions, both public and private. The data warehouse, which is running on Oracle, was built using snowflake schema.

Roles:

• Involved in the Extract, Transform and Load process, using Ab Initio for ODS and DSS instance by studying the business requirement from the business users.
• Responsible for designing Parallel Partition CPU bound Ab-Initio Graph for high volume data warehouse.
• Implemented the Parallel application by replicating the components- datasets and processing modules into number of partitions.
• Analyzed source and target data models and make necessary changes.
• Involved in Ab-Initio Graph Design and Performance tuning to Load graph process.
• Created test cases to make sure the data originating from source is making into target properly in the right format.
• Stress testing of ETL routines to make sure that they don't break on heavy loads.
• Consolidated customer records from various sources to create master customer list.

Environment: Ab-Initio 2.8, PL/SQL, Oracle 8 Unix shell scripting, Test Director, AIX UNIX, Windows NT/2000.