OBJECTIVE

• Over 5+ years of professional expertise in Analysis, Design, Development and implementation of software applications in Financial, Banking and Insurance industries mainly in the fields of Data Warehousing and Distributed Web based applications

SUMMARY

• Five years of IT experience in Analysis, Design, Development and Maintenance of various Business applications
• Outstanding technical and analytical skills, with extensive knowledge of Ab - initio ETL, COBOL, UNIX, and IBM Mainframe Systems
• Extensive knowledge in architecture design of Extract, Transform, Load environment also worked in Administration of Ab Initio system environments
• Strong experience in System Analysis and Design and Object Oriented Analysis & Design
• Extremely effective in System Development Life Cycle (SDLC) from analysis, design, development, testing and implementation in diverse range of software applications
• Very good exposure in Agile Lifecycle Model
• Strong experience in Ab Initio GDE, Co>Operating System and Enterprise Meta Environment (EME)
• Good Experience with Ab Initio Graph Programming and Data Manipulation Language (DML)
• Well versed in Data Parallelism techniques using MFS file systems
• Experience in designing Source to Target graphs and testing of ETL Mapping
• Extensively used AIR commands, perform dependency analysis and other EME related operations
• Good Experience in Unix shell scripting
• Good Experience in scheduling and administrating jobs using Operations Console scheduler
• Good Experience with Heterogeneous Source Systems like Oracle, XML, Mainframe and Flat Files
• Extensive experience with various Ab Initio components such as Join, Rollup, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, sort, Scan, Validate, Lookup, Transform etc
• Involved in writing complex SQL queries using Joins, Stored Procedures, Functions and Triggers
• Proficient using Oracle, SQL Server, PL/SQL, SQL *PLUS
• Excellent communication skills, sound technical knowledge, strong analytical skills.
• Excellent Leadership and team management skills
• Clear understanding of business procedures and ability to work as an individual and with the team.
• Well versed in Onsite - offshore work modal

TECHNICAL SKILLS

ETL Tools/Software’s: Ab Initio GDE 3.1.1, Co>Op 3.1.5.5, EME, TRMC

Programming Languages: Cobol, JCL

Database Tools: Oracle 10g, MS-Access, DbVisualizer 7.1.5, Oracle SQL Developer

Operating Systems: Windows 9x, Windows XP, UNIX, Linux

Scheduling tools: Operations Console, Zeke scheduler, CA7

Other Tools/Software’s: Tso/Ispf, Fileaid, Changeman, Savrs, Ca-ViewCics, Ims/Db, Eztrieve, Vsam, Spufi, Syncsort, Ibm Utilities, Idcams, Tcp/Ip, Ftp, SAR, Endevor, JIRA, Confluence, Share point

PROFESSIONAL EXPERIENCE

Ab initio Technical Architect

Confidential, Columbus, Ohio

Responsibilities:

• Transformed the source files received from various Line of business applications using various DDE standards
• Involved into Design, Development, Unit testing and QA Migration
• Involved into Development and Migration Approval Meetings to ensure that there are no conflicts with other team releases
• Coordinated with Offshore Developer to get the daily updates and assign the tasks
• Involved in the Client user meetings about enhancements and daily status meetings.
• Built various Sandboxes in order to create Adhoc & Regular applications in Ab Initio.
• Used Ab Initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases
• Developed PLSQL stored procedures that meet business requirements.
• Designed and Developed the graphs using the GDE, with components partition by round robin, partition by key, rollup, sort, scan, dedup sort, reformat, join, merge, gather Normalize, concatenate components.
• Also used the components like filter by expression, partition by expression, replicate, partition by key and sort Components.
• Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Demoralize, Reformat, Filter-by- Expression.
• Create Summary tables using Rollup, Scan & Aggregate.
• Isolated and Executed the Ab initio components in order to narrow down the ETL issues
• Coordinated with Stake holders to report the ETL rejections from reject and log files to ensure that the accounts are rejected according to the business logic and transformation rules
• Analyzed the upstream data flow received in the form of feeds and moved into the staging databases
• Coordinated with downstream team to analyze the downstream data flow from the ODS into other applications
• Ensured that data quality checks are satisfied for data consistency before reconciling them and moved into ODS
• Involved into the staging cleanup if the position and transaction job fails to avoid the duplicates and data inconsistencies.
• Creating and Maintenance of several Complex Graphs in Ab Initio for various banking application projects
• Used Enterprise Meta Environment (EME) for version control, OpConsole for scheduling purposes.
• Creation of new environments, EME, Sandbox, data directories, OpConsole Systems, Application, Group, Calendars
• Involved into Installation and upgrade of Co> Op, Op Console, LDAP, Authorization gateway, Oracle client.
• Coordinate with Ab Initio support to detail study of issues faced in Ab initio environments and find solutions to fix them effectively
• Unit Testing and QA Migration & Weekend Maintenance
• System Monitoring and availability

