SUMMARY

• A degreed IT professional with 7+ years of experience in Data Warehousing and Business Intelligence applications design, using MS SQL Servers 2017,2014, 2012, 2008r2.
• Solid expertise in Database Design, Administration, Implementation and Application Development.
• Solid hands - on skills in migration/upgrading of SQL Server 2008R2 to 2012.
• Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008R2/2012/2014 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS,SSIS, SSAS).
• Experience in database design and development using Microsoft SQL Azure.
• Extensive knowledge using PowerShell for different tasks.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema.
• Monitored and tuned SQL Server performance using System Monitor, SQL Profiler, Query Execution Plans and checking the consistency of database using DBCC Utilities.
• Experience in database programming in writing Stored procedures, User Defined Data Types,Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL.
• Excellent knowledge working with TFS and to track the user stories, features and Epics in TFS.
• Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.

TECHNICAL SKILLS

Cloud Technologies : Microsoft Azure

Databases: SQL Server 2008/2012/2014/2017, Azure (Cloud Server), Access, MySQL, Oracle 10g, 11g,12c.

Programming Languages: T-SQL, HTML, XML, PowerShell, VB.NET, ASP.NET

BI Tools: SSIS, SSAS, SSRS, Power BI

Operating Systems: Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional, Linux

Version Control: TFS/GIT/SVN

Languages: T-SQL, PL/SQL, C/C++, HTML, XML, VBScript, C#.Net, VB.Net, ASP.Net, ADO.Net, ActiveX, XML, MS Access, HTML,, Shell Scripting.

Tools: SQL Server Enterprise Manager, Management Studio.

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

Sr. SQL Developer

Responsibilities:

• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Migrated data between heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Prepared technical specifications for the development of SSIS (ETL) packages to load data into various target tables and defining ETL standards
• Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services (SSAS).
• Created Time Dimensions on OLAP Cubes using SSAS.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2008 r2.
• Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.
• Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Worked with Logical and physical models in Erwin
• Expertise in forward and reverse engineering using Erwin.

Environment: T-SQL, MS SQL Server Analysis Services 2008 (SSAS), MS SQL Server Integration Services 2008(SSIS), MS SQL Server Reporting Services 2008(SSRS), MS Excel, Erwin.

Confidential, Sterling, VA

Sr. BI ETL Developer

Responsibilities:

• Gathering business requirements from business team; providing technical specifications for customizations/implementations using Microsoft SQL Server Management Studio and Microsoft SQL Server Data tools.
• Writing complex SQL statements using joins, subqueries and correlated sub queries and Following Normalization and De-Normalization process while creating the tables to make quick Write and Read.
• Singlehandedly produced a Full-Functionality POC (proof-of-concept) solution on an Oracle Database to MSBI conversion project in 8 weeks which involved producing a complex financial/budgeting 2014 SSAS prototype cube to demonstrate effective replacement of a portion of existing SSRS reporting for a large Financial Organization.
• Created Data Modeling, Multi-Dimensional Modeling & created Star Schema and Snowflake dimensional schema using Erwin tool.
• Created parameter driven reports in Access and Excel running thru Access VBA front-end.
• Designed and developed an execution ETL framework using SQL Server that process all the loans into DWH and from DWH to Downstream applications using SQL Agent. Designed to run either in batch mode or sequentially and load the batch statistics into SQL Server tables.
• Designing and developed SSIS (ETL) packages to validate, extract, transform and load data from Cassiopae to LOP Data warehouse and then from LOP Data warehouse to downstream applications like EIS, LAPRO, REPO using SSIS.
• Worked with Data Analysts in completing the ICD (Interface Control Document) by converting the Business rules into Extract and transformation rules and Load into downstream applications using SSIS.
• Creating SSIS packages to pull the data feeds from linked servers (Oracle/ Sybase) and load data into Sybase servers
• Configuring SSIS Error handling process for all the packages using Task Factory.
• Develop, maintain and support all Fiscal Department MS Access Applications
• Monitoring and maintenance of development/QA/Production databases of SQL, Sybase ASE and RSA, Oracle, and MYSQL.
• Worked with the Budget Reporting Group users to enhance and advance the usability of the SSAS cube from POC stage phase to full Production phase which involved directly collecting requirements in real-time, coming up with solutions/ways of implementing these features within the context of cube drill-through, actions, MDX calculation items or reporting features residing on the SSRS reports; or figuring other ways of satisfying the client reporting need and presenting it to the client.
• Involving in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
• Developed SQL queries using stored procedures, Common Table Expressions (CTE’s), temporary table to support Power BI and SSRS reports.
• Set up Advanced functions, dashboard, Drill-Trough/Drill-Down, KPI/Indicators, linked reports, sub reports, Matrix Reports & Chart reports using Microsoft SQL Server 2014 Reporting Services (SSRS) and publish them to users in online thru Report Server and SharePoint server. Creating different professional reports, utilizing Dynamic & Cascading Prompts, sub-reports, charts, dynamic parameterized and conditional reports.
• Developed custom reports and deployed them on server using Power BI.
• Working with Azure SQL Databases for Excel and Power BI Reporting Tools.
• Developed OLAP Cubes using SQL Server Analysis Services (SSAS) and Created MDX queries, processed facts, dimensions and populating data through SSAS into SSRS Reports.
• Created data sources, data source views, Measures, Dimensions, Attributes, Hierarchies, and Calculations using SSAS multi-dimensional expression (MDX).
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard to improve the performance and implement the best practices. Troubleshooting performance issues, fine-tuning queries & stored procedures.
• Used TFS-Team Foundation Server for Version Controlling.
• Schedule Jobs daily/weekly/monthly using SQL Agent /Control-M to call the packages, Stored Procedures, Reports and Cubes and configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
• Implementing agile project methodology to provide estimations for each Sprint, and present status, highlight and discuss if any road blocks in Scrum meetings.

