SUMMARY

• Around 6 years of extensive experience in SQL Server Suite of products (SSRS/SSIS/SSAS) and involved in all phases of Software Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Experience in MS - SSRS, SSIS, SSAS, OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Worked with SQL Server 2008/2008R2/2012 and implemented new features.
• Extensively worked on Erwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Created user interface using Resource Layout and publish reports with Report Caster.
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, DTS Import/Export utility, and Bulk Copy Program (BCP).
• Used Lookups Transformation to get the data from reference data sets and scheduling the SSIS packages and Jobs.
• Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Created email subscriptions for data driven reports by using Report Manager.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Experience with Ad-Hoc reporting using Report Builder in SSRS for daily reports.
• Expertise in designing/creating several reporting services reports that have been formatted specifically for dashboard displays, i.e. with charts, KPIS, tables, etc
• Used Performance Monitor/Profiler to solve dead locks/long running queries.
• Worked on analyzing and performance tuning queries by looking at Query Statistics and Execution plans.
• Experienced in managing Alerts, Operators and Jobs through SQL Server Agent.
• Experience in writing complex SQL queries involving multiple table inner and outer joins, temporary tables, table variables.
• Experience in multiple domains including communication, healthcare, Mortgage and Insurance.
• Very good knowledge on healthcare data, Provider, Payers, HIPPA, Facets knowledge.
• Experienced in Visual SourceSafe version, TFS, control system product that delivers restore point and parallel collaboration capabilities, thus allowing application development organizations to work on several versions of software simultaneously
• Strong technical knowledge in Troubleshooting and Performance tuning.
• Created views to facilitate easy viewing implementation.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Hands-on experience in debugging stored procedures to optimize performance
• Assisted in restoring and updating the production database into development and QA environment for testing various stages of monitoring the queries.
• Experience in using variables, expressions and functions for the reports.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.

TECHNICAL SKILLS

Programming Languages: SQL, TSQL

RDBMS: MS-SQL Server 2000/ 2005/2008/2008 R2,Microsoft Access, DB2

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2008 R2, DTS

OLAP Tools: SQL Server Analysis Services (SSAS) 2000/ 2005/2008/2008 R2.

Reporting Tools: SQL Server Reporting Services (SSRS) 2000/ 2005/2008/2008 R2, Crystal Reports, Report Builder

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer

Data Modeling: ERWIN, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

MS SQL Server /BI DEVELOPER

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data types, Clustered & Non-clustered Indexes.
• Created database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005/2008 .
• Participated in migration from SQL Server 2005 to SQL Server 2008.
• Experience in tuning of Stored Procedures and query optimization to improve the performance and eliminate the deadlock situations and hang-ups on server.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Charts, Drill down reports, and Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Highly involved in creating, structuring, formatting reports using Report Designer and Report Builder.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on weekly and monthly basis.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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.
• Used Fuzzy Lookup and Fuzzy grouping transformations for improving the data quality of the existing data as well as new data that is being loaded into the database.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Designed the new data warehouse (DWH) while constructing the cubes and dimensions of a system for the purpose of analysis, decision making based on historical data.
• Created and designed dimensions and fact tables using star and snowflake schemas in SQL Server Analysis Service(SSAS)

Environment: SQL Server 2000/2005/2008 , ORACLE, MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008.

Confidential, Grapevine, TX

MS SQL Server /BI DEVELOPER

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data types, Clustered & Non-clustered Indexes.
• Created database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005/2008 .
• Participated in migration from SQL Server 2005 to SQL Server 2008.
• Experience in tuning of Stored Procedures and query optimization to improve the performance and eliminate the deadlock situations and hang-ups on server.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Charts, Drill down reports, and Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Highly involved in creating, structuring, formatting reports using Report Designer and Report Builder.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on weekly and monthly basis.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, 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.
• Used Fuzzy Lookup and Fuzzy grouping transformations for improving the data quality of the existing data as well as new data that is being loaded into the database.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Designed the new data warehouse (DWH) while constructing the cubes and dimensions of a system for the purpose of analysis, decision making based on historical data.
• Created and designed dimensions and fact tables using star and snowflake schemas in SQL Server Analysis Service(SSAS)

Environment: SQL Server 2000/2005/2008 , ORACLE, MS Access, EXCEL, VBScript, HTML, XML, Visio, Windows Server 2000/2003, ASP.NET, VB.NET, BIDS 2005/2008,Visual Studio 2005/2008.

Confidential, Chesapeake, VA

SQL Server Developer

Responsibilities:

• Actively Participated in technical discussions to understand changes and to gather business requirements.
• Analyzed to find the impact to EDW and downstream applications due to upstream enhancements.
• Performed the Source system analysis to make sure source data is aligned with EDW Data model.
• Created Technical and ETL Design Documents with details of source tables and Transformation logic.
• Developed several complex SSIS packages and performed Unit & Integration Testing.
• Created SSIS (SQL Server Integration Service) packages to extract data and scheduled Jobs to call the packages and Stored Procedures using SQL Server Agent.
• Involved in Bulk Load andIncremental Data Loadfrom various sources into SQL Server Database Engine with ETL Operations.
• Worked on creating SCD type I and SCD type II during incremental data loading from IR Server to EDW Server.
• Debugged issues and resolved time-to-time technical problems.
• Responsible for preparing the Release Documents and work with Release Management to release codes/objects to SQA and UAT environment.
• Responsible for fixing issues and bugs identified by SQA and UAT resources.
• Performed data query, extraction, compilation, and reporting tasks.
• Create T-SQL scripts to manipulate data for data loads and extracts.
• Created indexes, Views, complex Stored Procedures, user defined functions, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Performed Data Validation using SQL Server Management Studio 2008.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups, H-Lookups.
• Performed Data Analysis for automating various Customers Order Reports utilizing SSRS 2008.
• Designed and developed 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.

Environment: MS SQL Server 2008R2, MS SQL Server Integration Services 2008R2 (SSIS), MS SQL Server Reporting Services 2008R2 (SSRS), MS Excel, MS Access, Oracle, DB2, Flat Files

Confidential, Atlanta

SQL Server developer

Responsibilities:

• Analyzed the Business Requirement Document(BRD)to design a conceptual model to be implemented with T-SQL, SSIS, and SSRS to develop a solution.
• Involved in Planning, Defining and Designing the data needed for business requirement and provided documentation.
• Involved in all stages of development process - high-level design, implementation, testing, deployment and support of products adhering to company's SDLC.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure query optimization.
• Involved in designing, reviewing, and creating database objects like Tables, Views, Indexes, Stored procedure, Functions, Triggers based on logical design model, user requirements and physical constraints.
• Developed stored procedures to check the business rule, which can be run in loop for multiple databases.
• Designed SSIS Packages to transfer data from various sources like Flat Files, XML Files, SQL Server, Excel, and Access to MS SQL Server.
• Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS standards likeerror handling, loggingand working withpackage configuration files.
• Managed error handling of the packages by redirecting rows to an error log table.
• Created jobs using SQL server agent to run the packages in the daily basis and also scheduled jobs to be executed at the assigned time frame.
• Created SSIS (SQL Server Integration Service) packages to extract data and scheduled Jobs to call the packages and Stored Procedures using SQL Server Agent.
• Involved inIncremental Data Loadfrom various sources into SQL Server Database Engine with ETL Operations.
• 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.
• Involved in Debugging reports and deploying reports to the reporting server and scheduled the reports to run automatically launched the report builder for ad hoc reports.

Environment: MS SQL Server 2005/2008/2008 R2, MS SQL Server Integration Services 2005/2008/2008 R2 (SSIS), MS SQL Server Reporting Services 2005/2008/2008 R2 (SSRS), MS SQL Server Analysis Services 2005/2008/2008 R2 (SSAS), T-SQL, Windows XP, Windows Server, Visual Studio 2005/2008, Report Builder 2.0/3.0, MS Access, MS Excel.

Confidential, Livonia, MI

SQL SERVER/BI DEVELOPER

Responsibilities:

• Involved in planning & administration of the entire migration and performance.
• Actively participated in the business requirement meetings with the client.
• Involved in creating of the design document of the process.
• Developed backup restore scripts for SQL Server as needed.
• Tuned T-SQL statements using Indexes and Stored Procedures.
• Participated in migration from SQL Server 2000 to SQL Server 2005.
• Monitored SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Involved in migration of Data from Excel, Flat file, XML files to SQL Server by using DTS utility.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading.
• Implemented computational sensitive queries Stored Procedures.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Created triggers (After and Instead Of) and stored procedures to capture updated and deleted data from OLTP systems.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Profiler.
• Designed VB forms using the forms and crystal reports were made for business reporting purpose.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Designed and populated reporting tables, Views and Stored Procedures.
• Analyzing the Database Growth and Space Requirements. Handling Users, Logins or User Rights.

Environment: MS SQL Server 2005, MS SQL Server 2000, DTS, VB Script, SQL Server Integration Services, SQL Server Reporting Services, Crystal report 9.0,IIS server 6.0.