Resume

Sign in

Data Sql

Location:
Boston, Massachusetts, United States
Posted:
November 14, 2017

Contact this candidate

Vinayak Aggarwal

Mob.# 857.***.****

ac3bj1@r.postjobfree.com

PROFESSIONAL SUMMARY:

●Over 10 years of IT experience in system analysis, design, coding, implementation, customization, testing and production support of business applications in Client/Server environment.

●Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and Production.

●Experience in Informatica Designer Tools like Mapping Designer, Source Analyzer, Target Analyzer, Transformation Developer, and Mapplets Designer to do the ETL process.

●Experience in integration of various data sources with Multiple Relational Databases like Oracle/Sybase, XML files, worked on integrating data from flat files like fixed width and delimited.

●Extensively used the transformation components like Source Qualifier, Expression, Aggregator, Filter, Router, Sorter, Update Strategy, Lookup, Joiner and Sequence Generator.

●Good experience in performance tuning of Informatica mappings and SQL queries.

●Extensive experience in designing and working with Oracle 8i/9i/10g/11g and writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, Database Objects using PL/SQL and possess good understanding of oracle data dictionary.

●Experience in physical and logical data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, Slowly Changing Dimensions using Erwin and TOAD Data Modeler.

●Experience in Actuate ERD Pro 8.0/7.0, Actuate Report Server, API, Actuate Active Portal.

●Having knowledge of Big Data technologies.

●Experience in working with scheduling tools like Autosys.

●Performed various kinds of testing like Integration, Unit and User Acceptance testing.

●Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.

●Work well independently or as a part of team.

Academics:

Degree

Board / University

Percentage

B.Tech (I.T.) - 2006

Rayat Institute of Engg. And I.T. (PTU)

69%

Key Competencies & Skills

ETL/ Database Tools

Informatica PowerCenter 9.x, Toad, PL/SQL developer, ERwin, Toad Data Modeler.

Programming Languages

PL-SQL, SQL, Shell Scripting, C, Pro*C, Vb 6.0

RDBMS

Oracle, Sybase

Reporting tools

Actuate 7/8, Crystal Reports and Oracle6i report builder

Operating System

Unix, Window 2000/XP

Other Tools

Autosys, ClearCase, HP Quality center, RTC, Github, Rational team concert, HP service manager

Professional Experience

6. State Street Bank: - Aug 2015 to till date

Project

SDR Reporting (Swap Data Regulatory Reporting)

Domain

Finance

Title

Senior developer

Max Team size

10

Client Location

Boston, MA

SDR is FX regulatory reporting application which sends real time messages to CFTS/EMIR regulatory for Dodd-Frank mandate. This application supports different FX products like SWAP, Options, Non-Deliverable Forwards, Forwards and Non-Deliverable options. Real time trading data is being extracted from trading application; apply business logic and sends report/messages to DTCC for particular jurisdiction in FPML and .CSV format. Enhancing current flows to meet Mifid2 Post Trade regulatory requirement.

Responsibilities handling:

●Developed and enhanced various powercenter mapping to perform ETL operation while loading data from flat file, database to Data warehouse or ODS(Operational Data Store).

●Created various PL/SQL objects like packages, procedures, functions, triggers etc to perform business operation.

●Developing and maintaining various slowly changing dimension(SCD) type 2 mappings by using filters, lookup, update strategy and sequence generator transformation.

●Designing Developing various complex informatica mapping as fulfill business requirement.

●Extensively working on performance tuning of SQL queries and informatica mapping.

●Developed PL/SQL code for new requirements, enhancements and debugging of procedures, packages and other Oracle objects.

●Performing data analysis, identify data patterns to understand requirement more precisely.

●Working with business analyst to deep understanding of the business requirements and analyzing the various scenarios and use cases.

●Working with business analyst to understand requirement and created logical/physical data model.

●Working on re-engineering of SDR application’s CFTC module to come up more scalable solution.

●Working closing with database migration team to migrate database from Solaris to Linux box.

●Working in a highly production Agile teams and always ready to wear different caps as per need of project.

●Coordinating with various supporting team like Ops, DBA and release management team to deploy code in production environment etc.

Environment: Informatica 9.1.0, PL/SQL, Oracle 11g, Unix, Shell Scripting, ERwin, Toad Data Modeler, HP Quality Center, ClearCase, Rational team concert, Autosys.