Environment: MS SQL Server-2016/2014 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, TFS-Team Foundation Server Version Manager, Power BI, Azure, ER-Studio, Task Factory, SQL Agent, Razor SQL, Office-2013, MS Excel, MS Access, SharePoint, Power-Pivot, .Net (C#, VB)

Confidential, Richmond, Virginia

MSBI SQL Server Developer

Responsibilities:

• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Extensively involved in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Extensively used T-SQL statements and created multidimensional cubes for the analyzer and used pivot table to help the end-user get familiar with cube.
• Incorporated the SSIS Packages into MS SQL Server 2014 Integration Services by using Package Migration Wizard and Execute SSIS 2014 Package task.
• Designed and developed high level architecture for overall data transfer from the Oracle source to MS SQL Server with the help of SSIS using Script Task and C#.
• Generated Ad-hoc reports in Excel Power Pivot using Power BI for strategic planning.
• Ability to select correct tier for Azure SQL Databases and Azure SQL Date warehouses.
• Scheduled and monitored all maintenance activities of SQL Server 2014 including database consistency checks and index defragmentation.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Extensively involved in migration of data from different servers.
• Monitored performance and optimized SQL queries for maximum efficiency using SQL Profiler.
• Involved in gathering and analyzing business requirements for reporting purpose.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Created dashboard pages that use Excel Web Access Web parts and Reporting service Web parts.

Environment: MS SQL Server 2014, SSIS, SSRS, SSAS, Windows Server 2012, MS Office, Visio, Power BI, SharePoint Server 2010, Visual SourceSafe, ASP.Net, C#.

Confidential, Kansas City, MO

MS SQL Server Developer

Responsibilities:

• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Worked on analyzing the existing reports in Report.Net, Actuate and their data sources
• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created mapping tables to find out the missing attributes for the ETL process.
• 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, Column Mapping, Data dictionary and Metadata.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Extensively worked on OLAP cubes using SSAS.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Created queries for Drilldown reports to get the complete details of the sales sold region.
• Parameterized and Cascading Parameterized reports were designed and analyzed using SSRS.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Generated various reports by comparing the growth of sales based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of sales with respect to customers.
• Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services (SSAS).
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Used Visual Source safe for repository and maintaining versions.
• Extensively used formula fields, parameter fields, Running Total, Group selection and record selection in Crystal reports for writing new formulas.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Environment: SQL Server 2012/2008 Enterprise Edition, Analysis Services (SSAS), OLAP, Reporting Services (SSRS), Integration Services (SSIS), Microsoft Performance Point Server 2007, Microsoft Share Point Server, T-SQL, NET, C# MS Access and Excel.