SUMMARY

• Over 4+ years of experience in the field of information technology with expertise in Database Design, Development, Implementation and Support of MS SQL Server 2016/2014/2012/2008 R2/2008 and over 4+ years of experience in suite products like SSIS, SSRS, and SSAS.
• Extensive Experience in creating, configuring and Fine - tuning ETL workflows designed between Homogeneous and Heterogeneous Systems using DTS and SSIS of MS SQL.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS, SSAS) including MS solutions like MS EXCEL 2007/2010, 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.
• Skilled in creating virtualization reports using Power BI.
• Extensive experience with data modeling, logical and physical database design using Erwin.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2012/2014/2016.
• Creating and deploying parameterized reports using Power BI
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL Used various SSIS components like Conditional split, derived column, multicast, OLEDB sources, OLEDB destinations, control flow components, data flow components, Aggregates, Execute SQL
• In depth understanding of SQL Server Migrations and problem management.
• On-call duty with teammates 1-2 weeks per month and active involvement in Go-live activities.

TECHNICAL SKILLS

Languages: Transact SQL, PL/SQL, XML, C, Visual Basic 6.0, Java, Java Script, HTML.

Databases: SQL Server 2017/2016/2014/2012/2008/2008 R2/2005/2000R2, MS Access, Oracle 9i, Oracle 10g, 11g, MySQL, DB2

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Tableau 9.0/9.7

ETL Tools: DTS, SSIS, Data Stage, Informatica, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Crystal Reports 8.5/9/10/11

Data Modeling Tools: Erwin, Microsoft Visio 2000/2003

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server, SQL developer, SQL Profiler, Query Analyzer, SQL Server data tools (SSDT).

PROFESSIONAL EXPERIENCE

Confidential, Virginia beach, VA

SQL /BI Developer

Responsibilities:

• Developed various T-SQLstored procedures, triggers, views, and adding/changing tables and Table valued Functions for data extraction, data load and transformations.
• Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab-delimited and pipe-delimited.
• Worked on several State Reports and used SSIS to create multiple destination files from single/multiple sources.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2012.
• Exposure to Power BI concepts for creating visualized reports and publishing it within the team.
• Prepare the detailed level ETL mapping specification documents describing the algorithms and flowchart and mentioning the source systems, change data capture logic, transformation logic involved in each field, the lookup tables, lookup logic used and the target systems per each individual mapping involved with the Data marts.
• Also, document the important SSIS session properties that should be used for executing SSIS Packages from Teradata in to the SSIS Database.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Develop physical data models using ERWIN and created DDL scripts for database schema and objects.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc. and scheduled SSIS packages.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data so0urces using SSIS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Tested Power bi reports and verified the data with the source database data and checked the accuracy of data.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data intopowerpivot model.
• Imported Data from various sources such as SQL Server, SQL DB, SQL Server Analysis services, Excel etc. Worked on data modelling in Power BI.
• Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for cleaning and massing.
• Utilized Power BI Gateway to keep the dashboards and reports up to date.
• Developed complex DAX Queries to generate computed columns.
• Developed and published reports and dashboards using Power BI.
• Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services.
• Weekly presentation to the business users about the reports and their changes as required.
• Created Subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.

Environment: MS SQL Server 2014, Micro Soft Visual Studio, SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), Microsoft Office Share Point Server, XML, Oracle, ASP.Net and C#.

Confidential, Orlando, FL

SQL/ BI Developer

Responsibilities:

• The project is designed in two phase's data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
• Created differentPower BI reportsutilizing the desktop and the online service and schedule refresh.
• Developed Tabular Reports, Matrix Reports parameterized Reports Sub reports, Snapshot and Adhoc reports (SSRS).
• Developed physical data models using ERWIN/ ER Studio and created DDL scripts for database schema and objects.
• Experience inscheduling refresh of Power BI reports, hourly and on-demand.
• Worked on Installation and Maintenance of SQL Server 2014/2012 on Test, Development and for Production Environments worked closely with Admin teams.
• Stored Procedures, User Defined Functions, Views, TSQL for complex business logic.
• Design and implementation of SSIS/ETL process for the system. .
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Validated change requests and made appropriate recommendations, standardized the implementation of data.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Used c#.net asp web pages to show the deployed reports as required by the user
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Experienced in developingPower BIreports and dashboards from multiple data sources using data blending.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Uses of power pivot, red gate tools for different purposes. Use of source control product such as Team foundation server.
• Modified stored procedures to meet current design and used them in SQL Server.
• Maintain security, assign logins, permissions and desk support for problems related to Active Directory.

Environment: T-SQL, PL/SQL, MS Sql Server 2012/2008R2, SSAS 2012/2008, SSAS 2012/2008, SSIS 2012/2008, Power Pivot, Erwin r4, Oracle 9i, DB2, Visual Source Safe (VSS), Tableau, Windows XP, VB script.

Confidential

SQL/ETL Developer

Responsibilities:

• Composed user requirement documents, created technical specs and design documents for various projects.
• Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.
• Programming in SQL server using stored procedures, triggers, views, user-defined functions
• Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
• Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
• Used event handlers for event handling which includes on pre- execute, post execute and error.
• Involved in package logging in both standards (SQL server and file based) and custom logging using customer stored procedure and tables.
• Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using detect utility, command prompt with .bat files etc.
• Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
• Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
• Created ad-hoc reports more often based on end user requirements.
• Generated and formatted reports using global variables, expressions and functions.
• Involved in developing parameterized reports using single values, multi values and cascading parameters.
• Built effective queries for high performance reporting and rendered them to html, xml, pdf, MS word and excel formats using SSRS (2005/2008).

Environment: T-SQL, PL/SQL, MS Sql Server 2012/2008R2, SSAS 2012/2008, SSAS 2012/2008, SSIS 2012/2008, Power Pivot, Erwin r4, Oracle 9i, DB2, Visual Source Safe (VSS),, Windows XP, VB script.