SUMMARY

• Over 7 years of experience in analyzing, designing, tuning and developing client/server, Business Intelligence (BI) database application, using MS SQL Server 2012/2008R 2/2008/2005/2000 DTS/SQL Server Integration, Reporting and Analysis Services (SSIS, SSRS, SSAS) including 1 year plus experience in developing ASP.net web application using Visual C sharp.
• Extensive SQL Development experience in Healthcare and Retail industries with a strong understanding of data & analytics.
• Experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, stored procedures, and triggers using SQL Servers.
• Expert in creating indexes, Stored Procedures, user defined functions, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Experience across all phases of SDLC from project initiation to post-implementation.
• Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Designed and developed logical and physical data models using Sybase Power Designer 16.5, Erwin 4.1 and MS Visio 2010.
• Expert in developing, deploying packages and extracting data using SSIS from OLTP to OLAP.
• Experience in ETL Processes. Worked extensively on data extraction, cleansing/data integration, and loading from different data source using SSIS.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL
• Experience in deploying and enhancing the SSIS Packages from development server to production server. Used Bulk Copy utility extensively for loading data from Text to SQL Server database.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Extensive experience working with Business Intelligence data visualization tools with specialization on SSRS, MS Excel Power Pivot Dashboards, MS Excel Power View and Tableau.
• Efficient in generating Tabular, parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Experienced in using global variables, expressions and functions for the reports.
• Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Analysis Services (SSAS)
• MS SQL Server Reporting Service (SSRS)
• T-SQL
• SQL Server Management studio (SSMS)
• MS SQL Server Index Tuning Wizard
• SQL Profiler/Analyzer
• Database Engine Tuning Advisor
• SQL Agent
• Service Manager
• Visual Studio 2010/2008
• Erwin4.1
• Sybase Power Designer 16.5
• ASP.NET
• C#
• Team Foundation Server(TFS)
• MS Office (MS Visio
• MS Word
• MS Excel
• MS PowerPoint)
• Excel Power View
• Excel Power Pivot
• Tableau 8.2.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

MS SQL Server Developer/ BI Developer

Responsibilities:

• Develop complex SSIS Packages, SSRS reports and Cubes using Microsoft Business Intelligence Development Studio (BIDS).
• Create complex stored procedures, triggers, functions, indexes, tables, views using Microsoft SQL Server Management Studio (SSMS)
• Involve in designing and implementing data warehouse using Kimball’s bottom - up approach.
• Involved in developing of stored procedures for implementing Change Data Capture (CDC) technique to track and capture data changes.
• Develop SSIS package to implement ETL (Extract, Transformation, and Load) process on the changed data using query function of Change Data Capture (CDC).
• Use Red Gate SQL Compare 10 database tool to compare and deploy changes to SQL Server database schemas.
• Create jobs using SQL Server Agent Job to automated processes for the activities such as database backup processes and SSIS and SSRS packages run sequentially.
• Develop stored procedures and queries for generating reports such as drill down reports, drill through reports, parameterized reports etc. and used Report Manager to deploy the reports to production server.
• Prepare Ad-hoc report through report builder.
• Create custom report templates using SSRS, providing consistency of the report throughout the organization.
• Create and Design Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Create and Configured OLAP Cubes (Star Schema and Snowflake Schema) using SQL Server 2008 Analysis Services (SSAS).
• Enhance the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Develop T-SQL queries, functions, cursors, triggers and stored procedures to generate XML files, based on requirement specifications.
• Develop SSIS packages to convert XML files into flat files, to upload the generated flat files to FTP server and to download the flat files from FTP server to local server.
• Use XML marker, a XML reader tool, to view the flat file in proper format.
• Design and developed data structure to provide mapping between two databases and defined primary key, foreign key.
• Design entity relationship diagrams showing foreign key relationship between tables using SSMS database diagrams.
• Created SSIS packages to load data from ASCII text compressed flat files to staging tables. Also package used stored procedure to load data from staging table to respected tables in ODS database.
• Used Team Foundation Server to load database, Report and SSIS Packages.

Environment: T-SQL, MS SQL Server 2008R2, SQL Server Integration Services 2008(SSIS), SQL Server Reporting Services 2008(SSRS), SQL Server Analysis Services 2008(SSAS), Microsoft Visual Studio, SQL Compare 10 Database Tool, XML Marker, SQL Server Management studio (SSMS), TFS, MS Excel, MS Visio, Notepad ++

Confidential, Houston, TX

MS SQL and Report Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Created Configuration file using environment variable to capture the variables and for deployment purpose.
• Designed and implemented SSIS package to migrate data from multiple data sources for data analyzing.
• Extensively involved in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Extensively used T-SQL statements and created multidimensional cubes for the analyzer and used pivot table to help the end-user get familiar with cube.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers and used windows security for security purposes.
• Used indexes to enhance the performance of individual queries and enhance the stored procedures.
• Involved in providing information and assistance to the database administrator on physical models, setup and maintenance of database.

Environment: SQL Server 2008 R2/2008, SSMS, SSIS, SSRS, SSAS, HTML, CSS, Java Script, Team Foundation Server, IIS 7.0

Confidential, Arlington TX

Responsibilities:

• Worked extensively on SQL, ASP.NET and C#.
• Involved in Analysis, code development, code review, testing, bug-fixing, preparation of program specifications and unit test plans, production support.
• Analyzed and Prepared the Software Required Specification of the programs.
• Designed and documented Functional and Technical documents using MS Visio.
• Worked as a developer in creating different data object like Functions, Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in deployment, trouble shooting, problem solving and complete application support.
• Responsible for interacting with the client, understanding their requirements and implementing the necessary changes in the program

Environment: ASP.NET, C#, WPF, TFS, SQL Server 2000/2005, HTML, Java Script, IIS, N Unit Testing.