SUMMARY:

• Senior BI developer with experience in design and development of database, data integration and reporting applications across multiple domains.
• Proven qualifications in data modeling, analyzing requirements, planning, designing and implementing innovative database solutions that meet or exceed challenging business needs.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in MS SQL Server, Microsoft Azure SQL and SSIS (Integration Service) package design, constructing, and deployment.
• Designed, developed and implemented Power BI Dashboards, Scorecards & performance Reports.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Provided strategic and tactical contribution to ensure full project life cycle design, development and implementation of database solutions.
• Used SSIS Control flow tasks such as Execute SQL Task, For Each loop task, FTP Task, File system task. Used Data flow task, OLE Db connection, Derived Column task, Conditional split and Row count Transformation.
• In - depth knowledge of T-SQL, PostgreSQL Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Built effective reports/dashboards using visualizations such as Power KPI matrix, Stacked bar, Clustered bar, Donut, Waterfall, Gauge, Tree-map, Pie charts, Heat-maps, Histograms etc along with many custom visuals.
• Good experience in DAX formulas such as summarize group by, Intersect, calculate, filters and SUMX, MAXX, Hasonevalue, Hasonefilter and switch etc.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
• Extensive knowledge of DAX code to support the business requirements in column and measure variables.
• Worked as a Premium Capacity admin of Power BI and set up incremental refresh of reports containing large volume of data.
• Performed subscriptions and refresh extracts in Power BI as well as set up data alerts on business-critical data utilizing Power BI services.
• Set up Power BI Gateway Services for refreshing report from on premise databases.
• Added Row Level Security in PowerBI reports.
• Experience with Azure SQL Server, Azure Data Factory, BLOB storage.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
• Good verbal and written communication skills, analytical skill and competent team player.

TECHNICAL SKILLS:

SQL Server Tools:: SQL Server Management Studio 2017, PGAdmin III, SQL Data

Tools: 2015, Visual Studio. Report Builder

ETL & Reporting Tools: SSIS, Microsoft Power BI, SSRS, Tableau

Databases: SQL Server 2012/2017, Oracle, PostgreSQL

Tools: Microsoft SSMS, SSRS, SSIS, SSAS, MS Visual Studio, MS Office suite, SPSS, Dia, SQL Developer, Minitab, Visual Paradigm

Languages: T-SQL, HTML, PL/SQL, Java, C++

Operating System: Windows, MacOS

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Power BI Developer

• Confidential is an online Healthcare Portal who empowers everyone to shop for their health care.
• Confidential leads the market with a digital health platform powered by predictive analyticsengagement and incentive designs that drive new levels of engagement. The company creates measurable and sustainable health care savings for consumers, employers and health plans.
• Set up the entire Power BI environment for the company.
• Created the data warehouse on PostgreSQL.
• Installed third party data connectors to get data from PostgreSQL to PowerBI.
• Created various dashboards on Financial as well as Operational data.
• The Operational dashboard along with Daily Performance dashboard and Book of Business dashboard helped the company set up proper campaigns to target new customers.
• Installed Power BI Gateway Server.
• Set up Premium Capacity of Power BI.
• Worked as the capacity admin and handled all the access and permission controls.
• Scheduled automatic refreshes and alerts for the reports.
• Implemented Incremental refresh for the reports.
• Also added Row Level Security for different Sales team.
• Worked on couple of ETL projects to streamline their process of reaching out to customers.

Confidential, Southfield, MI

Data Warehouse and BI Report Developer

• Federal-Mogul serves customers in the automotive aftermarket with maintenance, service, and performance-enhancing products and original equipment manufacturers of cars, trucks, heavy-duty vehicles, commercial vehicles, agricultural, aerospace and other industrial applications with premium products. They provide factory-installed, original equipment products for cars, trucks, commercial vehicles, agricultural, rail and aerospace applications to customers around the world.
• Created and consulted on report user interface. Introduced new features of reporting that would be useful to the business users.
• Created reports based on SAP data from Inventory and Accounts Payable.
• Inventory and Accounts payable views were created by joining numerous facts and dimension tables in SQL database.
• Created drill through reports to get further insights into the data for each of the parameters on which quality was measured.
• Used custom Power BI visuals and conditional formatting of tables.
• Created many calculated columns and measures in Power BI using DAX to better evaluate quality.
• Showed values based on different currencies according to currency selected in slicer using current currency rates.
• Created executive dashboards to visually display the data to the business users.
• Created group workspace on Power BI service to enable business users to create their own reports using existing reports.
• Tested and validated report accuracy with the business users to make sure that warehouse and report data is consistent.
• Regularly monitored reports refresh schedule and fixed any issues that hindered the performance of the reports.
• Installed and monitored Power BI gateway on the data server to enable data refresh of the reports on Power BI Service.
• Implemented incremental refresh for large data sets for efficiency.
• Co-ordinated with Microsoft support to fix issues in Power BI service.

