Career Objective:

Seeking a challenging position of SQL Server developer in an environment where I will get an opportunity t use all my skills and my knowledge of the field.

SUMMARY:

• Experienced in industry standard SDLC Software Development Life Cycle
• Requirements Analysis, Physical Design, Development, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications.
• Project planning, scheduling, problem tracking, management and reporting.
• Well practiced in managing multiple projects simultaneously, and quickly learning and applying new technologies
• Experience with ETL/SSIS, SSRS, T-SQL DDL/DML
• Excellent knowledge in ETL using SQL Server Integration Services 2012/2008 SSIS , Bulk Insert.
• Expert in SSIS Logging, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Experience in designing database schemas like Star Schema and Snowflake Schema.
• Expert in writing Complex Stored Procedures, Indexed Views, DDL/DML Triggers and User defined Functions for data consistency and manipulation.
• Expert in performance tuning and optimization for T-SQL, stored procedures t improve data retrieval speed.
• Expert with large datasets and techniques for handling database partitioning, data compression, indexing.
• Expert in troubleshooting application performance problems Indexing, Optimizer, server configuration, Profiler, DMV etc. including TSQL programming and debugging skills.
• Designing enterprise reports using SQL Server Reporting Services generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS 2005/2008.
• Solid understanding of database concepts, data warehousing methodologies.
• Skilled in multiple application development environments:
• Win Forms applications development using C , ADO.NET.
• Microsoft .NET Framework 3.0 /3.5 /4.0 design and development using C , ADO.Net / ADO.Net Entity Framework.
• SQL Server 2008/2012
• Hands on knowledge of OOPS Object Oriented Programming Structure .
• Accomplished in Data Accessing using Data Adapter, Data Reader and Dataset in ADO.NET Providers for data manipulation.
• Possess excellent communication and inter-personal skills, am flexible and versatile in new environments, self-motivated, team-oriented and comfortable in multicultural environments.
• Product/Business knowledge includes Equities, Credit Default Swaps, and Derivatives.

TECHINICAL SKILLS:

• RDBMS:
• SQL Server 2008R2/2008/2005, Oracle, MS Access.
• SQL Server Tools:
• MS SQL Server 2008R2/2008/2005, MSSQL Server Reporting Services 2008R2/2008/2005 SSRS , MSSQL Server Integration Services 2008R2/2008/2005 SSIS , Oracle 9i/10g, SQL Query Analyzer, SQL Profiler.
• Programming Language:
• T-SQL, C , Visual Basic
• Reporting Tools:
• Crystal Reports, SQL Reporting Services.

EXPERIENCE:

Confidential

Senior SQL Server Developer, AVP

• Responsible for the development, support and maintenance of the Compensation Management application which allows the back end office of a broker dealer t calculate their advisors payout and allows the advisors access t their trade and payout data online.
• Lead the entire SQL SERVER 2005/2008 stored procedures development, including performance tuning, optimization and maintenance effort.
• Participate in technical design specification with business users, DBAs and technical managers t fully understand the requirements of the system.
• Design / develop / Implement C /Win forms application for Loan Repayment application t manage trader's loan repayments.
• Design / develop / maintain daily SSRS reports t see Advisor's daily activity as well as advisor gross commission.
• Design / develop / maintain monthly advisor payout SSRS reports.
• Design / develop / implement SQL Server archiving mechanism for historical reports.
• Design / develop and maintain SQL Server database aggregate tables t support trader activity dashboard.
• Design / develop and maintain an additional SQL Server objects tables, stored procedures, and views, functions t provide flexible hierarchical reporting mechanism for organization t maintain accounts, assets and revenue.
• Involve in designing, developing and testing of the ETL Extract, Transformation and Load strategy t populate data warehouse from various source systems feeds using SSIS.
• Design / develop / maintain new SQL Server objects tables, stored procedures t support new trader commission payout calculation process for Fee Based products.
• Lead investigations t resolving application performance problems Indexing, Optimizer, server configuration, Profiler, DMV etc.

Confidential

Senior SQL Server Developer, Consultant

• As part of the database development group worked on the trade level market value reconciliation between MRS and Finman for Aurora records used for P L reporting / Ledger accounting FINMAN, MRS . This reconciliation identifies breaks in market values and other attributes as determined necessary and try t find the possible reasons and report in a standard format t help facilitate the investigation and correction in a timely fashion.
• Designed / developed SSIS packages t validate, extract, transform and load data t Data warehouse database.
• Designed / developed SQL Server objects tables, stored procedures, views, and functions t support ETL processing.
• Deployed SSIS package int production environment and used package configuration t export various package properties t make package environment independent and scheduled Jobs using SQL Server Agent.
• Performed the transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Designed / developed SQL Server objects stored procedures, custom functions and views t support current market value reconciliation of equity cash products provided from various sources and sub-ledgers used for P L reporting.
• Designed / developed SSRS Parameterized, Drill down, Charts and sub reports t show the number of differences in a market value
• Documented technical design specification.
• Participated in sessions with business analysts t determine and document steps of the reconciliation of equity cash products.

Confidential

Senior C /SQL Server Developer.

• Supported trading of fixed income products including high grade, agencies, high yield, emerging markets.
• Managed the analysis and investigation of production data issues.
• Participate in technical design specification with business users, DBAs and technical managers t fully understand the requirements of the system.
• Designed / developed customized applications t analyze dealers trading activities using C /SQL Server.
• Led the effort in automating and enhancing billing processing system for the Finance department using C /SQL Server. The system replaced a manual process, in turn saving the company money by increasing the accuracy and accountability of the invoice payment process.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Designed / developed various SSIS packages ETL t validate, clean and load data int SQL Server.
• Used SSIS t implement the Slowly Changing Transformation, t maintain Historical Data in Data warehouse
• Managed report writing using SSRS like Table report, Matrix report, Chart Report, Pie charts column report.

Confidential

Senior Information Technology, Consultant

Participated in development of proprietary Fore foreclosure model used by MBS trading desk for daily trading, risk management and performance assessment, using Excel VBA.

Confidential

Senior Information Technology, Consultant

• Developed web enabled reporting utility, using C /JavaScript/ SQL Server which included developing Stored Procedures, Triggers, Views and performing query optimization.
• Participated in Schema design, which included creating tables and referential integrity based on business specifications.
• Developed SOAP client application t process reports on Demand, using C .

Confidential

SQL Server Database Developer, Consultant

• Designed and Implemented Excel reports for relating analyst estimate forecasts and research reports, using Excel VBA.
• Developed a series of SQL Server 2000 stored procedures t support all of the Clients applications.
• Designed and Implemented stand along as well as ad hoc reports using Crystal Reports/SQL Server stored procedures.

Confidential

Senior Information Technology Programmer, AVP

Dbportfoli Standard/AdHoc reporting application:

• Developed Data Access Layer using C / SQL Server t process the business logic and merge data from various data sources.
• Developed and maintained web based standard reporting utility for holdings and transactions reports, and customized templates for Adhoc Reporting application using ASP.Net, C , SQL Server stored procedures.
• Wrote complex calculation formulas for Crystal Reports.
• BT Brokerage Corporation
• Responsible for a day-to-day support of an Equity / Fixed Income desk.
• Analyzed trading data and designed VWAP Volume Weighted Average Price business reports using MS Access and Crystal Reports.
• Converted a commission and trade-tracking database from MS Access t a Visual Basic front end with an SQL Server backend.
• Developed a C parser that extracts trading data from a source file and loads int SQL Server on nightly bases.
• Developed a new business reporting system for the Sales group using Crystal Reports / Excel Reports using Excel VBA.

Confidential

Information Technology Programmer, Consultant

• Automated the import of monthly fund assets int the back-end server through the SQL Server DTS. The data was received as ASCII text files, which was then parsed and inserted int the appropriate tables.
• Responsible for designing SQL Server stored procedures on the back-end server. Created time-efficient, global procedures on the SQL Server t process the logic behind the application.

Confidential

Information Technology Programmer

Confidential

Information Technology Programmer