SUMMARY

• 8+ years of professional experience in development, implementation and administration of database systems as a MS SQL Server Developer using Microsoft SQL server 2017/2016/2014 /2012/2008R2/2005 in various domains including Banking, Insurance and Oil and Gas.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS, SSAS) including MS solutions like MS EXCEL 2009/2012, Microsoft Office.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
• Excellent in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Excellent knowledge to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like Microsoft Excel.
• Excellent in Design of ETL SSIS Packages for integrating data using OLE DB connection from sources like (Excel, CSV, Oracle, flat file,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating reports using SQL Server Reporting Services, like Crystal Reports, parameterized reports, sub reports, drill down reports, drill through reports, MS Excel spreadsheets and Power Pivot for client requirements in SSRS 2010/2014.
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions and features.
• Expertise in writing SQL Queries, Dynamics, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views and Cursors.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2012/2014) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Expert in Developing and Extending MSBI SQL Cubes, Dimensions and data source view MSBI SQL-Data Mining Models and Deploying and Processing MSBI SQL object.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server Analysis Services (SSAS).
• Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.
• Skilled in creating virtualization reports using Power BI
• Experienced in creating interactive dashboards and scorecards utilizing Power BI.
• Hands on experience in MS Power BI desktop and Power BI service.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Thorough understanding of Kimball’s theory, KPIs and Perspective, Data mining structures.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• On-call duty with teammates 1-2 weeks per month and active involvement in Go-live activities.
• Excellent communication skills, analytical skills, understanding of business requirements in various domains.

TECHNICAL SKILLS

• Languages: T-SQL, XML, HTML, C#.Net, ASP .Net.
• Data Application: SQL Server 2005/2008 R 2/2012/2014/2016 MS Access (2013/2003) and UML.
• Database Modeling Tools: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas. Microsoft Visio 2007, Erwin Data Modeler 8/7/5
• DB Utilities: SQL Server Management Utilities, Query Analyzer.
• GUI: DTS Import/Export, SQL Server Integration Services.
• BI Tools: SSIS/SSRS/SSAS, SSBI Development Studio, Crystal Reports.
• Reporting Tools: MS Access, Excel, and MS SQL Server Reporting Services2005/2008 R2/2012/ 2014,2016 SSIS, SSAS and Share Point, Crystal Report
• Operating Systems: Windows10/8
• Version control tools: Visual Source Safe (VSS), Subversion (SVN), Team Foundation Server (TFS)
• Others: ER-Win, MS Office.

PROFESSIONAL EXPERIENCE

Confidential., Gaithersburg, MD

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for the clients.
• Transformed data from different data sources like Oracle to SQL Server 2012/2008 using ODBC connection providers by creating various SSIS packages. Data is transformed from data warehouse to hub.
• Extensive T-SQL Programming using Views, Functions, Stored procedures, CTE’s and functions.
• Performed performance tuning by analyzing indexes, queries, and table size etc Database Engine tuning advisor and query execution plan tools.
• Developed and maintained various cubes using MDX complex queries using SSAS.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Working with various business groups while developing their applications, assisting in Database model design.
• Created package configuration in XML and used them to deploy packages across Test and production SQL servers.
• Designed and generated reports with different layouts using SSRS 2008R2 and exported them into Excel, PDF and HTML.
• Responsible for reverse engineering the company intranet and collaboration portals built up SharePoint 2013 and SharePoint 2010.
• Analysis and documentation of SharePoint architecture including central administration, SQL & Windows 2008R2.
• Involved in debugging the ASP.NET code and fixing the bugs.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Developed several REST web services supporting both XML and JSON to perform tasks such as
• Remote thermostat and demand-response management. REST web services leveraged by both web and mobile applications.
• Design and development for the Crystal Reports which work as a feed for the dashboard.
• Created Web reports for P2P/OTC and FI reports for base of the dashboard development.
• Implemented PowerShell scripts that automated creation of contacts from Active Directory users and updating of address books -increasing productivity and efficiency.
• Designed and developed various Service Management Reports like Cascading Prompts, Sales Reports, Portfolio Report, sub-reports, charts, and parameterized reports, conditional and dynamic reports and deployed various reports on Share Point Portal.
• Created report models for ad hoc reports when the end user wants to see the reports on fly.

