SUMMARY

• Highly motivated SQL server/BI Lead around 9 years of IT experiencehaving multiple skill set and extensive working experience indata warehousing and Business IntelligenceTechnologies wif expertise in SQL Server development,MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BIfor building, deploying and managing applications and services through a global network of Microsoft - managed data centers.
• Experienced in client requirement analysis, physical, logical design, development, debugging, testing, deployment, support and maintenance of business applications usingPower BI, SQL, SSIS and SSRS.
• Expert database engineer, NoSQL and relational data modeling using Microsoft Sql Server.
• Expertise in writing complex DAX functions inPower BI and Power Pivot.
• Implemented several DAX functions for various fact calculations for efficient data visualization inPower BI.
• Strong development skills wifAzure Data Lake,Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
• Use Azure SQL Database connector to connect toAzureSQL Database, Select teh appropriate Azure server and database to query teh data.
• Having good noledge on Teradata architecture, database features and Teradata tools.
• Used SQL Loader to load data from legacy system (CORE) and developed PL/SQL programs to dump teh data from teh staging tables to teh interface tables and concurrent programs to get data into oracle base tables.
• Extensive noledge of data warehouse methodologies.
• Hands on Experience in optimizing teh queries by creating various clustered, non-clustered indexes and indexed views.
• Proficient in creating objects such asStored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Querieson Microsoft SQL Server.
• Worked in Implementation life cycles of bothAgile and Waterfall Methodologies.
• Experience at Transforming and validating data usingSSIS TransformationslikeConditional Split, Lookup, Merge Join, Sort and Derived Column.
• Extensive noledge inTuning T-SQL queries to improve teh database performance.
• Designed and developed newETL/SSISpackage that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.
• Expertise in using DAX and generated dashboards & reports and integrating wif PowerApps
• Designed and deployed various SSIS projects using SQL to integration services catalogs and scheduled them.
• Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL in SSRS.
• Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
• Developed application in PowerApps usingCommon Data Service CDS, Flow, Excel, Forms and SharePoint online.
• Good noledge of defining, developing and deployingStar Schema, Snow flake Schema and Dimensional Data modellingusing MS SQL Server 2005 Analysis Services (SSAS) on EDW.
• Experienced in SSAS Tabular data modeling.
• Built adatawarehouseonSQL Server&Azure Database.
• Involved in importing data from large RDBMS systems to Hadoop using Sqoop.
• Hands on Experience working wifAzure Data Lake Analyticsto analyze teh structured, non-structured data from various sources.
• Created differentPower BI reportsutilizing teh desktop and teh online service and schedule refresh.
• Assist end users wif problems installing thePower BI desktop, installing and configuring teh Personal and On-Premises gateway, connecting to data sources and adding teh different users.
• Assisted customer in configuring and troubleshooting their row-level security for Power BI.
• Created different visualization in teh reports using custom visuals likeBar Charts, Pie Charts, Line Charts, Cards, Slicers,etc. Also, using different transformation inside edit query into clean-up teh data.
• Experienced in developingPower BIreports and dashboards from multiple data sources using data blending.
• Hands on experience working wif to analyze teh structured, non-structured data from various sources.
• Support teh business users and resolved issues pertaining to all teh supply chain management and distribution modules after go-live.
• Involved inperformance tuningby checking teh loads onIndexesby usingsql profilerandTuning advisor.
• Excellent noledge of all teh phases of Software Development Life Cycle (SDLC).
• Involved in keeping teh team focused and on track and also established meeting times, places and agendas.
• Excellent written and verbal communication skills and ability to translate technical concepts into business language and business language into technical requirements.
• Involved in coordinating meetings wif teh product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing teh task.

TECHNICAL SKILLS

BI tools: Tableau (2019.2/10.2/9.3.5/8.2 ), Tableau Server, Power BI, Looker

Databases: Oracle, DB2, SQL Server, My SQL, Teradata, Hive, PostgreSQL.

