SUMMARY:

• Over 14 years of overall experience in development, maintenance and application support.
• Extensive experience as a SQL Server Developer in Design, Analysis, Development, Modeling, Implementing and Testing of decision Support Systems using MS SQL Server 2005, 2008, 2008R2,2012 Services
• Have 6+ years of experience in capital markets, Asset management, financial services
• Expert in data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles
• Extensive experience as a Microsoft SQL Server 2000 / 2005/2008/2012 Developer in creating Business Intelligence Solutions like SSIS, SSRS, SSAS and expertise in designing and implementing Relational Database model as per business needs
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User define data types, Cursors and Indexes using T - SQL.
• Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
• Experienced in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2008/2012 with T-SQL
• Highly proficient in Tuning SQL queries, improving the query performance and hands-on experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Extensive experience in performing ETL transformations and creating jobs and packages using SSIS (SQL Server Integration Services 2005/2008/2012 ).
• Extensively worked on SSIS to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2005/2008/2012 )
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Experience in different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages and package configuration
• Expert Level experience in Markit EDM platform and worked on both Onsite and Offshore Model
• Extensive experience in working with Master Data Management, Reference Data Management.
• Extensive experience in L2 and L3 Support for Markit EDM, Analysis of production issues and Identification of root cause and provide break fix as short term solution
• Proficient in creating different export solutions for Front Office, Middle Office and Risk teams.
• Experience is processing Trades, Transactions, Positions, Performance and Risk data.
• Handled matching and mastering for different asset classes like equities, fixed income, currencies, futures, options.
• Experience in working with Bloomberg products like Back Office, Per Security.

TECHNICAL SKILLS:

Operating Systems: Windows.

EDM Tool: Markit EDM (Cadis EDM) Versions 7.5, 8.5, 9.0

ETL Tool: SSIS,DTS

Database: MS SQL SERVER 2012 /2008,2005,2000, Oracle 11g, MySQL, Sybase

Reporting Tool: SSRS, Crystal report

BI Tool: SSDT 2012 (SSIS/SSRS/SSAS)

Script Language: Windows batch Scripting, VB Scripting, Shell Scripting

Middleware: IBM WebSphere MQ Series, Data Base Message Queue

Scheduler: Dollar Universe(Orsyp), Control-M

FTP Tool: MoveIT,WinSCP

Language: C#, VB.Net, VB, T-SQL,PL-SQL,XML,XSLT, HTML

MS Technology: VS 2013/2010, Asp.net, WCF,MVC, Web Services

Version Control: VSS,TFS and SVN

Other tool: JIRA, RedGate

PROFESSIONAL EXPERIENCE:

Confidential, Livingston, NJ

SQL/ MSBI Developer

Responsibilities:

• Designed the Database and Enterprise Data Warehouse- Table structures, triggers, stored procedures and Primary Key/ Foreign Key Relationships, Table valued and Scalar Value Functions.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Involved in design and development of ETL (SSIS) and reporting (SSRS) for various business units like Lease, Loan and Regulatory report across the organization
• Designed Data Mapping documents, DDL scripts, and Data Dictionary and Meta data of the models and maintained them.
• Created SSIS package to extract, transform and load the data from heterogeneous data sources to destination using various tasks like SQL task, data flow task, and file system task.
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Wrote database functions, scripts, stored procedures, views, triggers and dynamic SQL query etc. using T-SQL wrote T-SQL complex stored procedures to load the data from different sources using BCP, Unix script
• Strong experience in Performance Tuning and working with the optimization of query plans using Execution Plan.
• Integrated Service Now to create Incidents through T-SQL using Curl Script
• Integrated WinSCP tool through T-SQL command to upload and download
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Created Script task using C# to load data from Excel 2003 and Latest version 2010, columns and rows are configured in metadata file
• Created Script task to connect Web services and Service Now API
• Designed and developed Web interface using Asp.net and C# for business user to see the report and trigger job on demand
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Used SQL Server Reporting Services 2005/2008 to design, render and test the reports using complex expressions to calculate, group, filter, parameterize, and format the contents of the reports.
• Created Drill-down, Drill Through and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).

Environment:: MS SQL Server 2012/2008 R2, T-SQL, PL-SQL, SSIS, SSRS, SQL Profiler, UNIX Shell script, BCP’s, XML, Oracle 11g, C# and Asp.Net

Confidential, Battle Creek, MI

SQL/ MSBI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Involved in development and implementation of SSIS, Azure Cloud services
• Debug and analyze the data in SQLite db file created at Azure blob storage
• Designed Data Mapping documents, DDL scripts, and Data Dictionary and Meta data of the models and maintained them.
• Wrote database functions, scripts, stored procedures, views, triggers and dynamic SQL query etc. using T-SQL
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).

Environment: MS SQL Server 2012/2008 R2, T-SQL, PL-SQL, SSIS, SSRS, SQL Profiler, UNIX Shell script, BCP’s, XML, Oracle 11g, C# and Asp.Net

Confidential

SQL Developer/ Markit EDM developer

Responsibilities:

• System Study of existing application and Requirement analysis from Business Users.
• Understanding the requirement for the development of EDM/ETL solutions.
• Responsible for writing Stored Procedures, Triggers and Indexing in the back end.
• Performed complex ETL transformations, created and automated complex packages using SQL Server Integration Services 2005 (SSIS)
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Created mapping specs and technical design documents for Markit EDM solutions
• Provide estimation and project plan to the customer and get signed off.
• Development and unit testing of Markit EDM solutions as per the design document
• Ensure that code developed is reviewed and is meeting Markit Best practices
• Coordinated with onsite\offshore team and business users for implementing project which are handled by both onsite and offshore teams
• Gather requirements from concerned stack holders and understand existing trade flow system
• Post live support
• Understand existing Algo system and gather requirement from concerned stack holders
• Level 2 production support for Trade flow related issues
• Helping other team members to implement the task by following MEDM and SQL standards.

Environment: Windows 2003 Server/XP, SQL Server 2008/2005, Markit EDM, IBM Message Queue, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, Think-Folio (OMS), ORSYP (Scheduler) Moveit central and JIRA

Confidential

Application, Database and SQL Server BI Developer

Responsibilities:

• Interacted with end users to gather business/report requirements. Designed the Business Requirement Document (BRD) as well as participated in design review meetings.
• Designed and developed first phase of application using ASP.NET, C#, ADO.NET, HTML, JavaScript and SQL Server 2000/2005.
• Created table structures, triggers, stored procedures and Primary Key/ Foreign Key Relationships, Table valued and Scalar Value Functions, perfomance tuning and indexing.
• Created oracle Packages and Stored procedures
• Extensively used Telerik Grid and other controls
• Worked on Murex reports
• Created User documentation for the application

Environment: Visual Studio 2010. ASP.Net, Oracle 10g, Telerik Web control, Murex

Confidential

Application, Database and SQL Server BI Developer

Responsibilities:

• Responsible for designing, developing and testing first phase of application using ASP.NET, C#, ADO.NET, HTML, JavaScript and SQL Server 2000/2005.
• Utilized Unified Modeling Language (UML) technologies for a complete view of the application including class diagrams, sequence diagrams, activity diagrams.
• Provided Session level security and password authentication using Session Objects and Cookies.
• Dynamic table generation with hyperlinks and events using code-behind and CSS.
• Implemented input validation using ASP.NET validation controls for pages with server controls.
• Used ADO.NET to access the Data Layer which is entirely based on XML and provides platform interoperability and scalable data access.
• Created Enterprise Profit& Loss (P&L) and Financial Reports, Dashboards and Scorecards using SQL Server Reporting Services (SSRS 2005).
• Windows Forms designed using Infragistics windows controls
• Responsible for writing Stored Procedures, Triggers and Indexing in the back end.
• Used Crystal Reports Viewer to generate Employee status Reports.
• Responsible for creation of Setup project for packaging and deployment of completed phase of software application.
• Migrated SQL server 2000 to SQL server 2005 database
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to SQL server.
• Database performance tuning, monitoring, scalability and Testing. This includes optimization of slow running stored procedures, deployment of locking mechanism to increase concurrency.
• Developed Client server appliaction for Vehicle emission testing

Environment: Visual Studio.NET, C#, ASP.NET, ADO.NET, XML, Web Services,WCF, JavaScript, IIS 5.1, Windows XP, SQL Server 2000/2005, HTML, Crystal Reports, Triggers and Stored Procedures.

Confidential

Application, Database and SQL Server Developer

Responsibilities:

• Responsible for designing, developing and testing application using VB 6.0 ASP.NET, C#, ADO.NET, HTML, JavaScript and SQL Server 2000/2005.
• Involved in database Schema design and development.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Developed client server applications using VB 6.0, VB.Net and ASP
• Used SQL Analyzer and Profiler analyzing the SQL statements and procedures.
• Developed complete Inventory application for many client

Environment: Visual Studio 2002, SQL server 2000, VB 6.0. ASP, C# and Web services