SUMMARY

• Over 9 years’ experience in Database Design and development with Business Intelligence using SQL Server 2014/2016, Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI,DAX, Power Apps, Power Automation, OLAP Cubes, Star Schema and Snowflake Schema.
• Strong experience with SQL query generation and data modeling.
• Responsible for building reports in Power BI from the Scratch.
• Microsoft Certified Power BI Developer.
• Expertise in developing applications using PowerApps, canvas, model driven app, Common Data Service CDS, SQL, Forms, SharePoint online, Dynamics 365 CRM, Azure.
• Expertise in using DAX and generated dashboards & reports and integrating with PowerApps.
• As a DBA professional and troubleshooting experience include SQL Server database administration, data modeling, gathering and analyzing business requirement and Operating Systems.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Strong skills in visualization tools SSRS,Power BI with UI/UX,Confidential Excel - formulas, Pivot Tables, Charts and DAX Commands.
• Experience on Migrating SQL database toAzure data Lake, Azure data factory,Azure SQL Database.
• Expertise in using DAX and generated dashboards & reports and integrating with PowerApps.
• Expertise in various phases ofproject life cycles (Design, Analysis, Implementation and testing).
• Collaboratively worked with the team from requirements gathering to project development, deployment, and production support on various projects.
• Hands-on experience in BMC Control-M &TWS Scheduler tool for scheduling ETL/ELT Jobs.
• Analyzed results of operations to discover more efficient ways to utilize resources; coordinated with successful simultaneous development of projects.
• Reviewed project status reports during each operational phase; prepared weekly project status reports for the management.
• Hands on experience in using version control software like Team Foundation Server (TFS).
• Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
• Experience with Production (24 X 7) and Development Environment.
• Good management skills, leadership abilities, self-motivate and fast learning abilities.

TECHNICAL SKILLS

• MSBI
• SSIS
• SSAS
• SSRS
• SQL
• T-SQL
• PL/SQL
• Python Programming
• Data Visualization
• Data Migration
• MS SQL Server 2014/2016
• MySQL
• Power Platform
• Power BI
• DAX
• Analytic Problem-Solving
• Visual Studio
• SSMS
• MySQL workbench.

PROFESSIONAL EXPERIENCE

Report Writer/Power BI Admin

Confidential

Responsibilities:

• Design backend databases, front end user interfaces and logical layers as per the business requirements.
• Designed and documented entire Architecture of Power BI Poc.
• Automated Dataflow refresh using Power Shell.
• Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW)
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduled refresh in Power BI service.
• Developed data capture and navigation desktop and mobile apps in Microsoft Power apps that connect to distribution center solutions design analytics in Power BI.
• Getting data from different sources like flat files, SQL Server, Oracle and Aure Blob storage, Azure SQL database and more.
• Create SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.
• Designed SSIS Packages to import and transform data between databases and external data sources using various transformations.
• Developed data ETL modules using DAX and generated dashboards & reports for day-to-day distribution center performance monitoring.
• Set up Microsoft Flow (Power Automate) to provide auto-approval and status update features based on predefined criteria.
• Involved in manual testing of the application.
• Created Drill Down reports, Drill Through report by Region.

Business Intelligence Specialist

Confidential

Responsibilities:

• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/ R2 and 2008 R2 to 2012.
• Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012.
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues.
• Performed database and SQL/TSQL Performance Tuning.
• Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Developed application in PowerApps usingCommon Data Service CDS, Flow, Excel, Forms and SharePoint online.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Migrated existing self-service reports and ad-hoc reports to Power BI.
• Set up Microsoft Flow (Power Automate) to provide auto-approval and status update features based on predefined criteria.
• Create and manage Reports subscriptions and schedules SSRS reports.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Automated file transfer processes and mail notifications by using FTP Task and Send Mail task in packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Data Warehouse Analyst

Confidential

Responsibilities:

• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from large number of tables.
• Configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Set up security and access profiles and procedures for database system administrators.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Schedule SSIS packages through SQL Server Agent - Jobs and make sure that the packages are executed for every 8 hours’ time span.
• Created MSBI (SSIS) packages using data transformations like Conditional split, OLE DB Command, Lookup, Data Conversion, Derived Column, Merge, Merge Join, Sort, Union, Union All.
• Worked on the production servers (CAD, RMS), extracted all the required tables and columns into other servers as per the requirement using SSIS.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Worked on MSBI (SSRS) in developing the reports such as Data Bar Reports, Drilldown Reports, Dashboard Reports, Map Reports, and Pie chart Reports, Parameterized reports.
• Developed Tabular Model infrastructure in SSAS for various Lines of Business and created over different interactive Dashboards using various visualizations in Power BI Desktop.
• Worked on expressions such as performing the calculations, concatenation them with the strings and formatting as per the requirements on the reports and dashboards.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Created Data Sources, Datasets and Parameters as per the requirements of the reports
• Created reports to retrieve data using Stored Procedures and accept parameters.

Business Intelligence Engineer

Confidential

Responsibilities:

• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Developed Power BI Apps on the service and developing, integrated, and managed RLS (Row level Security)
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Expertise in designing B2B data Exchange platform using ETL process.
• Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
• Experience in creating SSIS packages for XML based Business to Business Data exchange using different type’s task and with Error Handling and Reporting Capability.
• Used ProClarity for accessing and analyzing cubes and dimensions and worked on integration of SSRS.
• Using SSRS creating well-formed reports and web-based reports for Energy saving applications and transactions.

SQL Developer

Confidential

Responsibilities:

• Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. on various databases for critical data involving profit and loss, net Confidential, forecasting.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Designed and developed various complex reports.
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Conducting technical reviews of GIS Enterprise systems.
• Installing and developing with GIS software (ArcGIS Server and Openlayer)
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Fixed issues in the existing crystal reports.
• Run Quality Checks in order to make sure that the maps prepared by labelers are stable and correct and are in agreement with the regional map standards, irrespective of their location.
• Confirming the exit path information by implementing the utilization of videos and Confidential earth & updated street view.

Database Analyst

Confidential

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL Plus, PL/SQL and SQL Loader scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• 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.
• DevelopedStored Procedures, Triggers,andSQL scripts for performing automation tasks
• Performed and fine-tunedStored ProceduresandSQL QueriesandUser Defined Functions.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team.