PROFESSIONAL SUMMARY:

• Overall 5+ years of experience in IT Industry as Microsoft SQL Server Database Developer.
• Responsible for supporting and coordinating all Microsoft SQL Server 2000/2005/2008. This includes, configuration, maintenance, tuning, sizing, and planning in production, testing, and development environments
• Designed and developed routines for doing statistical analysis of research date. Created complicated SQL procedures as stored procedures to meet the requirements of the systems being developed.
• Extensive exposure to creation of databases, objects, stored procedures, Triggers, security, SSIS (i.e. Import and Export), Bulk Loading of Data, Transact - SQL, and SQL Server Agent and SQL Server profiler.
• Experienced with scripting in T-SQL in constructing tables, joins, user functions, views, indexes, triggers, synonyms and user profiles.
• Developed complex Store procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Implemented cursors for rebuilding indexes.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks.
• Managed all database servers in development, staging, test and production environments
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems, ERP to SQL Server 2000/2005/2008.
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Experienced in performing Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
• Worked in OLTP & OLAP environments that include QA, Production and development, implemented and maintained database schema and Entity relationship diagrams from business requirements.
• Implemented a well-planned backup and restore strategy protects databases against data loss due to damage caused by a variety of failures.
• Experienced on Performance monitoring using SQL Profiler scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.
• Hands on installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/ 2005/2000.
• Worked with internal enterprise architects and consultants, assisting in the development of current and target state enterprise data architectures.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and also worked in a technically challenging environment.

TECHNICAL SKILLS:

SQL Server Tools: SSMS, Profiler, Erwin, Export & Import (DTS), Lite speed, SQL Backup5, Business Intelligence Development Studio

Statistical Tools: SPSS, Minitab, Microsoft Excel

Databases: MS-SQL Server 2000/2005/2008/2012,MS Access 1997/2000/2007,MySQL, Oracle

BI Tools: SSIS, SSAS, SSRS,

Languages: C, C#, T-SQL, SQL, PL/SQL, ADO.NET, ASP.NET, HTML, XML

Operating System: Windows NT 2000 Server/ Server/ Server 2003/server 2008/Professional/ 4.0, Win XP Prof/Standard, Win 98, DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. MS SQL Server/ MSBI Developer

Responsibilities:

• Played an active role during the requirements gathering, analyzing and designing of the system
• Created reports using SQL Reporting Service (SSRS) for Customized and Ad-hoc Quires
• Converted Data Transformation Services (DTS) applications to SQL Server Integrated Services (SSIS)
• Created Packages in SSIS with Error handling
• Created SSIS Packages to pull data from SQL Server to Excel Spreadsheets and vice versa
• Loading data from various sources like OLEDB, Flat files to SQL Server database using SSIS packages and created data mapping to load the data from source to destination
• Successfully migrated data between different heterogeneous sources such as flat files, Excel and SQL Server 2008 using SSIS, BCP and Bulk insert
• Extensively used SSIS Import/Export Wizard for performing the ETL operations
• Used Various ETL tools like SSIS/DTS for data flow from source files like XML, Tables and Views to other databases or files with proper mapping
• Enhancing and deploying the SSIS Packages from development server to production server
• Extensively used SSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL task, Script task and Send Mail task
• Designed, Developed and Deployed Reports in MS SQL environment using SSRS-2008
• Created Parameterized Reports and Linked Reports with thorough knowledge of report serving architecture (Table, Chart and Matrix Report)
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data
• Developed Reports for business end users using Report Builder with updating status
• Developed different kind of reports such as Sub Reports, Charts, Matrix Reports, Linked Reports
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS
• Involved in writing heavy T-SQL stored procedures, complex joins

Environment: MS SQL Server2008/2012/2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Visual Studio, Windows 2008 Server, DTS, BIDS, MS Excel

Confidential, Minneapolis, MN

Sr. MS SQL Server (SSIS/SSRS)/T-SQL/ETL Developer

Responsibilities:

• Involved in Normalization of the database and bringing it to 3NF.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Created Tabular Reports, Cross Tab Reports and Sub Reports
• Created SSIS Packages to migrate slowly changing dimensions.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS)
• Designed, implemented, and monitor EDI processes to interchange invoicing and purchasing data with suppliers using industry standards.
• Worked on X12-850/860/830 EDI Documents.
• Set up Covast EDI Accelerator to receive X12 documents (setting up Parties, Party Aliases, EDI Receive Pipeline) & to generate Functional Acknowledgement(X12-997)
• Created XML Schemas (.xsd) from DTD's & EDI X12 ASC files using Covast EDI accelerator Schema generator.
• Built statistical reports in PowerPoint v2.0, Data Analysis Expressions (DAX) was used to create various calculations, including ratios to total/parents, financial comparisons between dates and previous runs.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Highly responsible for development and management of PPS, SSAS, SSRS and SSIS projects.
• Building KPI reports for the cubes and optimizing the reports.
• Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).
• Designed SSRS 2008 reports with Cascaded Parameters, Gauges and Interactive Charts, etc.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Created complex reports which involve more number of groupings and multi-value parameters
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Rendered the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Worked on Logical and physical database development (using ER-win, Normalization, Dimension modeling and Enterprise manager).
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports
• Create parameterized Reports using Charts, Cross-Tab and Sub-report types

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Reston, VA

Sr. BI Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Triggers and Stored Procedures.
• Created SSIS packages for migrating 2005 SQL database environment to SQL 2008.
• Exported data from SQL server 2008 tables to CSV files using SSIS packages.
• Created packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel spreadsheet to SQL Server 2008.
• Implemented Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.
• Worked with various SSIS packages which involve Transactions, Restart ability and rollback techniques.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different data transformations (DTS) using SSIS.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Involved in developing logical and physical modeling of the database using Erwin.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Designed and deployed various SSRS Reports in SQL Server 2008.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS 2008.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Designed, built and tested SSAS Cubes on SQL Server 2005.
• Process the cubes (SSAS), partitions as and when required
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Worked with different methods of logging in SSIS and advanced data mapping.

Environment: SQL Server 2008R2 Enterprise Edition, SSIS/SSRS/SSAS and SQL Management Studio 2008.

Confidential, Bothell, WA

Sr. BI Developer

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Involved in developing creative MS SQL solutions including Store Procedures, Views, Functions, User Defined Data Types, DTS/SSIS jobs, and job schedules assuring optimal functionality and adherence to corporate coding Specifications.
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Joins, Store Procedure, Triggers, Functions etc. using T-SQL to store data and to maintain database efficiently.
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc in SSIS packages.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used calculations, sorts, filters and sections to enhance data presentation in reports. Created many Cascaded parameters in the reports using SQL SSRS.
• Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS). Also created many multi valued parameters in the reports.
• Used Reporting Services to consume data from SharePoint sites and display reports and dashboards on SharePoint sites.
• Identified and worked with Parameters for parameterized reports in SSRS 2008 R2.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Delivered comprehensive BI through MS solutions including MS Excel, Microsoft Office SharePoint Server (MOSS), and Performance Point Server 2007 Improved Report Performance and performed unit testing.

Environment: SQL Server 2008R2, T-SQL, SSRS, SSIS, SSAS, Visual Studio 2008, MS Office 2007/2003,MS VSS,XML,MS SharePoint 2007,.net

Confidential

SQL Developer

Responsibilities:

• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Optimize query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Involved in merging existing databases and designed new data models to meet the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configured SQL Server 2000 on development server for designing and testing.

Environment: MS SQL Server7.0/ 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler.