SUMMARY

• Over 8 years of IT experience in Database Design, Development, Implementation and Support using various Database technologies (SQL Server 2008/2012, 2016 T - SQL, Azure Big Data) in both OLTP, OLAP and data warehousing environments.
• Experience in designing and development of visualization reports using Power BI and Tableau using various relational database including Azure SQL DB.
• Experience as report developer using Power BI visualization tool in conjunction with ETL SSIS; designed, developed and published multiple interactive Power BI visualization report/dashboard in Azure environment.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and Data marts and Data warehouse.
• Superior SQL skills and ability to write and interpret complex SQL statements and also mentor developers on SQL optimization and performance tuning
• Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query/ T-SQL/MS excel.
• Hands on experience in utilizing Power BI DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Microsoft Power BI experience (Power BI, Power Pivot, Power Query, Power View). Experience with SQL, T-SQL, MD DAX
• Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau
• Hands-on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.
• Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data messaging.
• Coordinate with ETL on MSBI (SSIS, SSRS, SSAS) to extract, transform and load data into the target database.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Exposure of end to end SDLC and Agile methodology
• Have good problem solving, time management skills, communication skills, self-motivated, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS

BI Tools: SSIS, SSRS, SSAS, MicroStrategy, Power BI Desktop (2.5/2.6/2.7), Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.0/9.2 Tableau Server

Webservice Tool: Soap UI, Ready API, Rest Assured, Postman

Automation Tool: Selenium Web driver, Selenium Grid, Appium

Data Modeling: ERwin 9.5.2.

Databases: Teradata 15, Oracle /11g/10g, SQL Server 2014/2016, PostgreSQL 9.3

Cloud Platforms: Microsoft Azure

ETL Tools: Informatica Power Center 9.6.1, MS SSIS

Languages: C#, ASP.NET, VB.NET, JSON, PL/SQL, C++, C, Transact-SQL, UNIX Shell Scripting, SQL

Others Tools: MS Word, MS Access, T-SQL, TOAD, SQL Developer, Microsoft Office, Teradata SQL Assistant, Rally, JIRA, Control - M

Operating System: Windows 2000/2003/2008 Server, Windows NT, XP, Vista, Windows 7, 8 and 10.

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

SQL Power BI Developer

Responsibilities:

• Actively involved in the Analysis phase of the business requirement and reports/dashboards design.
• Coordinated with business users at various levels and call meetings during the different phases of projects to deliver successfully.
• Interacted with Business Analyst, Data Modeler and team Members within the organization to understand business processes, implement the logic.
• Validate and developed Meta Data for all developed reports in Microsoft Power BI Desktop.
• Coordinated with ETL team on data transformations using SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Installed SQL 2016 SQL server Database engine, SSIS & SSRS features in the Development environment as needed.
• Involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified.
• Generated context filters and data source filters while handling large volume of data.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Have used Z-order to overlap the reports on each other using Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• 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.
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques
• Created various views using Power BI (Tree maps, Scatter plot).
• Responsible for drafting documentation for describing the metadata and writing technical guides.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Created multiple data model and used as a common data source for the reporting purpose.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Improved performance by identifying the bottlenecks in Source table, recommended for creating index.
• Performed data validation, data profiling, data auditing and data cleansing activities to ensure high quality report deliveries·
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Performed Data profiling and analysis using complex SQL, data sitting into target tables.
• Performed detailed data investigation and analysis of known data quality issues in related databases through SQL.
• Used Visual Studio Team Services (VSTS) for version controlling, assisted in documentation, and creating data dictionary.
• Created effective Test Cases and performed Unit and Integration Testing to ensure the successful UAT.
• Prepared user training documented for smooth transaction to support team.

Environment: Microsoft Power BI 2.7x, SSIS, SSRS, SSAS, SQL Server2014/2016, Power BI Service, Power BI Gateway, Power BI Report Server, MicroStrategy, Visual Studio 2015, VSTS, C#, .Net, PowerShell, T-SQL, MySQL, AZURE SQL DB, Azure Storage Explorer, Azure Blob, Advance Excel.

