PROFESSIONAL SUMMARY:

• Highly motivatedSQL server/BI Leadaround 10 years of IT experiencehaving multiple skill set and extensive working experience indata warehousingandBusiness IntelligenceTechnologies with expertise inSQL Server development,MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BIfor building, deploying and managing applications and services through a global network of Microsoft - managed data centers.
• Extensive experience in using Microsoft SQL Server, IT Projects involving Business Intelligence (BI), Data Warehousing and Data Conversion in System Design, Development and Support of Microsoft SQL Server.
• Experience developing powerful data visualizations using Microsoft Power BI, Qlik and Tableau.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting MS SQL Server
• Experienced in client requirement analysis, physical, logical design, development, debugging, testing, deployment, support and maintenance of business applications usingSQL Server 2014/2012/2008/2005, SSIS and SSRS 2005/2008/2012/2014/2016.
• Expertise in design and development with latest Microsoft Azure data and BI tools and services including Power BI, Azure SQL Database, and Azure Synapse Analytics (SQL Data Warehouse).
• Extensive experience using Logic Apps, Power BI Report Server in Azure Environment.
• Designed a website using an HTML editor and employing Java and ASP.NET code for various sites functionality.
• Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI desktop.
• Expert database engineer, NoSQL and relational data modeling using Microsoft Sql Server.
• Extensive experience in implementing ETL, Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, and Azure Data bricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau.
• Having good knowledge on Teradata architecture, database features and Teradata tools.
• Used SQL Loader to load data from legacy system (CORE) and developed PL/SQL programs to dump the data from the staging tables to the interface tables and concurrent programs to get data into oracle base tables.
• Extensive knowledge of data warehouse methodologies.
• Implemented row-level security policies in Azure Synapse Analytics (SQL DW) and within Power BI data models.
• Delivered performance-enhancing recommendations on Azure Synapse Analytics data warehouse including partitioning schemes, sorted columnar indexes, and the use of materialized views
• Extensive experience on Business analysis and Enterprise reporting solutions delivery using Crystal Report.
• Created and maintained numerous Crystal Reports including financial and operational Reports.
• Worked on all the Products in Power BI such as Power BI Desktop, Power BI Pro, Power BI Embedded, and Power BI Report Server.
• Assist end users with problems installing the Power BI desktop, installing and configuring the Personal and On-Premises gateway, connecting to data sources and adding the different users.
• Experience in Power Apps applications & BI development using the Microsoft Power Platform.
• Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging and Maintenance of Power BI Applications.
• Create dashboards on snowflake cost model, usage in QlikView.
• Created program in python to handle PL/SQL functions like cursors and loops which are not supported by snowflake.
• Convert and review code from oracle PL/SQL programming to snowflake code, make performance changes and test.
• Good working experience on object - oriented programming like Java & Python.
• Implemented report integration among Power BI, Tableau, SSRS and Python reports.
• Conducted investigative projects utilizing Python for data analysis and machine learning.
• Hands on experience of configuring components of Dynamics 365 and office 365 product stack.
• Expertise Knowledge in writing DAX Queries and MDX Queries.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Hands-on experience Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake Schemas.
• Strong knowledge in Power BI using SQL Server.
• Designed the whole process of end - to -end process of API development. Created the solution for automating the process
• Power APPS to show User info Lists and services including all office 365 user search functions.
• Experience in importing power apps feature within Power BI reports.
• Experienced in configuring SSO with Ping Access using out of the box and custom developed authentication schemes.
• Strong Knowledge in designing and creating dimension and cubes with Snowflake and STAR schema using SSAS.
• Having good knowledge on Teradata architecture, database features and Teradata tools.
• Utilized the various templates in Power Apps and Power Automate Admin Center to create business solution with-low or no-code solutions.
• Supplemented complex query techniques of passing Multi - Valued parameters and cascading parameters in MDX.
• Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data.
• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.
• Skilled in creating measures, calculated columns and performing time series analysis using DAX in Power BI.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map and Sub-Reports.
• Developed SSIS solutions for ETL and Business Intelligence process for Data Integration and Migration Services.
• Implemented Confidential Dynamics CRM solutions by customizing entities, forms, views, workflows, dashboards and reports.
• Good hands-on practice with the new Lightning System Design which helps to quickly and easily create modern enterprise apps using Lightning App Builder and Lightning Components.
• Expert in development and deployment of SSIS packages from various sources like MS Access, Oracle, Excel, Microsoft SQL Server, flat file, and XML.
• Experience in Developing and Extending SSAS Cubes, Building the Dimensions, Deploying, Processing SSAS objects, Cubes with Snow Flake Schemas and Star Schema using SQL Server Analysis Services (SSAS).
• Good working experience in implementing Data Warehousing BI Application Development using Cognos.
• Developing the Relational and Dimensional Model using Cognos Framework Manager and applied data level and object level securities.
• Experience in developing and maintaining SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Teradata, Flat files.
• Experience with creating ETL processes from source and link data to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies that drive value.
• Worked on configuring various data adapters for MySQL, Oracle, SQL Server, Teradata, Flat, Delimited Files, Lotus Notes, and JSON.
• Knowledge of full software development cycle, including code reviews, source control management and working knowledge of Agile.
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Experience in Retail Banking Application.
• Excellent Communicator with the ability to deal with issues with precision & accuracy.
• Self-motivated with a clear aptitude in research, analyze, understand business requirements and write accurate specifications with good leadership qualities.

TECHNICAL SKILLS:

Power BI Tools: Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS

Database Technologies: Microsoft Access, My SQL, SQL Server

Programming: SQL, PLSQL, TSQL

Operating System: Windows, Unix/Linux

Cloud Platform: Windows Azure

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Auxiliary Skills: MS Office Suite, Microsoft Visio, ER Modelling, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida.

Sr. MSBI/Power BI Lead

Responsibilities:

• Worked closely with various teams across the company to identify and solve business challenges.
• Gathering and analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Import data from different data sources to create Power BI reports and Dashboards.
• Experience in developing Reports, Charts, and Dashboards using Power BI Desktop and manage security based on requirements.
• Heavily involved in testing Snowflake to understand best possible way to use the cloud resources
• Having knowledge on Apache Spark, developing data processing and analysis algorithms using Pyspark.
• Create a test environment to test database migration and transformations prior to production implementation.
• Transform, define, navigate the data from data source and performed merge and append queries using Power Query.
• Getting data from Teradata data warehouse.
• Developed POWER BI Ad hoc reports on top Existing Teradata data warehouse.
• Implemented complex query techniques of passing multi-Valued parameters and cascading parameters in MDX.
• Developed Auto retrieval and insertion of NOSQL data using Py Mongo and MongoDB with Python programming.
• Created Crystal Reports Repository objects (Reports template, commands)
• Implemented report integration among Power BI, Tableau, SSRS and Python reports.
• Conducted investigative projects utilizing Python for data analysis and machine learning.
• Implemented Confidential Dynamics CRM solutions by customizing entities, forms, views, workflows, dashboards and reports.
• Create dashboards on snowflake cost model, usage in QlikView.
• Created program in python to handle PL/SQL functions like cursors and loops which are not supported by snowflake.
• Convert and review code from oracle PL/SQL programming to snowflake code, make performance changes and test.
• Setup API specifications and communicate with client partners for API consumptions.
• Worked on Open Token Adapter to establish SSO between two native applications.
• Worked with Power Apps and Power Automate to create apps.
• Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
• Created different chart types and drill down reports using Power Bi Desktop (SSRS).
• Involved in defining report layout in SSRS.
• Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI
• Published reports and visualizations to Power BI Service and thereby created dashboards.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data into Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Good working experience in implementing Data Warehousing BI Application Development using Cognos.
• Developing the Relational and Dimensional Model using Cognos Framework Manager and applied data level and object level securities.
• Good experience in developing Lightning Components and Lightning Apps to provide better and more interactive interfaces to end users, which help in sales enhancements.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements.
• Experience in generating on-demand and scheduled reports for business analysis or management decision.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Shared the created workspace across the organization using Power BI Apps.

Confidential, San Francisco, CA.

Power BI Report Developer (Remote)

Responsibilities:

• Worked with Project team to outline Project requirements.
• Gathering and analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Expert in creating complex Crystal Reports (Ad-hoc Reports, Frequency Reports, Summary Reports, Drill Down, Dynamic Grouping, Graphical, aging Reports).
• Created Crystal Reports Repository objects (Reports template, commands)
• Well versed with HIPAA, Facets, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Profiled the legacy database tables to provide data cleansing issue reports to the client.
• Developed data reconciliation SQL queries to validate the overall data migration
• Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.
• Created measures, calculated columns and performed time series analysis using DAX in Power BI
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed the data using Statistical features in Power BI to develop trend analysis and published the reports on the Power BI Services.
• Created different chart types and drill down reports (SSRS)
• Participated in the configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Implemented complex query techniques of passing multi-Valued parameters and cascading parameters in MDX.
• Involved in defining report layout in SSRS. Created complex stored procedures for reporting services and Analyzed reports.
• Generated several daily and monthly critical reports.
• Created and maintained several ETL jobs and resolved any issues associated with the jobs.
• Developed and maintained SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Teradata, Flat files.
• Performed several performance tunings using execution plan and SQL profiler to improve the performance.

Confidential, Atlanta, GA.

SQL-BI Developer/Analyst

Responsibilities:

• Created reports like parameter-based reports, graphical reports, excel reports, drill-down chart using SSRS and tabular report and generated on-demand and scheduled reports for business analysis using SSRS.
• Responsible for creating Power BI reports and deploying it to Power BI Services.
• Created the Dashboards and shared it to user groups using Power BI Apps.
• Experience with the Windows Azure cloud platform (IaaS and PaaS).
• Performed time series analysis using DAX expressions in Power BI.
• Used Power BI to create self-service BI capabilities and use tabular models.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data into Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.
• Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
• Performed configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.

Confidential

SQL Developer

Responsibilities:

• Built SQL Server Queries for Power Pivot based reporting to deliver on managers reporting needs.
• Widely used Excel, Access and SQL Server to cleanse, de duplicate and format client files.
• Provided complex reports using Excel, Access and PowerPoint.
• Expert in writing Parameterized Queries for generating Tabular, drill down, drill through and sub-reports using SSRS 2012 and generating on-demand and scheduled reports for business analysis or management decision.
• Processed large amounts of health data for data visualization and statistical modeling and report results of statistical analyses, in the form of graphs, charts, and tables.
• Worked with EPIC and Clarity databases for everyday workflow.
• Experience in creating different visualizations and dashboards using Power BI
• Wrote SQL queries, CTE and sub queries for Stored Procedures.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables.
• Designed and modified the existing packages accordingly by using the transformation tasks such as Script Component, Lookup, Derived Column, Condition Split, Union All, Copy Column, Aggregate and Audit Transformation.
• Created Data Profile packages for data quality using SSIS Data Profiling Task.
• Worked on extensive SQL Server Integration Services (SSIS) - Extracting data from 8 different sources and load into data warehouse after applying business logic and data profiling.
• Involved in creating different reports based on the business request and ad hoc requirements using SSRS.