5. Fidelity Investment Management Technology: - Nov 2013 to Aug 2015

Project

AAT Shared Data Project

Domain

Finance

Title

Technology Lead

Max Team size

5

Client Location

Boston, MA

Shared Data is data warehouse which store the reference data for various type instruments like open ended fund, closed ending fund, ETF, Equity, Future, Indexes etc. Reference data is coming from various vendors and data loads using Informatica loader into stage tables. Various data quality rules apply to clean the data and loads the clean data to ODS (operational data store). From ODS various products access data and load the required data into their respective data marts. This data is being used by portfolio manager to take decisions and also used in performing many quantitative and qualitative analysis.

Responsibilities handling:

●Perform data analysis and identify data patterns, issues and trends.

●Developing a deep understanding of the business domain, document business requirements and analyzing the various scenarios and use cases.

●Working closely with the system analysts and project managers on multiple tracks.

●Developed PL/SQL code for new requirements, enhancements and debugging of procedures, packages and other Oracle objects.

●Created database objects like tables, views, synonyms, indexes, and sequences.

●Worked with Power Center -Designer tool to develop mappings to extract and load the data from flat files, Oracle to Oracle.

●Created various transformations like Source Qualifier, Joiner, Update Strategy, Rank, Expressions, Aggregator and Sequence Generator to load data into targets.

●Created reusable transformations and mapplets to use in multiple mappings.

●Created and ran debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.

●Tuned Mappings for optimum performance.

●Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, synonyms.

●Wrote SQL queries for data and report validation in TOAD.

●Co-ordination with different team within FIMT (e.g DBA, Release engineering and DB Ops) at both onsite and offshore for any technical issue, deployment, migration, database dumps. Also handing 4 members teams at offshore.

●L3 support and working on long term solution of frequent occurring incidents.

●Creation of UNIX shell scripts and using Autosys to schedule the triggering of these UNIX shell script jobs.

Environment: Informatica PowerCenter 9.1.0, PL/SQL, Oracle 11g, Unix, Toad, HP Quality Center, RTC, Github, Rational team concert, HP service manager, Autosys.

4. Capital Group Companies: - Oct 2010 to Oct 2013

Project

Portfolio Accounting

Domain

Finance

Title

Technology Lead

Max Team size

20

Client Location

Irvine, CA

Portfolio Accounting (PA) is book of record for accounting at the overall fund level and this posts transactions at the account level keeping track of account positions, cash and accrual. PA application is split into two groups as CRMC and CGII because of the business requirements of Capital Global International Inc. (CGII) and Capital Research and Management Company (CRMC) which are two different companies. CGII manages institutional clients, while CRMC manages mutual fund clients. The PA systems are used by CRMC and CGII accountants to perform their day to day accounting activities. This application is mainly on Informatica PowerCenter, Actuate, Shell script, C language and Unix with Sybase as database.

Responsibilities handled:

●Identified technical solutions to solve business requirements and provide technical leadership during enhancements and development.

●Provided analysis and fix for emergency production issues.

●Gathered business requirements by conducting detailed interviews and one on one meeting with business users, stakeholders and SME's.

●Extensively used TOAD and PL/SQL Developer for daily development jobs.

●Worked with Business Systems Analysts and Database Administrators to understand and implement functional and nonfunctional requirements into the project.

●Identified issues with current database and resolved them. Installed and configured relevant components to ensure database access. Diagnosed and resolved database access and performances issues.

●Extensively worked on Actuate ERD Pro 8.0/7.0 report designer tool to develop the complex reports using PL/SQL and T-SQL stored procedures.

●Worked with Power Center -Designer tool to develop mappings to extract and load the data from flat files, Oracle to Oracle.

●Created various transformations like Source Qualifier, Joiner, Update Strategy, Rank, Expressions, Aggregator and Sequence Generator to load data into targets.

●Coordination with different team like production support, application release team to deploy code in production environment.

●Performed unit testing of Actuate erdpro 7/8 reports, Informatica tasks and also supported QA team for their QA/UAT testing.

Environment: T-SQL, Oracle 10g,PL/SQL, Sybase, Unix, Informatica PowerCenter 8.x, Actuate e.Report designer professional 7/8, Perforce, Autosys, Rapid SQL

