SUMMARY

• Software professional with 7+ years of experience as Data Analyst developing & deploying OLTP, OLAP applications utilizing Microsoft Suite of products in DEV, UAT & PROD environments.
• Developing complex SQLs, Physical, logical database design and Performance tuning.
• Creating and developing BI Dashboards with rich look and Row level security, Drill through, Increase and decrease analysis and hierarchies.
• Database migration, source connectivity, extract/import/transform data, data cleansing, append/execute queries, parsing parameter and Invoking custom functions.
• High Level Design to integrate data using OLE DB connection from heterogeneous sources
• Developing various types of reports such as drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Excellent in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources
• Experience in configuration and maintenance of Report Manager & Report Server and Scheduling the Reports in Report Manager.
• Experienced in full life cycle ETL development using SSIS. Creating many complex SSIS packages using SQL Server Integration Services 2015/2012/2008 R2 as part of the automating the process.
• Experience in installing, configuring, managing and troubleshooting SQL Server 2016/2012/2008 R2.
• Experience in Ad - hoc reports, data driven subscription reports
• Experience in Agile and Scrum Methodologies.
• Excellent communication, presentation and interpersonal skills.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Experience in Data Warehouse design, Dimensional Modeling, ETL Design.

TECHNICAL SKILLS

• Desktop (July 2018, Feb 2019), Pro, Mobile, Dashboards, Report Server, Report Builder, Report Services, DAX functions.
• MSBI SQL Server Analysis Services (SSAS)
• MSBI SQL Server Reporting Services (SSRS)
• QlikView 12 / 11 / 10
• Tableau
• MSBI SQL Server Integration Services (SSIS), DTS
• SQL Server 2016/2014/2008/2005 ,
• Oracle 11g/10g, DB2, MS Access, Excel,
• Flat File / CSV, MS Office 365 SharePoint
• SQL, PL/SQL, T-SQL, HTML, DAX, M code
• Erwin, Visio 2000
• Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers
• Agile, Scrum
• Star Schema, Snowflake schema, Facts and Dimensions tables

PROFESSIONAL EXPERIENCE

Confidential, Maumee, OH

MSBI/ Power BI Developer

Responsibilities:

• Analyzing & Migration of QlikView Dashboards/Reports to Power BI
• Creation of Power BI reports, visualizations, tabular cubes, data models and publishing them
• Creation of geographical visualizations with slicing and dicing across different locations.
• Developing custom calculated measures to satisfy business needs with complex data models (n-n)
• Creating complex dashboards by pinning many visualizations in the workspace as per the insights provided.
• Creating dashboard KPI's using Direct Query & custom attributes with slicers and other filters
• Creating data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Creating complex Custom Views to create data sets to be used by dashboards
• Generating Drill down, Drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group & filter.
• Developing ETL packages in SSIS to pull data from diverse sources such as Excel, SQL server, flat files, Oracle DB for the daily load and maintain a centralized data warehouse
• Generating customer reports using SQL Server Reporting Services 2012/2015/2017 from the OLTP data sources
• Generating periodic reports based on the statistical analysis of the data
• Creating the KPI to show the difference between actual, plan and forecast data using visuals
• Creating User Roles & Groups and provide row level security to them
• Creating KPI, Gauges, Clustered column chart, Slicers for better understanding of the report
• Testing/Validation of reports for data quality, transparency, consistency, and accuracy
• Publishing reports, visualizations and dashboards.

Environment: Power BI Desktop, Power BI Service/Office 365, Power BI Report Server, Power BI Global Gate way, DAX SSIS / SSRS / SSAS 2014, SQL Server 2014, Oracle 12, SQL Server Management Studio 2014, Office 365 SharePoint, Windows 10, QlikView

Confidential, Southfield, MI

MSBI/Power BI Developer

Responsibilities:

• Analyzing data requirements to support the business processes within the scope
• Creating required Data Models in coordination with Data Architects to accomplish Various Report requirements of the Business
• Working with data models with complex relationships and connecting to different data sources
• Creating data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Creating complex Calculated Columns / Measures / Tables, bookmarks, alerts & visuals out of the data available in source tables to have best performance.
• Developing several reports with multi-level drill downs and used several Charts to represent the data in the reports using SQL Server 2008 Reporting Services (SSRS).
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Tuning the reporting application for performance & stability by adhering to business rules/requirements.
• Deploying and scheduling Reports to generate daily, weekly, monthly and quarterly Reports including snapshots
• Working with gateways to schedule the report and data
• Publishing reports and visualizations and thereby developing dashboards.

Environment: Power BI Desktop, Power BI Service, Power BI Report Server, Power BI Global Gate way, DAX SSIS / SSRS / SSAS SQL Server 2016, SQL Server Data tools 2016 TFS, Microsoft Visual Studio 2016, Windows 10

Confidential

Sr. QlikView Developer/ Test Analyst

Responsibilities:

