OBJECTIVE

Over 9 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

PROFESSIONAL SUMMARY

• Over 7 years of experience in using Ab Initio as the ETL tool. Extensive knowledge in architecture design of Extract, Transform, Load environment also worked as Analyst gathering user's requirements
• 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
• Good Experience in Unix shell scripting and in writing wrapper scripts to call Abinitio deployed scripts and psets
• Good Experience in scheduling jobs using Autosys and Control-M scheduler
• Good Experience with Heterogeneous Source Systems like Oracle, XML, Mainframe and Flat Files
• Exposure on other ETL Reporting Tools such as Business Objects, OBI Answers
• 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
• Exposure onV-Model, Agile Scrum and Kanban Lifecycle Models
• Strong Knowledge of Data warehousing concepts such as Dimensions, Facts, Star and Snowflake schemas
• Involved in writing complex SQL queries using Joins, Stored Procedures, Functions and Triggers
• Exposure on CA Workload Control Center to automate the IST, UAT and Production Ab Initio ETL Jobs
• Excellent Communication Skills, Sound Knowledge and strong analytical skills
• Proficient using Oracle, SQL Server, PL/SQL, SQL PLUS, SQL Loader and TOAD
• Hands-on Experience with Java Springs, SOAP RestFul APIs, MongoDB, Pymongo and Postgres
• Excellent communication skills, sound technical knowledge, strong analytical skills.
• Clear understanding of business procedures and ability to work as an individual and with the team.

SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Abinitio Technical Lead

Responsibilities:

• Transformed the source files received from TS2, Fidelity and EOS to create the Init, Clean, Nrch and LR files using various DDE standards
• Involved into Sprint Planning, Team retrospection, and Sprint grooming meetings
• Involved into Design, Development, Unit testing and QA Migration for various Agile stories
• Developed the Agile monitoring dashboard framework to track the alerts sent to various vendors
• Involved into Development and Migration Approval Meetings to ensure that there are no conflicts with other team releases
• Involved into Abnitio 2.15 to 3.1 upgradation, Unit Testing and QA Migration
• Involved into Code Checker and Data lineage process to ensure the DDE coding standards
• Coordinated with Offshore Developer to get the daily updates and assign the tasks and burn down the sprint hours in Version1
• Involved into L3 Support on weekly basis to monitor the jobs and Control-M and address the Sev3 and Sev4 incidents
• Involved in the Client user meetings about enhancements and daily status meetings.

Environment: Ab Initio GDE 1.15, Co>Operating System 2.15 3.1, Oracle 11g, WINSCP, UNIX Shell Scripting, Control-M Scheduler, MongoDB, RoboMongo, Python, Pymongo and Java Springs , SOAP and RESTFUL API, DB2, SQL and TERADATA

Confidential

Abinitio Technical Architect

Responsibilities:

• Built various Sandboxes in order to create Adhoc Regular applications in AbInitio.
• Used Abinitio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases
• SFTP the New Existing production dumps from EMEA and ASIA regions to refresh the regional IST databases for various ETL agile scrums
• Loaded data into oracle database from various regional EMEA and ASIA operational data sources.
• Developed PLSQL stored procedures that meet business requirements.
• Creating and Maintenance of several Complex Graphs in AbInitio for various banking application projects
• Used Enterprise Meta Environment EME for version control, Autosys for scheduling purposes.
• 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.
• Extensively implemented data parallelism using .mdir and .mfctl files
• 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.
• Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited.
• Developed Unix Korn shell wrapper scripts to invoke the stored procedures to move the demographic staging data into ODS and to force-reconcile the financial accounts
• Involved into Autosys R11 Upgradation using CA Workload Control Automation
• Involved in testing the sandbox migration projects of various product processors from 2.12 to 2.15
• Extensively used the EME air commands such as air tag create, air save, air project export, air promote load, etc.
• 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
• Analysed the upstream data flow received in the form of feeds and moved into the staging databases
• Coordinated with downstream team to analyse 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
• Ensured that the data are forcefully reconciled if the accounts are failed in DQ Data Quality Checks
• Involved into the staging cleanup if the position and transaction job fails to avoid the duplicates and data inconsistencies
• Creation of VT to receive the scrubbed production feeds for various product processors
• Ensured that the ODS is scrubbed if the unscrubbed feeds are loaded with BISO Business Information Security Office approval
• Reporting the ETL issues during dataload in Team Track
• 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 Man
• Configuration of weblogic 10.3 domains during the upgradation of jdk version 1.6.0 22, 29 and 31
• Configuration of weblogic 10.3 domain during the Oracle upgradation from 10g to 11g and Solaris to AIX

