SUMMARY

• Over 9 years of experience in system analysis, design, development and implementation of Relational Database and Data Warehousing Systems.
• Extensively worked on Stored Procedures, performed debugging, troubleshooting and performance tuning.
• Experienced in Data Conversion,  Data Modeling, Multi - Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Data Modeling Tools.
• Excellent in optimizing T-SQL (DDL and DML) queries,De-normalization to improve the database performance.
• Expert in creating Indexed Views, complex Stored Procedures, effective Functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Strong experience in Stored Procedure, formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.
• Experience with .NET development, either C# or VB.NET.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance, Backups and recovery, Installing and configuring SQL Server and high availability and disaster recovery like mirroring, log shipping and Replication.
• Proficient in Data analysis, Data modeling, Database design and Data migration, data loads, database integration/conversions, performance tuning and optimization.
• Excellent in High Level Design of ETL Packages for integrating data from heterogeneous sources (Access, Excel, Oracle, flat file, Text Format Data).
• Highly proficient in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services and  with MS SQL 
• Proficient in developing Custom Reports and different types of Chart,   reports and distributing reports in multiple formats 
• Expert in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache also developed drilldown reports using  SQL.
• Expert in designing reports using SQL Server Reporting Services and Excel Pivot table based on  cubes which make use of multiple value selection in parameters pick list, cascading prompts, dynamics reports and other features of reporting service.
• Extensive knowledge in various reporting objects
• Experienced in generating on-demand and scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services
• Skilled in Database programming for Data Warehouses, proficient in modeling, Snow  modeling and reporting tools.
• Proficient in Data Warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment .
• Expert in developing and extending SSAS Cubes, Dimensions and Data Source Views in SSAS - Data Mining Models, Deploying and Processing SSAS objects.
• Highly motivated, well organized, excellent leadership, interpersonal communicational skills and goal oriented.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2005/2000, SQL Server Management Studio (SSMS),SQL Server Data Tools, Business Intelligence Design Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS), Data Transformation Services (DTS), Tableau 8.0/8.1/8.2, Oracle Data Base, SAP Crystal Report, Query Analyzer, Erwin Designer, Er-Studio, Visual Studio, MS Office, MS Access, At Task, Share Point, Power Point, Share Point, Team Foundation Server (TFS),Xcelcious, Visual Basic, C#, Java, C++ and Windows XP/NT/2000/98.

PROFESSIONAL EXPERIENCE

BI Developer 

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in SQL Server.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata.
• Develop  package solution by deploying into Production Server and create an audit table for the package by including basic logging information in order to monitor the automatic executions
• Wrote parameterized queries for generating  reports and sub reports using global variables, expressions, dynamic SQL, stored procedures and functions.
• Preparing reports that need more analytical works by identifying the right voters in the data ware house so that it will be easy to feed them the right information.
• Created  parameterized, cascaded and sub reports by writing complex stored procedure using dynamic SQL.
• Moved the data from the appropriate databases to end database and maintained batch log files and worked on the statistical analysis of the data using SQL Server Reporting Services.
• Mastered the ability to design and publish rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently and Handled admin activities granting access, managing extracts and Installations.
• Worked closely with political department to understand key political measures and then identify the individual metrics and measures that need to be seen on reports.

Environment: MS SQL Server 2012/2008, MSSQL Server Integration Services (SSIS), Tableau 8.2, T-SQL, SQL Query Analyzer, SQL Server Index Tuning Wizard, Share Point, Visio, Windows 7.

Database Developer 

Responsibilities:

• Helped in translating business requirements into technical design specifications and preparing high-level documentation for the database design and database objects.
• Created SQL scripts to insert/update and delete data in SQL Server database. Created database tables, wrote complex stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Writing complex Stored Procedures to populate Dimension, Fact and aggregate tables in order to get the designed Dash Board output.
• Optimizing query performance with the help of Execution Plan and SQL Profiler.
• Designed  Templates for developing  Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Created batch files to move files from Secured  server to deployment/Production server that integrated the execution of stored procedures, SQL commands and SSIS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the Audit table.
• Involved in performing incremental loads while transferring data from  to data warehouse using different data flow and control flow tasks.
• Preparing Adhoc Reports for different regional hospitals from Clarity Database Oracle Database using Crystal Report and PL SQL Query Oracle.
• Designing Yearly, Quarterly, Monthly and Weekly Dashboard and Analytical reports based on different Hospitals that include Summery and Detail reports.
• Creation of metrics, attributes, filters, reports, and rich dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.
• Building Data Marts for dash board and analytical reports as well as for managers to prepare their own Custom reports.

Environment: MS SQL Server 2012/2008, MSSQL Server Integration Services (SSIS), Tableau 8.0/8.1 Oracle Data Base, SAP Crystal Report, T-SQL, PL-SQL, Er-Studio, Visio, Windows 7.

BI Developer 

Responsibilities:

• Used complex query statements like stored Procedures, sub queries, correlated queries, joins and  functions to insert the data depending on the criteria into the tables.
• Created Stored Procedures, User-Defined Functions, Scripts and Cursors on Development and Test servers for pre-deployment testing.
• Created SQL Server Agent Alerts to monitor the SQL Server Events and SQL Server Performance Alerts and notify the Administrators of the critical situations.
• Used various  data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Created the package to import data from multiple sources to the staging environment and to export data from the staging environment to the Data Warehouse.
• Created variables and configuration files to make the package more dynamic and schedule jobs to run automatically using SQL server agent.
• Configured the package to send email messages if tasks in the package workflow succeed or fail, or send messages in response to an event that the package raises at run time.
• Created Custom Logging for New  2008 packages which recorded Insert/Update/Delete and System information that is required for debugging the package.
• Created reports using 2005 and deployed them to the Report Server and Configured and maintained Report Manager.
• Automated the Entire load processing for the weekly and monthly Process and created report ranging from Drill-down, Drill through,, Parameterized, Dashboard, Scorecard and Analytical Reports.
• Designed and implemented, Facts, Dimensions and  cubes using Dimensional Data Modeling standards in SQL Server 2008 that maintained data.

Environment: MS SQL Server 2008/2005, MSSQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Erwin Data Designer, OLAP, Windows XP.

BI Developer 

Responsibilities:

• Designed, Implemented and Maintained Database Schema, Entity Relationship Diagrams, Data Modeling, Tables, Stored Procedures, Functions, Triggers, Constraints, Indexes, Views and complex SQL statements.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created clustered/non-clustered indexes.
• Used T-SQL for creating various Complex Objects like Tables, View, Functions and Stored Procedure for storing and processing data in required form.
• Migrated all  packages to SQL Server Integration Services and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Created  Packages using Pivot Transformation,Execute SQL Task, Data Flow Task and Execute Package Task.
• Worked extensively with business users gathering requirements to generate customized SQL reports.
• Created Sub-reports, Drill down Reports, Summary Reports, Parameterized Reports, and  Reports using  and developed complex stored procedures and functions to generate dash board reports.
• Created jobs, alerts to run,packages periodically, automated processes for the activities such as database backup processes and Packages run sequentially using SQL Server.
• Created a number of cubes with multiple fact measures groups, and multiple dimension hierarchies, critical  using as per OLAP reporting needs.
• Actively participated in User Acceptance Testing, and debugging of the system.

Environment: MS SQL Server 2005/2008/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS), Visual Studio, Microsoft Office, Business Intelligence Development Studio (BIDS), SQL Server Management Studio, Windows NT/2003.

BI Developer 

Responsibilities:

• Based on the design document and data base model, cleaned up the old server environment and made it ready for the migration of data base from SQL server 2005 to SQL server 2008.
•  Migrated database from SQL server 2000 to SQL server 2005 using backup/ restore also investigated and corrected data and user related errors for both data base and report servers.
• Written complex queries and stored procedures to fulfill the enhancement requirements of data base migration project.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Extracted data from various data sources such as Access Database and SQL Server using multiple transformations provided by  such as Data Conversion, Conditional Split, Insert, Merge and Union all.
• Used  to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Experience in generating reports Parameterized and Drill through Reports using  and developed stored procedures using functions to generate various kinds of reports.
• Built advanced reports using query parameters, report parameters, user access restrictions, filters and interactive sorts.
• Highly skilled in configuring and creating  solutions for ETL and data migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for Packages.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Query Analyzer, Windows 2000/XP, MS Word, MS Excel.

BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Designed and applied entity attributes description and definition for the models.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Designed, developed, debugged and tested  packages, reports and T-SQL Stored Procedures.
• Extracted and transformed data from various sources such as SQL Server, Excel, Access and Flat files using  into destination tables as per business requirements.
• Used various  tasks such as Conditional Split, Derived Column, and Lookup, which were used for data scrubbing and data validation checks during Staging; before loading the data into the Data warehouse.
• Administered, monitored and supported  packages and ETL process. Wrote support documentation for  reports and Stored Procedures.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of performance.
• Identified the database tables for defining queries to generate different kinds of reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Identified the Data Source and defined them to build the Data Source Views.
• Created the complex  cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified and define key performance indicator 2008.

Environment: Ms SQL Server 2005/2008, Business Intelligence Design Studio (BIDS), SQL Server Integration Service (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Service (SSRS), Visual Studio, Microsoft Office, Erwin Designer, Windows NT.

BI Developer

Responsibilities:

• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Developed physical data models and created DDL scripts to create database schema and database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Imported and Exported data from various sources using SQL Server tools such as SQL Server 2005 Integration Services.
• Migrated data between SQL Server 2000 to SQL server 2005 using Copy Database Wizard and manually attached/detached.
• Migrated data from Heterogeneous data Sources and legacy system (Oracle, DB2, Access, Excel) to centralized SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Creation and development of SQL server reports, reporting structure, which includes financial and composite reports for existing and new clients.
•  Deploying and scheduling reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Created List Reports, Parameterized Reports, Cross tabs Reports, Drill-down Reports, Ad hoc Reports, using  to estimate bank balance sheet impact.

Environment: MS SQL Server 2000/2005, Data Transformation Services (DTS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS), MS Access, Microsoft Excel, Microsoft Visio, Windows XP.