SUMMARY

• A result Driven Software Professional With 6+Years Of Progressively Responsible Experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, OLTP (Batch Processing, Online Processing), OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modelling using Confidential SQL Server 2016/2014/2012/2008 R2 /2008, SSIS, SSRS and SSAS.
• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.
• Skillful inETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for Power BI.
• Extensive experience in M-Scripting to manipulate the data coming from the data sources like Relational SQL databases by using several functions like split column and assigning variables to the M-scripts wherever necessary.
• Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Proficient knowledge ofData Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modelling and reporting tools.
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
• Worked with Confidential Power BI, DAX expressions, Power View and Power Query integrated with share point.
• Proficient in writing complexT-SQL (DDL, DML),newfeatures likeCTE, Ranking Functions, TOP(n), PIVOT, XML PATH, SQL,Physical, logical database designand Performance tuning.
• Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Expert in creating and developing Power BI Dashboards into rich look.
• Knowledge in all types of Database migrations with all the versions of SQL Server.
• Expertise in designingSSISpackages to import and transform data between databases and external data sources using various transformations.
• Experience inAd-hocreports, data driven subscription reports by usingSSRS.
• Experience in developingSSRS reports - ParameterizedReports,linked reports,Sub reportsby Region, Year, Quarter, Month and Week.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) usingWaterfallandAgile methodologies.

AREA OF EXPERTISE:

• Microsoft SQL Server 2014/2016
• Power BI
• Tableau
• Excel
• MS Access for VBA
• Data Manipulation
• Data Cleaning
• Data Validation
• Data Analysis
• Visio
• MS Office

TECHNICAL SKILLS

Analytical Tools: Power BI, Tableau, SSRS, SSAS, Business Objects

ETL Tools: SSIS

Databases: MS-SQL Server

Data Modeling Tools: Power Designer, ER Studio, MS Visio

Languages: SQL, PL/SQL, HTML, XML.

Operating System: Windows, UNIX (HP-UX, Solaris, AIX), Linux

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Data Analyst/Tableau Developer

Responsibilities:

• Worked with business team and stakeholders to understand the functionality and business requirements.
• Designed, developed, and tested an interactive Tableau Story as a presentation deck for an enterprise level IT Leaders meeting.
• Created many TDE (Tableau Data Extract) for various Projects and Scheduled Refreshes on Tableau Server for Hadoop Hive.
• Converted the existing SSRS reports to Tableau Dashboards with drill down and interactive visual representation of Hive data.
• Actively involved in providing training and educating on Tableau functionality along with the demo on the Tableau Story functionality to be used for the Enterprise meetings as a deck.
• Designed and developed a Tableau Server usage report for tracking the usage metrics and monitoring Server health.
• Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users, and adding them to the groups and scheduled instances for reports in Tableau Server.
• Prepared a Tableau Story prototype to replace an existing power point deck produced from the Tableau Dashboards and other necessary Business inputs.
• Organized demos to the Product Owner/ Stakeholders for POCon Tableau Story.
• Actively involved in training team members and end users on Tableau functionality.
• Enhance the current Custom SQL queries for the Tableau workbooks to improve the Dashboard performance.
• Provide recommendations that enable data quality and help in better decision-making.
• Utilized Tableau Server to publish, maintain and share the reports with the business users.

Environment: Tableau Desktop/Server 2018.1.7, Oracle 11g, SSRS, SAAS, MS SQL Server,SSIS, SSRS, Tableau, Python, MS Excel, SAS Studio, Data Mapping, Data Profiling, SSRS,PL/SQL, Power BI, MS PowerPoint, Visualization, Data analytics, Data Management, and Data Segmentation.

Confidential, Purchase, New York

Data Analyst and Business Intelligence Engineer

Responsibilities:

• Created visualizations of net revenue, profits across various beverages.
• Assembled large, complex data sets that meet functional / non-functional business requirements.
• Designed and executed analytic projects, generated insights to support business decisions using advanced analytical and visualization techniques such as descriptive, predictive, and prescriptive analytics.
• Designed and maintained Data processing system.
• Creating user forms using Excel VBA for end users to see Pivot tables and Visualizations.
• Using Excel Power Query to clean, organize, calculate, and visualize financial dashboards across different beverages.
• Creating Regression models using Machine Learning to predict the Better vs Worse scenarios across multiple regions of North America for 28 different beverages.
• Adjust pricing models using the Elasticity factor over multiple regions.
• Analyzing the average weekly volumes and creating reports and visualizations.
• Created financial data models using Pepsi’s Analysis server in Excel.
• Working with analytical techniques like Linear Regression, Logistic Regression, Time-series models, Classification Techniques.

Environment: SQL/Server, MS-Office, Microsoft Power BI, DAX,SQL Server, SSIS, MS Visual Studio.

Confidential

Jr.Data Analyst

Responsibilities:

• Work with business and project team members (Architect, Solution Designer and SMEs) to understand and create reporting solutions. This includes prototyping potential solutions or modifying existing work to meet new/ changing needs with the use of development standards, processes, and tools available to the team.
• Conducted JAD sessions, interacted with the End users on a regular basis for resolving issues pertaining to the reports, attending weekly status meetings.
• Understanding the use of structured data, dimensional models or cubes and various forms for reporting.
• Created data mapping documents for the worksheets/dashboards to be built.
• Designed and developed data mapping procedures ETL-Data Extraction, Transformation and Loading process using Informatica for integrating data.
• Designed and developed a business intelligence dashboard using Tableau software allowing executive management to view current and past performance sales trends, forecast sales and to track existing customer sales.
• Created Tableau dashboards using advance charts, drill downs, stack bars, bar graphs, scattered plots, and geographical maps.
• Perform development activities from gathering requirements, designing solutions, through developing reports, to testing and deployment.
• Using Blending created Complex workbooks and Dashboards by connecting to multiple data sources.
• Maintained documents for change request and implemented procedures for testing changes.
• Actively tracked schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project and are on the same page, milestone tracking and avoiding scope creep issues.
• Used Tableau URL Actions to navigate from the main Dashboard to detail Reports.
• Built Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company.
• Created and edited the update schedules, managed scheduled update tasks on Tableau server.

Environment: Tableau 9.2/8.3,, SQL Server 2010/2012, Toad, Power Designer, Mercury Test Director, Microsoft Office (Word, Access, Excel, Outlook, Project).