ETL: Alteryx designer, SSIS

Operating Systems: Unix/Linux, Windows7/XP.

Other Tools: MS-Office suit (Word, Excel, Power Point)

Programming: T-SQL, PL/SQL, C, C++, Java

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. SQL/Power BI Lead Consultant

Responsibilities:

• Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) wif teh help of ETL process.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.
• Developed various solution driven views and dashboards by developing different chart types includingPie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Developed various dashboards to no theschool climate, school safety, risk factors, and risk behaviors.
• Created dashboard forschool system financial informationwhich includesrevenue and expenditure by district.
• Developed customGeorgia district map visual,teh SVGis written inline wifin a Bootstrap 2 container.
• Written some Java script plugin that makes teh polygons work like hyperlinks.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business usingPower BI.
• Written complex DAX functions inPower BIand Power Pivot like COUNT(), SUM(), RELATED(), LOOKUPVALUE(), RANX(),CALCULATE(),etc
• Used various sources to pull data intoPower BIsuch as SQL Server, oracle.
• Involved in installation ofPower BI Report Server.
• Developed reports to visually explore data and create an interactive reportExcel and Power BI.
• Using a query editor inPower BIperformed certain operations like fetching data from different file.
• Createdgroups, content packs.
• Created teh KPI to show teh difference between actual and forecast data.
• Working wif import and direct query, creating custom table in thePower BI.
• Merge queries and append queries, remove columns and split columns, choosing required columns in teh data.
• By using Power BI desktopconnected to various data sources, working wif different visualizations.
• Developed and published reports and dashboards usingPower BIand written TEMPeffectiveDAXformulas and expressions.
• Utilized Power QueryinPower BItoPivot and Un-pivotthe data model for data cleansing and data massaging
• Created several user roles and groups to teh end - user and providedrow level securityto them.
• Created Power BI Reportsusing teh Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Worked on importing custom visualizations.
• Worked wiftable and matrix visuals, worked wif different level of filters likereport level, visual level filters, page level filters.
• Used various data visualizations wifPower BI.
• Created reports utilizingSSRS, Excel services, Power BIand deployed them onSharePoint Serveras per business requirements.
• Designed different types of KPI's for percentage growth in different fields and compared over teh period of time and designed aggregations and pre-calculations in SSAS.
• Involved in designing partitions in cubes to improve performance using SSAS.
• CreatedTabular modelreports to slice and dice huge volumes of data.
• UsingTabular modelprovided more security to data atRow level.
• MDX programming,DAX expressions, analysis and business forecasts.
• Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.
• Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud usingPower BI desktop.
• Creating reports from importing, direct query and live data from several data sources.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.
• Experience in combining data from different sources by using ofpower query.
• Experience wif, power pivot and dashboard designer.
• Troubleshoot and support reports inPower BI workspaceswhenever there are issues in production.

Environment: MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Oracle 11G, SQL Profiler, T-SQL, Power Bi Desktop, Power Bi pro, Visual Studio 2010, HTML5, Java Script.

Confidential, Virginia