Environment: Ab Initio GDE 1.15, Co>Operating System, Oracle 11g, WINSCP, Putty, UNIX, Autosys R11.3, Business Objects, Weblogic, Websphere, Solaris and AIX Webservers

Confidential

Senior Application Developer

Responsibilities:

• Responsible for fully understanding the source systems, documenting issues, following up on issues and seeking resolutions.
• 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 Design Document for the all the modules required for development.
• Responsible for analyzing source and target data models and making necessary changes to the mapping document.
• Executed BI Test Scripts for Analytics Subject Areas in both Real Time OLTP and History OLAP
• Run Incremental/Full ETL in Data warehousing Application Console Informatica and tested SIL and SDE Informatica mappings/workflows to verify the Historical Reports
• Verified the Real time and History reports for Constraint Testing, Threshold Testing and Code Page Compatibility
• Verified the Initialization Blocks Session Variables and Repository Variables , Security Filters of the Implemented Metadata, Calendar Models, Exchange Rates and Forecast Summary through Real time and History Reports
• Involved in I18N Internationalization Testing, L10N Testing Localization and Partition Testing
• Executed the Regression BI Test Scripts Logical SQLs using SATA and compared the Reports using WinDiff for discrepancies
• In depth Analysis of NQ Logs to identify the platform issues.
• Analyzed the test results and generated the defect report in Oracle E-Business Suite
• Reengineered the Data Driven Framework to automate Web Services Scenarios using Load Runner TSL Scripting and track the process results in the best way
• Implemented and Executed Load Runner TSL Scripts for WS v1.0, WS v2.0 and Service API Calls for various kinds of releases such as RTO-x x 8, 9, 10, 11 Formal pass Releases, Staging and Validation, White glove test, EBS Integration and Regression Pass
• Implemented and Executed Sanity Load Runner TSL scripts for Patch testing, Localization testing
• Developed WS API Scripts for SSO Login Testing and Executed the same using WebScarab
• Developed WS API Scripts for Stateless and Stateful Web services and Executed the same using JMeter
• Developed Work Queue and Work Item Filter containing open and closed work items for each technician.
• Developed port and equipment problem reports. Reports also provide drill down and filter capability.
• Designed and developed the view components using HTML, AJAX, JavaScript and JSP.
• Developed Actions to handle requests and perform business logic. Developed Jasper reports.
• Designed and developed the business process and data process layer using POJOs and EJBs.
• Used CVS version controlling and TOAD for writing queries and stored procedures.
• Created solutions based on customer requirements, adapted existing solutions, performed system engineering, software design, support and function tests.
• Wrote Stored Procedures, Triggers and Sequences to support database related functions.
• Used Test Track Pro for bug tracking and issue management. Performed unit and integration testing.

Environment: Ab Initio GDE, Co>operating System, WS API tool, soapUI, Load Runner TSL Scripting , Oracle E-Business Suite and Rational ClearCase, Quick Test Professional VB Scripting , JMeter Performance Testing , WebScarab SSO Testing

Confidential

Programmer Analyst

Responsibilities:

• Extensively used Ab-Initio ETL tool to unit test the graphs
• Involved into staging data validation and analyzing the ETL rejects
• Understood the business requirements with extensive interaction with Onshore coordinators and BAs
• Design and execution of Unit level test cases
• Maintained locks on objects while working in the sandbox to maintain the privacy
• 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 EME Commands like air object export, air object import, air tag list, air object cat, etc
• Extensively used the sandbox commands like air sandbox info, air sandbox lock, air sandbox run, air sandbox parameter, etc.
• 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.
• Executed the User Acceptance Test Scripts from Lotus Notes in System Testing Phase II
• Analyzed the Test Results and generated the defect report in HP Quality Center and Bugzilla
• 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
• Identified the Automation Scenarios Sample Selection Module using QTP VB Scripting and prepared the Proof Of Concept

Environment: Ab Initio GDE, Co>Op 2.14, HP Quality Center, Lotus Notes and CVS