Confidential, Akron, OH

Data Warehouse and BI Report Developer

• Confidential is a business solutions company that provides technology and marketing support to enhance the consumer’s experience and the operational efficiency of a car wash. It is the leading provider of “turnkey” car wash solutions. Its suite includes a complete offering of fully customizable point of sale and tunnel control software. They provide hardware, support and business solutionsincluding human resources, marketing and solution-specific site-improvement planning.
• Facilitate requirements gathering and develop unique simple solutions to meet the immediate and long-term needs of business customers.
• Plan, create, coordinate, and deploy data warehouse.
• Design end user interface.
• Create best practices for data loading and extraction.
• Develop data architecture and data modeling within structured data warehouse environment: .
• Develop reporting applications and data warehouse consistency.
• Develop and implement ETL routines according to the DWH design and architecture.
• Support the development and validation required through the lifecycle of the DWH and
• Business Intelligence systems, maintain user connectivity, and provide adequate security for data warehouse.
• Monitor the DWH and BI systems performance and integrity provide corrective and preventative maintenance as required.
• Schedule SSIS jobs to import data from two BI staging tables on different servers to the warehouse.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Created a composite view to combine data from various tables. This is the master view that has data from all the source tables and it is used for overall reporting purposes.
• Created several other views like Inventory, Accounts Receivable View, BOMView, Orders
• Taken Backlog, SFQuotes Opportunity Clairzen View, Market Penetration View, Cost Of
• Support, Customer Items View, Shoretel Daily Response Time in SQL that consists of some of the data sources for better data visibility and custom report requirements.
• Created financial overview dashboard for executive team at the company for daily updates.
• Created detailed dashboard for customer service support group.
• Created several reports for inventory monitoring to keep track of top vendors, unit produced, production schedules, fill rates, expected receipts, stock status, daily inventory transactions, on-hand inventory usage, inventory aging, total inventory quantity and value.
• Created the following report for sales team - customer open orders, customer orders, parts sales history, customer sales summary Created several KPI reports to keep track of new bookings, new quotes and backlog.
• Created few reports to get insight into market penetration of several products of the company. These reports proved very helpful in targeting unchartered territories.
• Monitored report and dashboard update schedules.
• Also monitored SSIS job schedule for data pull from two different servers.
• Aided users on creating small reports based on existing reports.
• Updated reports with new features as and when they came out to ensure users had the best experience using these reports.

Confidential, Pennsylvania

• Built, Maintained & scheduled various reports in Power BI.
• Created connection to external data sources: web, CSV, excel, SQL Server.
• Drill down, drill through, slicers, hierarchies, sync slicers across pages.
• Built effective reports/dashboards using visualizations such as Power KPI matrix, Stacked barClustered bar, Donut, Waterfall, Gauge, Tree-map, Pie charts, Heat-maps, Histograms etc.
• Optimized employee performance tracking using various KPI’s in internal dashboard and financial dashboards.
• Built dashboards using data from OneDrive and scheduling automatic data refreshes.
• Set Alerts on data changes through email or power BI app.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, measures queries in power bi desktop to show good data analysis techniques.
• Created Roles and implemented row level security for user authentication in POWER BI.
• Worked on all types of transformations that are available in Power bi query editor.
• Designed, built and deployed ETL/SSIS packages with different data sources (SQL ServerFlat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.
• Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing.

Confidential

BI Analyst

• Actively involved in gathering requirements from business, involved in modifying various technical and functional specifications.
• Created Dashboards with interactive views, trends and drill downs.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Analyzing the requirement and building SQL Queries.
• Created Cascading reports in Dashboard.
• Experienced with creation of Users, Groups, Projects, Workbooks and the appropriate permission sets for Tableau Server and security checks.
• Experienced in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Worked with Live and Extract connection.
• Building, publishing customized interactive reports and dashboards, report scheduling using
• Tableau server.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.

Confidential

Database developer

• Understand the customer Requirements and the Technical specification Documents.
• Built data connection to the database using MS SQL Server.
• Experience querying data in T-SQL, writing reports where the data resides in databases including MS SQL Server.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Developed Tableau Dashboards with various chart views for Visualization Solutions.
• Developing data model to create reports and dashboards.
• Created Worksheet by using calculations and aggregations.
• Created Filters, Groups, Sets on Tableau Reports.
• Publishing sheets and dashboards on server Using Tableau Desktop.