SUMMARY OF EXPERIENCE

• 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
• 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
• Hands-on experience with Java Springs, RestFul APIs, MongoDB, Pymongo and Postgres
• Strong experience in Ab Initio GDE, Co>Operating System and Enterprise Meta Environment EME
• Exposure on Ab Initio Graph Programming and Data Manipulation Language DML
• 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 ETL Environment Setup for various Agile Scrums
• 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 Triggres
• Exposure on VBA Programming to create Excel Macros to prepare the Daily Status Report, Weekly Status Report to project the test execution metrics
• 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.
• 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.

S PROFILE

PROJECTS SUMMARY

Confidential

Designation : Lead Engineer

Project Experience

Project 1

Confidential

Role : Lead Engineer

• Tools Used : MongoDB, RoboMongo, Python, Pymongo and Java
• Duration :
• To transform the existing Oracle data model into Mongodb collections and documents
• To transform the existing Oracle Datamodel into Postgres Datamodels
• To Identify the embedded documents of Normalized Oracle DMS tables
• To call the mongodb API driver through Pymongo
• Hands-on Experience with Mongodb Collections, Documents, CRUD operations
• Hands-on Experience with Mongodb Objects through various APIs Pymongo and Java

Project 2

Confidential

Role : Lead Engineer

• Tools Used : Ab Initio GDE 1.15, Co>Operating System 2.15 3.1, Oracle 11g, WINSCP, Putty, UNIX, Control-M Scheduler
• Duration : 2 Years Ongoing
• To involve into Sprint Planning, Team retrospection, and Sprint grooming meetings
• To Design, Development Unit testing of graphs in DMS sandboxes
• To Coordinate with Offshore Developer to get the daily updates and assign the tasks and burn down the sprint hours in Version1
• To Migrate he code into QA system and integration regions using self-service EME portal or PCMA quotes
• To run Code checker and Data lineage scripts to ensure that the design complies with DDE standards
• To monitor the jobs in Control-M schedule and address the L3 incidents of various severities
• To involve into defect review meetings and work on closure

Company : Confidential

Designation : Technical Architect

Project 3

Confidential

Role : Ab Initio Lead

• Tools Used : Ab Initio GDE 1.15, Co>Operating System, Oracle 11g, WINSCP, Putty, UNIX, Autosys R11.3
• Duration : 2 Years Ongoing
• Description: Confidential consists of set of reporting and analytical capabilities which are delivered through integration of transaction, AUM and Revenue Data to drive decision making and planning activities. It facilitates users to access financial and demographic information from OneSource and ProjectOne. It makes Transactions and Member Level data readily available through Business Objects Front End without which OneSource Information was formally requested and obtained from the back end in the past. It exposes the fields from OneSource frond end in combination with the few fields available only through the back end or sourced from GMIC. It is used by Product Management, i.e. US Investment, Custody, Banking, Risk and Compliance, Analysts Creating reports for Management and Bankers, Marketing, Operations and etc.
• Confidential Project One is a data warehousing project for CPB Citigroup Private Bank . It mainly serves as a reporting tool for the High Net-Worth Clients of CPB and also as a source of information for other Applications like BI, MANTAS, GMIC, GDS, IOS, etc.
• OS CRM is a system for managing clients and sales prospects where the information like members, relationships, call reports are brought from one source system through ETL jobs.
• Global MIS dashboard will provide a graphical view of consistent client and product information globally to aid senior business leaders in monitoring and measuring key business metrics on a daily basis. Business leaders can also analyse the information based on time period say Monthly, Quarterly, Yearly. The entitlements and privileges will be provided for each user and based on that the user will be able to access the various functionalities of Global MIS Dashboard application. Dashboard is user-friendly platform to navigate and access data based on the specified time period.

Roles and Responsibilities:

• Build various Sandboxes in order to create Adhoc Regular applications in AbInitio.
• Check in/Check Out existing applications Using EME in order to perform the necessary modifications.
• 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
• Involved into the ODS-ODS dataflow between 2 regions
• 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

Project 4

Confidential

Role : Abinitio Lead

Tools Used : Ab Initio GDE, Co>Op 2.15, Web Server, ISIS Rendition Tool, Oracle Weblogic Administration Console 8.1, SSH Teltia Client, Java Decompiler

• Duration : 2 Years Ongoing
• Project Description:
• Project One is a data warehousing project for CPB Citigroup Private Bank . It mainly serves as a reporting tool for the High Net-Worth Clients of CPB and also as a source of information for other Applications like BI, MANTAS, GMIC, GDS, IOS, etc.
• OneSource is the application which takes care of the onboarding process of any new customers and takes care of their demographic information such as account name, relationship, entitlement group, address and other personal information.

Responsibilities:

• Create and Configure the ETL sandboxes for multiple regions EMEA and ASIA
• Configure the regional sandboxes against the regional common db sandboxes
• Hands-on experience to Configure, start, and stop WebLogic Server instances to setup the front end to populate the data from target tables
• Hands-on experience to Configure WebLogic Server clusters
• Hands-on experience to Configure WebLogic Server services, such as database connectivity JDBC and messaging JMS
• Coordinated with Web Hosting Group to configure security parameters, including managing users, groups, and roles
• Hands-on experience to Configure and deploy your applications ejb, java, web artifacts
• Hands-on experience to Monitor server and application performance
• Hands-on experience to View server and domain log files
• Hands-on experience in identifying the weblogic environment, connection pool issues and proposing the solutions to fix them
• Hands-on exposure in monitoring and collecting the logs for the connection leaks, non-serialization objects
• 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
• Responsible and took the primary role in deploying the new applications and providing the Environment support for Onshore and Offshore TCoE across the regions US, EMEA and AP
• Provided production support 24/7 and coordinated with developers, Management and end users to resolve the critical issues by applying java, db and property file changes to the existing environment
• Actively involved in adding the new features and configuration changes for the existing environments
• Actively involved for the Migration of couple of business applications from Solaris to AIX and Oracle 10g to 11g
• Extensive experience in problem tracing, WebLogic log files and trouble shooting problems related to the applications deployed on WebLogic Application Server
• Configured and created weblogic domains, clusters, servers, connection pools, JMS queues and topics by using Oracle Weblogic Administration Console
• Closely worked with DBA teams to kill the locks, clean-up the stale session, rebuild the unusable indexes, refresh the data model from UAT and production into IST, sync-up the regional databases
• Coordinated with the Development and IST Release Management team to receive and deploy the packages on-time and track the deployment status in deployment tracker
• Coordinated with Change Management and UAT Release Management Team to deliver the IST packages after deployment and check-sum the packages for regions through md5 file creation and track the RFC closure to ensure that the packages are picked up by regions on-time
• Coordinated with Production Support team to refresh the IST Environment from the Production code tar balls to bring the IST upto the production speed and ensure that the environment is baselined for the subsequent releases
• Creation and Track the RFC to refresh the data model from production or UAT into IST and ensure that the production/UAT data are masked by running the appropriate mask scripts adhering to the BISO approval process
• Reporting the package issues, Environment Issues in Team Track to make sure that defect-free package is delivered to the UAT and Production

Confidential

Role : ETL Consultant

• Duration :
• Tools Used : Oracle Business Intelligence, Data warehouse Application Console, Siebel Analytics Test Automation SATA , Oracle SQL Developer
• Description: Analytics helps to quickly perform historical analysis and spot trends over time. It analyzes key issues such as win/loss issues and average deal size. It answers On Demand a unique component that provides business solutions such as hottest selling products, top sales representatives in terms of current year and revenue which is presented via interactive charts, pivot tables and reports.

Roles and Responsibilities:

• Involved in meetings to gather information and requirements from the business.
• 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

Confidential

Role : WS Analyst QA Coverage and Project Coverage

• Tools Used : 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
• Description: The term Web services describes a standardized way of integrating Web-based applications over the Web. Web services allow businesses to communicate with each other and with other clients, without intimate knowledge of each other's IT systems. Web services share business logic, data, and processes through a Web services application programming interface API . Application developers can then add the Web services to a software application such as a Web page or executable program to offer specific functionality to users.

Roles and Responsibilities:

• Gathered Business requirements and Mapping documents.
• Preparation of Webservice Soap Requests and Populate the target tables from SOAP Responses using Ab Initio GDE Graphs
• 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
• Analyzed the WS API Test results and generated the defect report in Oracle E-Business Suite
• Played QA Representative Role for Agile Methodology to automate the WS new features which were implemented in Scrums
• Involved in Agile Story Point Estimation, Demonstration of Agile features to PM and Handing-Off Agile deliverables to QA Coverage
• Involved in Effort Estimation through Use case Point Estimation in Non-Agile
• Executed the WS API Scripts for various Web Service Clients such as Segmentation Wizard, Mail Merge for Word and Mobile Sales Assistant
• Closed-Loop the production defects to maximize the Testing Coverage
• Executed the SQL queries using SQLTools for the background DB Verification
• Implemented Test Plan Automation using Perl to reduce the manual effort of preparing the SOAP Requests and SOAP Responses

Confidential

Role : ETL Analyst

Environment : Ab Initio GDE, Co > Operating System

• Tools Used : Ab Initio GDE, Co > Operating System
• Description: Autosys job scheduling involves into the automation of all ETL jobs using autosys jil scripts. It involves the creation of job, defining the job sequence, execution and debugging of ETL jobs.
• Coordinated the Business and development teams to understand ETL job sequence
• Extensively created the jils for various ETL jobs
• Extensively used the autosys commands sendevent FORCE STARTJOB, KILL JOB, JOB ON ICE, KILL JOB commands
• Given the presentation and demonstration of sample etl job execution at the each scrum
• Involved in the Oracle 9i to 10g upgration and execute the jils against the Oracle 10g databased to find out the regression issues

Confidential

Role : ETL Analyst

• Tools Used : Ab Initio GDE, Co>Op 2.14, HP Quality Center, Lotus Notes and CVS
• Description: The Data Management System originates from the need to migrate the existing survey-processing systems in the CSO from the VMS-based environment to a client/server environment. It is currently estimated that within the CSO, there are approximately 150 applications/systems written and maintained by central IT and a further 250 end-user applications written and maintained locally. Rather than migrate these applications as they currently stand, it is hoped to consolidate as much common processing as possible into a suite of corporate applications. This will serve to limit the number of applications required and promote consistency and re-use across the various survey sections within the CSO. This suite of applications will reside on a corporate database storing all data required in the survey-processing lifecycle. This suite of corporate applications is to be known as the Data Management System. There are 10 modules in DMS such as Register Management, Sample Selection, Survey Management, Data Capture, Imputation, Aggregation, Seasonal Adjustment, Dissemination, Respondent Management, and Security.

Roles and 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