SUMMARY

• Over 11+ years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of various software applications to support ETL, Reporting and Analysis of data using Business Intelligence initiatives.
• Exceptional hands - on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) for 2017, 2014, 2012, 2008 R2, 2005.
• Proficient in Oracle Business Intelligence Enterprise Edition (OBIEE) and hands on experience in migrating on premise reporting tool to Cloud managed reporting tool.
• Possess solid understanding of logical and physical data modeling techniques for both relational and dimensional models.
• Proficient in database modelling for OLTP, Data Marts, Operational Data Store (ODS) and OLAP.
• Involved in Designing and Building of OLAP dimensions and cubes using SSAS.
• Familiarity with Star and Snowflake schema data modelling techniques for OLAP database design.
• Hands on expertise with ETL process using DTS/SSIS to load and process high volumes of data for front-end, web and reporting applications.
• Proficient in migrating of earlier versions of SQL Servers to latest versions and experienced in migrating Version controls.
• Strong T-SQL and PL/SQL skills to define queries for generating drill down reports, handling parameterized reports and to create stylish report layouts in SSRS 2005/2008/2012/2014/2017.
• Experience in gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Have sound knowledge on DAX and worked on complex data analytical calculations and data modeling in Power BI and Dynamic Security in DAX (SSAS Tabular / Power BI)
• Developed various solution driven views and dashboards by developing different chart types including Pie charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI and Tableau.
• Having sound knowledge on Data Factory and created many data flows and pipelines to ingress/egress in Azure Data lakes / Azure SQL Datawarehouse.
• Have hands on experience and proven track record of expertise with performance tuning.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Security, User management and Performance Tuning.
• Expertise in monitoring patches, permissions, and service deployments in Cloud environment.
• Expertise in Setting cloud system security strategies, policies, and procedures.
• Ability to lead the team of junior developers and desires to show initiative in solving problems and can work both independently and in team environments.
• Has the ability to prioritize and adapt quickly to workload changes.

TECHNICAL SKILLS

Languages and Software: MS SQL Server 2017/2014/2012/2008 R2/2008/2005, Oracle 10g/11g/12c/18c, OBIEE, SSRS, SSIS, DTS, Informatica, SQL, PL/SQL, C/C++, HPQC, Crystal Reports, Agile/Scrum, Jira Project Management, Maestro Scheduler, Team Foundation Server (TFS), Power BI, Microsoft Azure, Oracle cloud Infrastructure(OCI), Oracle Analytics Cloud (OAC) - BI/ DV,SSAS, Essbase cubes, Snowflake, Azure Data Factory (ADF), Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton CA

Senior BI Developer/ Cloud Admin

Responsibilities:

• Extensively works on SSRS Reports, Power BI and Tableau Dashboards and delivers complex reports/dashboards from different data sources such as SQL/Oracle Data bases, SSAS/Essbase cubes and Snowflake data warehouse.
• Generated insights, trends and actionable recommendations, leading to implementation of initiatives and projects, create presentations and share effectively data and insights to key stakeholders.
• Creates and Modifies SP's and formulated basic coding and scripting to be utilized for reports within the organization.
• Analyzes data models, data relationships, and dependencies for greatest optimization.
• Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file, SQL, and Oracle databases.
• Building the pipelines to copy the data from source to destination in Azure Data Factory (ADF V1).
• Worked on creating dependencies of activities in Azure Data Factory.
• Developed various solution driven views and dashboards by developing different chart types including Pie charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Have sound knowledge on DAX and worked on complex data analytical calculations and data modeling in Power BI and Dynamic Security in DAX (SSAS Tabular / Power BI).
• Proficient in writing DAX formulas and expressions.
• Collaborates with end users and other IT resources to determine appropriate means of meeting business requirements
• Leverages webinars, on-line tutorials, and user forums to continually enhance knowledge of current tools, technologies, and best practices. Evaluates and implements innovative usage of cutting-edge technology.
• Provides guidance and mentoring to junior team members.

Environment: MS SQL Server 2017, SSRS, SSIS, SSAS, Essbase, OCI, OAC, Snowflake, Jira, Service Now, Power BI, Agile, Tableau, Azure Data Factory (ADF), Azure

Confidential, Beloit, WI

Sr. BI Developer/DBA

Responsibilities:

• Owned and driven the technical design, development, and on-going support of Enterprise Data Warehouse and associated ETL processes.
• Analyzes, tune, and optimize ETL packages, Stored Procedures & SQL scripts to ensure peak performance.
• Generated periodic reports based on the statistical analysis of the data from various time frame using SQL Server Reporting Services (SSRS) and Tableau.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2012 that maintained data. Actively supported business users for change requests.
• Serving as the team’s Application DBA as required to support database deployments and performance tuning.
• Set up maintenance tasks such as database backups, consistency checks and Database optimizations (by using scripts).
• Design and implement backup and restore strategy and recovery disaster Planning.
• Monitor, analyze and identify disk I/O, memory, and processors bottlenecks.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Data blending implemented on databases and generated interactive dashboards in Tableau.
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, SharePoint, Business Intelligence Development Studio (BIDS), MS Excel 2013/2010, Power Pivot, Agile/Scrum, Team Foundation Server (TFS), Tableau, Master Data Management (MDM), Master Data Services

Confidential, Charlotte, NC

Sr. BI Developer

Responsibilities:

• Actively participated in gathering Business requirements to implement functional and technical specifications.
• Involved in cube requirements and built cube from scratch and played critical role in deciding on attributes, measures, and hierarchies for the cubes
• Trained End users to browse cube data using Microsoft Excel 2013/2010 and Power Pivot.
• Created drill down, drill through, sub and linked reports using SSRS as well as managed the subscription of the reports
• Created dashboards using benchmarked data to provide an analytical snapshot of point in time data.
• Converted Cognos Reports to SSRS Reports based on users’ requirements
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded into the audit table.
• Provided back-end support for functional tuning and performance testing.

Environment: MS SQL Server 2012/2008R2/2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel 2013/2010, Power Pivot, Cognos, Star Team, HPQC

Confidential, Atlanta, GA

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required.
• Developed SSRS Reports with Oracle as Data Source using PL SQL as back-end code.
• Identified and Defined Fact relationships in SSAS.
• Upgraded more than 40 packages from and SQL Server.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored, and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Optimized stored procedures and indexed query using Index Tuning Wizard.

Environment: MS SQL Server 2012/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.