SUMMARY

• Over 8 years of experience in Data Analysis, Design, Implementation, Data warehousing and support of Business Intelligence Applications in Retail, Finance, E&P and Food services.
• Strong experience in Confidential BI tools (SSIS, SSAS, SSRS and Power BI).
• Strong understanding of Data warehouse concepts, ETL strategies and data modeling techniques such as STAR and Snowflake.
• Strong Understanding in Snowflake Cloud DW
• Strong understand about business logic and created data model by using SQL queries.
• Strong Knowledge in Creating relationships between Fact and Dimension tables in Tabular Model and created power BI reports, dash boards models, data sets.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row - level security, joins, data blending, and dashboard actions.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes.
• Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards.

TECHNICAL SKILLS

BI Tools: Power BI, Tableau 2019/9x/ 10x, SSRS, SSAS, Crystal Reports, Cognos.

ETL Tools: SQL Server Integration Services (SSIS), Azure Data Factory

Databases: Confidential, SQL Server, MySQL, SQLite, Hadoop/HBase, Hive, MS Access, Confidential 12c, Vertica, Salesforce, DB2.

Applications: Confidential Office, MS Visio, Share point

Web Technologies: HTML, CSS, JavaScript

Web Scripting: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio

Cloud: Azure, AWS

Methodologies: Agile, Waterfall.

s: Implemented end to end BI solutions from project kick-off through data requirements, data collection, modeling, processing, and validation and delivering of results within budget and timeline.

: Master of Business Administration Confidential, India

PROFESSIONAL EXPERIENCE

Plano, TX

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
• Developed Conceptual, Logical and Physical Models using ER Studio.
• Designed and developed scalable ETL pipelines using SSIS and Azure Data Factory.
• Hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe, etc.
• Snow SQL Writing: SQL queries against Snowflake.
• Designed and developed calculated measures using DAX and MDX Expressions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power BI to create dynamic reports and dashboards with Drill down and Drill throughs.
• Troubleshoot slowly running reports and dashboard elements to improve report performance.
• Deployed and shared the reports to Power BI service, Mobile Apps and SharePoint Server and setup gateways, Low Level Security for end user interactions.
• Built and maintained Power BI dataset and data flows to consolidate disparate data from multiple sources to support self-service report authoring and seamless data insights
• Expertise in writing complex DAX functions in Power BI and Power Pivot
• Developed functionalities like Role Level Security (RLS) with Power BI desktop, assigned and validated in Power BI Service to ensure visualization data security for the enterprise
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Explored data in a variety of ways and across multiple visualizations using Power BI.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Weekly presentation to the business users about the reports and their changes as required.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Produce high quality and high value visualizations in Tableau that are Regulation W restricts certain kinds of transactions between banks and their affiliates.
• Quickly resolve any internal customers issues raised and publish new versions of dashboards on a regular basis.

Environment:: Power BI , Pentaho, Tableau, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler, Tableau Desktop 2019.4, 10x, Tableau Server, SQL Server 2008/2008 R2, Netezza, Tableau Prep, SharePoint, MS Visio, spark, Agile, Jira, SSIS, SSAS and SSRS

Confidential, Reston, VA

Business Intelligence Consultant

Responsibilities:

• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.
• Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
• Helped the scrum team ensure they meet the definition of 'done' for each product feature and removed internal and external impediments to their progress.
• Quickly resolve any internal customers issues raised and publish new versions of dashboards on a regular basis.
• Executed dashboard setups and data manipulation using DAX.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Explore data in a Variety of ways and across multiple visualizations using Power BI. Familiar with Power BI Dataflows, Power Apps, Data modeling, Row Level Security.
• Integration of power BI service portal Imported data from SQL Server DB, Azure SQL DB to Power BI.
• Developed and implemented reporting, analytics, and data visualization solutions with Power BI.
• Translated business user concepts and ideas into comprehensive business requirements and design documents.
• Developed Conceptual, Logical and Physical Models using ER Studio.
• Designed and developed scalable ETL pipelines using SSIS.
• Created project plans in accordance with project management framework standards and procedures. Identified ongoing issues and gaps within project plans, to eliminate implementation issues.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Gathered user requirements analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Restricted data for users using Row level security and User filters.

Environment:: Confidential BI Stack -2008(SSIS, SSAS, SSRS), Cubes, Dimensional Modeling, MDX Scripting, SQL, Agile, Tableau

Confidential, Riverwoods, IL

Business Intelligence Consultant

Responsibilities:

• Interacting with business users to identify and build out visualizations.
• Experience with Sorting, Building Groups and using in visualizations.
• Developed Extraction Transformation and Loading (ETL) Strategies, Data Governance and Exception Handling Strategies.
• Developed the Conceptual, Logical and Physical Data Models, Data Flow Diagrams (DFD), Source to Target Mappings and Data Dictionaries.
• Developed end to end BI solutions using Confidential BI Stack
• Involved in Interacting with business users and performed Gap Analysis according to Client requirements.
• Created various interactive reports/dashboards using SSRS.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.

Environment: Confidential BI Stack -2008(SSIS, SSAS, SSRS), Cubes, Dimensional Modeling, MDX Scripting, SQL, Agile

Confidential, Bakersfield, CA

Business Intelligence Analyst

Responsibilities:

• Developed Extraction Transformation and Loading (ETL) Strategies, Data Governance and Exception Handling Strategies.
• Developed the Conceptual, Logical and Physical Data Models, Data Flow Diagrams (DFD), Source to Target Mappings and Data Dictionaries.
• Developed end to end BI solutions using Confidential BI Stack
• Interacting with business users to identify and build out visualizations. Experience with Sorting, Building Groups and using in visualizations.
• Involved in Interacting with business users and performed Gap Analysis according to Client requirements.
• Created various interactive reports/dashboards using SSRS.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Experienced on Date functions creating, executing test Cases, and documenting the Test Results.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Confidential BI Stack -2008(SSIS, SSAS, SSRS), Cubes, Dimensional Modeling, MDX Scripting, SQL, Agile

Confidential, Boca Raton, FL

Business Intelligence Analyst

Responsibilities:

• Involved in setting up BI Infrastructure as the company being a Startup.
• Actively involved in gathering requirements from game teams, involved in modifying various technical & functional specifications
• Assisted Finance team with the audit data.
• Develop Data warehouse model in Amazon Redshift and reviewing the schema in a timely manner to ensure storage and data accuracy.
• Coordinate with DevOps and Infrastructure teams to prevent data loss.
• Maintain EMR Clusters and Scala code for the ETL processes.
• Develop scripts in Hive and SQL, based on the requirement and experienced using Amazon Athena.
• Used Tableau Extensively to create various reports for Finance and KPI’s.
• Put together Email notification from tableau report and load errors monitoring to end users as soon as pipelines finish for the game teams to react quickly in case of discrepancy.
• Worked with the game teams for BI Integration and third-party SDK’s integration.
• Scheduling and Monitoring Amazon Data Pipelines and using Amazon Web Services
• To write and trigger various test cases in SDK using swift, conducting unit tests, and testing the functionality of SDK.
• Experience with data from third-party services such as Facebook, Confidential, iTunes, Fabric and Leanplum.
• Involved in Onsite & Offshore coordination with the Beijing Team to ensure the completeness of deliverables.
• Analyzed cost-cutting strategies and made recommendations.
• Experienced with Scrum process

Environment: Confidential BI Stack -2008(SSIS, SSAS, SSRS), Cubes, Dimensional Modeling, MDX Scripting, SQL, Agile