SUMMARY

• 7 years of IT Professional experience in Development, Database Design, Client Analysis and Presentation using SQL Server 2008/2005/2000 with expertise in SSRS, SSIS and SSAS.
• Work experience in various industrial sectors such as Financial, Banking, Medical and Insurance Services.
• Developed Various Risk Reports (FX, Interest Rate, Commodity, Credit and Issuer Risk) for Market and Credit Risk Managers in Fixed income division.
• Experienced in TSQL (DDL,DML), documenting, coding, programming, modifying and implementing Business Intelligence solutions using SQL Server 2000/2005/2008 .
• Experience in designing Database Models using Microsoft Visio and Erwin.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate Functions, and effective Triggers to facilitate efficient data manipulation and data consistency.
• Expert in using tools like SQL Profiler, Execution Plan, Windows Performance for monitoring and tuning MS SQL Server performance.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, and BCP.
• Experience in loading a flat file, Excel file using Import - Export Wizard.
• Experience in Importing/Exporting Data from various data source like Excel. Oracle, DB2 and Flat file using SSIS.
• Experienced in defining Query for generating Drill Down Reports and handling Parameterized Reports in SSRS and sorting the data, defining subtotals for reports and designing report layout.
• Expert in migrating of databases from older versions of SQL Server to SQL Server 2008.
• Developed Drill through/down, Cross-Tab, Cascading parameterized reports using SQL Server Reporting Services (SSRS) and deploying them using web applications onto the web servers.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Experienced in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experienced with all the phases of Software Development Life Cycle (SDLC) and Quality procedures and standards while executing projects.
• Ability to efficiently perform in a team and individually without supervision.
• A multi tasking analytical thinker with the ability to work on fast paced work Environment.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000/7.0
• Oracle 9i
• MS Access 97/2003
• DTS (Data Transformation Services)
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• Crystal Reports 9
• MS Enterprise Manager
• SQL Profiler
• SQL Query Analyzer
• OLAP Services
• SQL Agents
• SQL Alerts
• SQL Jobs
• SQL Mail
• ER-Studio
• C
• C++
• MS Visio
• XML
• T-SQL
• PL/SQL
• XHTML
• CSS
• Visual Basics MS Office
• ASP
• ASP.Net
• Visual Studio
• Windows 9x//NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

MS SQL SSIS/SSRS Developer

Responsibilities:

• Creates extracts for Market and Credit Risk Management by enriching positions with Market data (Bloomberg, Fitch, SnP and Moody).
• Participated in Software Development Life Cycle, involved in discussion on business requirements and implement them using MS Visio 2007.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Developed Database Triggers to enforce Data Integrity and additional Referential Integrity.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Designed SSIS Packages to transfer data from various data sources like File system, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Designed, Developed and Deployed reports such as Tabular Reports, Matrix Reports, Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder 3.0 and Generated Reports using Global Variables, Expressions and Functions.
• Responsible for scheduling Reports using subscription services of Sql Server Reporting Services .
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Applied various data transformations like Slowly Changing Dimensions, Aggregate, Sort, Derived column, Multicasting, Conditional Split.
• Merged data from heterogeneous data sources into SQL Server 2008 by creating SSIS package in BIDS.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Used SQL Server 2008 to design, implement and manage data warehousesOLAPcubes.
• Managed the historical data in the data warehouse from various data sources.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Environment: MS SQL Server 2005/2008, Business Intelligence MS SQL ServerIntegrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), visual studio 2005, MS Visio, Share Point Server (MOSS) 2007.

Confidential, Little Rock, AR

MS SQL Developer

Responsibilities:

• Installed and configured SQL Server Reporting Services (SSRS) 2008.
• Created stored procedures and T-SQL Queries to create Tables, Views, and triggers and stored Procedures and tuned the existing Stored Procedures.
• Designed and implementation of stored procedures and triggers for automating tasks.
• Developed SQL Server Stored procedures and DTS packages to extract data from database.
• Implemented constraints on tables.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment
• Responsible for scheduling Reports using subscription services of Sql Server Reporting Services to run daily and on weekly basis.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into Reports.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Provided various security standards and subscriptions to report server
• Understanding the OLAP processing for changing and maintaining multi dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experienced in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experienced in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Lookup, ForEach Loop, Multi Cast, column conversion, Audit.

Environment: MS SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i, Sybase.

Confidential, New York, NY

MS SQL Server Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, deployment and user training.
• Designed, developed and tested processes, which include the creation of SQL views, scripts, stored procedures and DTS packages.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules.
• Extracted data using Query Analyzer and DTS packages.
• Tuned and optimized SQL statements, stored procedures and views.
• Wrote complex SQL queries and could quickly understand requirements for complex queries and procedures.
• Created DTS packages for transforming data from various data sources.
• Fine tune complex SQL queries and Stored Procedures to increase performance.
• Suggested creating Clustered and Non Clustered indexes on tables
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.

Environment: MS SQL Server 2000/2005/2008 , ETL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) DTS, T-SQL, MS Office Components, Microsoft Visio Studio.

Confidential

SQL/.Net Developer

Responsibilities:

• Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
• Developed Web Forms using ASP.NET and C#.
• Implemented the project using n-tier architecture with presentation tier (ASP.NET),
• Business Tier (C#) and backend database tier (SQL Server).
• Configured the Web.Config file for Authentication, Session, and Trace.
• Used ADO.NET Connection, Command, Datasets, Data Adapter, Data Reader and XML to retrieve and store the data in SQL Server 2000.
• Created Web User Controls and Custom Controls.
• Created Stored Procedures and triggers for automated operations.
• Consumed Web Service Successfully.
• Created Tables, Views, Indexes and Relations using SQL Enterprise Manager.
• Used Visual Studio.NET debugger and ASP.NET trace functionality to debug the application.
• Used Visual Source Safe for version control and history during development.
• Involved in reporting using Crystal Reports.

Environment: MS SQL Server 2000, T-SQL, Microsoft Visual Studio 2003/2005, Oracle 9i, MS Excel, MS Access 2000, Windows NT.