SUMMARY

• 6 years of IT experience in Business Analysis, System Analysis, Data analysis, Software Design, Development, Implementation and Maintenance of Business Intelligence and across Agriculture, Airline Services, Banking and Retail domains
• Passionate individual successful at undertaking complex assignments and delivering promising results
• Skilled in data analytics, business analysis, R programming, Python, ETL design, front end development and analytical reporting.
• Highly Proficient in Agile, Iterative, and Waterfall and Scaled Agile Framework (SAFe) software development life cycles.
• Well acquainted with SDLC, STLC and QA processes.
• Proven expertise in functional, integration and regression testing for UI and back - end.
• Expert in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
• Expert in designing and developing analytical reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating data from multiple sources and help users to identify critical KPIs and facilitate strategic planning in the organization.
• Strong knowledge in SQL using SQL Server and Oracle databases.
• Worked in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Pipeline Pilot.
• Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Spotfire, Alteryx, Pipeline Pilot, Informatica, MicroStrategy and Database technologies.
• Worked with TIBCO Spotfire to communicate and update business information
• Excellent knowledge in designing and developing dashboards using TIBCO Spotfire by extracting the data from multiple sources (Flat files, Excel, Access, SQL server, Oracle).
• Involved in Performance Tuning and Deployment of TIBCO Applications.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Knowledge of data mapping/migration, Cleansing, Profiling and Data Governance.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Possess strong knowledge of database management in writing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Adept in analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT) and assisted in Post - Production support.
• Awarded best employee for the season twice in a year for successfully completing the projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Analysis Tools: Tableau, TIBCO Spotfire, Power BI, MS SSRS, MS SSAS, MS Excel (VBA, VLOOKUP, Pivot tables)

Data Integration (ETL) Tools: Alteryx, Pipeline Pilot, Informatica, MS SQL Server Integrated Service (SSIS)

Project Management: SDLC - Waterfall & Agile methodologies, project life cycle, MS Project 2013, JIRA

Programming: SQL, PL/SQL, Python, R-Script, C#, CSS, HTML, JavaScript, jQuery

Application Software: MS Office, Eclipse, MATLAB, Visual Studio, MS Excel advance, MS Access, MS Visio, Toad Oracle

Manual Testing: Requirement analysis, Test scenario design, Test case design, Test data management, Test Execution, Database testing, Regression testing and Defect tracking

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Led the development of prescriptive data model to optimize operations and increase efficiency
• Analyzed requirements, developed and debugged applications using BI tools
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Designed, developed, tested, and maintained Tableau reports based on user requirements.
• Preparing reports, extracts and integration of existing data as needed to support analysis, visualizations, and statistical models.
• Designing, developing and providing technical solutions through Tableau reports based on user requirements.
• Extensively worked on designing and creating tableau dashboards. Also, automated dashboards to help stakeholders in implementation of strategic planning in the organization.
• Extensively worked on advance visualizations techniques in Tableau to assist business users in represent data visually to solve complex problems.
• Worked with leadership management team for visualizing the key customer metrics, driving better solution in consumer POD and supply chain.
• Utilized various Tableau functions like LOD, WINDOWS SUM, WINDOWS AVG, conditional functions (IF, Nested IF, CASE, etc.), RANK, Table calculations like Percentage difference, Percent of Total, Moving Average, YTD, YOY, etc. for various measures/calculated fields.
• Worked on view orientation, Sizing, layout, Color, Fonts, Tooltips, for building Interactive dashboards/reports.
• Extensively worked on Tableau dashboards optimization for better performance and monitoring. Specifically dealing with huge volume of data sets in tableau.
• Extract, transform, and load data from a variety of data sources into staging datasets in redshift environment and ultimately into tableau for reporting.
• Extensively worked in preparing strategical planning and implementation of successfully delivery projects within the POD and supply chain teams.
• Scheduled data refresh on Tableau Server for weekly and monthly increments upon business requirement and ensured views and dashboards display changes in the data accurately.
• Published dashboards to the tableau server and communicated with the end stakeholder for PMO Usage
• Integrated projects in the server and organized workshops on the projects for better usage of the capability built in the dashboards.
• Publishes reports/dashboards on Tableau server & embedded views in other web applications.
• Worked on administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Worked on year end activity for Database audit and performed year end activities for Business Panorama.
• Performed database audits and created reports in tableau based on the audit logs.
• Provided application support for all the applications of Business Panorama.
• Performed data loads based on weekly and monthly schedules and worked on various issues we received based on the tickets we received in IRIS.

Environment: Tableau 2018.3 (Desktop/Server), AWS Redshift, Alteryx, Talend, Oracle, SQL Workbench, Control - M, AWS, Jira, Agile, SSMS, Microsoft Office Suite (Word, Excel, Macros, Pivot tables, PowerPoint, SharePoint)

Confidential, Richmond, VA

Data Architect

Responsibilities:

