BI Engineer

Manasa Sarvani Gudivada

Bellevue, WA 425-****-***

*************@*****.***

PROFESSIONAL SUMMARY

●Over 7+ years of experience in design, development, testing, performance optimization and reporting using SQL Server Database Engine and Studios.

●Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries, generating cubes on SQL Server 2008 R2/2012/2014/2016.

●Extensive SQL/Business Intelligence/Reports Development experience in Pharma industry with a strong understanding of data, analytics and involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of various projects.

●Created live Dashboards and Apps using Power BI, deployed, Published, and scheduled refresh of Report data sources.

●Worked on Maps, different type of charts, visualizations, Drilldown, Drill Through, hierarchies, Bookmarks with Power BI.

●Worked on Complex reports using Power BI with connection modes Live Connected, Import and Direct Query types.

●Experience is designing and developing OLAP structure SSAS Tabular Model for building data warehouse.

●Created Hierarchies, DAX measures, partitions, Row-level security, Star / Snowflake modelling of fact and Dimensions in SSAS Tabular Model

●Experience in Extracting, Transforming and Loading (ETL) data pipelines using SSIS to import data from heterogeneous sources.

●Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using SSIS.

●Excellent experience and understanding of database design, migrating data using SSIS, relational integrity, Constraints, OLAP, OLTP, Cubes and normalizations.

●Expert in development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS with SQL Server.

●Created ETL Pipelines in Azure Data Factory to import data from Azure Synapse Analytics to Azure SQL Database

●Migrated existing SSIS Packages to Azure Data Factory pipelines to read data directly from Azure Data Lake

●Built Pipeline in Azure Dev Ops with CI CD configuration for database project to deploy automatically in Database.

●Hands on experience with analysis of business, technical, and functional requirements and Developed, Executed & Tested the test plans, test cases and test strategies.

●Experienced in writing T-SQL with constructing Triggers, Tables, implementing stored Procedures, Functions, Views, and Data Integrity

●Scheduled SQL Agent jobs including Processing of SSAS Cubes, triggering SSIS pipelines, Running Stored procedures, sending notifications, running DB backups.

●Knowledge of installing, configuring, managing Microsoft SQL Server Business Intelligence applications.

●Having direct hands-on experience, proven ability, required skill set in accomplishing critical Server builds with short deadlines.

●Enthusiast towards learning and gaining knowledge about technologies in Industry 4.0 like Machine Learning, Data Science, IoT

●Expertise in upgrading and migrating SSIS packages, resolving complex issues and Error Handling in SSIS.

●Expertise in implementing High availability: Mirroring, Log shipping and Replication.

●Have created various pivot tables and charts using MS Excel.

●Knowledge regarding cubes and developed measures and dimension members using Multi-Dimensional Expression (MDX) to meet additional needs that were calculated from existing measures.

●Good communication, analytical skills, self-motivated, quick learner and an active team player and team leader. Very flexible and ready to take new challenges.

●Experienced in capturing data changes made to the tables.

●Maintained positive communications and working relationships at all business levels.

●Analyzed, identified, and documented data mapping between source, stage, and destination repositories.

●Ability to easily translate complicated technical information to business centric people and vice versa allowing excellent collaboration between cross functional and global teams facilitated by excellent communication skills.

●Performed OS Upgrade, DR Solution Processes set-ups, documentation & execution. SRDF Role swaps, MIMIX role swaps, SSL in 8 iSeries machines.

EDUCATION:

Educational Qualification

Year

College

GPA

MS in Information Technology

August 2018 – May 2020

University of Cumberlands

3.63

Bachelor’s in engineering

May 2004 –May 2008

JNTU Hyderabad, INDIA

3.3

TECHNICAL SKILLS

SQL Server Tools

SQL Server Management Studio, Enterprise Manager, SQL Profiler, Tuning Advisor, SQL Analyzer, Query Analyzer, Replication, SQL Server Business Development Studio (BIDS), TFS

Databases

SQL Server 2016, DB/400, SQL/400

Scripting Languages

T-SQL, Python

DW / BI Tools

SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, Power BI, DAX, MDX

Operating Systems

Windows 10, OS/400 V7R1, V6R1, V5R4, V5R3, V5R2

Cloud Tools

AZURE BLOB Storage, Azure Data Factory, Azure Logic Apps, Azure Data Lake Store

Other Tools

IBM Client Access, Operations Navigator, Showcase. Web Based HMC Console, Operational Console, TWINAX Console, Integrity, Magic, Service center, Manage now R1& R2

PROFESSIONAL EXPERIENCE

University of Cumberlands Aug’18- May’20

Williamsburg, KY

Responsibilities

Created Analytics projects over Surveillance Systems, Automation of Retail Marketing, Analyzing Medicare demand in US.

Worked on various Data marts built and worked on enabled easy access to months of customer and product data. The Data Warehouse was more than 1 Terabyte in size and features powerful analytical tools, flexible reporting capabilities and leverages the corporation's authoritative sources of information.

Streamlined the operational processes to be more efficient and cost effective by reducing the costs of disk size by 90%).

Collaborate with internal marketing managers and stake holders on requirements, Transition the work items to Team.

Involved in Data Modelling to design OLTP DB tables, Views, stored procedures, user defined functions, Indexes.

Implemented Dimension Modelling in building Facts and dimensions, created column stored indexes to improve performance.

Designed and Developed Power BI Reports with latest Layouts, implemented features like bookmarks, parameters, complex DAX in creating Measures / calculated columns, Scheduling One Drive Refresh with Live Connected and Import sources

Created Power BI Reports over Multiple files in Azure Data Lake Storage as source, combined files and created trends.

Conceived, designed, developed, and implemented the data warehouse solution from scratch.

Creating Live Connected Reports and Pinning in Dashboards using Power BI.

Implemented Row level security to limit user access in SSAS Tabular Model

Created DAX measures, Calculated members, relationships, Partitions over years with strategy in SSAS Tabular Model

Created Attribute relations, Usage based optimization, dynamic partitions, tuning the performance of the cube.

Key Player in involving Optimization of SSAS Tabular Cube and Improving Performance of Reports.

Created live Dashboards and Apps using Power BI, deployed, Published, and scheduled refresh of Report data sources.

Scheduled SQL Agent jobs including Processing of SSAS Cubes, triggering SSIS pipelines, Running Stored procedures, sending notifications.

Created DWH pipelines with full load, delta load types using transformation like Lookup, SCD, OLEDB Command, Sort, Fuzzy Grouping, Conditional split, Derived Column.

Created MDX queries based stored procedure using Open Row set query over SSAS model to generate daily health report.

Developed pipeline in Azure Data Factory to import data from Azure BLOB Storage to SQL Server Database

Scheduled and triggered Azure Data Factory Pipeline using Azure Logic Apps

Created Runbook based on Power shell to copy CSV files from Share point to Azure BLOB Storage

Created Power Apps POC with Power BI to visualize the Real time data with changes on the fly.

Used R Studio along with GGPLOT package to create visualization in Power BI Report R visual.

Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.

Testing of records with logical delete using flags.

Environment/Technologies: Windows 10, T-SQL, Microsoft SQL Server, Power BI, DAX, MDX, SSIS, SSAS, SQL Management studio, Visual Studio, Power Shell, Azure Data Factory, Azure Logic Apps, Azure Run Book, Azure Data Lake Store

Novartis May’14- Feb’15

Hyderabad, India

Responsibilities

Segregated existing reports from Novartis environment to Alcon environment.

T-SQL development includes stored procedures and user defined functions.

Created SSIS Packages with Master-child architecture and scheduled.

Created ETL pipelines for full and incremental load on daily basis.

Created SSRS Reports, data driven subscriptions and deployed on SharePoint applications.

Built Dashboards to showcase server health-based Reports on SSRS.

Implemented Transactions, Error handing in T-SQL applications.

Transitioned multiple steps of pipelines to SSIS ETL packages.

Built SSIS Packages to Process Multi-dimensional OLAP Cube.

Created Calculated Members, Hierarchies, Perspectives and written MDX Queries.

Automated Backup and Restore of .ABF file using SSIS maintenance tasks.

Scheduled data driven Report Subscriptions in SSRS.

Prepared data models for Retail Promotional Analytics

Driven the development and maintenance of reporting analytic solutions.

Drafted complex SQL queries and perform allocation testing from front end/ user interface.

Extensively written SQL for ETL and Reporting Testing.

Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.

Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.

Extensively executed T-SQL queries to view successful transactions of data.

Environment/Technologies: Windows 7, T-SQL, Microsoft SQL Server, SSRS, SSIS, SSAS, SQL Management studio, Visual Studio, Power Shell

Alcon Laboratories (India) Pvt Limited Apr ’12– May’14

Bengaluru, India

Infrastructure– Analyst

Responsibilities

Managed the iSeries Systems hosting manufacturing, inventory sales and reporting applications which supports the Advanced surgical, Pharmaceutical and Vision care business units.

Worked on Power 6 systems with external storage (VMAX2771 & VMAX2774).

Quarterly Role swaps are performed for MIMIX & SRDF environment.

Technical focal point for the Application team for their environmental issues.

Object analysis and Conversion were performed for Operating system upgrade and IQ’s are documented accordingly.

Accountable for the Installing Single, Group and Cumulative PTFs.

