SUMMARY

• Over 8 years of experience as a MS SQL Server Developer working on large - scale enterprise and performance critical applications.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server 2000 / 2005 / 2008.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger coding, testing, debugging and installing to support client server and software applications.
• Expert in using BI tools SSIS, SSRS and SSAS in MS SQL server 2005 and 2008; MS Access.
• Involved in the Logical Design of the Database & transforming it into a Physical Design.
• Performed Data Modeling using Erwin.
• Experienced in supporting a team of application developers for their .NET database application.
• Transformed data from various data sources using OLE DB and ODBC connections.
• Experienced in SQL Development in the .NET environment especially with CLR Stored Procedures.
• Well experienced with DTS, BCP and Jobs for MS SQL SERVER.
• Experience with batch, database, real-time, flat-file, Oracle, XML files, CSV files data load and dynamic data migration methodologies.
• Expert in the Installation of Analysis Services in MS SQL SERVER 2000.
• Exceptional Computer Science background with programming skills in VB6 & VB.NET as a Junior Programmer.
• Excellent knowledge of development in OLTP and OLAP environment, dynamic OLAP, multi-dimensional data structures MOLAP and HOLAP.
• Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
• Worked extensively on system analysis, design, development, testing and implementation of various projects.
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), aggregations, and user-defined functions.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.
• Self-Motivated and possess the ability for critical thinking, analysis, good interpersonal and communications skills. Technically motivated and creative. User oriented with a desire to learn client's business requirements. Excellent knowledge of health care, finance, manufacturing, sales and insurance industry applications.
• Ability to work excellently as an individual and also as a proactive team member with minimum amount of supervision.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• SQL Server Reporting Services 2005/2008
• SQL Server Analysis Services 2005/2008
• MS SQL Server Integration Services 2008/2005
• MS Access
• C++
• HTML
• VMware
• MS Visio 2003
• Windows server 2000/2003
• Crystal Reports XI/8.5/8.0
• Visual Studio 2005/2008
• MS VISIO 2000/2003 Remote Desktop
• DreamWeaver
• Flash
• Ms Office
• Ms Frontpage

PROFESSIONAL EXPERIENCE

Confidential, Owings Mills, MD

SR SQL BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Created numbers of complex formula in sub report.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Created Packages to group logically related column types and to transfer data.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Designed both logical and physical data models in Erwin r 7.2

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Analysis Server 2008,VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, Manhattan, NY

Sr MS SQL BI Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on wealth information, account information, research reports using adhoc reporting to be used by the clients and advisors.
• Identified and worked with multivalved parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients,advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updations to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly.
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports 10, Visual Studio 2005, MS Office 2007, SQL Profiler

Confidential, Pleasanton

MS SQl/BI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2005.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created Query Parameters and Report Parameters to control data returned by the query and filter data at report level.
• Created linked, unlinked and on-demand sub Reports.Understood the various complex reporting requirements of company and created web reports using Reporting Services.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and wrote
• SQL code to access and manipulate data stored in relational databases.
• Developed, monitored and deployed SSIS packages.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Created User Defined functions for sharing formulas across multiple reports.
• Modified existing reports according to requirements of the end users.

Environment: MS SQL Server 2005, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS,BCP, T-SQL.

Confidential, Louisville, KY

MS SQL, SSIS/SSRS Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2005 with latest Service Packs.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Developed Event Handlers for executing Stored Procedures and storing the rows Inserted, rows Selected, rows Rejected, rows Updated and rows Unchanged in appropriate SQL Tables.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Creating package dependencies by calling Child packages within Parent.
• Using Configurations to make dynamic changes to packages. Configurations like XML, SQL Server and Environment Variables have been used.
• Using the Default logging as well as Custom Log to keep track of the package.
• Migrating SQL Server 2000 DTS packages to SSIS Packages.
• Designed, administrated and developed Star Schema Data marts
• Designed and created OLAP cubes defining the dimensions and relationship between dimensions and measure groups
• Experience in creating multiple reports (SSRS) in Drill mode using tables, crosses tabs and charts.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Developed stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, and Implementation.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2005, MS SQL Server Reporting service 2005, MS SSIS, T-SQL, Windows 2003

Confidential

SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from SQL server 7.0 to 2000.
• Written various stored procedures for the purpose of application development.
• Tuned SQL statements (Using Indexes) and Stored Procedures.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Disaster recovery and database maintenance plan.
• Replication of data using Transactional method.
• Migrated data from sql server 7 to sql server 2000 successfully
• Data conversion from Text File into SQL Server Table.
• Created constraints and validated database integrity.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed and implemented user log in and security.
• Extracted Data from MS Access.
• Created many complex Stored Procedures / Functions and used them in Matrix Reports.
• Created reports and hosting it in the web for the users.

Environment: MS SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler