SUMMARY

• 13+Years of IT experience as Microsoft SQL Server/Business Intelligence Developer in Production/Development environments.
• Expertise in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Thorough knowledge of fixing Performance Issues using query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in writing T - SQL (DDL, DML and DCL) scripts and expert in ETL development using Microsoft Business intelligence technologies like SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS) and SQL Server Analysis Services(SSAS).
• Developed complex SQL queries using stored procedures, common table expressions (CTEs),PIVOT table, temporary table to support SSRS reports and Power BI.
• Experience creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variable, Parameters, Environment Variables for SSIS Packages.
• Very good Experience in Error and Event handling: Precedence Constraints, Break Points, Check Points and Logging.
• Experience in creating Ad-hoc reports and tuning of reports. Excellent knowledge in RDBMS concepts and constructs.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• As a part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Expert creating various types of reports including Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Deployed (Native Mode) SSRS reports on to the report manager and delivered using 'pulled' and 'pushed' methodologies.
• Created and designed a Tabular Model (configured OLAP cubes, Dimensions, Measures, Data mining, Data source and Data source views and Star and Snow Flake Schema of Data marts) using SQL Server Analysis Services(SSAS).
• Experience in creating Power-BI Dashboards using sources like azure blob storage, azure SQL.
• Excellent Communication, Analytical skills and Interpersonal skills. Exceptional ability in mentoring team members, learning new concepts and self-motivated.
• Proven ability in multitasking for multiple requests under tight deadlines competing priorities.
• Good exposure in planning and executing all phases of software life cycle. Experiences in gathering requirements from business process, functional & technical specs, writing up development requests, draw program logical flow diagrams, and test scripts for custom programs, reports & enhancements.
• Experience in working with multiple domains such as Healthcare, Life Sciences and Man Log.
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences.
• Co-ordination with internal and external team members.
• Project delivered under stringent timelines and high pressure.
• Work with different groups in the organization
• Provide inputs to technical team
• Successfully managed complex projects with global implementation, and rapidly evolving requirements.
• Exceptional ability to maintain and build client relationships, able to comfortably converse with all facets in the client’s organization.
• Involved in Project Management, Project Tracking and Team Management.
• Managed analysis, design and decision-making for a change request.
• Rich experience in translating Business requirements to understandable IT systems requirements and Implementing CMM Methods & Procedures across the organization.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio (SSMS) SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS) Data Transformation Services (DTS)

Reporting tools: SSRS, Power-BI

RDBMS: SQL Server …, MS-Access.

Languages: C, C#, VB 6.0, T-SQL.

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

Sr. MSBI\SQL Developer

Responsibilities:

• Having experience in complete end to end ETL creation of SQL Server Integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring).
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2012 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge.
• Worked on Standard\Data driven subscription in SSRS reports to deliver report.
• Migrated crystal reports to SQL Server Reporting Services (SSRS).
• Assisted internal and external report designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals and document map in SSRS.
• Created Claims dashboard reports in Power BI - creating data Models and reports with different visualizations and Managing the dashboard reports.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.

Confidential, Solon, OH

MSBI\SQL Developer

Responsibilities:

• Involved in analysis, design and development using SSIS 2008 and created stored procedures in SQL Server 2008.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan and defined Check constraints, Business Rules, Indexes, and Views.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created User Defined Functions (UDF's) to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transform.
• Employed SSIS Data Profiler Task to profile Target Source Systems and build ETL Solutions, which was helpful in designing the table structures and cleaning data for data consistency.
• Used configuration files and variables to deploy SSIS packages across several Environments (Development/Testing/Production).
• Created and tuned Event Handlers, Checkpoints and logging to maintain active packages.
• Extensively utilized SSIS packages functionality to create complete ETL Process using scripts, stored procedure, Functions and Transformation of Data in BIDS.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Developed Cascading Parameters for Employee Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2008.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Confidential

Team Lead\SQL Developer

Responsibilities:

• Involved in requirement gathering, analysis and design for the application development.
• Written technical documentations such as High level and Low-Level Design Specs for the project.
• Developed ASPX pages, user controls using C#.Net.
• Used Data Reader and Dataset for data manipulations and interaction with the database using ADO.Net
• Deployment of application in the production Server via PMR (Production Move Request).
• Managed all aspects of internal deployment projects and work closely with the internal teams on status, issues and communications
• Defined business specifications with the internal user community for the global deployment of the application and managed product gaps from business specifications for product enhancement.
• Provided technical support for implemented applications; diagnosing and reporting bugs, and upgrades as needed and coordinated with functional departments to gather system specifications.
• Interacted with senior management within Product Development, Business organizations and Global IT.
• Provided technical assistance and support to customers in a professional manner while working with other members of a team to maintain the application interface, and architecture of the website.

Confidential

System Analyst\SQL Developer

Responsibilities:

• Designed GUI screens using ASP.NET, C# and involved in analysis, design and development of Applications.
• Implemented the coding standards and basic design patterns created the stored procedures in SQL Server.
• Provided technical support for implemented applications; diagnosing and reporting bugs, and upgrades as needed and Designed, Developed and tested the web pages.
• Used web services.

Confidential

Software Developer

Responsibilities:

• Created the stored procedures in SQL Server
• Developed the web pages using ASP.NET with C#
• Used Data Reader and Dataset for data manipulations and interaction with the database using ADO.Net
• Written high level technical documentation to the project
• Designed, Developed and Tested the web pages
• Created the Test case and Test Log documents

Confidential

.Net\SQL Developer

Responsibilities:

• Involved in analysis, design and development of Applications and Created the stored procedures in SQL Server.
• Developed the web pages using ASP.NET with C#.
• Used Data Reader and Dataset for data manipulations and interaction with the database using ADO.Net.
• Written high level technical documentation to the project and Designed, Developed and tested the web pages.

Confidential

.Net\SQL Developer

Responsibilities:

• Involved in analysis, design and development of Applications.
• Created the stored procedures in SQL Server and developed the web pages using ASP.NET with C#
• Used Data Reader and Dataset for data manipulations and interaction with the database using ADO.Net
• Written high level technical documentation to the project and designed, developed and Tested the web pages