• Analyzing the reporting requirements with the business users and developing the technical specifications.
• Implementing Data Extract, Transform and Data model & Application.
• Extracting data from the data sources and Transforming the data
• Developing User Interfaces in Application layer (layout all Charts, Tables and List Boxes)
• Implementation of the Incremental Load. Resolving synthetic keys using various techniques such as aliasing, join, concatenation, dropping fields, etc.
• Using set analysis to calculate/aggregate the fact data as per the requirements.
• Developing Dashboards using Charts (Straight table, pivot table, Line, combo Chart etc.), List Boxes, Multi Box, Input Field, Table Box, Statistics Box etc.
• Developing Dashboards with detail drilldowns, threshold gauges and alerting mechanisms.
• Creating customized charts with stacked bar and line.
• Attending Scrum meetings during planning, development, testing & implementation phases.
• Implementing access controls for row, object, column and sheet level security.
• Automation of QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point in Development Environment.
• Developing various types of Dashboards/Applications - Outbound, Inbound, On-time, Part Analysis, Cost Management and KPI’s
• Developing Test Plans/Cases, error handling processes
• Performing Debugging, Troubleshooting, Performance tuning, Maintenance & Upgrades
• Performing Unit, Regression, System & Integration testing.
• Developing Key Performance Indicators based on business requirements.

Environment: QlikView 12.x, 3-Tier Architecture, QMC, QVD, Set analysis HADOOP/HAWQWindows Servers, MS Office 2010, TOADInformatica 8.1

Confidential, Maumee, OH

QlikView Developer/Test Analyst

Responsibilities:

• Requirement gathering, documentation & review with Business
• Developing user interactive dashboards by extracting data from multiple sources according to business requirements.
• Extracting data from various sources (such as DB, Excel, CSV), storing into QVD files, writing complex ETL scripts to process them
• Developing QVD scripts to load historical and current data using Incremental logic.
• Building hourly and daily reports for mobile (iPhone compatible) and desktop application.
• Developing ETL Scripts while loading the data, resolving loops & ambiguity joins.
• Using Section access and Sheet access to make the application available to desired users.
• Creating Input boxes, Pivot Tables, Straight Tables, Bar Charts, Buttons, Multi boxes on the UI to make it more accessible to User community.
• Using SET Analysis and Aggregate functions to look back 30 days or 60 days and get the required information.
• Creating different kind of tables (Pivot, Straight) to display overall quarter/year level OTD performance.
• Testing Applications, reports using review checklists, data quality and Performance tuning the reports
• Providing weekly, monthly & ad hoc web analytics reports.
• Auditing the critical Google analytics tags to enhance the accuracy of the data collected.
• Automation QlikView jobs in QlikView Publisher and rolled out to QlikView Access Point in Development Environment.

Environment: QlikView 11, QVD, Set Analysis, Oracle 12, SQL Server 2008, Flat files / CSV, Excel, MS AccessMicrosoft Windows XP Professional, 2007

Confidential, Chicago

SQL Server Developer

Responsibilities:

• Extracting the data from various data sources such as databases, Excel documents and CSV files,
• Transforming, Cleansing and load the data into target tables for analyzing and creating reports.
• Creation of SSIS Packages to load Data from Existing Data Model to new Data Model and Data Warehouse.
• Designing complex packages for moving data from various sources and environments using SSIS
• Enhancing SSIS Packages for performance tuning and parallelism. Scheduling the SSIS packages using SQL Agent in SSMS that involves nightly maintenance.
• Working with various transformations like Lookup, Fuzz Lookup, Merge, Sort, Multicast, Conditional Split, Script Component, Loop Containers.
• Designing dynamic reports on the newly developed ERM Model for financial data users using SSRS.
• Involved in Performance tuning of SQL Server Queries used in SSRS Report and used Report Snapshots
• Creation of user groups in Report Manager for limited access to the end users in SSRS.
• Working with Data Quality team and Data Architects to identify bugs in the new Data Models
• Automation of Data Quality process that involved lot of T-SQL programming like Functions, User Defined Functions, Stored Procedures and Views.

Environment: SSIS, SSRS, MS-SQL, BIDS XML, OLAP, Cubes, XML, Flat Files, CSV Files, MS SQL Server 2008/2005

Confidential

SQL Server Developer

Responsibilities:

• Analyzing business requirements, build logical & physical data models using Erwin.
• Designing DTS Packages to transfer data between servers, load data into database, and schedule the jobs to do these tasks periodically.
• Developing ETL SSIS jobs for extracting, cleansing, transforming and loading data into data warehouse.
• Preparing the data mapping for all the migrated jobs
• Performance tuning of ETL transformations, data validations and stored procedures.
• Performing data cleansing by creating tables to eliminate the dirty data using SSIS.
• Designing, developing and deploying reports in MS SQL Server environment using SSRS
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .net.
• Filtering inaccurate data from legacy system using complex T-SQL statements, constraints and triggers for data consistency.
• Designing reports in multiple formats such as Excel, PDF, XML, HTML, .doc and CSV using SQL Server Reporting Services (SSRS).
• Using MS Access for smaller databases to create the tables and generate the reports.
• Scheduling SQL Server Agent Jobs to run every day to update changes in the base tables.

Environment: SSIS, SSRS, BIDS Erwin, .Net Framework, ER Studio, C#, ASP.Net XML, MS Access, Excel, SQL Server