SUMMARY

• Highly adaptable and experienced with SQL Server Suite of products (Power BI, Azure, SSIS, SSRS,SSAS)
• Experience with Full life Cycle of Data Warehouse development and ongoing support.
• Experience with BI application design and development principles.
• Experience in upgradingMS SQL Server to MS SQL Server, andMS SQL ServertoMS SQL server.
• Experience in Developing and TuningT - SQL, PL/SQLComplex Queries, Stored Procedures,UDF’S,triggers, views, Indexed views and error handling using Try-Catch blocks.
• SAS Programing and Development.
• Data Analysis / regression / visualization with SAS / Power BI/ Python / Excel
• Experience with analyzing and debugging existing Complex stored procedures, Query optimization.
• Experience inad-hoc SQL queries Sub-queries,CTE’s(common table expressions), Table Variables and Physical Temp Tables.
• Experience in using all theData Virtualization toolsand integrating with the applications and services.
• Experience in Data Conversion and Data Migration usingSSISacross different databases likeOracle, MS access and flat files.
• Cloud computing implementation experience using Azure Data Lake, Azure Data Factory, Azure Machine Learning & PowerShell scripting.
• Experience in Cube designing in BI Development Studio(SSAS)to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in creating different types of Complex Reports usingSSRS.
• Experience in analyzing design, development and application usingSQL Server Integration Services(Control Flow, Data Flow, Error Handling, Datatransformation Tools, Data Conversion).
• Experience at building and deploying multi-valued parameterized reports usingPower BI,Tableau.
• Experience in Developing and ExtendingSSASCubes, Dimensions and data source viewsSSAS-Data Mining Models and Deploying and ProcessingSSASobjects.
• Experience in buildingTabular Model Cubefrom Scratch in Databases with differentMeasuresandDimensions.
• Worked withConfidential Power BI,DAX expressions, Power View and Power Query integrated with share point.
• Experience in developingOLAP Cubesby using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Experience in a fast paced Agile Development Environment, Test - Driven Development(TDD)and Scrum.
• Experience in calculating measures and dimension members using Multi-dimensional expression(MDX),mathematical formulas, and user-defined functions.
• Experience with SQL Server Reporting Services(SSRS)and generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts inSSRS/Power BI.
• Having Knowledge onSQL Azure,Azure Data warehouse,Azure Data Lake.

TECHNICAL SKILLS

Integration Services: SQL Server Integration Services (SSIS)

Reporting Tools: Power BI, SSRS, SAS, Crystal Reports, BO-Universe, Web Intelligence, Excel

Languages: C, SQL, T-SQL, PL/SQL, UNIX

Databases: SQL Server, DB2, Big Data, Oracle, MYSQL, PL SQL, Rest API, SAS, Azure SQL, MS Access, Azure Data Lake & Azure Data Factory (ADF)

ETL Tools: MS SQL Server Integration Services (SSIS), Informatica Power Center

Scripting: HTML, Shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City

Power BI/ MSBI Consultant

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script taskandSend Mail tasketc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
• Developed parameterized reports,drill down, drill through reports,sub reportsas per the report specifications and functionality.
• Implemented complex business logic throughT-SQL stored procedures, Functions, Viewsandadvance query concepts.
• Created databases and schema objects including tables,indexesand appliedconstraints, connected various applications to the database and written functions, stored procedures and triggers.
• Data copied from ADLS to Azure SQL database using ADF pipelines invoked using PowerShell scripting.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data drivensubscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to theSharePoint server, IIS Server, Integrated SharePoint serverwith Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements usingPower BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to supportPower BIand SSRS reports.
• Developed complex calculated measures usingData Analysis Expression language (DAX).
• EmbeddedPower BIreports on SharePoint portal page and also managed access of reports and data for individual users using Roles.
• Provided 24X7 production support to ensure timely and error free delivery of reports.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development ofhierarchies, dimensions, attributes, properties, calculationand allocation routines for delivering the desired KPI’s in the Cubes.
• Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters usingSQL Server configurations, XML configurations.

Environment: MS SQL Server 2008R2/2012/2014, SSIS, SSRS, Management Studio, Visual Studio,DTS, Windows 7,MS Office 2010/2013,Windows Server 2008 and Windows Server 2008 R2,Visio 2010/2013,Power BI Desktop, Power BI Service.

Confidential, Austin, TX

Power BI/MSBI DEVELOPER

Responsibilities:

• SMEforPower BIand work extensively on Confidential Business Intelligence stack and Oracle SQL Developer with web-based application tools.
• Implement reports usingREST APIsandReal - time streaming data setin Power BI report, which helps the business needs to see the live data.
• Develop web-based application tools which helps the business to run their operation process smoother.
• DevelopingPower Appsto help the business and customer to manage the organization data to run their process much smoother than ever using mobile phones or even on browsers.
• Migrating from existingTableau,SAP Crystal reportsintoPower BI.
• SAS programs for handling large / longitudinal data / transactional data
• Creating / modifying / updating SAS ODS/ Reports
• CreatedConfidential Flowfor Approvals, complicated processes and automated the process for the business using triggers and actions.
• Developing customized reports by usingSAP Crystal reports2013 tool and publishingand maintaining the reports.
• Developed integration ofPower BIreports intoPower Appsand interacting the data by visuals throughPower Appsand modifying the existing records in real time accordingly.
• Created Workspace and Apps inPower BIand giving access to end users to Apps.
• Designed aPower BI Data Modelwith multipleFact TablesandDimensionsdepending on the business requirements.
• Wrote complex Measures in Power BI depending on the requirement usingDAXqueries.
• Experience in Custom Visuals and Groups Creation inPower BI.
• Wrote complexT-SQLqueries to achieve the Business requirement.
• Managing / monitoring/ trouble shooting batch SAS programs
• Training the LPSD Group Business users to use Power BI tool from End to End and make them to build their own reports.
• Created a Training Documentation for the End Users.

Confidential, Orlando, FL

ETL/MSBI/Power BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Involved in different stage of System Development Life Cycle from defining, designing and developing the new system to testing evaluating and maintaining the system.
• Working with different business users to adopt the data visualization -Power BIin the Organization and get insights from the data.
• Work with the technical Team to gain a good understanding of the database models used forPower BIreporting.
• Design and development ofETLpackages to load the data into Marts implemented to performcleansing,mapping,profilingandwhole governanceon a real time process.
• Experience in creatingSQL data models/QueriesforPower BIandAd-hocReports.
• DevelopPower BIreports & effective dashboards after gathering and translating end user requirements.
• Experience in writingstored proceduresandfunctionson numerousSQL server.
• Extensively used different transformations i.e., looping, data formatting, check points, error handling, email notification inSSISpackages
• Involved in completeSSISlife cycle in creatingSSISpackages, building, deploying and executing the packages in both the environments (DevelopmentandProduction).
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) fromExcelandFlat filetoMS SQL Server.
• DesignedSSISpackages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2014.
• Writtenstored proceduresand used them inSSISpackages.
• Used various Transformations inSSISDataflow, Control Flow using for loop Containers and Fuzzy Lookups and ImplementedEvent HandlersandError HandlinginSSIS packages.
• Built aTabular Modelcube from scratch data and byMDXqueries fetched data toSSRSandPower BIreports.
• Designed aData Modelwith multipleFact TablesandDimensionsdepending on the business requirements.
• Responsible for building reports inPower BIfrom theScratch.
• Experience in Custom Visuals and Groups Creation inPower BI.
• Responsible for creating and changing the visualizations inPower BIreports andDashboardson client requests.
• Used to connect different data sources likeSQL DB(SQL Query),Tabular Model(DAX Query), Web Trends toPower BIand generate reports with differentvisualizations.
• Created CalculatedColumnsandMeasuresinPower BIand Excel depending on the requirement usingDAXqueries.
• Created reports by using Joins in multiple tables from multiples database using complexSQLqueries.
• WritingMDXqueries to get the data from a tabular model.
• Has extensively doneData profilinganddata quality analysis.
• Design and development ofSSASTabular cubes to satisfy the end user reports by creating different types of Reports and Dashboards inPower BI.
• Created complicatedDAXmeasures in thePower BIreports as per the requirements of the Business Users.
• Experience in ImplementingPerformance testingandLoad Testing.
• Involved inBug/Root CauseAnalysis and providing theresolution.
• Worked on Identifying the slow runningad-hocreports and came up with the performance improvements.
• Implemented the test automation suite inC#which helped the test team to enforce high quality testing and effort saving.

Environment: MS Visual Studio 2015, Power BI, SSAS (Tabular), SQL Server Management Studio 2016, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS SharePoint, GIT Hub.

Confidential

SQL Server DBA/MSBI Developer

Responsibilities:

• Developed backup restore scripts for MS SQL Server as needed.
• Upgraded to latest version from MS SQL server .
• Responsible for Disaster recovery and database maintenance plan.
• Designed and implemented data access stored procedures and automating tasks.
• Performed Job scheduling and alerts.
• Optimized queries and performances using varies MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution plan and Index tuning wizard.
• I have created packages to extract data from Source to Destination using various tasks and transformations
• I have involved in Creating packages to implement Business Logic
• I have involved in Cleansing the data using SSIS Packages
• I have involved in Creating Packages to Extract data from Source to Staging database and from Staging database to Data Warehouse
• I have involved in Unit Testing as per test cases

Environment: SQL Server 2000/2005 Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSRS.