SUMMARY

• 8+ years of IT experience in database design, development and support of Microsoft SQL Server for Production/Development environments.
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Good knowledge of Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL).
• Experienced in redesigining and successfully migrating applications to new platforms.
• Hands on experience in implementing complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server by Play Now Radio">Analysis Services (SSAS) and Reporting solutions using Microsoft by Play Now Radio">SQL Server Reporting Services (SSRS).
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS.
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix).
• Created and scheduled subscriptions for the reports using SSRS 2008/2012.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema.
• Experienced in providing 24X7 production support for critical ETL processes and strategic financial reports.
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.
• Conversant with all phase of Software Development Life Cycle (SDLC).
• Good Experience working and implementing processes in different bussiness domains like Finance and Mortgages.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance. Expert in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans.
• Experience in using Audit functions and extensively used exception handling for catching and reporting errors.
• Very Strong on tools such as Erwin Data Modeler, Visio, TFS and have full understanding of the Software Development Life Cycle.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like SQL server 2000/2005/2008/2008 R2/2012/2014/2016, MS Access databases and strong knowledge of SDLC principles.

TECHNICAL SKILLS

Relational Databases: MS SQL Server 2000/2005/2008/2008R2/2012/2014/2016, MS Access, oracle

Programming Languages: T-SQL, HTML, XML, C, C#, Pl Sql

Reporting Packages: SQL Server Reporting Services, Crystal Reports, MS Excel, Cognos

Tools/Methodologies: MS Visio, Erwin, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies, testing tools, UAT, VB.net

Operating Systems: Windows NT/98/2000/XP/7, Windows Server 2003/2008, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Plano, Texas

MSBI / Power BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing ComplexSSRSReports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Responsible for creating datasets usingT-SQLandStored Proceduresand involved inData visualization.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Provided 24X7 production support to ensure timely and error free delivery of reports.

Environment: MS SQL Server 2016/2014/2012/2008R2, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel, Windows 7

Confidential, Dover, Delaware

MS SQL Server Developer

Responsibilities:

• Developed free-form reports using MS - SSRS tool for consolidating multiple reports into single report delivered in .pdf format to the power users. Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Provided 24X7 production support to ensure timely and error free delivery of reports.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.
• Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations.

Environment: MS SQL Server 2012/2008 R2, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel, Windows 7, Agile, Scrum, Visual Studio 2008/2012.

Confidential

MS SQL Developer (SSIS/SSRS)

Responsibilities:

• Plan, design, and implement application database code objects, such as tables, stored procedures, functions and views in partnership with business analysts and technical architects.
• Used the SSIS to migrate Databases such as Access database, flat files to centralized IT destination.
• Implemented complex business logic and processes through T-SQL stored procedures, Functions, Views and advance query concepts.
• Reported financials to the management with variety of SSRS reports and dashboards for better and effective decision making.
• Good experience interacting with end users for understanding bussiness processes and implementing the same through T-SQL for process automation.
• Designed complex and custom reports using SSRS with drilldown features, sub reports, charts.
• Compressed data files by removing empty database pages and updating index statistics.
• Created SSIS packages to transform data from different data sources into application required formats for e.g. Unpivoting.
• Designed and deployed SSAS cube for reporting P&L's in an effective and efficient way to users and to overcome the drawbacks of excel pivots.
• Testing software to ensure the code is correct, fixing ('debugging') errors where they occur, and rerunning and rechecking the programme until it produces the correct results.
• Used Event Handlers and logging for Exception Handling in SSIS packages.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Working with trainers and technical writers to develop user support materials.
• Automated redundant and repetative tasks using different tools and objects available in SQL Server.
• Timely support and maintenance of the application to ensure uninturepted business deliverables.

Environment: MS SQL Server 2008/2005, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel, Windows 7

Confidential

MS SQL DEVELOPER (SSIS/SSRS)

Responsibilities:

• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Planned, designed, and implemented processes to recieve, transform and load valuable data from external sources into local databases.
• Structured the entire ETL process using SSIS in a systematic way, right from tracking the files for availibility to extracting the files to and loading them to their appropriate destinations.
• Designed SSIS Packages to load data from differnt sources like excel, flat file, csv etc.
• Designed Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, mail task, Derived Column, and For Each Loop, Data Conversion etc.
• Provoided 24X7 support to ensure all the data warehousing activities were completed and reports were up-online.
• Coordinated with the offshore teams on the requirement gathering and enhancements to the existing DataMart and model.
• Writing MDX queries for cube calculated members to meet business requirements.
• Replicated the entire ETL process from Production to Development environment for debugging production issues and demoing results of new requirements to business users.
• Debugged T-SQL queries for performance tuning. Ensured the entire ETL process completed within the deadline time and investigated various stages and reasons for delays.
• Justify required changes to packages and redeploy to various environments.
• Created SQL Server reports using SSRS, tasks included defining requirements, design, develop, test, implement and maintain reports.
• Developed parameterized reports, linked reports, matrix and tabular reports with drill down and drop down menu option.
• Deployed the generated reports on to the Report server and fine-tuned the database objects to ensure efficient data retrieval.
• Worked on with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.

Environment: MS SQL Server 2005, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Vb.net, Windows Server 2003

Confidential

MS SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management.
• Developed complex T-SQL Stored Procedures, Functions, Tables, Views, Indexes and other SQL joins and statements to extract required data from servers across loactions and load them into local databases.
• Implemented the AGILE Method of Development.
• Gathered functional requirements and written the technical specifications.
• Designed logical / physical data models and defined primary key, foreign key. Extensively Involved in Designing (Logical and Physical) of Databases.
• Created database objects like tables, views, indexes etc using T-SQL statements.
• Configured RAID (Redundant Array of Independent Disks) levels.
• Working with Third Party tools like Red Gate, Quest tools.
• Created and modified stored-procedures, triggers, cursors. Created & managed the Database Users, Login Ids and Security.
• Wrote different complex SQL queries including inner, outer join and update queries.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Active part in maintenance of data cubes for OLAP.
• Setup SQL Jobs, Operators, Alerts and Mail Profile.
• Created the documentation for SQL server and service packs installations.
• Configured and maintained Snapshot and Transactional replication for 3 environments.
• Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
• Used SQL Profiler for getting the trace activity for the Various Stored procedures and used Index Tuning wizard for performance betterment.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using SQL Server Integration Services (SSIS).
• Used DTS to created jobs to populate some of the tables with data from other servers.

Environment: MS SQL Server 2005, Transact-SQL, HTML, SQL Server Management Studio (SSMS), Vb.net, Windows Server 2003, MS Access, Erwin, DTS, SQL Profiler, Query Analyzer, T-SQL, Windows 2000 and XP