• Learnt about the structure of the company and the process of workflow in Confidential .
• Worked in the Confidential Risk Management team as a data architect.
• Analyzed requirements, developed and debugged applications using BI tools
• Interacted with the users and business analysts to assess the requirements and performed impact analysis
• Used agile software development with Scrum methodology.
• Involved in Data migration from traditional databases to Cloud.
• Created Dashboards in Tableau based on the user requirement for AML.
• Created affinity analysis dashboard and Radical charts for better understanding data.
• Published reports to the server and given authentications to the users.
• Created ad-hoc SQL queries for customer reports, executive management reports.
• Extensively worked on Tableau dashboards optimization for better performance tuning.
• Analyzed scripts in Teradata and created new queries in Snowflake using SQL Workbench.

Environment: Tableau Desktop 10.1.3, Oracle SQL Developer, SQL Workbench, Snowflake, Teradata, AWS S3 and Jira

Confidential, Chesterfield, MO

Data Analyst/ Reporting Analyst

Responsibilities:

• Led the development of prescriptive data model to optimize operations and increase packaging efficiency
• Analyzed requirements, developed and debugged applications using BI tools
• Interacted with the users and business analysts to assess the requirements and performed impact analysis
• Used agile software development with Scrum methodology.
• Worked in coordination with clients for feasibility study of the project in Spotfire and with DB Teams for designing the database as per project requirement.
• Produced databases, tools, queries and reports for summarizing and root causing failure data.
• Designed, developed, tested, and maintained Spotfire reports based on user requirements.
• Designed and maintained Spotfire and Tableau visualization dashboards on daily basis to facilitate Field testing all over North America
• Experience with Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment.
• Strong experience in creating sophisticated visualizations, calculated columns and custom expressions.
• Developed Map Chart, Cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions.
• Extensively used Spotfire and Tableau to create data visualizations enabling prescriptive operations and increasing data visibility.
• Developed various new reports using complex Spotfire dashboards by using the key concepts filtering scheme, data on demand, Property Controls, text areas in TIBCO Spotfire reports
• Created Information Links for many databases for populating data into Visualization from underlying databases such as Sql Server and Oracle.
• Extracted data from AWS cloud and used in pipeline pilot and created reports in Spotfire and Tableau.
• Built scalable pipelines, model deployments and reusable protocols using pipeline pilot to support daily operations
• Migrated couple of reports from Spotfire to Tableau, Power BI and Superset.
• Preparing reports, extracts and integration of existing data as needed to support analysis, visualizations, and statistical models.
• Extensively worked on designing and creating the dashboards. Also, automated Dashboards to help end users to identify the KPIs and facilitate strategic planning in the organization.
• Used data blending for reading data from different data sources, while designing dashboards.
• Created ad-hoc SQL queries for customer reports, executive management reports.
• Extensively worked on Tableau dashboards optimization for better performance tuning.
• Extensively worked with various functionalities like context filters, global filters, Drill-Down Analysis, Parameters, Background images, Maps, Trend Lines and created customized views, conditional formatting for end users.
• Assisted report/visualization developers and statistical modelers in filtering, tagging, joining, parsing, and normalizing data sets for use in reports & analytical models.
• Extract, transform, and load data from a variety of data sources into staging datasets and ultimately into visualization tool.
• Worked on Data blending, Data preparation using Pipeline pilot for tableau consumption and publishing data sources to Tableau server.
• Created scripts in Python and R for calling APIs through Insomnia and Postman.
• Developed custom SQL connections and calculated fields within the environment to facilitate automated production of data visualizations.
• Provided production support to various tools and created tickets in Jira.

Environment: TIBCO Spotfire 7.x, Tableau 10.x (Desktop/Server), Pipeline Pilot, Alteryx, Oracle, SQL Server, MS SQL, AWS, Python, R-Script, Power BI, SharePoint, APIs, Insomnia, Postman, Jira, MS Office Suite (Word, Excel, PowerPoint)

Confidential

Data Analyst/Tableau Developer

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts and End Users and gathered business requirements.
• Analyzed requirements, developed and debugged applications using BI tools
• Acted as a Liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Developed Logical data model using Erwin and created physical data models using forward engineering.
• Translated business and data requirements into Logical data models in support of Enterprise Data Models, OLAP, Operational Data Structures and Analytical systems.
• Involved in collection and cleaning of large amount of unstructured data using Excel and python.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created extracts and scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Developed dashboards with interactive views, drill downs and published them to the portal with user level security.
• Developed various reports using Tableau features like Parameters, Filters, Sets, Groups, Actions, etc. to present users with various scenarios of predictive analysis.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Developed reports to analyze multiple measures using Blended Axes and Dual Axes.
• Created and updated custom SQL scripts to serve as data sources for various reports and handled performance issues effectively.
• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau. Also, involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Worked closely with all team members in implementing Tableau BI tool in all IT projects.
• Generated reports using SQL queries and published them to users in online thru Tableau server.
• Involved in generating Daily/Weekly Sales and Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics and Top Executives to give an overview current Trends.
• Worked on Donut chart, Bubble chart, drill down analysis using tableau desktop.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards. Reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Provided post implementation production support.

Environment: Tableau 10.x/9.x/8.x (Desktop/Server), Alteryx, Erwin, Oracle, SQL Server, Python, SSIS, SSRS, MS Office Suite (Word, Excel, PowerPoint)