SUMMARY

• Over 9+ years of experience in IT and Financial Analysis, Mining, Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms. Used SQL and SAS, replacing queries and testing results extensively
• MBA from Babson College, Boston wif dual concentration in Strategy and Entrepreneurship - worked on several real life business assignments performing cruicial analysis such as business risk assessment, cash flow analysis, EBITDA analysis, Discounted Cashflow analysis WACC and strategy analysis
• Gained exposure to several research and analysis tools such as Bloomberg Terminal, Capital IQ research
• Strong knowledge of financial management skills such as ROI analysis, financial modelling, and project management stills like time estimation, task identification, and scope management
• In-depth knowledge in Tableau Desktop, Tableau Server
• Strong knowledge of Spotfire, Birst and Microstrategy
• Expertise to design, deploy rich Graphic visualizations wif Drill Down and Drop down menu option and Parameterized using Tableau.
• Created complex visualizations dat utilize various graphs like Scatter Plots, Bar, Stacked Bars, Heat Maps, Filled Maps
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues wifin Tableau Server and Reports.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Worked wif cross functional teams in various organizations understanding requirements engineering, analyzing and documenting business and system requirements
• Extensive experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server
• Working knowledge of extensive research and financial tools such as Capital IQ, Bloomberg Terminal
• Expertise in Project Planning, Project Design, creating functional specifications and data flow diagrams.
• Proficient in MS-Visio for model diagrams, MS-Word and MS-PowerPoint
• Expertise in system modeling methodologies like agile
• Experienced in tuning long running SQL queries for better performance.
• Expertise in using Version controllers like GITHUB and Clear Case.
• Proficient in data-sets like OLAP and OLTP.
• Strong team member wif good communication and analytical skills
• Worked on other BI Tools like SAP BO, HANA, BOBJ
• Worked on Financial data modelling and SAS data mining to project future revenue growth models
• Experienced in describing and communicating business processes by using Flowchart, Use Case Diagram, Sequence Diagram and Workflow Diagram, using tools like MS Visio
• Consulted big ticket companies’ C level executives elicit business requirements, suggest strategies by applying various techniques, such as Joint Application Development (JAD) sessions, SME and Stakeholder Interviews, Brainstorming Sessions, Questionnaires and Prototyping
• Excellent Communication, problem solving, troubleshooting and decision-making skills.

TECHNICAL SKILLS

BI Tools: Tableau 6.x/7.x/8.xDatabase Oracle 11g/10g/9i, MS Sql Server 2003/2005. SQL 2008/2011

Utilities: SQL*Loader, SQL Developer, Clear Quest, Clear Case, ToadLanguages VB, PL/SQL, Java Script, Toad, Asp.net, Imhotep, Ramses, IQL.

Operating Systems: Windows 7/2003/2008, Linux

PROFESSIONAL EXPERIENCE

Tableau BI Developer

Confidential, Groton, CT

Responsibilities:

• Transitioned the existing data visualization tools to Tableau, educated client on Tableau and building a Tableau lead environment
• Led JAD sessions on requirement gathering, extracting GRC and internal research data from CMDB and using SQL, and analyzed data by creating visualizations for enabling C level executives form strategies
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 8.1 to Tableau 8.2
• Installed Tableau9.0
• Created and assisted users in Tableau dashboard development and assessment of need of Tableau Server(in the process of implementation)
• Transitioned reports from currently used set ups like SAP BO, HANA and Flat Files to Tableau
• Administered and provided analysis on financial data for R&D department and Cost Analysis
• Defined and created procedures to install Tableau desktop in silent mode
• Defined Group level security standards for Tableau and documented and educated application teams on pre-defined access levels and their purpose
• Working wif Mobile App Development and Testing Group to analyze data and application gaps
• Defined best practices for Tableau report development
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Utilized Microsoft Office Suite proficiently including Excel, Word, and PowerPoint by creating numerous end clients related documents

Environment: Tableau Desktop 8.2, Tableau 9.0, Tableau server / Administrator, Oracle 11g, Sharepoint, Flat Files, Microsoft Excel

Sr. BI Consultant

Confidential, Austin, Texas

Responsibilities:

• Involved in the data based product analysis of products like Job Search, Indeed Resume, Indeed Apply using internal and external tools, perform gap analysis and suggest and implement future course of action using A/B testing
• Created Proof of Concept visualizations using Tableau and demonstrated capabilities to the management and got funding approval for the tool
• Evaluate BI tools like Spotfire, Birst, Tableau for 4 months
• Designed and developed intuitive Tableau Dashboards against Remedy Database to bring visibility on enterprise wide Incident, Problem and Change Tickets
• Studied data trends to improve the quality of data products
• Performed ad hoc data extraction using data mining techniques such as SQL, Hive, keyword search
• Built visualizations against various Data Sources like Flat Files(Excel, Access), Google Analytics and Relational Databases(Oracle, Sybase)
• Worked wif Indeed’s finance team to analyze financial statements-assessing investments, revenue anaysis and cash flow analysis
• Built reporting against Single Table, Multiple Tables and Complex Custom SQL.
• Built complex formulas in Tableau for various business calculations.
• Designed and deployed reports wif Drill Down and Drop Down Menu option and Parameterized and Linked Reports on products like Indeed Resume, Indeed Apply, Job Alerts, Hosted Jobs, Company Pages, Android and iPhone apps, Mobile websites
• Monitor and analyze key metrics to improve search results through stemming, query normalization, and click-through rate (CTR) analysis
• Work wif cross functional teams like product and marketing to ensure product quality and upbeat performance ensuring no downtime or bad user experience
• Created side by side bars, scatter plots, stacked bars according to deliverable specifications
• Identify performance and development related data w.r.t. mobile app, analyze market performance(rankings, feedbacks) and work wif developers in creating efficiencies
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution
• Installation and Configuration of Tableau Servers in Clustered environment where resources were allocated based on the activities dat are planned to be performed in the environment
• Administered user, user groups, and scheduled instances for reports in Tableau
• Defined Group level security standards for Tableau and documented and educated application teams on pre-defined access levels and their purpose
• Experience wif Active Directory Integration wifin Tableau Environment for automated user provisioning
• Designed Strategy for Automated Software Delivery through Silent install process for distribution of Tableau Desktop Client Tools
• Created Financial Forecasting models to aid senior management for TEMPeffective decision making
• Setup environment wif optimal performance of the reporting application by performance monitoring, capacity planning, and tuning for multiple members on multiple projects
• Creating Database Objects Views, Materialized Views, Indexes for efficient access of data against the Database for complex calculations and to leverage database processing power for faster query processing.
• Used Restore Feature to allow smooth migration from previous environment

Environment: Tableau Desktop 7.0, 8.0, 8.1, Birst, Spotfire, Tableau server / Administrator, Oracle 11g, Toad, Windows, MS-Office, SQL 2008

BI Consultant

Confidential, MA

Responsibilities:

• Analyze complex data from various data repositories and become familiar wif user base locations
• Conduct business requirement review sessions wif IT and Business teams to understand what the outcome should be based on data elements.
• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis
• Create users, define authorization levels for users and group as Tableau Administrator
• Served as a liaison between the business and the IT department by conducting weekly calls/meetings wif stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed
• Extensive market research to assess new markets, calculate marketing spends, customer acquisition costs and perform ROI and market growth analysis
• Created area map to find out potential customer base wifin United States and Europe and found gaps in areas where competitors lacked due to several demographic issues. Created quick filter to narrow down individual states and cities along wif revenue being generated in individual state or city
• Created side by side bar chart comparison of Confidential ’s competitor users who were domestic vs. international along wif providing profit revenue generated
• Created line charts to display trends over a period of time for Confidential ’s product usage and tied it wif bar charts to show revenue growth based on users upgrading to additional features of the product additionally adding filter to choose between business and personal users
• API data was extracted by DBA dat was put into SQL Server or Flat File and I was plugging dat data into Tableau from either flat file or SQL Server
• Extensive use of SAP tools for BI purposes
• Reviewed queries dat were automatically build by Tableau and edited them as and when needed along wif writing basic custom SQL queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports
• Utilized Microsoft Office Suite proficiently including Excel, Word, and PowerPoint by creating numerous end clients related documents
• Designed and deployed reports wif Drill Down and Drop down menu option and Parameterized and Linked reports using Tableau
• Defined Group level security standards for Tableau and documented and educated application teams on pre-defined access levels and their purpose

Environment: Tableau 7.x, Oracle 11g, Toad, Windows, MS-Office, SQL Server 2008

Sr. BI Consultant

Confidential

Responsibilities:

• Liaison between the client and development team to support the client's data analysis and reporting needs.
• Proficient in discussing and defining project, Gap Analysis wif the clients from both a business and technical perspective
• Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management end of day feeds
• Understood reporting, ad hoc analytical usage of the new data model and proposed physical database design recommendations
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets
• Involved in creating a dual-axis bar chart wif multiple measures
• Created report schedules on Tableau server
• Created incremental refreshes for data sources on Tableau server
• Administered user, user groups, and scheduled instances for reports in Tableau server and documented upgrade plan from Tableau 6.0 to Tableau 6.1
• Created and assisted users in Tableau dashboard development
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode
• Established best practices for Tableau development
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Involved in writing complex SQL queries using but not limited to table joins (inner and outer)

Environment: Tableau 6.x/7.x, Tableau Server/Administrator, Oracle 9i, SQL Server 2000, SQL, PL/SQL, Visio MS-Office, Excel

Business Analyst

Confidential

Responsibilities:

• Gatheird user requirements and business requirements from business/user group and documented User, Business, Functional, and Technical requirements specifications using MS Word and MS Visio dat provided appropriate scope of work for technical team to develop prototype and overall system.
• Used HP Quality Center to track and manage all defects and enhancement process.
• Used MS PowerPoint to create presentations for the business owners and other stake holders.
• Used MS Visio to create UML diagrams and design High Fidelity wireframes.
• Wrote SQL queries for requirement analysis and data validation.
• Perform data analysis and validate business requirements.
• Prepare data mapping specifications - Include data flow diagrams, field level mappings and rules for multiple applications.
• Provide data analysis and recommendations for the correction, enhancement and/or development of Customer Analytics applications.
• Managed and coordinated all phases of Software version update project and supported staff - met stringent deliverables and implementation date.
• Process mapped Operations, which identified redundancies, manual processes and backlogs, which improved efficiency of departments and service levels.
• Identifies Actors, Activities, Artifacts, and Workflows and developed use case diagrams using MS Visio.
• Implemented Rational Unified Process (RUP) as the software development methodology.
• Performed GAP analysis and came up wif alternative options which could be preferred to better serve its members and customers.
• Ability to lead requirements definition and design sessions through use of interviews, surveys, user workshops, product/prototype demo
• Wrote test cases and test plans for the related and assigned scripts according to the test strategies defined in the project and testing team guidelines.
• Tracked and maintained Stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
• Experience documenting investment related business process, trade reconciliation and trade processing.
• Extracted and manipulated data using SQL.
• Designed and implemented SQL queries for the retrieval and management of data.
• Reviewed development plans, quality assurance test plans, and user documentation to ensure correct interpretation of original specifications