SUMMARY

• 8+ years of experience in Information Technology in System analysis, design, development, Implementation and maintenance of Data Warehouse project, providing Business Intelligence through Power BI Dashboards and Reports in SDLC and Agile environment.
• Extensive experience in Power BI development skillset including visualization development, use of parameters, and report optimization.
• Experience in working with ETL team on Data Migration using SQL, SQL Azure, Azure storage, Azure Data Factory, SSIS and PowerShell
• Worked with ETL team in Defining the transformation logic in the ELT (Azure Data factory) and SSIS
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Interacts with business user at various levels and coordinated meetings during the different cycles of the project.
• Strong knowledge of data warehousing methodologies and Agile methodology.
• Involved in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Generated context filters and data source filters while handling large volume of data.
• Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
• Have good experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI.
• Experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
• Experienced in Supporting end - user reporting using Power BI.
• Good understanding of the Data modelling (Dimensional & Relational) concepts like Star Schema Modelling, Snowflake Schema Modelling
• Experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS. Experience in testing and writing SQL statements.
• Hands on experience with MSBI (SSIS) to extract, transform and load data into database.
• Perform Data profiling and analysis of structured and unstructured data in Hadoop environment using Hive / HDFS.
• Part of the end user team where in gathered requirements and daily scrum meetings.
• Prepared projects, dashboards, reports and questions for all JIRA related services.
• Good experience in Migration of Reports & Packages in different environment.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Mastered the ability to design and deploy rich Graphic visualizations using Power BI and Tableau.
• In-depth knowledge on SQL queries and working with SQL Server 2014, 2016.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on data blending and increased the dashboard performance by extracting data.
• Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.
• Strong commitment to organizational work ethics, decision-making and managerial skills.
• Good communication and presentation skills work well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop 2.6, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.x/9.3 Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

ETL Tools: SQL Server Integration Services, Informatica

Databases: Oracle 10g/11g, MS SQL server 2014/16, Teradata 15, Azure SQL DB

Hadoop Ecosystem: HDFS, Hive

Operating System: Windows, UNIX

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

Others: TOAD, Oracle SQL developer, MS Office, FTP, Control-M, Teradata View Point, Teradata SQL Assistant, Rally, JIRA, GitHub, JSON

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr. Power BI Developer / MSBI Developer

Responsibilities:

• Participated in the user requirement gathering and Design meetings.
• Worked closely with Business Analyst, Data Modeller and all team within the organization to understand business processes.
• Read source data from Azure SQL DB, CSV, ORACLE, and SQL Server through Power BI.
• Read different formats of Source data from hive like JSON, ORC, and TXT.
• 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.
• 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
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• 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.
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Involved with ETL team on transformation logic in the ELT (Azure) and migrating the SSIS packages to Azure Data factory (V2).
• Closely worked with ETL to implement Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ELT processing
• Coordinated with ETL team on calling the procedures in Azure Data factory pipelines
• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes.
• Analyse source system data to assess data quality using SQL query.
• Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop, and implement enterprise-class data warehousing solutions.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Experiences in various types of tasks like to load source data in target using SSIS.
• Created Row level security so based on role, the end user can view the data.
• Analysing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Created no of views, calculated tables, calculated columns and measures.
• Hand on Experience in UNIX to write basic commands, Moving files from HDFS to local and vice versa.

Environment: Microsoft Power BI 2.6x, SSIS, SQL Server 2016, ORACLE 11g, SQL Developer, SQL Azure, Azure storage, and Azure Data Factory, PowerShell

Confidential, Plano, TX

Sr. Power BI Developer / MSBI Developer

Responsibilities:

• Requirement’s analysis and detailed functional design for the various blocks identified within the Perform data modelling using Star Schema to meet customer business and technical requirements.
• Designed, developed reports and Dashboard Reports in Power BI Desktop and published to Power BI Web and working Power BI Pro.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI
• UsedPower BItool to perform previously Excel done reporting to save time and energy.
• Worked on various types ofDAX functionslike Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions and text functions.
• Created graphical dashboards and reports inPower BI.
• Performed Row level Security to limit access to certain group or individuals.
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for Power BI service.
• Installation of Power BI desktop, version upgradation and patches installation in client computers
• Configured the "Firewall" settings at theAzureSQL Database server
• Performed Power BI administration tasks like configuration of governance policies, usage monitoring, provisions of licenses, capacities and organizational resources
• Expertise in creating Cell Level Security in cubes and Power BI Dashboard Reports to supporting end users using SSAS.
• As a Power BI and Cognos SME responsible for the design, development and production support of interactive data visualizations used across the company.
• Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
• Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
• Excellent SQL skills for daily testing of data using various SQL queries.
• Enhanced and deployed the SSIS Packages from development server to production server.

Environment: Microsoft Power BI 2.6x, SSIS, SQL Server 2016, ORACLE 11g, SQL Developer, SQL Azure, Azure storage, and Azure Data Factory, PowerShell

Confidential, Chicago, IL

Sr. Power BI Developer / Data Analyst

Responsibilities:

• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI.
• Building Ad-Hoc reports in Power BI depending on Business requirements is one of the major responsibilities.
• Used to connect different data sources like SQL DB (SQL Query), Tabular Model (MDX Query), Web Trends to Power BI and generate reports with different visualizations.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created bottom count, top count, cross join, non-ascendants, log MDX queries for creating Calculations and KPI’s on a cube.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Designed a Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
• Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts.
• Worked with Excel Power Pivot Tables.
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance. Create Parameterized SSRS Reports and PowerPivot Workbooks using data of Tabular model and Cube data model to prove the functionality of database
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop
• Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
• Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
• Created story using sequence of worksheets to convey information using Tableau.
• In Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.
• Blended data from multiple sources like SQL Server 2014, PostgreSQL, oracle 10g, Teradata into one report by selecting primary keys from each database for data validation.
• Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
• Used different functions like number, string, date, Type conversions, aggregate functions.
• Created performance recording to improve Tableau’s performance.
• Effectively used data blending feature in tableau desktop.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Wrote complex SQL queries to read data from source databases to analyses source system.

Environment: Tableau 9.1 (Tableau Desktop, Tableau Server, Tableau online), MS Office Suite, Oracle 10g, MySQL, UNIX, SQL Server 2014

Confidential, San Antonio, TX

Power BI Developer / MSBI Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing reports in Power BI.
• Built Data Analytics or visualization using Power BI (Power View integrated with Share Point).
• Worked with DAX/MDX queries in building expressions for various business calculations.
• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
• Involved in Developing Power BI visualizations and dashboards using Power BI Desktop.
• Created Grouping, sorting columns and writing expressions according to the business requirements.
• Transferred the data using SSIS packages.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• UsedSSISto createETLpackages to validate, extract, transform and load data toData Warehousedatabases.
• CreatedSSIS packages to Export data from text file to SQL Server Database.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• Generating Ad-Hoc reports on a timely basis and also to fulfill immediate requirements.
• Used star and snow flake schema in designing cubes for creating SSAS packages.

Environment: MS SQL Server 2008/2012 Enterprise Edition, MS SQL Server Reporting Services 2012, Power BI.

Confidential, Bloomington, IL

SQL (SSIS, SSRS, SSAS) Developer

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports.
• Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
• Involved in creating, deploying and configuring reports according to the requirements.
• Involved in writing scripts for the client’s requirements for generating reports.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers. Developed complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications using SQL server 2005.
• Involved in creating, deploying and configuring reports according to the requirements.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Fixed reports and bugs in stored procedures.
• Managed the security of the servers (Logins and users).
• Installed and Configured SQL Server 2005 Integration Services (SSIS) and Reporting Services (SSRS) for Dev and QA environments.
• Documented the flow of the project.

Environment: MS SQL Server 2000/2005, SSRS, SSIS, Project server 2007, Crystal Reports, HTML, VSS, Office 2007 bundle, Windows XP, Windows 2003 Server.

Confidential, McKinney, TX

SQL BI Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Knowledge of Database Performance monitoring tools
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis.
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: SQL Server 2005/ 2008, T-SQL Windows Enterprise Server 2003/ 2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2003, SFTP