3. Citi Bank NA: - Jan 2010 to Sep 2010

Project

TRIMS(Trade Record Information System)

Domain

Finance

Title

Associate Consultant

Max Team size

50

Project Location

Mumbai, India

TRIMS is an a intelligent MIS system used handling the end to end Trade transactions with the Banks perspective having full fledge functionalities suitable for all kinds of actors in the business. It mainly revolves around Letter of Credit (LC), Bills and other important documents. The Maker/Checker modules have been developed in TRIMS for all functionalities for assuring the secured transaction processing. So TRIMS is mainly divided into TRIMS imaging and TRIMS processing closely coordinating to accomplish the client requirements in Trade business.

Responsibilities handled:

●Worked as a developer in creating complex Stored Procedures, packages, triggers, cursors, tables, views and other SQL joins and statements for applications.

●Designed and implemented complex Pro*C batches, stored procedures and packages. Implemented constraints on tables.

●Created code packages to deploy the code in higher environments like QA, UAT and Production.

●Independent unit testing(IUT) and System Integration testing of applications for performance, data Integrity

●Provided production support after the system was delivered to the client.

●Created indexes, constraints and rules on database objects.

Environment : Pro*c, PL/SQL, SQL, Oracle 10g, Java, Unix, SQL Developer, Toad.

2. Unit Trust Of India Asset Management Co.(UTI AMC): - Oct 2008 to Dec 2009

Project

UTI Generic (UTI-GS)

Domain

Finance

Title

Project Coordinator

Max Team size

20

Project Location

Mumbai, India

The aim of the project is to provide investor services using a centralized database as well as a common front end for all the branches and all mutual fund schemes. The System has a multi-tier architecture with the front end in Java and Oracle 9i as the RDBMS. I was responsible of handling two modules Accounting & reconciliation (This module provides clear picture about account entries of sale, repurchase and transfer of units. It gives general ledger code wise details data to UTI AMC, SUUTI for their reconciliation purpose. Only on basis of this data AMS had fund their bank account. It contains Pro*C batches like Accounting batch, SAP batch, Profors5, Reconciliation and funding batch.), Bulk Driver and Reports (This module provides all MIS report, report for investor and report for internal use. Most of the reports are called by Pro* c batches and automatically generates PDF at Day end).

Responsibilities handled:

●To understand the business involved and related it to the design of different components of the generic system.

●Developed low-level designs (LLDs) and URS (user requirement specification) to suit business requirements.

●Developed and enhancing of Pro*C programs and schedule the programs through Autosys scheduler.

●Provided production support after the system was delivered.

●Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using SQL and PL/SQL in Development and Production environment for Oracle 9i.

●Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

●Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

●Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Environment: PL-SQL, Oracle 9i, Pro* C, Oracle 6i report builder, Unix, TOAD, PL/SQL Developer.

1. Ambuja Cements Ltd.: - Aug 2006 to Sep 2008

Project

ACL – ERP

Domain

Manufacturing

Title

Programmer

Max Team size

5

Project Location

Ropar, India

The aim of the project is to provide integrated solution to complex manufacturing processes. It is complete enterprise resource planning package includes sales & distribution, finance, production planning, plant maintains, human resource and raw material/purchase. I am responsible of handling two modules Sale and Distribution (This module is used to manage and control the process of sale & distribution system, right from procurement of sales order to the dispatch the same to the client. This module comprises of sale order booking, preparation of delivery notes, excise invoice, packing and loading, gate transactions, weighbridges module and transporters documents. As well as various sales & distribution and logistics related MIS reports) and Sales Accounting (The objective of the module is to records and maintain the customer related transactions such as invoices, debit/credit notes for various types of rebates/discounts, balance transfer, receipts, commissions, C&F bills, reimbursements etc. It also contains various MIS reports).

Responsibilities handled:

●To understand business requirement from development.

●Developed and enhancing of Pro*C programs.

●Provided production support after the system was delivered.

●Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using SQL and PL/SQL in Development and Production environment for Oracle 9i.

●Created Seagate crystal reports, data extraction and data loading scripts for different databases and schemas

●Development of vb6.0 code to enhance the functionality of ERP to handle business needs.

Environment: PL-SQL, Oracle 9i, Pro* C, UNIX, VB6.0, Seagate crystal report, TOAD, PL/SQL Developer.



Contact this candidate