TECHNICAL SKILLS:

ETL and Data Warehouse Tools: Big Data Tools Exposure

Languages: Operating Systems

Project Management Tools: Configuration Management ToolsSubversion GitHub IBM Rational Clear Case IBM Rational Clear Quest

PROFESSIONAL EXPERIENCE:

Confidential, Boston MA

Senior Ab Initio Developer

Environment: Ab Initio 3.1 (GDE), Co>Op 3.1 ETL, Flat files, Oracle and SQL Server tables and Share Point, Eagle PACE as data sources, WINDOWS Operating System, CA Workload Automation for scheduling, Oracle for Staging and Data Mart, PYTHON for ad - hoc data formatting, cleansing, and comparison.

Responsibilities:

• Worked on analysis, design and development of the MarketingMart data model.
• Worked on generating various Data Analytics reports from the Mutual Fund Securities NAV (Net Asset Values), Holdings and Performance data.
• Designed Data Model for the configuration data that will be imported from Share Point.
• Developed Ab Initio graphs to extract data from various sources like Eagle PACE, OBI (Oracle Business Intelligence).
• Developed graphs to extract data for downstream reporting or PDF generation.
• Developed Ab Initio graphs to invoke Web Service calls to Microsoft Share Point in batch mode and extract the configuration from the lists.
• Design and develop scheduling using CA (Computer Associates) Workload Automation tool.
• Defined and documented workflow for the user community to perform various business functions like addition of new share class to a fund, modification of any fund attributes, etc.
• Used Agile Scrum methodologies to implement Share Point migration project to build a custom user interface.
• Developed wrappers, housekeeping scripts and for archival of data files, lookup files, source files etc.

Confidential, NJ

Senior Ab Initio Developer

Environment: Ab Initio 1.15 (GDE) ETL, FIX Messages, Flat files, Oracle tables for data source, AIX, LINUX Operating System, Sun Solaris 10, Autosys for Scheduling, Oracle for ODS and Data Mart.

Responsibilities:

• Worked on design and development to rate the performance of various algorithms used in Citi’s ALGO trading systems.
• Defined and enforced standards for incoming data sets, data loading, ETL code, and reporting.
• Lead a team of ETL developers’ onsite and a team of four developers offshore.
• Acted as a point of contact to provide and correlate response to regulatory queries, TMMS exams from financial regulatory bodies.
• Performed business and technical impact analysis for new trading systems also for all existing front end system changes.
• Centralized all regulatory reporting that is distributed over various Order Management Systems into GEDW for cost savings and accurate reporting.
• Spearheaded a gap analysis effort between real time FIX messages and an EOD feed to assist in retirement of EOD feed generating systems.
• Built a robust ETL platform to link order flow references among various trading systems and to load report ready data into warehouse that presents the entire trail of order and execution flow
• Designed and developed complex Ab Initio graphs to link the Order flow from various trading systems and to handle desk transfers, order crossing among other things.
• Developed wrapper, housekeeping scripts and stored procedures to create and drop partitions, fetch and remove raw data files, tracking processing times, space usage.

Confidential, NJ

Senior Ab Initio Developer

Environment: Ab Initio 1.15 (GDE) ETL, Mainframe for data source, AIX 5.2 Operating System, Autosys for Scheduling, DB2 for Data Mart

Responsibilities:

• Involved in Collecting and defining requirements, translating into functional design documents and participate in the technical design and user documentation processes.
• Key member of BMS ETL team, responsible for developing Ab Initio ETL interfaces for HISTORY data extraction processing.
• Responsible for setting up and configuring the environment for the offshore and onsite for Ab Initio setup.
• Responsible for converting 5-year history data to Staging ETL through generic graphs, that extracts and data per reporting period basis for BMS data mart.
• Implemented Lookups, lookup local, In-Memory Joins and rollups to speed up various Ab Initio Graphs.
• Complete scheduling of the BMS jobs using Autosys Scheduler for Data Extraction, Dimension Processing, Fact Processing, Summary Tables and Extreme reporting graphs.

Confidential

Ab Initio Developer

Environment: Ab Initio 1.12 (GDE) ETL, Mainframe for data source, AIX 5.2 Operating System, Oracle 9i

Responsibilities:

• Define Data transformation rules between source and target systems in Ab Initio GDE
• Translate application design specifications into Ab Initio application code
• Configuration of Upstream and Downstream feed files using Ab Initio GDE
• Debugging/Enhancing complex graphs, validation of data load/unload from source systems in Ab Initio GDE
• Develop Source/Target data mapping in Ab Initio GDE

Confidential, CA

Ab Initio Developer

Environment: Ab Initio 1.12 (GDE) ETL, Mainframe for data source, AIX 5.2 Operating System, DB2 UDB.

Responsibilities:

• Migration & Maintenance of the ETL processes for set of applications that comes under the CDI-CMLS suite of applications.
• Making strategies for effective support of the existing applications and for the development of the new enhancements.
• Effort estimations, Customer Interaction, Project Delivery Co-ordination.

Confidential, OH

ETL Developer

Environment: Oracle PL/SQL, UNIX Shell Scripts, Sun Solaris 2.6 Operating System

Responsibilities:

• Design of new subscription to various downstream applications within AT&T requesting for a separate or new data feed
• Design of extraction and load process for the new data feed requests.
• Design and development of new intermediate database tables, UNIX shell and PL/SQL scripts to support the new data feed.
• Identify production issues and facilitate speedy problem resolution.
• Monitoring and Maintenance of Business Applications
• Plan, coordinate and implement changes within schedule liaising with Change Management Team
• Debug SQL Procedures and Unix Shell Scripts
• Bug Fixing and Tracking
• Effort estimations, Customer Interaction, Project Delivery Co-ordination

Confidential, NJ

SQL Developer

Environment: Oracle PL/SQL, UNIX Shell Scripts, C, C++, Sun Solaris 2.6 Operating System

Responsibilities:

• Migration of the DMG activities for the application from IBM-US (AT&T)
• Production support and data Maintenance activity
• Design, Development and Testing for enhancement project
• Interaction with customers to understand the new requirements and come up with detailed designs
• Technical documentation

Confidential, NJ

SQL Developer

Environment: Oracle PL/SQL, UNIX shell scripts, C, Sun Solaris 2.6 Operating System

Responsibilities:

• Developing backend stored procedures modules Alarm Manager.
• Code/Design Review and Testing.
• Preparation of design document and unit test plan.

Confidential

Developer

Environment: C++, Rational Rose for Design, Oracle 8i, HP-UX

Responsibilities:

• Coding of the BRO’s & EBO’s for various Transactions.
• Understanding the Functionality of the Transactions.
• Design of Test Cases for the Transactions.
• Preparation of Test Data for the Transactions.
• Transaction Flow Testing of the Transactions

Confidential

Developer

Environment: Customized VB, C, and SQL Server

Responsibilities:

• Fixing of customer-reported bugs and internally reported Bugs (part of migration to new version) of the E-Accounts & E- Invoice module
• Preparation of Checklist for Code-review
• Review of code written/modified by other programmers
• Documentation of the applications in the E-Invoice module by doing a code-walkthrough

Confidential

Developer

Environment: Power Builder 5.0, Sybase, C, Sun OS

Responsibilities:

• Preparation of Program Specification
• Sybase SQL Coding for reports
• Defining Standards for SQL & C Code
• Design of a unique Template for Report Generation, which can be used for all the Reports.