SUMMARY:

• Leverage 10 years of information technology experience include 7 year of Tableau development, 3 years of Microsoft Business Intelligence tool Power BI, Business Analysis, Reporting experience and proven ability to identify business needs and deliver valuable solutions with accuracy and process efficiency. A career dedicated to create custom complex data analytics in Microsoft Power BI and Tableau Desktop to identify trends within quality data and find new sources of revenue within customer data. Consistently recognized for understanding and leveraging business analysis, data analysis, data migration, data transformation, data integration and providing quality reports in industries like retail, media, finance and health care.
• Willing to relocate: Anywhere
• Authorized to work in the US for any employer
• Solutions - driven Business Intelligence analyst/developer with experience leading cross-functional teams in the development, documentation and delivery of process innovations driving the attainment of business goals.
• 6+ Years of experience in business data analysis, database design, design quality evaluation, internal & external reporting, manual data collection, UAT, training, and development.
• 5+ years of experience developing Data visualization reports and dashboards with both Power BI and Tableau Desktop.
• Work closely with business users, SMEs, external stakeholders (clients), project managers, accounts managers, end-users, quality assurance, sales and marketing, training and IT personnel for gathering requirements, analyzing processes and devising solutions for new and existing technical projects.
• Participated in requirements workshops to identify business needs and requirements
• Excellent writing skills in preparing Business Requirements Documentations (BRDs), System
• Requirement Specifications (SRSs), System Design Specifications (SDSs), functional specifications, defining project schedule, timeline and budgets and training technical and non-technical users.
• Very strong data visualization experience with Tableau
• Technical Writing - Writing and editing system documentation.
• Strong in MS Visio, MS Excel (Pivot table, chart, Lookups, Macro, VBA), SQL (SQL and PL/SQL Query)
• Extensive experience with Power BI, Tableau Desktop and Tableau Server in Tableau 10.x as a Developer and Analyst
• Experience in checking KPIs, establishing data collection process and analytical tasks required to advice the corporate
• Worked on the development of Dashboard reports for Key Performance Indicators for business analysis.
• End-to-end experience in designing and deploying data visualization using Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu options and Parameterized.
• Extensive experience in various reporting objects like Hierarchies, Filters, Calculated Fields, Sets, Groups and Parameters, DAX, Relationship management in Tableau and Power BI
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting,
• Parameters and Trend lines.
• Sharing Tableau Desktop workbooks with stakeholders to view using Tableau Reader
• Experience with managing project deliverables and ensuring completion of milestones

TECHNICAL SKILLS:

SQL, T: SQL, PL/SQL, Stored Procedure, Python, R, Hive QL, ANSI 89/92

Databases: SQL Server, Oracle, Amazon Redshift, Postgres, MySQL, Various Cloud Technology

Operating Systems: Windows Server, Windows UNIX

ETL Tools: Alteryx, Informatica, SSIS, Import/Export Wizard, BI Studio

OLAP Tools: SSAS, MS Excel, Toad, SSMS, Query Analyzer, Bex designer, SQL Developer.

Reporting/Dashboard Tools: Tableau, MS Power BI, Alteryx, Xcelsius, SSRS, MS Excel, Webi, Crystal, Dashboard designer, SAC

Business Tools: Word, Excel, PowerPoint, Access, Outlook, SharePoint, Jira

Source Control: Team foundation Server 2010, Visual source safe (VSS)

Data Modeling: Normalization, Denormalization, Star Schema, Snow Flake Schema, SCD Type 1/2/3

PROFESSIONAL EXPERIENCE

Lead Business Intelligence Developer & Reporting Analyst

Confidential - Remote, NY

