SUMMARY:

• Over 5 years of experience in the IT Industry and worked on Tableau Desktop, Tableau Server, Power BI Desktop, Power BI Server and efficient in connecting various data sources.
• 5+ years of extensive data analyst, Tableau Experience in Enterprise Environment, in Tableau 10.5/ 10.3/10.2/10.1/ 9. x/8.x/7.x as a Developer and Admin.
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,
• Integrated custom visuals based on business requirement using power BI desktop
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color - coded tabs etc. in Tableau 10 desktop/Server.
• Developed Tableau Data Extracts from the above-mentioned data sources using Pentaho Data Integration ETL tool.
• Hands on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.
• Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
• Secured Tableau server on AWS to protect the Tableau environment using Amazon VPC, security group, AWS IAM and AWS Direct Connect.
• Disaster Recovery setup, including Backup Primary setup and configuration.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement.
• Experience in the maintenance and scheduling of Tableau Data extracts using Tableau server and the Tableau Command utility.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Teradata, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD's (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Design.
• Experience in deployment of Business Objects and Web Intelligence from various Sources oracle, Teradata, Ms Sql Server.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and sequel server reporting services(SSRS).
• Have an idea on state of Wisconsin privacy regulations while working on the dashboard workbook.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility, SQL, Cloudera Hadoop and Hive, Apache SOLR, MapReduce, Amazon Redshift.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

PROFESSIONAL EXPERIENCE:

Power BI Developer

Confidential, TX

Responsibilities:

• Guide the design and development of data management and business intelligence projects to drive strategic decisions through data driven actionable metrics and insights.
• Designing, developing and maintaining business intelligence solutions. Crafting and executing queries upon request for data. Presenting information through reports and visualization.
• Knowledge of and proven expertise with cloud implementations in AWS, Azure
• Provide subject matter expertise in data modeling and architecture design. Assist in evaluating and selecting the best technologies and tools to support the BI mission.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Manage development and production issues impacting our clients and operations.
• Build BI reports, dashboards, drill-downs, filters, graphs, etc. on the Microsoft Power BI platform.
• Monitor and improve data and BI processes to meet firm SLAs and increase efficiency.
• Leverage technology capabilities and standards while working with technology system owners to identify appropriate data sources, define and build required data transformation logic.
• Significant experience solutioning, architecting, designing, implementing, migrating, and operating in an enterprise cloud environment
• Perform detailed data analysis to derive insights and deliver operational mechanism such as dashboards or ad-hoc reports.
• Maintain in-depth knowledge of IT industry best practices, technologies, architectures and emerging technologies.
• Provide architectural consulting to programs, projects and product initiatives.
• Review new and existing solution delivery for compliance with IT standards, policies and Ensure that project documentation captures significant architectural decisions.
• Identify architectural risks and propose alternatives and solutions.
• Provide analysis of project, including business case, ROI and post-project review.
• Drive innovation, best practices and achievement of strategic objectives.

Environment: Power BI Desktop, Power BI Server, MS Office Suite, SQL Server, Oracle, Informatica, Teradata, MS Excel.

Sr. Power BI Developer / Sr. Tableau Developer

Confidential, State of Michigan Dimondale, MI

Responsibilities:

• As Sr. Tableau Developer, primary activities included designing technology roadmap for Tableau; product installation and implementation development of insightful dashboards; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
• Solving P1 issues for the users in the production.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• Architect and design API Security, Container Security, Azure / AWS Cloud Security, etc
• Created and maintained SOX documentation required for critical financial file systems.
• Mentored and trained less tenured Business Analysts for their development.
• Use tools such as SQL and Insync for investigation of issues and work closely with our Actuarial and Underwriting Customers.
• Managed projects ranging from large to small.
• Created, maintained and queried relational database (MS Access). Understand and use SQL regularly for problem analysis.
• Member of a team that created the proof of concept for the selection of the ETL tool (BI tool). Sat with vendors and evaluated vendor tools during the proof of concept.
• A member of the team that designed and created the infrastructure for a Data Store which was used for conversion and routing of information created outside of the company and moved to Safeco data source.
• Created specifications for the conversion of data outside of Safeco into legacy data. Learned and understood complexities of outside systems and was able to convert into Safeco terms.
• Work and communicate daily across departmental boundaries.
• Proven strong analytical and problem solving skills.
• Team member of the data warehousing initiative - conducted interviews with high level management about their data warehousing needs.
• Willingness to learn new technologies. Enjoy working on the technical side as well leading project efforts.
• Created incremental refreshes for data sources on Tableau Server.
• Created report schedules, data connections, projects, groups in Tableau Server.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Created Adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau Adhoc reports.
• Design interactive dashboards in Tableau Desktop and published them to Tableau Server.
• Strong presentation skills
• Attention to detail and quality.
• Ability to work independently and deliver around tight timelines.
• Coordinate with multiple technology teams on production releases and related administrative tasks.
• Able to thrive in an environment that requires flexibility and multi-tasking.

Environment: Tableau Desktop 10.5/10.3, Tableau Server 9.3, MS Office Suite, SQL, T-SQL, PL/SQL, Ms-Excel, MDX, DAX, OLAP Cubes, Microsoft Analysis Services.

Sr. Tableau/Power bi Developer

Confidential, NC

Responsibilities:

• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
• Created interactive data visualizations in Tableau, using relational and aggregate data sources.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Integrated custom visuals based on business requirement using power BI desktop.
• Converting all operational excel report into Power BI Reports.
• As a Tableau SME, responsible for the design, development and production support of interactive data visualizations used across the company.
• Deep experience in architecting cloud solutions for enterprise
• Experience in deploying solutions in Azure and AWS platforms
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Provide Support to Business users in Business Objects Reporting.
• Identify areas of opportunity to improve ROI of marketing activities by analyzing customer behavior.
• Worked on all types of transformations that are available in Power bi query editor.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Implemented metrics, filters, reports, dashboards and also created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
• Implemented workbooks to display Year to Date, Month to Date, Quarter to Date analysis for Operational expenses for IT leaders based on Accounts, and generated bullet graphs.
• Implement complex formulas, calculations & Level of detail (LOD) within Tableau to meet the needs of complex business logic.
• Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Designed and developed ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Connected Tableau to various databases and performed live data connections, query auto updates on data refresh.

Environment: Tableau Desktop 10.5/10.3, Tableau Server 9.3, MS Office Suite, SQL Server, PL/SQL, Informatica, Teradata, MS Excel.

Tableau/SQL Developer

Confidential

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets. Developed Inventory reconciliation, Sales KPI summary update reports, Days Inventory on hand report for different channels, firms and products rolling up by month end.
• Created SQL views to pull data from SQL Server and developed reports using advanced calculations, filters and parameters.
• Training business users for all things Tableau and data analysis.
• Creating New Schedule's and checking the task's daily on the Tableau Server.
• Maintaining server activities, user activity, and customized views on Tableau Server analysis
• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005, and MS Access databases.
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Extracted data from xml and flat files using SSIS.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Designed, programmed, deployed and tested the requested Reports.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application Database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2000/2005/2008 , Erwin, MS Access, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML.

TECHNICAL SKILLS:

ETL tools: SQL Loader, Informatica Power Center 8.1, 7.1, 6.2.

BI Tools Libraries: Tableau Desktop 10.x, Tableau Server, Tableau online, Tableau Public, Tableau Reader, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integrating Services(SSIS), Alteryx 11

Python: Python, Spark, Scala, Panda, Numpy, Scipy, Pydoop, PySpark

Databases: SQL server, Oracle 8i,9i,10g, Teradata, SAP hana, Redshift, hadoop

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: Python, PySpark, MS-SQL, MySQL, hive, HTML5, CS3, JavaScript and XML

Web Servers: Apache web server, Microsoft IIS 4.0, Jboss 6.4

OS: Windows XP/03/07/10, OS X, Linux/Unix

Front-End Tools: Microsoft Project, Microsoft Office, Microsoft Excel