PADMAJA PERLA

Mobile: +1-774-***-****

E-mail: ad2aoi@r.postjobfree.com

EXECUTIVE SUMMARY

* **** ***** ** ********** in Microsoft Database Technologies that includes experience in Database Design and Development in Insurance, real estate and Health care Domains. Experience in Business intelligence as BI Developer in data modeling, development and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.

Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using Power BI SQL Server 2016/2014/2012, DTS, SSIS, SSAS and SSRS 2016/2014/2012.

Experienced on Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App).

Excellent in writing T-SQL, working on DTS, SSIS, SSRS Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.

Knowledge of SDLC phases such as Requirement analysis, design, development, implementation, deployment and maintenance with Good understanding of methodologies like Waterfall and Agile.

Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.

Experience on publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for upcoming data in power BI server.

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.

Extensive Experience with MS BI Stack, including SQL Server (latest versions) SSIS, SSRS, BIDS, Power BI, MDS.

Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub Reports, Global map reports in both Power BI Desktop and Power BI Cloud service.

Robust MS Access and excel skills with Power pivot, PivotTable, PivotChart, Power view, VLOOKUP functions and formulas.

Expertise in Power BI, Power BI Pro, Power Bi Mobile.

Expert in Creating and developing Power Bi Dashboards into a rich Look.

Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.

Experience in Migrating Data from an older version to newer version of MS SQL Server 2016.

Experienced in creating interactive dashboards and scorecards utilizing Power BI.

Hands-on experience in MS Power BI desktop and Power BI service.

Hands on Experience in Data Migration from MS SQL Server to Oracle ERP Systems.

Strong team player with great verbal, written communication and interpersonal skills

Skills:

OLAP/Reporting Tools

SSRS, SSAS, DAX, MDX, Power BI, Tableau

Relational Databases

SQL Server database 2014/2012/2008 R2/2005, Oracle 12c, 11g, SQL Server Azure, MS Access

SQL Server Tools

Microsoft Visual Studio 2010/2013/2015, SQL server management studio

ETL Tools

SQL Server Integration Services (SSIS), SQL Server DTS

Other Tools

Microsoft Office 2003/2007/2010 and 2013, Power pivot, PowerBuilder

Programming languages

MySQL, PL-SQL, JAVA, Python

Data Warehousing & BI

Star Schema, Facts and Dimensions tables

Operating Systems

Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

WORK EXPERENCE

Project 1

Delta Airlines, USA (May 2021 –April 2022)

Environment

SQL Server 2016/2017, Microsoft Visual Studio 2015/2017, MS Office, DAX, SSIS, SSAS, SSRS, SharePoint, Power pivot, Power view, Power BI.

Description

Delta Airlines connected cabin initiative enables the next gen onboard seatback entertainment experience unlocking a truly personalized experience with connections to other enterprise services (e.g., SkyMiles, SkyPro) that enables choice and control for both Delta and the customer.

Responsibilities:-

Role :- Power BI developer

●Created/Updated database objects like tables, views, stored procedures, function, packages.

●Scheduled Automatic refresh and scheduling refresh in Power BI service.

●Wrote calculated columns, Measures queries in Power BI desktop to show good data analysis techniques.

●Designed MS SSIS Packages to extract data from various OLTP sources to MS SQL Server

●Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.

●Created SQL Jobs to schedule SSIS Packages, Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

●Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

● writing SQL Queries, Dynamics, subqueries and joins for generating Stored Procedures, Triggers, User-defined Functions, Indexes, Views and Cursors.

●Used SQL Server Profiler to trace the slow running queries and the server activity.

●Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Project 3 Hallmark Property Developers( 09/2012 – 08/2014) Hyderabad, India

Environment SQL Server 2012/2014, Microsoft Visual Studio, MS Office, DAX, SSIS, SSAS, SSRS, SharePoint, power bi.

Responsibilities:

Role: SQL DEVELOPER/BI DEVELOPER

●Created Power BI Dashboards with Tiles and Pins from Reports, Insights and Workbooks

●Created new reports from Datasets using Power BI Cloud Worked with Edit Interactions

●Developed SSIS package for transferring the data between MS Excel, Flat Files and SQL Server.

●Worked with DBA to perform data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.

●Worked with Power BI Report Publish options from Power BI Desktop.

●Worked on various Power BI Visuals and Visual Properties including Tree Map, Pie Chart, Funnel, Scatter Bar Chart and Column Charts

●Experience in Error Handling using global variables and logging of the errors into the database.

●Created various Tables, Views and Indexes.

●Created complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, Multi Cast, column conversion, Fuzzy Grouping, Script Components.

●Wrote complex Stored Procedure, Queries, Triggers, Functions, User-defined functions and Cursors for application.

●Used SQL Profiler to trace out problems in slower execution plans.

●Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.

●Created Filtered reports using report parameters, stored procedures & cascading parameters.

●Created several report subscriptions to deliver reports to the end users via email.

Contact this candidate