SUMMARY:

• 12+ 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 7 (Remedy),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: MS SQL Server 2008/2005/2000 , Oracle 8i, MS 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

DB Developer /SSIS-ETL Lead

• Worked as a 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 for global project rollouts for client-facing and internal regulatory reporting, prioritizing enhancements with risk managers and senior traders.
• 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.
• Created 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.
• 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.
• Managing offshore development, testing and Production deployment using SVN and QC/JIRA.

Technical Environment: SSIS, SSRS, MS SQL Server 2008/2012 Oracle 11i, Autosys, Rapid SQL.

Confidential, NY

SQL Developer/ETL/DB Architect

• 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 CDI (Customer Data Information) Project to establish standard formats for data sets and data exchange across all connected subsystems by creating Security, Customer Account and Trading Master 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 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 and SSAS Cube 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 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, Microsoft Visual Studio 2005/2008

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

Confidential

SQL Server Developer

• Developed stored procedures, functions and views according to business requirements
• Defined check constraints, business rules, indexes, and views
• Performed database backups and restoration .Regularly monitored the system for bottlenecks and suggested /implemented solutions.
• Responsible for performance tuning of slow running SQL queries and sp’s using SQL Profiler
• Wrote stored procedures for application developers and some user defined functions. Converted various SQL statements into stored procedures thereby reducing the number of database accesses
• Worked with DTS Wizards and SSIS to load files to SQL Server .Created alerts for successful or unsuccessful completion of scheduled jobs
• Enhanced the old logical and physical database design to fit new business requirements
• Implemented new design by changing existing sp and view to incorporate new business requirements.
• Performed and created development support, document reviews, test plans and integration of the system
• Wrote standard and complex SQL queries to perform data validation.

Technical Environment: DTS, SSIS, MS SQL Server 2000/2005, Windows 2000/2003, Visio