SUMMARY

• Over 8 years of experience in Database Design, Developing BI applications utilizing SQL server, BI Stack Power BI, Integration Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Experience in Development and maintenance of database applications on MS SQL Server OLTP/OLAP, BI stack and (SSIS/SSRS/SSAS) environment.
• Experience with Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Experience with Power Pivot and Dashboard Designer.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Utilized Power BI to create various analytical dashboards that shows critical KPIs such as billing hours along with slicers and dicers enabling end - users to make filters.
• Implemented Power BI gateway different source to matching analysis criteria and further modeling for Power BI pivot and power view.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS, SSAS, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Experience with SSIS performance tuning using counters, error handling, event handler, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated Transformations to be used in SSIS packages.
• Experience in designing Dynamic SSIS Packages using variables, expressions, containers.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using SSIS Packages.
• Experienced in writing expressions and fine-tuning reports. Created many Drills through, Sub, Parameterized and Drill Down reports using SSRS.
• Extensively worked in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in ETL, OLAP, BI Reports and Dashboards, Power BI, Power Query, Power View, Power Pivot. (Microsoft BI Stack).
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Experience in creating executive level Dashboards, Charts using SSRS, Power pivot and Excel.
• Experience in performing a Bulk Loads into SQL Server and Incremental updates with SSIS.
• Expert in Looping through All Files in a Folder and Loading into SQL Server and other databases.
• Leveraged Azure SQL Data Factory to load Azure SQL Data Warehouses for analytics and reporting.
• Experience in writing stored procedures, Indexes, Views and user defined functions.
• Experience with Fragmentation and Query analyzer for SQL Server and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
• Expert in creating Data Source Views (DSV), Dimensions, Hierarchies, Partitions.
• Expert in creating calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Experience in Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, FACT and Dimensional tables.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases.

TECHNICAL SKILLS

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

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

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), SQL Server Integration Services (SSIS).

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

Data Modeling Tools: Erwin, Microsoft Visio

Operating Systems: Windows 98/XP/NT/ 2000/2003/2008/10 , UNIX, LINUX, Mac OS

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

Sr. SQL/SSIS Developer

Responsibilities:

• Design and develop ETL process to integrate data among business systems and Data warehouses in Oracle and MS SQL Server.
• Develop physical data models using ERWIN and created DDL scripts for database schema and objects.
• Maintain and develop system integrations among enterprise front and back end applications (ERP, CRM, EDI, Demand Planning, Manufacturing Control Systems)
• Modify SSAS cubes in order to resolve production issues or as per requirements by the business.
• Extracted data from data sources Oracle, CSV files, text files, SQL-Server and applied required transformations to clean the data.
• Work directly with the business users in order to gather requirements and understand their usage of the data in depth.
• Work with VB script in SSIS packages in order to ensure the data flow according to the business requirements.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and T-SQL code.
• Check daily jobs and verify databases in order to ensure the correct flow of data from different systems like IFS (Industrial and Financial Systems) which is a Oracle Financial ERP system for Silgan, WMS (Warehouse Management system), Pivotal system which holds retail and distributor data.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Design, code and test and trouble shoot business reporting for end users in Business objects Crystal Reports, SSRS and Tableau.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Developed Flowcharts with Visio/VBA/Excel/SQL, which was used in storing Flowchart elements.

Environment: SQL Server 2016, SQL Server 2012, DTS, SQL Server Business Intelligence Development Studio 2008R2, Microsoft Visual Studio 2008, MS Excel, MS Access, Windows Server 2008, Crystal Reports 10.0, Tableau, Oracle 10g, Power BI.

Confidential, Dayton, OH

Sr. SQL Developer

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of tables for efficient Report Design.
• Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data to the database.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012/2014.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Deployed SSIS packages and Reports to Production Servers.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Experience in developing reports using SSRS 2014 and SSRS 2012.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
• Created cubes, dimensions and measures and calculated measures as per business requirements.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions using the SSIS tasks.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2012/2014.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created complex SQL stored procedures using Microsoft SQL Server 2012/2014.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Build database queries and test cases for the testing team to test the reports.

Environment: SQL Server 2014/2012/2008 , Business Intelligence Studio (SSAS, SSIS, SSRS), T-SQL, Erwin, MDX, Oracle 10g, MS Excel.