SUMMARY

• Work closely with clients to understand their needs and create actionable plans for reports or dashboards
• Expert in generating on - demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS), Tableau and Power BI Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client
• Solid knowledge of Tableau Desktop and Power BI report performance optimization
• Quantify and relate structured and unstructured data according to project, model, platform-specific, or research needs
• Analyze and obtain insights into large datasets by creating visually compelling and actionable dashboards or interactive reports
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and Power BI.
• Enhance performance and/or scope of dashboards and reports through data blending and optimization of database objects
• Optimize relational/multidimensional databases and data modeling for OLAP and ROLAP
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Provide technical support, troubleshooting, report design, and monitoring of system usage in enterprise environments
• Migrate data, reports, and packages using variety of programming methods, analysis tools, and management services
• Create and update end-user documentation to support implementation and knowledge transfer
• Expert on maintaining and managing Tableau and POWER BI driven reports and dashboards.
• Complete special projects, research requests, or ad hoc tasks as assigned by managers

TECHNICAL SKILLS

BI Tools: Tableau (Server & Desktop), Power BI, Adv MS Excel

Databases: Oracle, DB2, SQL Server, Greenplum, Amazon Redshift

Querying Tools: Aqua Data Studio, SQL* Plus, Toad, Oracle SQL Developer

ETL Tools: ODI, Informatica,Alteryx

Data Modeling: ERwin, MS Visio

Prog. Languages: PL/SQL, T-SQL, Java/J2EE, SAS, R

Scripting Language: Unix Shell Scripting (Bash)

Operating Systems: Windows, Linux (RHEL, CentOS)

Analytical Tools: R, SAS Enterprise Guide, SAS E-Miner, Adv MS Excel

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. BI Data Analyst

Responsibilities:

• Design and develop Business Intelligence and Reporting applications using Tableau
• Provide an end to end experience in designing and deploying reports/data visualizations using Tableau
• Lead discussions with business partners to identify functional requirements resulting in development of system specifications and applications
• Administer all aspects of development and production environments including security and performance tuning
• Ensure application stability and performance by monitoring existing production systems to ensure they are working correctly and that they reconcile with the system of record
• Interact with the existing database developers and DBA to understand the existing schema
• Optimized the query performance in database with modification to SQL queries, removing unnecessary columns, establishing necessary joins, creating useful indexes
• Excellent SQL skills for daily testing of data using various SQL queries
• Ensure adequate testing and validation is completed for all projects
• Provide ad-hoc data analysis and support to business functions
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using Tableau desktop

Environment: Windows 7, Linux, Tableau Desktop (10.x/2018.x/2019.x), Tableau Server (10.x/2018.x/2019.x), Microsoft SQL Server, Cloudera Hadoop, DB2, Sybase IQ, Agile, Java, Informatica, JIRA, Aqua Data Studio, SharePoint and Microsoft Excel

Confidential

Sr. Data Analyst / BI Developer

Responsibilities:

• Designed, developed and tested various Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases
• As a Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company
• Participate in client requirement discussions and suggest design and architecture for new interfaces
• Provide an end to end experience in designing and deploying reports/data visualizations using Tableau desktop and Tableau server; provided initial training to end users as needed
• Lead discussions with business partners to identify functional requirements resulting in development of system specifications and applications
• Migrated existing Tableau reports to point to Amazon Redshift from SQL Server.
• Subject matter expert in supporting business applications, ensured system availability, security and audit controls and procedures are maintained and followed
• Identify and deal with problems as they arise, escalating and involving senior management where appropriate
• Administer all aspects of development and production environments including security and performance tuning
• Ensure application stability and performance by monitoring existing production systems to ensure they are working

Environment: Windows 7, Tableau Desktop (9.x/10.x), Tableau Server (9.x/10.x), Power BI, Microsoft SQL Server, Amazon Redshift, SAP HANA, DB2, Agile, Java, Informatica, JIRA, Aqua Data Studio, and Excel

Confidential, New York, NY

BI Developer / Data Analyst

Responsibilities:

• Participate in client requirement discussions and suggest design and architecture for new interfaces
• Research back-end systems development; analyze and tune database objects using SQL/PSQL in Aqua Data Studio
• Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across same and various data sources
• Develop complex queries for Tableau dashboards and ad hoc analytical reports used by investors, issuers and traders
• Administered deployments and coordinated monitoring or job schedules on Tableau server
• Expert in connecting multiple data sources in Power BI to implement working reports
• Expert in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop
• Researched problems thoroughly to diagnose the root cause by pulling data from multiple Sources, Developed Reports and dashboards using Power BI
• Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports

Environment: Windows 7, Tableau Desktop 9.2, Tableau Server, MS Office, Aqua Data Studio, SQL server 2012, Hive, SAP HANA, SecDB, Oracle Database, Teradata SQL Assistant, SSIS, SSRS, Agile Methodologies, Java, Microsoft Office Suite (Word, PowerPoint, Excel)

Confidential, Logan, UT

BI / Data Analyst

Responsibilities:

• Harnessed Tableau data blending feature and defined best practices for Report development
• Standardized BI function to create database layers with user-friendly views that powered Tableau reports and dashboards
• Expert in connecting multiple data sources in Power BI to implement working reports
• Optimized query performance by modifying SQL, removing unnecessary columns, and creating efficient joins or indexes
• Expert in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop
• Fine-tuned SQL queries using optimizer hints for joins, parallelism, and execution plans
• Improved quality of work by creating unit test plans to be executed prior to QA handover
• Migrated existing SAS reports into Tableau and build new reports using SQL Server database

Environment: Windows 7, Tableau Desktop 9.0, Tableau Server, Power BI, MS Office, MS Visual studio 2013, SVN, SQL server 2012, MySQL, Oracle Database, Teradata, C#., SSIS, Agile Methodologies and JavaScript.