Performance tuning which involves ASP, CPU & Job tables’ growth etc.

Performed successful upgrade of MIMIX, Showcase, MPLUS and XCOM.

MIMIX environment are created for the business-critical files and are monitored and replicated without any interruptions.

Knowledge of Working on AS400 hosted applications like Showcase, JDE, XCOM, Alert, MIMIX & TAATOOL.

Monthly Disk reports for all the LPARs are circulated to the respective application advocates.

Successfully implemented the alert system and escalation for Low, Medium, High, and Critical system & application alerts using MPLUS.

Incident Management & Work Order Management - Ensuring that all incidents are handled & closed as per the process documents and within SLA.

Change Management – Performing Scheduled change within given SLA and downtime as a normal and emergency change as per requirement.

Provided operational support to EDI reporting.

Environment/Technologies: AS 400, Operations Navigator, Showcase. Web Based HMC Console, Operational Console, TWINAX Console.

IBM

Bengaluru, India Mar ‘11 – Apr ‘12

SQL Developer

Responsibilities

Gather requirements from users for commercial Bi Applications based Cognos report.

Created table, views, Procedures and User defined functions in SQL Server for reporting

Created Packages in SSIS for Cognos and SSRS reporting

Scheduled Cognos Cubes using SQL Service Agent

Scheduled Cognos based reports and created burst reports for user groups.

Review job schedule within designated system to ensure jobs processed, including verification of record counts.

Conducts daily/weekly meetings Share the status updates to Client periodically.

Analyze and understand the BI applications.

Gather all the information from the current team/s who support the BI apps (ETL, BI, Database, Upstream and Downstream dependencies)

Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing and Created and executed Test scripts for system validation and user acceptance testing (UAT)

Environment/Technologies: Windows 7, T-SQL, Microsoft SQL Server, COGNOS, SSRS, SSIS, MDX, SQL Management studio, Visual Studio, Power Shell

IBM

Bengaluru, India Jul ‘08 – Mar ‘11

Senior Engineer – System Admin

Responsibilities

Collaborate with different business units to plan, coordinate, and execute the major activities that were performed for different business units of Walt Disney World.

Successfully built several IBM i systems as per the Technical Specification Document (TSD)/business requirement for different business units of Walt Disney World.

Successfully executed all the Disaster recovery exercises that were performed as BCRS requirement.

Performed successful installation and upgrades of i) system OS ii) system firmware iii) third party tool upgrades (ACO, Robot, Power lock) iv) MIMIX.

Performed several system configurations for different business units of Walt Disney World like SSH, SSL, SNTP, SMTP, SFTP, etc.

Was Accountable for the PTF management and negotiating with client for Server downtime.

MIMIX

Provided several Defect prevention plans as a part of continual improvement plan and automated few procedures for Disney account.

Successfully completed several DASD, Memory and processor upgrade activities for Disney Vacation club, Disney stores and Buena Vista studios group.

Successfully migrated the existing production system from V5R4 on i570 to V7R1 on Power system for Disney stores business unit.

Participated in all the escalations as a key team member and handled the severity 1/server down situations (Major incidents) and resolved within the SLA.

Participated in all the Major changes for this account and completed successfully.

Established the ITIM vault process in Disney account for managing the shared ids.

Data Conversion Activity: Includes Saves, Restore & Manage MIMIX for different schemas which has an approximate window of 24-36Hrs & coordination with application team.

Vendor Co-ordination for hardware break-fix, HW/SW installation/upgrades.

Participated in several DR exercises as the BCRS Requirement and completed successfully which was appraised by the higher management.

Supporting the customer on the daily BAU activities and during the weekend.

On-call support during the off hours and during the weekend.

Assist all the pool members during Major Incidents/Major changes.

Assist pool members during technical escalations and drive them to closure.

Incident Management - Ensuring that all incidents are handled & closed as per the process documents and within SLA.

Problem Management - Identifying the reoccurrences of incidents. Determining the root cause and fixing the problem

Change Management – Performing Scheduled change within given SLA and downtime as a normal and emergency change as per requirement.

Reporting - All incidents / problems are reported in team DSR (Daily Status Review), Filling timesheet, creating technical & process documents, updating the documents regularly and getting them approved and sending monthly report to all clients with full system performance and its status

Environment/Technologies: AS 400, IBM Client Access, Operations Navigator, Showcase. Web Based HMC Console, Operational Console, TWINAX Console, Integrity, Magic, Service center, Manage now R1& R2.

Certification

ITIL Foundation

Power BI certification from UDEMY

Non- Technical Achievements

•Worked as Change Management Process coordinator.

•Worked as Transition coordinator for IT-Hub movement from Bengaluru to Hyderabad.

Contact this candidate