SUMMARY

• Over 7 years of experience in implementing and developing various BI applications using wide range of BI tools.
• Experience in developing the data visualizations using Microsoft Power BI, Tableau, Qlik view, SQL Server
• Experience with all phases of software Development Life Cycle (SDLC) and Agile Methodologies.
• Experience in writing SQL commands, developing and writing new database objects such as tables, views, indexes, complex stored procedures, triggers, locking issues, BCP, common table expressions (CTEs)
• Involved in Business Analysis of the OLTP and OLAP data and in decision support with extensive database programming.
• Experience on end - to-end implementation of Oracle DRM and maintenance of metadata of various upstream and downstream systems
• Hands on experience in both Relational and NOSQL database management using tools like, Microsoft SQL Server, Oracle SQL, Mongo DB.
• Developed T-SQL scripts for performing automation tasks, performed stored procedures and SQL queries and User Defined Functions.
• Worked in implementation of both Agile and Waterfall methodologies.
• Experience in transforming and validating data using SSIS transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Proficient in creating objects such as stored procedures, views, triggers, user defined functions, cursors, derived tables, common table expressions (CTEs) and complex queries on Microsoft SQL Server.
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.
• Experience in Data Modelling, Database design, normalization techniques using Database diagrams, Erwin and other Data Modelling tools.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse and Azure Storage Explorer.
• Involvement in developing reports and dashboards from multiple data sources such as on premises and cloud using Power BI Desktop.
• Experience in combining data from different sources by using power query.
• Assist end users with problems installing the power BI desktop, installing and configuring the On-Premises gateway, connecting to data sources and adding different end users.
• Experience in transforming and validating the data using SSIS transformations like conditional split, lookup, merge join, sort and derived column.
• Performed Data migration using tools like Data import/export, bulk insert and BCP between the SQL Server.
• Maintained the log and audit information in SQL tables, experienced in providing logging, Error handling by using event handler and SSIS packages.
• Created different Power BI reports and dashboards from multiple data sources using data blending.
• Responsible for creating requirements documentation for various projects.
• Experience in database development and release management concepts, practices and procedures along with performance turning database code in OLTP and OLAP environments.
• Involved in Coordinating meetings with the product committee, project manager, and functional management to discuss project impediments and completion of the tasks.
• Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, Mac.

Languages: JAVA, PYTHON, SAS

Web Development: HTML, CSS, XML, DHTML, SOAP, API Testing, JavaScript, PHP, JENKINS, VB SCRIPT

Databases: SQL Server 2014/2013/2012 , MS Access, T-SQL, Oracle 11i/12c

Reporting Tools: JIRA, Bugzilla, Quality Center, ASANA

Web Servers: Microsoft IIS 7/8.0, Apache, Postman

Design Concepts: Design Patterns, UML, VISIO

IDE: Visual Studio 2015. Eclipse.

Version control: Visual Source Safe, Team Foundation Server, GIT

Front End Libraries: JSON, Angular JS, Bootstrap.

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Power BI Developer

Responsibilities:

• Developing the high-level test matrix based on the business requirements, functional and technical specifications for the assigned projects.
• Gathering the data from various external sources into data ware housing system with the help of ETL process.
• Designing the database by adding tables, creating stored procedures, views and performance turning of SQL queries and stored procedures.
• Developing the test cases based on the test matrix including the test data preparation for data completeness, data transformations, data quality, performance and scalability.
• Transform the data into user friendly visualization to give business users a complete view of their business using Power BI.
• Developing various solution driven views and dashboards by different chart types including pie charts, bar charts, tree maps, circle views, line charts, area charts, scatter plots in Power BI.
• Use various sources to pull data into power BI such as SQL, ORACLE etc.
• Perform certain operations like fetching data from different file using a query editor in Power BI
• Develop SSIS packages that can extract data from various sources and merge into only one source for Power BI Reports.
• Create Power BI reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Develop reports to visually explore the data and create an interactive report Excel and Power BI
• Create reports from importing, direct query and live data from several data sources.
• Explore the data in various ways and across multiple visualizations using Power BI.
• Develop SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Involve in Data Migration using SQL, SQL Azure, Azure Storage and Azure Data Factory, SSIS PowerShell
• Perform data quality analysis using advanced SQL skills and extensive SQL querying on staging, Data warehouse and Data Mart.
• Merge queries and append queries, remove columns and split columns choosing required columns in the data.
• Create and deploy cubes in star and snowflakes schema. Performed and worked with dimensions measures, MDX queries.
• Implement copy activity, custom Azure Data Factory Pipeline Activities.
• Contribute to the development of knowledge transfer documentation.
• Involve in troubleshooting, resolving and validating data to improve the data quality.
• Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.
• Work in Agile methodologies with daily scrum calls, sprint planning and retrospective meetings.

Confidential - Washington DC

Power BI Data Analyst and SQL Developer

Responsibilities:

• Gathered and documents the business requirements for analytical reports. Participated in the requirements meetings and data mapping sessions to understand the business needs, Identified and documented detailed business rules.
• Implemented and delivered the MSBI platform solutions to develop and deploy ETL, analytical, reporting on SQL Server using SSAS, SSIS, SSRS
• Integrated the custom visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support power BI and SSRS reports.
• Worked with the Microsoft team on product limitations and communicate limitations and tool capabilities to the business stakeholders.
• Converted the existing Azure Data factory V1 to Azure Data Factory V2 and implemented SSIS package in Azure environment using Integration Runtime(IR).
• Developed complex calculated measures using Data Analysis Expression Language (DAX)
• Maintained log information in Text file to tracking errors and recording package execution status. Created configurations, checkpoints and breakpoints.
• Generated Ad-hoc reports in Excel power pivot and shared them using Power BI to the decision makers for strategic planning.
• Gave application demos to customer and other teams at the end of every sprint.
• Created stored procedures and performed index analysis for slow performing SSRS reports to bring down the report rendering time from 15min to 30 seconds.
• Expertise in generating reports using SQL Server reporting services and MS Excel Spreadsheet and power pivot.
• Developed custom calculated measures using DAX in Power BI to satisfy the business needs.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Confidential - California

SQL Developer/Power BI

Responsibilities:

• Used T-SQL queries and views based on business reporting requirements, performance tuning and various complex SQL queries optimization.
• Created DTS packages to transfer the data from Oracle to SQL Server.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading the data into database.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Hosted SSIS, SSRS, knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel power pivot and shared them using Power BI to the decision makers for strategic planning.
• Created and maintained various subscriptions in the Report Manager for the Reports.
• Performed Data profiling, data analysis to identify the legacy data that needs to cleanse prior to the migrations using SSIS data profiling task, data profile viewer, and T-SQL queries.
• Understood the existing ETL and relational database frameworks and scheduled packages using SQL Server agent jobs.
• Designed high level ETL architecture for overall data transfer from the source server to the enterprise services warehouse.
• Involved in creating database objects using stored procedures, triggers, functions, views and T-SQL joins using T-SQL.
• Hands on Experience working with SSIS, for ETL process ensuring proper implementation of event handlers, loggings, checkpoints, transactions and package configurations.
• Experience in creating multidimensional cubes using SSAS and designing DW schemas.