Environment: MSSQLServer2012,2008R2/2008,SSIS,SSAS,SSRS,WindowsServer2003,SSIS/SSAS/SSRS, SharePoint, Crystal reports, Web Services, PowerShell, Tableau and MS access Excel.

Confidential, Houston, TX

Responsibilities:

• Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008R2/2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Worked with development teams in the design of physical databases and in modification.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Implemented business logic as .NET Framework assemblies (C#, VB.NET).
• Extensive Excel work using pivot tables and complex formulas to manipulate large data structures.
• Developed data mining algorithm from energy bill data using RDBMS and .Net technologies.
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Designed and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 Reports Services (SSRS).
• Developed Data Interface layer using ADO.NET and C# for data access.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Developed SSIS process design architecting the flow of data from various sources to target.
• Built ETL SSIS packages both design and code to process data to target databases.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Created data entry both web and windows application, with LINQ to query XML Documents.
• Help in leading team in creating SSIS templates for developing SSIS Packages.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance

Environment: Windows 2003/2008 Server, MS SQL Server 2008R2, BIDS, ASP .NET, XML, SSIS, SSRS, Service Broker, C#, PowerShell, MS VSS

SQL Developer,

Confidential, Minneapolis, MN

Responsibilities:

• Involved in the installation of SQL server and installed SQL server enterprise manager tools using SQL Setup.
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic.
• Optimized queries by looking at execution plan for better tuning of database.
• Designed and developed various complex reports using drill down, drill through, cross tabbed reports etc.
• Responsible for ongoing maintenance and management of existing reports. Also to optimize report performance.
• Used Report manager to deploy reports, schedule reports and created groups and users.
• Designed and developed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different transformations like lookup, merge join, fuzzy lookup, derived columns etc.
• Involved in automating SSIS packages using SQL server agent jobs, windows scheduler and third part tools.
• Implemented event handlers & error handling in SSIS and notified process results to various communities.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2005/2008, SQL Server Management Studio, MS Excel, T-SQL,

Confidential, McLean, VA.

Responsibilities:

• Developed SSIS, SSRS / T-SQL Code and scheduled jobs for Jobs Monitoring Automation.
• Gathered, organized and validated data to answer business questions as need by the management.
• Defined report layouts for formatting the report design as per the needs.
• Written Complex Stored Procedure for the reports using T-SQL and dynamic SQL.
• Scheduled the reports to run automatically and send the reports in different formats via email or upload the reports to shared folder or a SharePoint website
• Identified slow running query and optimization of stored procedures to tweak the performance.
• Involved in day-to- day maintenance and solved any issues related to reports.
• Created different visualization in Power BI per the requirements.
• Responsible for deploying the SSIS packages and scheduling the package through jobs in all tiers Including dev, test and production.
• Worked on Type 1 and Type 2 packages for incremental to load data from source to DataMart.
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables and views.
• Performed tuning of tables using normalization and by creating indexes.
• Used Microsoft Azure as the back-end for rendering reports and dashboard for the Power BI
• Managed day-to- day operations of the database systems activities and worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS).
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Code Reviews, customization and maintenance of code across applications using TFS
• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS 2014 packages.
• Worked with scheduling and publishing of reports in SQL server reporting services and integration with Microsoft Office tools like automatically emailing reports in various formats such as Excel, PDF etc.
• Responsible for release of code into QA and production.

Environment: SQL Server 2012/2014/2016/2017 , SSIS, SSRS, C#.Net, Excel, Power Pivot, Power BI Desktop, Power BI Web, TOAD, TFS, VB.Net, Visual Studio 2010/2013, COSMOS, AZURE Database, SharePoint, XML, HTML.