• Interact with business users to identify dashboard strategies, wire frames and analysis presentations.
• Delivered multiple dashboards Mitigate Risk, Track Critical Dates, Portfolio Summary, Optimize Cost, Browse Properties, Manage Transactions and C &W performance summary.
• Delivered multiple reports; Critical Dates, Target market Rent vs Offers, Lease Holdovers, Transaction
• Schedules, Mark to market variance, Upcoming expansions/Area, Portfolio ownership overview, Largest site cost summary, Upcoming expirations/Area, Building cost/Area, Regional cost Summary, options lease, opportunity lease and lease scoring summary.
• Continuously analyze existing KPIs, reports, and dashboards to understand gaps with stakeholder needs and act to close these gaps.
• Delivered UAT test cases
• Transferred Tableau Dashboard to Power BI.
• Created dashboards using M Query and DAX functions.
• Data modeling with Power BI relationship tool within Power BI Apps.
• Created business requirements and analyzed data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created dashboards by extracting data from various sources using parameters, sets, groups and calculations.
• Developed interactive dashboard and applied actions (filter, highlight and URL) to dashboard and created calculated fields, mapping, hierarchies and drilling through reports in dashboard.
• Developed Charts like, Bar over bar, Butterfly chart, Donut Chart, dual-axis bar chart with multiple measures and data blending in case of merging various sources.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Performed extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Performed Tableau type conversion functions when connected to relational data sources.
• Used Web data connector and developed Tableau dashboards using various websites based on Json and HTML.

Environment: Tableau Desktop 9.1/10.5, Power BI, SSRS, Tableau Server, Oracle, Tab Jolt, MySQL, Hadoop, Cloud database, Salesforce, Microsoft PowerPivot, Pivotal HD, HDFS, Microsoft SQL server 2012, MS Excel/Access, Windows 8.

Sr. Tableau Developer / Power BI Developer

Confidential, Greenwich, CT

• Interact with business users to identify dashboard strategies, report layouts, and analysis presentations.
• Validate and developed Meta Data for all developed reports in Microsoft Power BI Desktop.
• Enterprise Customer Information Management: Data infrastructure, platform and data management expertise; marketing technology application management; enterprise customer data strategy and integration.
• Marketing performance analytics, targeting, and List creation to drive high performance marketing strategies; Marketing ROI and campaign-based measurement; Customer level enterprise scorecards, for key business and customer segments.
• Continuously analyze existing PMO KPIs, reports, and dashboards to understand gaps with stakeholder needs and act to close these gaps
• Developed analytics solutions by defining and translating business requirements into dashboard & reporting solutions and implementing them within Microsoft Power BI Desktop and visualizations.
• Mentored business power users to create reports/dashboards using Power BI.
• Design, build and maintain logical model for Tableau reporting application.
• Design, build and maintain all Tableau schema objects (attributes, facts, hierarchies).
• Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Designed different BI Dashboards for the Company Executives, through an efficient use of Tableau Report Services.
• Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters.
• Built Complex Reports using advanced reporting functions like with YTD calculations, percentage differences, sets and groups etc.,
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Defined best practices for Tableau report development.
• Delivered funnel analysis report, Corporate Strategy reports, EMEA business review reports, seller performance reports and financial reports.

Environment: Microsoft Power BI Service, Power BI desktop, DAX, SAP, Microsoft Excel, SalesforceService Now, SQL Server 2012, SSAS, Tera Data, Oracle and CONA Billing system.

Sr. Visualization Expert

Confidential, Houston TX

• Involved in database development using stored procedures, triggers, views and cursors.
• Created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
• Wrote efficient Stored Procedures for the Optimal Performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries.
• Responsible for creating datasets using T-SQL Stored Procedures and involved in Data visualization.
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Used Power BI Custom visuals like Power KPI, Chiclet Slicer, InfoGraphic Designer, Spline Chart to make the visuals look and understand better.
• Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Designed Data Model in Power BI Designer according to the Structure and Hierarchy of Data.
• Worked on KPI (Key Performance Indicators) in Power BI to track the progress & reach goals.
• Deployed Dashboards, Reports and Data sources in the Power BI Service.
• Generated custom and parameterized reports, sub reports in SSRS.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Worked on SSRS Reports such as Cascading Reports, Parameterized Reports, Sub Reports, drill through Reports, Cached Reports & Subscriptions.
• Created Shared Datasets & Sources in SSRS for Doing Reports in Report Builder.
• Worked on Cloud platform Azure for storage applications.

