Data Sql
Resume:
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