SUMMARY

• 10+ years of experience in IT data analysis, requirement gathering, design and development in financial, capital market and Investment banking.
• Comfortable interacting with senior management, project teams, business users and product vendors.
• Excellent in performing Data, Gap, Risk and Feasibility Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Extensive background in Data base design and development creating index, views, stored procedure and user defined functions.
• Experience in data transform from one server to other servers using tools like DTS/SSIS
• Experience in performance tuning, query optimization and maintaining and optimizing a data warehouse
• Proficient in designing and implementing ETL packages involving data extraction from multiple sources, deploying complex packages from test to operational environment, and scheduling packages using SQL agent, Auto Sys and Control M
• Experience in report generation Ad - hoc reports, drill down and drill through reports using SQL Server Reporting Services (SSRS) and in configuration of report server and report manager
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member
• Experience managing change management using ITSM 9 (Remedy) & Service Now ITSM, Version Control using TFS & SVN, bug tracking using Quality Center & JIRA
• Effective at documenting and communicating complex process and data flow situations through the use of process flow diagrams Strong knowledge of data flow diagrams/ERD, & system overview diagrams
• Provide constructive input to the Project Manager and provide detailed support for project planning and feasibility analysis.
• Create and implement design document to follow a structured approach to organize requirements into logical groupings of essential business process, business rules, and information needs to ensure that critical requirements were not missed.
• Prepare data mapping documents to document the ETL logic to allow maintenance and future modifications to be performed with minimal confusion.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/XP/2003/Vista, MS-DOS.

Databases and Languages: SQL Server 2012/2008/2005/2000 , Oracle 8i/11i,Access, Sybase, C #,VB.Net

ETL Tools: DTS (Data transformation services),SQL Server Integration Services(SSIS)

Database /Utility Tools: SQL Profiler, SQL Query Analyzer, Management studio Index Analyzer, DTS Import/Export, Backup Server, SQL Agents, Control M.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal reports, MS Excel.

Testing Tools: Quick Test Pro, Quality Center, Issue Tracker JIRA

Workflow and Case Tools: MS-Visio 2003/2007, ER Win, MS-Project 2002, MS-OFFICE

Version Control: Visual Source Safe, Subversion (SVN), Team Foundation Server(TFS)

Methodologies: Water Fall, Rational RUP methodology, Agile methodology

WORK EXPERIENCE

Confidential, NY

Dev Lead

• Working as a Lead to Develop for database objects such as SSIS packages, tables, store procedures, functions, views and indexes using T-SQL and Oracle 11i for QRM (Quantitative Risk Management) and ALMIS (Asset and Liability Management Information System).
• Working on Implementation of critical projects related to regulatory requirements like CCAR and LCR as a Part of Basel III, Recovery and Resolution Preparedness as part of SR-14.
• Using QRM and SAS analytical tool for forecasting future and calculating Risk and Var and synthesis info in reporting.
• Working on Implementation to Source over 95% of the total balance sheet of the bank, greatly reducing manual work. Completed data sourcing for new WSS file for MM Synthetic Trades using SSIS.
• Working on Implementing a Recon process between GL & Book Value (SSRS) with adjusting entries to ensure integrity of data. Added Received Collateral into the Deposit and Funding Reports.
• Working on Implementation Business Rules/Filters into the ETL (SSIS) process ensuring that data is ready for consumption into QRM and any other downstream process.
• Working on Implementation a separate History database to reduce time to recover in the event of a significant event that required the database to be restored from a backup.
• Working on RLAP (Resolution Liquidity Adequacy and Positioning) - Considers the ability of each Material Entities (ME) to meet resolution liquidity needs.
• Working with Vendors and Users to support QRM (Risk frame) day to day issues and work with Windows and DBA team to facilitate patches and releases.
• Improve data quality by adding Legal Entity and maturity date of the loan for CCAR/DFAST roll-up configuration tables to Tested and accepted source system.
• Completed major GLRI efforts: Populated total net cash outflow in LCR storage table Added new columns to the LCR automated report data and Added rule for InTrader Securities .
• Created new LCR Report by Currency Categories, Populated Market Value for total HQLA Subtractive Values for LCR Automation
• Support QA, UAT and Prod releases and Run book for Production support team.

Technical Environment: Visual Studio, SSIS, SSRS, SQL 2008/2012, Remedy 9, Oracle 11i, Autosys, Python.

Confidential, NY

DB Developer /SSIS-ETL Lead

• Worked as ETL Lead to Developed and manage of team of 6 developers: for database objects such as SSIS packages, tables, store procedures, functions, views and indexes using T-SQL and Oracle 11i for global project rollouts for client-facing and internal regulatory reporting, prioritizing enhancements with risk managers and senior Management.
• Worked on Implementation of critical projects related to regulatory requirements like CCAR, MRA, SEFT and LCR as a Part of Basel 11 & III .
• Worked on Creation of SSIS packages to load Positions, securities & client data using AutoSys, apply business logic for implementation of risk platform & handed to Prod support with run book having process details.
• Implemented a file SLA process to automatically send notifications for late files and End of Day report of all ETL Loads.
• Cleansing data/ Implement business logic using C sharp in SSIS Package.
• Worked as a DB Architect Analyze and Consolidate data from different sources (csv, sql, oracle. etc) into one common risk plate form after apply business logic in SP’s and using SSIS Packages by making sure exiting system support new architectural changes.
• Worked to bring data from all Margin System (TMS, MDS, and CBAR etc) to one common risk platform and Perform Query optimization when needed.
• Extended functional development for data persistence and to share the data with the other teams by archiving schema.
• Proficient in using query Optimization tools like Precise and sql enlight for SQL and OEM (Oracle Enterprise Manager) for Oracle.
• Worked as Report Developer Lead on Margin Risk reporting that includes:
• Analyze the various business requirements and Supervised reporting initiative with developers and BA to produce customized reports in SSRS. By producing daily report containing global risk and margin ratio categories, crucial market and operational risk statistics after all SSIS process.
• Enhanced existing risk reporting suite for prime brokerage clients across New York, London, and Hong Kong by Creating Margin Summary, analysis break down for Risk Users.
• Worked on Data Analysis by creating Exception reports for positions and securities that does not meet pre-defined criteria’s.
• Support Month end Reports for users for domestic & international prime brokerage clients.
• Worked as Dev Ops to Manages Release process to QA/UAT and Production that includes proper version control using SVN tracking issue using QC/JIRA, release scripts using HPDMA, validation and deployment document.
• Manages Lower environments that includes backup and restore databases, permissions, coordination with DBA’s, Windows and network teams for upgrade, patching and server reboots.
• Hands on python development using the proprietary framework (quartz): ETL, calculation, reporting and review peer’s code and signoff for release.

Technical Environment: Visual Studio, SSIS, SSRS, SQL 2008/2012 Oracle 11i, ServiceNow, Autosys, Python.

Confidential, NY

SQL Developer/ETL

• Develop database objects such as SSIS packages, tables, SP (store procedures), functions, views and indexes using T-SQL for decommissioning Lehman legacy system and Data Management Project.
• Worked on Project to establish standard formats for data sets and data exchange across all connected subsystems using SP and SSIS.
• Created design document and Implemented Automation of Research Commissions for strategic equities initiative to consolidate and streamline Soft Commission calculations by creating SP, SSIS Package and Autosys jobs for TMS, FISS, EQDW and SINACOR Sources.
• Enable downstream reporting systems of Equity to move away from using average retention rates to actual by populating values by Creating SP, SSIS Package and SSRS Reports.
• Worked on MDM (Master data Management) Analysis Project created and loaded landing and lookup tables using TOAD and SQL Loader.
• Manage upgrade and release process to QA, UAT and Production using SVN.Maintain and track enhancement and bug remediation information using JIRA.

Technical Environment: SSIS, SSRS, MS SQL Server 2008, Oracle 11i, Windows XP, Rapid SQL.

Confidential, NY

SSIS/SQL Developer

• Develop database objects such as SSIS packages, tables, store procedures, functions, views and indexes using T-SQL and Oracle for RDS (Risk Data Store).
• Worked on Standardizing the data in RDS which is a common risk data warehouse platform .Data from different sources was loaded (SSIS) into the warehouse to compute risk analysis for the assets traded, Performance, Exposure, Risk and Attribution reports were delivered to risk users.
• Implement system development and enhancements as a team lead for decommissioning Golden source Project (GS) and integration with RDS by creating SSIS Packages and SP’s.
• Loaded data using SSIS from different sources like Excel, text, CSV etc into SQL Server and Oracle 11i tables using attunity after complex transformations and applying business rules using C sharp for Tera Data Migration Project.
• Analyzing Actual PNL and Calculated Hypo PNL by creating SSIS Packages, SP and SSRS Reports and deploy to Report Manager.
• Cleaning and implement business logic in SSIS Packages and in SP for Totoro, GRMS, and HMD other feed sources.
• Actively participate in production deployment, support and manage Autosys jobs by coordinating on shore and off shore teams.
• Worked Closely with BA Team for Business requirement & Design document and delivering KT to QA team for testing and helping them to create test cases and scripts.

Technical Environment: SSIS, SSRS, MS SQL Server 2008, Oracle 11i, Windows XP, SQL Developer, SVN

Confidential, NY

ETL/SQL Server Developer

• Leveled the requirements at business, system and sub system levels for the Risk Lockup Compliance Project for the prime brokerage group.
• Designed jobs loading position and security data from Beams, Paladyne, WSO & Geneva systems.
• Involved in the integration of BARRA (Equity Analytics), Bloomberg, Risk Metrics, and Fact Set systems to load the risk and security data by creating SSIS packages.
• Wrote and modified stored procedures, functions and views according to the new business requirements
• Created sql scripts and reports for data analysis by creating drill down and drill through reports in SSRS and deployed to Report Manager and Share point.
• Performed T-SQL tuning and optimizing queries for reports. Analyzed the database growth and space requirements using SQL Compare and NANT to compare different servers and generate scripts for migration
• Used SQL Agent and Control M to create SSIS jobs for data Processing.
• Created run book document for operation team response in case of job failure, created scripts for regression and functionality testing
• Maintained project plan and issue tracking using Quality Center. Used Remedy 7 as a change management tool and TFS for version control.
• Worked extensively on troubleshooting data quality and various production issues.
• Handle errors during data moving and sequence the tasks as per requirements in SSIS Package

Technical Environment: SSIS, SSRS, SSAS, MS SQL Server 2005/2008, Windows XP.

Confidential, NY

ETL/SQL Server Developer

• Created and modified existing SQL Store Procedures, views and functions for new product restructuring
• Integrated the SSIS package, converted all existing DTS packages of MS SQL 2000 to 2005 by adding extra SSIS task as well provided logging/error handling in SSIS packages
• Created data validation report, Configured the SSIS package for different environments and incorporated Excel, text and csv files to sql database
• Used Profiler to find poorly performing queries and deadlocks,resolved various performance issues and coordinated with DBA team for database maintenance plan
• Created fund performance summary and detailed level reports using SSRS
• Converted Oracle stored procedures and views to SQL and used Tool SQL Navigator
• Created Fund Performance and Attribution report to analyze the funds status with historical comparison using SSRS.

Technical Environment: SSIS, SSRS, MS SQL Server 2005, Windows XP, Microsoft Visual Studio