Sr.Power BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures and triggers.
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using power pivot, power query, power view.
• Designed and developedPower BIgraphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports inExcel Power Pivotand shared them usingPower BIto teh decision makers for strategic planning.
• Gathering teh requirements and writing teh ad-hoc SQL query batches to update teh data and metadata for delta and history loads.
• Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created data marts and multi-dimensional models like Star schema and Snowflake schema.
• Implemented severalDAXfunctions for various fact calculations for efficient data visualization inPower BI.
• Designed complex data intensive reports inPower BIutilizing various graph features such as gauge, funnel for better business analysis.
• Extensive use ofDAX(Data Analysis Expressions) functions for teh reports and for teh tabular models.
• Designed/Developed table driven ETL process wif Perl and shell scripts, which in turn calls OWB mappings, Informatica oracle code to loadEDW.
• CreatedPower BI reportsby using Joins in multiple tables from multiples database using complex SQL queries.
• Designed aPower BIdata model wif multiple fact tables and dimensions depending on teh business requirements.
• Experience in custom visuals and groups creation inPower BI.
• Experience inscheduling refresh of Power BI reports, hourly and on-demand.
• Apply teh Business rules on teh data coming from multiple operating companies. Maintain teh business rules in a table for visibility to all required processes to develop Power BI reports & TEMPeffective dashboards.
• Load teh processed data into final view point centralized DWH for further Power BI reporting.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Working experience wif column store indexes, table partitioning inSQL SERVER 2012.
• Working experience wif in-memory concepts of OLTPdatabases inSQL SERVER 2014.
• Hands on experience working wifSSIS, for ETL process ensuring proper implementation ofevent handlers, loggings, checkpoints, transactions and package configurations.
• Designed high level ETL architecture for overall data transfer from teh source server to teh enterprise services warehouse.
• Worked in creating complex stored procedures,SSIS packages, triggers, cursors, tables, and viewsand other SQL joins and statements for applications.
• Generated reportsusing global variables, expressions and functions.
• Configured reporting services in SQL Server 2008.
• Created different power pivotreports as per teh client requirement.
• Gathered data and visual requirements from business users to deliver TEMPeffective reports, dashboards and analytics.
• Involved in implementing Key Performance Indicator(KPI) Objects inSSAS2008. Create Calculate member inMOLAPcube usingMDXin SSAS.
• Implemented several DAX functions for various fact calculations for efficient data visualization inPower BI.
• Experience in designing, building teh dimensions, cubes wif star schemausingSQL Server Analysis Services (SSAS)for analyzing purpose.
• Performance tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, cte’s, redesigning schemas and many more.
• Also, went through query execution plans, sql profilers and did query optimization.
• Expertise in generating reports usingSQL Server Reporting ServicesandMS Excel spreadsheetsandPower Pivot.
• Involved in performance tuning using indexing (Clustered Index, Non-Clustered Index) tables.
• Created differentPower Pivotreports as per teh client requirement.
• Converted teh existingAzure Data Factory V1toAzure Data Factory V2and also implemented SSIS package in Azure environment usingIntegration Runtime(IR).
• Done configure diagnostics, monitoring and analytics on Azure platform along wif scale and resilience for Azure websites.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Worked closely wif teh team in meeting teh deadlines pertaining to design and development deliverables.

Environment: MS SQL Server 2008R2, T-SQL, SQL Profiler, Visual Studio (2012), Power Bi Desktop, Team Foundation Server (2012), MS Analysis Services 2005, MS Reporting Services, MS Access, Import & Export Data, Oracle Warehouse Builder, Power Bi Desktop, Power Bi pro, Source Control Management System Windows XP, Index Tuning Wizard.

Confidential, Atlanta

SQL-MSBI-Power BI Developer

Responsibilities:

• Optimized teh performance of queries wif modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficientstored proceduresto perform data cleansing and loading task when data is loaded into staging area.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into teh database.
• MigratedDTS packagesfrom SQL Server 2000 to SQL Server 2008 asSSIS Packages.
• C reated efficient, robust SSIS packages for data movement and loading wif error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access intoSQL Server 2008usingSSISPackages inBusiness Intelligence Development Studio.
• CreatedSSIS packagesto validate, extract, transform and load data to data warehouse databases.
• Extensively worked wifSSIStool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split,Lookup, Aggregator, Multicast and derived Column.
• Wrotestored proceduresandUser Defined scalar Functions (UDFs)to be used in theSSISpackages andSQL scripts.
• B uilt connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Deployed SSIS Package into Production and usedPackage configurationto export various package properties to make package environment independent.
• ImplementedEvent handlers and Error handlingin SSIS packages and notified process results to various user communities.
• Tested, cleaned and standardized data meeting teh business standards using fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes error handling andSlowly Changing Dimensions.
• Worked on database Compression for different databases to save space across different environments.
• Hands on experience in managing Azure Storage Accounts.
• Wrote many stored procedures for cleaning, manipulating and processing data between teh databases.
• Extensively usedJoinsandCommon table expressionsto simplify complex queries involving multiple tables
• Developed complexstored proceduresand views to generate variousdrill-throughreports,parameterizedreports andlinkedreports usingSSRS.
• Created differentPower Pivotreports as per teh client requirement.
• Experience in creating multidimensional cubes usingSSASand designing DW schemas.
• Enhanced teh functionality ofOLAP Cubeby creatingKPI, Actions and Perspective from huge dataset usingSQL Server2008 Analysis Services(SSAS).
• Worked on filtered views and Base table integration between different Source systems.
• UsedVisual Studio 2008as Source Control, to maintain drop location to test, all docs and scripts.
• Wif teh help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status.
• Scheduled teh packages inSQL Server Agenton daily/weekly/monthly basis.
• Document newSSISpackages and train senior analyst on basic SSIS concepts.
• Interacted wif vendors, developers and customers to manage teh business requirements.
• Createdpig scriptsto teh files landing in blobs to position teh fields according to teh third- party requirement.
• Extensive noledge and hands on experience in azure data warehouse, data lake and data factory,U-SQL.
• Verified business requirements and functional specifications.

Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle, MS SQL Server Management Studio SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Pig, Azure, SQL Profiler, T-SQL, Power Bi Desktop, Data Warehousing, Data Transformation Services (DTS).

Confidential, Kansas

SQL/MSBI/ETL Developer

Responsibilities:

• Gathering requirements from business users and converted data to build rich dashboards.
• Conducted brainstorming session wif business users to clarify any questions wif respect to teh requirements.
• Involved in teh complete life cycle of teh project and in teh data analysis process.
• Worked wif various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs
• Worked closely wif business users, interacted wif ETL developers, Project Managers and members of QA teams.
• Created actions filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Administered user, user groups and schedules instances for reports in Tableau.
• Worked extensively wif advance analysis Actions, Calculations, Background images, Maps.
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc
• Defined best practices for tableau report development and TEMPeffectively used Data Blending feature in Tableau.
• Developed Tableau data visualization using cross tabs, heats maps, scatter plots, geographic map, pie charts, bar charts.
• Working extensively using Excel to validate teh data and use as teh source data files.
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Created Drill-through reports, parameterized reports and linked reports using SSRS and were integrated in teh Performance point server.
• Analyzing teh data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Used Erwin for developing data model and forward engineer teh data model.
• Conducted data validation to ensure data quality.
• Involved in User communication for requirement gathering and Change control and code control policies and procedures.

Environment: Tableau Desktop, SQL Server, DB2, Oracle, Microsoft Excel, Hive, MS Access.

Confidential

Business Data Analyst

Responsibilities:

• Identifying new and existing bugs and wrote test cases.
• Manually tested teh web application to ensure teh flow of teh application functionality
• Performed Black Box, Negative, Regression, and Integration & Security Tests Using manual testing techniques
• Performed XML validation and testing
• Performed backend testing to validate teh data using SQL queries
• Performed negative and positive testing using SQL queries
• Performing UAT Regression Testing after each build during SDLC
• Setting up projects in Quality Center, writing test cases, executing them and performing bug tracking
• Documented bugs found out during teh process of testing
• Testing Applications built wif SOA by sending request and waiting for responses
• Executing test cases manually to verify teh expected results
• Mentoring and building skills in more junior members of teh QA team
• Set-up, co-ordinate & conduct system & UAT testing wif Business Analysts and end-field users after teh applications were all set
• Participated in weekly status report meetings
• Database querying in both OLTP and OLAP RDBMS systems

Environment: .Net, Windows, MS Office Suite