PROFESSIONAL SUMMARY:

• About 9 plus years of overall experience in diverse Designing, Developing, Implementing and Testing Data warehouse Applications in the Domain of Banking, Has extensive hands - on experience in ABINITIO DEVELOPMENT and UNIX. Have worked with the Banking giant like Confidential and currently working with the Client Confidential .
• A hard working and talented professional with excellent communication, analytical and programming skills, ability to work effectively in a team, flexibility to work on different technologies, a self-learner with proven expertise in development activities, including requirement analysis, design, testing and client interaction.
• Involved in complete life cycle of the Project like Requirement gathering, Source System Analysis, Development, Testing of all process and code components and implementation of the project.
• Interaction with the client on a daily basis for requirement gathering and status updates.
• Proficient in the development of ETL (Extract, Transform, Load) processes with a good understanding of source to target data mapping, ability to define, capture Meta data and Business rules
• Had been responsible for implementing 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.
• Worked with Reformat, Rollup, Scan, Join, Partition, Read Excel and Write Excel, Input table, and Output table components
• Worked using Input and Output table components for loading operational or source data into database.
• Involved in different types of testing including system integration testing and unit testing.
• Development of Ab-initio graphs for historical updates.
• Creation of wrapper scripts, Validation script & Stored Procedure.
• Involved in Performance Tuning of Ab Initio graphs using Various Ab-Initio Performance Techniques.
• Involved in conducting reviews for the Ab Initio codes after development.

TECHNICAL SKILLS:

Methodologies: STAR & SNOWFLAKE modeling and Agile.

Tools: Ab Initio (Ab Initio - XFRs, EME, Data Profiler, Web Services, Messaging and Queues, and Control-m

BI Tools: Business Objects

Database & Utilities: Oracle 8i/9i/10g, TeradataV2R5/V2R6, SQL Server 6.5/7.0, Sybase11.0, FastLoad, MultiLoad, Oracle SQLLDR and DB2

Programming Tools: Basic Java, C#.Net, C, C++, TOAD, Oracle SQL Developer, Unix Korn and C shell.

Scheduling Tools: Autosys, SAM, Operational Console and Control M

Data Profiling Tools: Ab Initio Data Profiler. Ab Initio ACE

Operating Systems: SUN Solaris 8x, HP 11i, Linux, Windows XP/2000/NT

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead

Environment: Ab Initio, UNIX, DB2 UDB

Responsibilities:

• Prepared documents like LDD, solution architecture, security interaction and test case document etc.
• Understanding and preparation of requirements for the user stories.
• Designing of basic framework that ensures maintenance of proper coding standards.
• Interacting with the other Team members and resolving the concerns within the other modules of the Project.
• Considering the challenges that are faced and documenting these and take it to the clients for deciding on the exact resolution Methods.
• Conducted Knowledge Transition (KT) sessions to other developers.
• Design & Development of Ab Initio graphs using various components like Transform (Reformat, Filter By Expression, Join, Dedup etc), Partition (Partition By Expression, Partition By Key, Partition By Round-Robin etc), Departition (Concatenate, Gather, Merge, Interleave), Sort (Sort, Sort within Groups) and Multi stage (Rollup, Scan, Normalize) that run on a daily, weekly and monthly basis and FTP reports/files to client Servers.
• Creation of Unix wrapper scripts for supporting the Graphs in PROD environment.
• Worked with generic graphs.
• Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like Check In and Check Out were used for this purpose.
• Performing Transformations on source data with Transform Components like Reformat, Filter-by-Expression, Rollup etc.
• Done appropriate unit-level testing, log defects in QC and the management of the review process for the Ab Initio deliverables.

Confidential

Project Lead

Environment: Ab Initio, UNIX, DB2

Responsibilities:

• Involved in the functional and detailed design of the project.
• Worked on developed dynamic graphs to register the files received from source systems or any third party sources.
• Development of Ab-initio graphs for historical updates.
• Creation of wrapper scripts, Validation script & Stored Procedure.
• Interaction with the client on a Weekly basis for requirement gathering and status updates.
• Involved in Performance Tuning of Ab Initio graphs using Various Ab-Initio Performance Techniques.
• Involved in conducting reviews for the Ab Initio codes after development.
• Developed graphs to load data into tables and validate the new data in comparison with already existing data.
• Wide usage of Lookup files while getting data from multiple sources and size of the data is limited.
• Process and Transform delta feeds of source data, which comes in daily.
• Developed one-time graphs for data quality checks and to find potential issues.
• Performed transformations of source data with Transform Components like Join, Dedup Sorted, Rollup, Reformat, and Filter-by-Expression.
• Used EME repository to perform check-in and check-out project objects.
• Performed reject and error analysis on graphs by attaching error and rejecting files to each transformation and making provision for capturing and analyzing the message and data.
• Extensively used Database, Dataset, transform, Sort and Partition components for extracting, transforming and loading.
• Involved in System Integration testing and Unit Acceptance testing.
• Tuning of Ab Initio graphs for better performance
• Used Oracle SQL Developer to verify the counts and results of the graphs.

Confidential

Senior Analyst Programmer

Environment: Ab Initio, UNIX, DB2

Responsibilities:

• Involved in all the phases of the project.
• Development of Ab-initio graphs for historical updates.
• Creation of wrapper scripts, Validation script & Stored Procedure.
• Interaction with the client on a Weekly basis for requirement gathering and status updates.
• Involved in Performance Tuning of Ab Initio graphs using Various Ab-Initio Performance Techniques.
• Responsible for the pre & post implementation validation.
• Created Test Plans and Test scenarios.
• Giving support to the application after the Implementation in warranty period and resolving the issues.

Confidential

Lead

Environment: Ab Initio, UNIX, DB2

Responsibilities:

• Development of Ab-initio graphs for historical updates.
• Creation of wrapper scripts, Validation script & Stored Procedure.
• Develop new ETL historical data conversion graph to load LCA / Corporation / MCA / ICA / BCA Profile currently on Stellar onto Confidential .
• Interaction with the client on a Weekly basis for requirement gathering and status updates.
• Involved in Performance Tuning of Ab Initio graphs using Various Ab-Initio Performance Techniques.

Confidential

Senior Analyst programmer

Environment: Ab Initio, UNIX, DB2

Responsibilities:

• Involve in Development Life Cycle to analyze the requirement, Design & Build a Graph
• Interaction with the client on a Weekly basis for requirement gathering and status updates.
• The Sources System files from Different source systems need to be separated based on the Subject areas
• Developing Ab Initio Graphs by using the different components as per the business requirements.
• Involved in conducting reviews for the Ab Initio codes after development.
• Giving support to the application after the Implementation in warranty period and resolving the issues.

Confidential

Senior Analyst programmer

Environment: Ab Initio, UNIX, DB2

Responsibilities:

• Consistent reuse of Ab Initio artifacts, for example transform functions and record format definitions.
• A clear demarcation between country specific functionality and common elements to ensure that the implementation is repeatable for multiple countries.
• Data acquisition handles enterprise and country specific source interface feeds.
• The DA Framework contains utility graphs to read flat file source definition spreadsheets to generate internal Ab Initio definition objects (DMLs). These can also be auto-generated by AI for some source types (Database tables, COBOL Copybooks, Data Models, etc).

Confidential

Senior Analyst programmer

Environment: Ab Initio, UNIX, DB2

Responsibilities:

• Communicates Managers/users along with on-site Coordinator to get the exact requirements.
• Involved in the Detailed Design of the Source System Transformation.
• Developed a Graph which used as a Validation for all the input files of different sources based on the rules applicable.
• The Sources System files from Different source systems need to be separated based on the Subject areas
• Developing Ab Initio Graphs by using the different components as per the business requirements.
• Involved in conducting reviews for the Ab Initio codes after development.
• Extensively used transformations like Partition components, Join, Replicate, Reformat,
• FilterByExpression and Rollup various standardized business processes.
• Translate business requirements to design
• Developing Ab Initio Graphs by using the different components as per the business requirements.
• Involved in testing the functionality of the modules
• Involved in Designing the Technical Design Document and prepared Unit Test Cases
• Giving support to the application after the Implementation in warranty period
• To make a development or correction to the existing graph if the job failure is related to Ab Initio graphical development issues.
• To run the graph after the correction and check whether it is implemented correctly or not