Environment: Ab Initio GDE 3.1.1, Co>Operating System 3.1.5.5, Oracle 11g, UNIX Shell Scripting, Operations Console Scheduler, DB2, SQL

Ab Initio Technical Lead

Confidential

Responsibilities:

• Preparation Weekly Status Report to highlight the project progress, issues, risks and dependencies (Weekly Scrum Meeting in Agile Process)
• Preparation of Lesson Learned Document to document best practices followed during the release, things not going well and action items to be taken (Retrospection Meeting in Agile Process)
• Involved into the IST classification of UAT defects (ETL, Packaging and Environment) which gives the necessary inputs to the Release quality Metrics
• Exposure in Project Management through the creation of deliverables, tasks and timesheet entry through Plan Arena as part of Project Management
• Understood the business requirements with extensive interaction with Onshore coordinators and BAs
• Design and execution of Unit level test cases
• Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited.
• Used inquiry and error functions like is valid, is error, is defined and string functions like string substring, string concat and other string * functions in developing Ab Initio graphs to perform data validation and data cleansing.
• Extensively used File management commands like m ls, m wc, m dump, m copy, m mkfs etc.
• Extensively used the sandbox commands like air sandbox info, air sandbox lock, air sandbox run, air sandbox parameter, etc.
• Extensively used the EME air commands such as air tag create, air save, air project export, air promote load, etc.
• Maintained locks on objects while working in the sandbox to maintain the privacy
• Responsible for deploying Ab Initio graphs and running them through the Co-operating systems mp shell command language and responsible for automating the ETL process through scheduling.
• Involved in Comprehensive end-to-end testing.
• Implemented the Test Scripts and Updated the RTM for document defects
• Involved in Metrics Calculation such as Defect Leakage, Requirement Leakage Index, Defect Aging, Defect Retest Aging and Quality of Index
• Executed SQL Queries using DBVisualizer to verify that the values imputed in the Java Transformation are properly stored in the staging table

Environment: Ab Initio GDE 3.1.1, Co>Operating System 3.1.4, DB2, Putty, UNIX, Operations Console

Senior Application Developer

Confidential

Responsibilities:

• Excellent JCL and Cobol Programming skills.
• Developed design documentation for enhancements to mainframe system.
• Provide analysis, design and detail construction of company's corporate systems to include Revenue Accounting applications in a COBOL, DB2, CICS, SAS environment.
• Analyzed and tested new systems using Xpediter, IBM Utilities, and Eztrieve.
• Reviewed Mapping documents provided by Business Team, implemented business logic embedded in mapping documents into Ab Initio Graphs and loading tables needed for Data Validation.
• Prepared the Detailed Technical Design Document for all the modules required for development.
• Responsible for analyzing source and target data models and making necessary changes to the mapping
• Interact with LOB’s on requirements clarifications.
• Interact with Clients on business requirements changes.
• Responsible for fully understanding the source systems, documenting issues, following up on issues and seeking resolutions.
• Assigning, coordinating and reviewing deliverable.
• Testing and Preparing the Unit Test Plans.
• Integrated and User Acceptance Test cycles execution.
• Review of design, code and testing for defect free deliverables.
• Fixing Issues out of Integrated System testing and User Acceptance Testing
• Project Implementation and Production Support.
• Supporting production jobs for any IMS abend.
• Provide proven problem research and resolution skills via 24/7 weekly on-call production support of daily batch jobs
• Checking the quality of the software and determining it’s degree of compliance to standards
• Monitoring performance continuously and look out for channels of improvement and cost-cutting.
• Conducting knowledge sharing sessions on various processes and technologies used in the project to other team members.

Environment: Cobol, JCL, CICS, IMS/DB, EZTRIEVE, VSAM, SPUFI, FILEAID, CA7, SYNCSORT, IBM Utilities, IDCAMS, TCP/IP, FTP, SAR, CHANGEMAN, ENDEVOR, GDE, TRMC, OpConsole