SUMMARY:

• Professional MS SQL BI consultant with 6 plus years of extensive IT experience working in MS 2008/R 2/2012/2014/2016 and Azure cloud environment. Hands - on knowledge and expertise in MS BI suite such as (SSIS, SSAS, SSRS, SharePoint and Power BI) with more focus towards reporting layer by using OLAP data architecture within industries such as Flavor, sales, healthcare, insurance, banking and education.

TECHNICAL SKILLS:

Database: MS-SQL Server 2012/2008R2/2008/Azure SQL

T-SQL: Programming, Dynamic SQL, C#.Net

Data Modeling: ER-win, MS Visio

BI Tools: Power BI, Power Pivot, Tableau

Integration Services (SSIS): Analysis Services (SSAS, OLAP Cubes)

Reporting Services: (SSRS, Report Builder)

Development Tools: BIDS, SSDT, SSMS

Source Control: Team Foundation Server (TFS)

SharePoint: 2013/2010, PerformancePoint Services

Microsoft Azure: Cloud Services (PaaS & IaaS)

PowerShell: Azure SQL Database (PaaS)

Azure Storages: (Blobs, Tables, Queues)

Backup/Recovery: Azure Data Factory

Azure Data: Warehouse

SDLC: Agile, Scrum, Waterfall, and Spiral

PROFESSIONAL EXPERIENCE:

Confidential, Geneva, IL

MS SQL Power BI Developer

Technical Environment: SQL Server 2014, SQL Server 2016, Visual Studio 2015, TSQL, SSIS, SSDT, Tableau, MDX, DAX, Power BI, M query, Data migration assistant, Microsoft dynamics AX, Salesforce.

Responsibilities:

• Designed Database workflow and migrated data from multiple servers.
• Developed technical, functional, relational, data dictionary and data mapping documents.
• Utilized TSQL and created many store procedures, user defined functions, triggers, synonyms, linked servers, indexes, User profiles, and entity relationship diagrams.
• Utilized data migrating tool and successfully migrated data from multiple servers
• Optimized database objects such as stored procedures, functions, DDL/DML triggers, indexes by TSQL Scripts and also created work logs.
• Fetched data from Microsoft dynamics AX and created multiple store procedures, Jobs, security and multiple linked server connections
• Utilized Power BI, excel and tableau in creating working models for reports and utilized them for data analysis.
• Created complete custom Pyramid report using Power BI from scratch which is complex and helps in analyzing data up to date on sales and presented it in quarterly reports.
• Created Supply chain, Sales detail dashboard, Departmental reports (RG report, order fulfillment monthly update) from scratch using Power BI Services.
• Maintained and optimized leadership dashboard, order fulfillment dashboard, revenue generation dashboard.
• Wrote DAX, MDX, MQuery, SQLVIZ(tableau) scripts for creating and utilizing the advanced functionalities of tools.
• Created multiple dashboards utilizing pie, donut, bar, Tree map, heat map, hierarchy slicer, slicer, Gauge, Info graphic designer for building visually attractive and user interactive reports.
• Created reports by live connection, direct query from SQL, used Salesforce reports, salesforce manager from power bi services, created multiple live connections with Excel to automatically update the Excel data.
• Generated on-demand user interactive reports with regular refresh rates.
• Created complex calculations in Power BI reports including string manipulation, custom aggregations and ratios, logic statements and quick table calculations, basic arithmetic calculations.
• Published reports and created multiple workspaces utilizing Power BI Services, Microsoft Office 365, Tableau server.
• Created test SSIS Packages, test bed, reports for side by side comparison on challenges for data migration.

Confidential, San Diego, CA

MS SQL Power BI Developer

Technical Environment: SQL Server 2012, Erwin, TSQL, SSIS, SSAS, SSRS, SSDT, SQL Azure, Tableau, TFS, MDX, DAX, Power BI, SharePoint, PerformancePoint Services

Responsibilities:

• Collaborated with team members for designing the database workflow and created multitude of business requirement documents.
• Maintained referential, domain, and column level integrities with constraints, triggers and rules as demanded by business process.
• Utilized T-SQL structures in constructing user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Implemented the master-child package technique to manage large ETL projects efficiently.
• Utilized various SSIS transformations such as merge join, union all, OLEDB command, conditional split to transform data to load into dimensional databases.
• Wrote MDX scripts for KPIs to get trends, status and created calculated members based on the business requirements in SSAS.
• Designed and implemented a variety of SSRS reports such as parameterized, drilldown, ad-hoc, and sub-reports.
• Optimized SSRS reports utilizing stored procedures, caches, execution log views, expressions, and snapshots.
• Scheduled and delivered on-demand reports for business analysis utilizing subscriptions in SSRS.
• Created multiple dashboards with filters and parameters for analyses utilizing power view in power BI.
• Created user interactive dashboards utilizing parameters, actions and various data visualizations utilizing tableau desktop.
• Utilized Power BI to create a working prototype of the potential reports that could be generated to compare it with existing reporting tool being used in the company.
• Designed cross-tab, geographical maps, scatter plots and utilized Power View and Power Map to visualize the reports as demanded by the user.
• Published Power BI reports utilizing Power BI Services and Microsoft Office 365.
• Utilized Power BI desktop to create and analyze seamless flow of the data into data visuals for rich UI experience for better insights.
• Created interactive models and customized column aggregations by writing DAX using Power View in Excel 2013.
• Performed subscriptions and refresh extracts in Power BI as well as set up data alerts on business-critical data utilizing Power BI services.
• Created scorecards, stack bars, bar graphs, scattered plots, geographical maps utilizing Power BI desktop.
• Implemented complex packages utilizing SSIS transformations like merge join, union all and many other transformations.
• Created packages utilizing SSIS for data extraction from flat files, excel files, and OLEDB to SQL Server.
• Created and implemented error handling at SSIS package level at control flow and data flow utilizing event handlers, precedence constraints and error data pipeline in case of exceptions at run-time.
• Deployed and configured SSIS packages to the production server with parameters in the SSISDB catalog.
• Optimized SSIS packages utilizing parallelisms, fast load options, buffer sizes, and checkpoints. Implemented checksums as incremental load technique to fetch incremental to optimize package.
• Configured virtual machines on Azure cloud to migrate on-premises SQL database.
• Created a test bed and compared side-by-side on the challenges to move data from private cloud servers to public cloud servers.
• Collaborated with cross-functional teams utilizing TFS for source control.

Confidential, Scottsdale, Arizona

SQL/Power BI Developer

Technical Environment: SQL Server 2012, T-SQL, SSDT, SSIS, SSAS, SSRS, Tableau, Erwin, MDX, SharePoint, Power BI

Responsibilities:

• Developed functional/technical specifications such as business scope document utilizing agile methodology.
• Wrote scripts to create and optimize database objects such as stored procedures, functions, DDL/DML triggers, and indexes.
• Created packages utilizing SSIS for data extraction from flat files, excel files, and OLEDB to SQL Server.
• Performed effective error-handling on TSQL scripts utilizing try…catch blocks, @@error, and raiserror functions as desired by the complexity of the business logic.
• Optimized SSIS packages with non-blocking/synchronous transformations and setting task/transformation properties.
• Designed OLAP architecture for changing and maintaining the warehouse, optimizing dimensions, hierarchies and adding the aggregations to the cube with SSAS.
• Applied formatting in SSRS reports with features such as grouping, drill-down, parameters and sub reports.
• Utilized cascaded parameters to generate a report from two different Data Sets.
• Scheduled reports execution in SSRS on daily/weekly basis to support the incremental load in OLAP.
• Deployed reports on SharePoint servers for easy access to the users by setting permissions and roles at report server in SharePoint integrated mode.
• Created dashboards with multiple worksheets, linear graphs, and pie charts utilizing Power BI.
• Built dashboards with techniques for guided analytics, interactive dashboard design, and visual best practices utilizing Power BI.
• Created complex calculations in Power BI reports including string manipulation, basic arithmetic calculations, custom aggregations and ratios, logic statements and quick table calculations.
• Worked on Team Foundation Server (TFS) to synchronize data from multiple sources.

Confidential, Mount Laurel, NJ

BI Reports Developer

Technical Environment: SQL Server 2008R2, T-SQL, BIDS, SSIS, SSAS, SSRS, Erwin, TFS, SharePoint, Tableau.

Responsibilities:

• Collaborated with scrum master and business analyst for writing functional specifications based on business reporting needs.
• Developed and implemented ETL mapping document, normalization and de-normalization of existing tables for accelerated query retrieval.
• Designed and tuned database objects such as tables, procedures, functions, triggers, indexes, and views utilizing T-SQL.
• Designed mappings between sources and operational staging targets utilizing star schema.
• Created the packages to extract data from flat files, excel and oracle and loaded into SQL Server database.
• Designed various ad-hoc queries for customer reports and executive management reports; developed multiple types of reports such as tables, matrix, drill through reports.
• Created interactive reports with SSRS, utilizing the report parameters, query parameters, expressions and filters.
• Utilized features such as interactive sorting, document map, actions in SSRS reports to make it more interactive.
• Generated on-demand and scheduled reports with SSRS for business analyses and managerial decisions.
• Subscribed SSRS reports to users utilizing standard and data-driven subscriptions as per the format requested and needed by the clients.
• Created interactive dashboards utilizing parameters, actions and various data visualizations utilizing tableau desktop.

Confidential, Branchville, NJ

Reports Developer

Technical Environment: SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, MS Excel, Tableau.

Responsibilities:

• Participated in JAD session to analyze BRD and designed functional requirement specification document.
• Designed and developed physical and logical designs, forward and reverse engineered utilizing Erwin.
• Created and managed schema objects such as tables, views, indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Assisted in designing ETL strategy from source to destination utilizing a staging area for data profiling and cleansing within SSIS.
• Optimized SSAS cubes by assigning appropriate storage modes such as MOLAP, HOLAP and ROLAP to partitions, eventually improving query performance.
• Utilized different layout in SSRS reports such as matrix, tabular, chart, tablix to display data in a grid format.
• Designed various analytical reports depicting KPIs along with slicers and dicers utilizing Tableau.
• Developed dashboard solutions for reporting, as well as published the dashboards onto web pages utilizing Tableau, and SharePoint.
• Developed workbooks, dashboards, global filter page, and complex parameters based calculations with tableau desktop later published on tableau server.
• Utilized TFS for Version control and change management for cross functional team communication.

Confidential, Brooklyn NY

SQL Developer

Technical Environment: SQL Server 2008/R2, BIDS, Erwin, T-SQL, SSIS, SSRS

Responsibilities:

• Attended sessions with users and business clients to gather specific requirements.
• Finalized ER-Diagram by writing SQL query to implement business logic.
• Created different indexes on tables to optimize SQL query performance and analyzing execution plans.
• Designed and created CTEs for effective query of hierarchal data structures with less efforts and better performance.
• Performed overall maintenance operations on OLTP such as re-building indexes, updating statistics and taking periodical backups.
• Designed various SSIS packages to ensure clean and filtered data from different sources.
• Utilize charts, graphs, conditional formatting in SSRS to visualize OLTP/OLAP data in proper way for analytical purpose.
• Created complex stored procedures and SQL agent jobs for several reporting services reports.