PROFESSIONAL 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 ( Confidential ) and SQL Server Reporting Services
• (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in MS SQL Server, Microsoft Azure SQL and Confidential (Integration Service) package design, constructing, and deployment.
• Designed, developed and implemented Confidential Dashboards, Scorecards & performance
• Reports. Expertise in Confidential, Confidential Pro, Confidential Mobile.
• Provided strategic and tactical contribution to ensure full project life cycle designdevelopment and implementation of database solutions.
• Used Confidential 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 ProceduresDDL/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 barClustered 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 Confidential and set up incremental refresh of reports containing large volume of data.
• Performed subscriptions and refresh extracts in Confidential as well as set up data alerts on business-critical data utilizing Confidential services.
• Set up Confidential 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:

Microsoft Certified Professional, Microsoft Specialist

SQL Server Tools: SQL Server Management Studio 2017, PGAdmin III, SQL Data Tools 2015Visual Studio. Report Builder

ETL & Reporting Tools: Confidential, Microsoft Confidential, SSRS, Tableau

Databases: SQL Server 2012/2017, Oracle, PostgreSQL

Tools: Microsoft SSMS, SSRS, Confidential, 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

WORK EXPERIENCE:

Confidential Developer

Confidential, NJ

Responsibilities:

• 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 Confidential Gateway Server.
• Set up Premium Capacity of Confidential .
• 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

Data Warehouse and BI Report Developer, Southfield, MI

Responsibilities:

• 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 Confidential visuals and conditional formatting of tables.
• Created many calculated columns and measures in Confidential 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 Confidential 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 Confidential gateway on the data server to enable data refresh of the reports on Confidential Service.

Data Warehouse and BI Report Developer

Confidential, OH

Responsibilities:

• Develop data architecture and data modeling within structured data warehouse
• 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 Confidential jobs to import data from two BI staging tables on different servers to the warehouse.
• Designed Confidential 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. These reports proved very helpful in targeting unchartered territories.
• Monitored report and dashboard update schedules.
• Also monitored Confidential 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

Student in Information Science

Responsibilities:

• Built, Maintained & scheduled various reports in Confidential .
• 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 Confidential app.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in Confidential service.
• Wrote calculated columns, measures queries in Confidential desktop to show good data analysis techniques.
• Created Roles and implemented row level security for user authentication in Confidential .
• Worked on all types of transformations that are available in Confidential query editor.
• Designed, built and deployed ETL/ Confidential 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 Confidential /DTS packages.
• Experience designing and building complete ETL/ Confidential processes moving and transforming data for ODS, Staging, and Data Warehousing.

Confidential

BI Analyst

Responsibilities:

• 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

Responsibilities:

• 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.