SUMMARY

• 6+ 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, 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, 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, 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, Tampa, FL

SQL BI Developer

Responsibilities:

• Extracted data from various sources likeSQLServer2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
• Developed free-form reports using reports using MS-SSRS tool for consulting multiple reports into single report delivered in .pdf format to the power users.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Worked on SSIS (DTS, DTSX) packages for Data Integration Services. Used SSIS to produce a Data Mart for reporting.
• Extensively used System variables and created User-Defined variables for SSIS packages.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and developed them onserverusingSQLServerReporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data usingSQLServer Reporting Services (SSRS).
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.
• Created reports using stored procedure and experience in building reports on Analysis Services cubes (SSAS).
• Worked with Report Builder 2.0, Report Models and Ad Hoc reports and worked with Tableau desktop, Tableauserverand Tableau reader in various versions of Tableau.
• Managing the ReportServercontents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQLServer2012/2008 R2 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS. SSAS, OLAP, XML, SharePoint, Agile, Visual Studio 2010, .Net Framework 3.5, Window 8