Confidential, Florida

MSBI/SQL BI Developer (T-SQL, Teradata)

Responsibilities:

• Skilled in development and tuning of SQL queries, Stored Procedures, data extracts, Data analysis and query optimization, and other performance tuning.
• Write advanced SQL queries and stored procedures to perform complex database tasks using T-SQL and Teradata 14.0 and implemented best practices to maintain optimal performance.
• Design, develop, maintain support and test advanced SSIS packages across Dev/UAT/Prod environments.
• Worked on all types of transformations that are available in Power bi query editor.
• Created interactive reports customized for the business using Power BI Desktop.
• Created various SSRS Reports involving variety of features like Scorecard reports, Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Reports, and also involved in Dashboard reporting, Share Point with Power View tool etc.
• UsedTeradata utilities fast loadto load data.
• Installed and configured and maintained Power BI Report Server.
• Designed and developed SSAS tabular model for data analysis using DAX queries and also multidimensional cubes analyzing the transfer measures using MDX queries.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations.
• Created and developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Developed SQL queries using stored procedures, common table expressions, temporary table to support Power BI reports.
• Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis
• Design reports based on business requirements. Deploy the reports to Power BI Service Workspaces to create Dashboards for consumption by end users.
• Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Environment: Teradata SQL Assistant, Teradata Fastload, Teradata FastExport,SQL Server2008 R2/2012, MS SQL Integration Services 2008 R2/2012, MS SQL Reporting Services 2008 R2/2012, Visual Studio 2008, C#, web DEV(VB.NET), MS Excel Power Pivot,Power BI, Power Query,SQL Server Reporting Services (SSRS).

Confidential

SQL Server/ Power BI Developer(SSIS, SSAS, Power BI, Azure)

Responsibilities:

• Actively involved in the Analysis phase of the business requirement and reports/dashboards design.
• Interacted with Business Analyst, Data Modeler and team Members within the organization to understand business processes, implement the logic.
• Involved in ETL processes and develop source-to-target data mappings
• Coordinated with ETL team on data transformations using SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Read data from multiple sources like CSV/SQL Server 2016/AzureSQL DB through Power BI for creating Dashboards/ Reports.
• Generated context filters and data source filters while handling large volume of data.
• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Have used Z-order to overlap the reports on each other using Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Performed Data profiling and analysis using complex SQL, data sitting into target tables.
• Performed detailed data investigation and analysis of known data quality issues in related databases through SQL
• Created effective Test Cases and performed Unit and Integration Testing to ensure the successful UAT.

Environment: Microsoft Power BI 2.7x, SSIS, SQL Server 2016, Power BI Service, Power BI Gateway, Power BI Report Server, C#, VB.NET, Visual Studio, SQL Server 2014, MySQL, Azure SQL DB, Advance Excel, SQL, T-SQL, SSIS.

Confidential

MSBI Developer

Responsibilities:

• CreatedSSISpackages to automate the ETL processes included Meta data on record count, file size and run time
• Involved in Index Analysis and Performance Tuning.
• Worked on reconciliations of balances from different systems.
• Analyzed requirements with developers, business analysts and provided my inputs.
• Wrote and executed the test cases to perform System, Functional and Regression testing.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Wrote and edit SQL queries for database testing and reports verification.
• Experienced inETLData Warehousing, database testing using Informatica for Workflow process.
• Created SSIS packages, deployed on server and worked with DBA to run the package.
• Experienced in analyzing multidimensional cubes in SQL Server 2005 Analysis Services (SSAS) by using skills like slicing and dicing, drill down, drill up, and drill through.
• Written several complex SQL queries to validate the Data Transformation Rules for ETL testing.
• Worked on creating Run Book for the packages created to be executed.
• Worked on Star Team application to check in and check out the codes.
• Worked on creating Visio diagrams to explain the design process.
• Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment: SQL Server 2005, T-SQL, MDX, MS-Office, MS Access, Visio, Erwin