SUMMARY

• Over all 6 years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications, Designed and developed Analytics solutions using TIBCO Spotfire, SQL, Power BI, Tableau, PL/ SQL, MS SQL, SQL *FORMS, SQL Server, Business Intelligence through SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS).
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Worked extensively on TIBCO Spotfire, Tableau and Power BI reports
• Expert on creating multiple kind of Power BI Reports and Dashboards
• Strong Knowledge in Data Analytics tools such as Power BI, Tableau, Spotfire, QlikView etc.
• Created, Maintained & scheduled various reports in Power BI.
• Proficient in all phases of SDLC (analysis, design, development, testing and deployment) and highly competent in gathering user requirements
• Published Power BI reports from Power BI desktop to Power BI service.
• Created different visualization in Power BI according to the requirements.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Worked on designing dashboard / reports to give them consistent and professional looks using TIBCO Spotfire Professional/Power BI / Tableau
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
• Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Excellent hands-on experience in groups, hierarchies, and measures, KPIs
• Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, for Analytical Projects and Data Visualization Community.
• Expert in working on all phases of Data warehouse from gathering requirements to testing, implementation, and support.
• Experience in creating complex Spotfire dashboards and visualizations by using the key concepts filtering scheme, data on demand, Property Controls, text areas in TIBCO Spotfire reports using Tibco Spotfire Professional, Installation of Tibco Spotfire server, Administrative tuning and monitoring the server.
• Excellent knowledge in Performance tuning methodologies Confidential a database level, ETL, and Report Level.
• Proficient in the ER-Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model.
• Excellent knowledge of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modeling and reporting tools.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Expert in Creating, configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL profiler Monitoring tool.
• Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.
• Optimized all major relational database and datawarehouse and accessed multidimensional databases and flat files using SSIS.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Expert in generating reports using SQL Server Reporting Services (SSRS).
• Proficient in SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Expertise in DAX & MDX Languages which helps in understanding and analyzing the data.
• Worked in all the products in Power BI such as Power BI Pro, Embeded, Premium, Power BI Mobile...
• Proficient in implementing surrogate key generation strategy in the Data warehouse.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Data Warehousing/BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, Power BI, Tableau, Spotfire.

RDBMS/DBMS: SQL Server, MS SQL SERVER 2005/08/12, ORACLE 9i/10g, MS Access.

Database tools: Management Studio, SQL Profiler, Database Tuning Advisor, Query Analyzer, DTS, Performance Monitor, Client Configuration Utility, Server Configuration Utility.

Programming Languages: C#, .net, VBScript

Protocols / Middleware: TCP/IP, HTTP, FTP, UDP/IP, DOM, ODBC

Visualization Tools: Power BI, Tableau, Spotfire, Power Pivot

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Power BI Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Designed SSIS packages for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, and OLEDB supported databases.
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for POWER BI Report Deployments
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Published reports to Azure-based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Written stored procedures and used them in packages.
• Implemented Event Handlers and Error Handling in SSIS packages .
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Built a Tabular Model cube from scratch data and by DAX queries fetched data to SSRS and Power BI reports.
• Extensive use of DAX expressions in tabular models as per business requirements.
• Extensive use of perspectives and hierarchies in models to efficiently serve reporting needs.
• Responsible for building reports in Power BI from the Scratch.
• Experience managing Big Data platform deployed in Azure Cloud
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse, Azure Blob, Azure Storage Explorer
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Worked on various Conditional formatting in power bi visuals to define the data in appropriate way.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing
• Developed different types of reports such as Descriptive, Predictive, Prescriptive for end-users.
• Created Drilldowns, Drill throughs and Bookmarks in Power BI Reports for easy navigation and storytelling.
• Created Dynamic Dropdown measures in slicer with the help of DAX in Power BI Desktop.
• Developed and deployed reports for the internal users in Power BI Report Server.
• Implemented DAX Time-intelligence functions SAMEPERIODLASTYEAR, PREVIOUSYEAR, PREVIOUSQUARTER to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: MS SQL Server 2017, SQL Server Integration Services 2017 (SSIS), SQL Server Analysis Services 2017 (SSAS Tabular), SQL Server Reporting Services (SSRS), Power BI Desktop & Service, DAX, Azure, T-SQL, Microsoft Visual Studio 2017,DAX STUDIO, TFS, MS Excel.

Confidential, Nashville, TN

MSBI / Power BI Developer

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on daily basis.
• Create reports in Power BI utilizing the SSAS Tabular via Analysis connector as Data Source.
• Expert in developing multiple kind of Power BI Reports and Dashboards.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service & Report Server.
• Explore & Analyze data in a Variety of ways and across multiple visualizations using Power BI.
• Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Created Dashboard Reports using Power BI and Tableau .
• Primarily involved in Data Migration using SQL, SQL Azure, Azure Storage, and Azure Data Factory, SSIS, and PowerShell. Created processes 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.
• Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI.
• Developed many Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.
• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data.
• Worked on both live and import data to Power BI for creating reports.
• Worked with Power BI gateway to schedule daily job to refresh data
• Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server using Direct Query.
• Managed relationship between Power BI using Schemas such as Star & Snowflake.
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
• Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.

Environment: MS SQL Server 2014, SQL Server Integration Services 2014 (SSIS), SQL Server Analysis Services 2014 (SSAS), SQL Server Reporting Services (SSRS), DAX, T-SQL, Microsoft Visual Studio 2014, JIRA, Import/ Export Tools, MDS, DQS, Power BI Desktop, TFS, Tableau, MS Access.

Confidential, Memphis, TN

Sr. Consultant

Responsibilities:

• Created complex Spotfire dashboards and visualizations by using the key concepts filtering scheme, Data on Demand, property controls, Text Areas TIBCO Spotfire reports using Tibco Spotfire Professional.
• Handled Designing and developing the information links, Data Source, Columns, Joins, Filters and Procedures in TIBCO Spotfire.
• Configuring and Managing Scheduled updates for the analysis, managing user roles, supporting deployment process In Spotfire.
• Proficient in designing multiple enterprise level Spotfire Analytical solutions.
• Developed Cross table, Bar chart, Pie Chart, Tree map and complex reports that involves Property Controls, Custom Expressions, information links with different data sources, SAS, ORACLE, SQL SERVER, Excel and Flat Files.
• Giving access to new users and maintaining Spotfire's servers.
• Worked with users on how to use Spotfire as an analysis tool including training as well as collaborating on report generation.
• Developed effective data mapping and SQL scripts using Spotfire for efficient data extraction
• Designed Spotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Worked on designing dashboard / reports /applying Geo map to the data In Spotfire to give them consistent and professional looks using TIBCO Spotfire Professional.
• Responsible for TIBCO Spotfire platform administration tasks, TIBCO Spotfire database administration tasks, and providing production and operational systems support to Clients and Stakeholders
• Responsible for TIBCO Spotfire Administration activities, Installing, configuring, user/group, library, server management etc.
• Managed TIBCO Spotfire Web player to conduct user acceptance testing for several business reports
• Formulated dashboard specifications and generated status reports.
• Documented and maintained practices for system installations and configurations
• Worked extensively on visualization properties and complex interactive features such as multiple markings, filtering schemes, configuring bar chart, line chart, graphical table, combination chart, scatter plot, pie chart, table, cross table, and summary table visualizations.
• Worked in close association with customers for requirement gathering and effective analysis.

Environment: Tibco Spotfire 7.5,7.6,7.7 Spotfire Web Player, Spotfire server, Servlets, Windows 2008 server, SQL Server 2008, Teradata

Confidential, Branchburg, NJ

Sr. Consultant

Responsibilities:

• Gathered business requirements and designed functional and technical requirements documentation.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
• Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end
• Understanding existing business model and User requirements.
• End to End development dashboard
• Performed exploratory and regression data analysis for multiple departments and assisted in business decision making
• Data analysis, Data visualization, Machine Learning, Statistical programming
• Responsible for data analysis, validation, cleansing, collection and reporting
• Involved in installation and configuration of Spotfire
• Creating High end visualization using most advance technology with Spotfire
• Involved in Project planning, estimation, Sow creation and implementation of successful project.
• Worked on the Migration plan to move the Spotfire dashboards to Acceptance/Production and guide the end users to get the necessary access through the corresponding Active Directories.
• Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices
• Server Configuration and Installations of Spotfire
• Performed day to day administration for Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting
• Designing and Maintenance of the license
• Involved in creating database objects like tables, views, procedures, triggers and functions using T-SQL to provide definition, structure and to maintain data efficiently
• Development of dashboard using complex KPI/reports using SSRS and Power BI

Environment: Tibco Spotfire 6.5, 7.0 Windows 2008 server, SQL Server 2012

Confidential

SQL MSBI Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system.
• Worked closely with Business Analysts to produce all required documentation.
• Worked with Product Development Team to architect Database Design and strategy.
• Worked with Business Users to architect Data Warehouse strategy based on reporting, analytical and dishoarding requirements
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Created, insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Developed SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Ensures standards and best practices are established and met for consistent and accurate use of Tableau across the company.
• Responsible for Tableau administration, including user provisioning, server management, license administration, and version upgrades.
• Identify and raise system capacity related issues (storage, licenses, performance threshold)
• Performance, capacity & utilization monitoring
• Optimization and Performance tuning
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Published Power BI reports from Power BI desktop to Power BI service.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Created different visualization in Power BI according to the requirements.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Power Pivot Transformation, and Slowly Changing Dimension.
• Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert s cripts.

Environment: MS SQL Server 2012/2008, SSIS, T-SQL, C#, .NET, Visual Basic 6.0, ASP,Tableau, Performance Point, Data Analyzer, Visual Studio 2010, VB Script, MS Access, Excel, SQL Profiler, Windows 2007.