Environment: MS SQL Server, SQL Server reporting services (SSRS), SQL Server Integration Services

2014 (SSIS), SQL Server Analysis Services 2014 (SSAS), T-SQL, DAX, SQL Server, Power BI DesktopMDX, JIRA, Tableau, Microsoft Visual Studio 2014, Excel, Azure.

Sr. Tableau Consultant

Confidential, New Jersey, N. J

• Developed tableau dashboards tracking Sales Performance, Trend Analysis, Payer reporting, Manager Activity Report, Sales Inventory, Call Planning/Activity, Field Activity, KPI Reports and Attainment report using US Map and geographical codes.
• Learning Alteryx for self-service data analytics to prep, blend and analyze data for the reporting needs.
• Getting trained on AWS Technical Essentials and moving Tableau on AWS.
• Created payer dashboards for all the business units to get the details of the plan name, formulary status, payer pay type name TRx/NRx (Market and Product) details.
• Created dashboard to show the following details - Top 5 payers - Market TRx details, Physician TRx, Payer TRx.
• Received monthly files for each product (Elidel Monthly, Jublia Monthly etc.) with their payer entities information (Cigna, Pfizer, PBM plus administered plans), IMS Id( for prescribers), the product group ID and their 13wk TRx counts and converted this information to dimension and fact tables in the SQL database to be consumed by tableau dashboards.
• Used Tableau Prep to prepare, shape and clean the data for analysis.
• Worked on operations such as filter, split, join, union etc... In tableau prep to clean and shape the data.
• Gathering requirements from users-sales reps, District managers and Regional managers and acting as a liaison between the business and technical side of the organization.
• Upgraded Tableau server and work as an architect under the guidance of the lead architect.
• Adding users and groups using tableau server and providing National level or Territory view level access.
• Built ETL packages using SSIS to load Roster data, weekly data and monthly payer data.
• Worked on creating usage dashboard for all the business units by bringing in PostGre tableau database into our SQL environment and refreshing it on regular basis.
• Worked on creating IC Scorecards with the confidential data showing final pay, commissions and other financial benefits of the Territory managers, District and regional managers.
• Extensive use of SQL server database, creating views, creating dimension and fact tables based on reporting requirements.
• Brief understanding of Pharmaceutical business units and reporting requirements.

Environment: Tableau Desktop, Tableau server, SQL Server, Alteryx, JIRA, SharePoint

Confidential, Houston, T.X

Oracle Database Administrator/OBIEE developer

• Performed Database Performance Tuning and Monitoring of Databases.
• Designed and implemented Security Policies.
• Configuring the Auditing of database at DB or OS level, to monitor illegal use of database.
• Utilized Oracle Export and Import utilities to perform logical database backup and recovery, to move Oracle data from one machine, database or schemas to another and to detect database corruption
• Controlling and monitoring user access to the database.
• Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet.
• Created schemas with partitioned external tables for a production environment, using SQL Plus.
• Using Hints in Select Statements for Best Execution Plans. (After gathering statistics through Explain Plan, Analyzing the Table, Indexes).
• Configured the database for maximization of disk space utilization and memory utilization and minimizing the disk I/O to make the application faster.
• Administered Oracle 9i and Infrastructure support using Oracle OEM.
• Performed requirement analysis, capacity planning for databases and system infrastructure.
• Populated Oracle tables with data from external and non- oracle files using SQL*Loader utility.
• Used Stored Procedures for performing complex business logic involving database access and for validating information.
• Support the database with logical backup as well as cold and hot backups.
• Design variety of Triggers for object create, alter, drop, server errors, startup/shutdown and for logon/logoff.
• Built Databases and refreshed them by executing the scripts.
• Developed shell scripts for day to day database administration activities.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Written SQL Loader Scripts for data extraction and transformation.