SUMMARY

• Overall 8 + years of IT experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment.
• Extensively worked on Tableau 7.x/8.x (Desktop, Server, Mobile, and Public), Micro Strategy, and SSRS.
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Sound knowledge of Retail, Health Care, Insurance, Telecom and Financial industries.
• A highly motivated and excellent team player with technical expertise in software engineering processes and outstanding knowledge on life cycle of the software design process (SDLC).
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensive knowledge of all phases of the Software development life cycle (SDLC), Agile, Scrum and the iterative Rational Unified Process (RUP).
• Proficient in conducting Gap Analysis, Designing data flows and communicating the trade - off decisions on product features based on technology and customer requirements.
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Managed cross-functional teams through Software Development Life Cycle.
• Designed the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Extensively providedtechnicalandanalyticalexpertise in responding tocomplex,specializedreport requests requiringhigher-level data analysisanddata management services.
• Outstanding knowledge in designing and developing Data Marts using Kimball/ Inmon methodologies.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), MS Access and client/server applications.
• Experienced in Performance Tuning by analyzing and comparing the turnaround times between SQL and Tableau.
• Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Extensively involved in Reverse-Engineering and Business rules extraction expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

BI Tools: Tableau, MicroStrategy, Business Objects, SSRS, SAS

ETL Tools: Informatica, Data Stage, Microsoft SQL Server Integrated ServicesRequirements Management Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Change Management: HP Open View, CA Service Manager, Lotus Notes & Service Management

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Databases: Teradata, Oracle, SQL Server, DB2, Sybase, Access

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Defect management tool: HP Quality center 10.0

Scripting Languages: C, C++, HTML, SQL, PL/SQL and XML

Data modeling: Power Designer, ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Pewaukee WI

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Actively involved in Setting up Tableau Environment.
• Work closely with front office, Cash Management, Loans Operation and compliance team to understand their needs and creating visualization on Tableau.
• Creating Visualizations in tableau using Excel, DW and SharePoint data.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS VISIO, Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential, St Louis MO

Sr. Data Analyst/Tableau Developer

Responsibilities:

• Liaison for project managers, managers, directors, and stakeholders.
• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
• Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.
• Develop, derive and clarify functional specifications and Use cases.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Designed the conceptual and business process models.
• Implementation of new systems including the integration of the new system with existing systems.
• Verifying installed systems to ensure that they adequately meet user requirements.
• Physical design of data record data files and databases.
• Developed mappings and workflows in Informatica to extract data files used as source for various Tableau reports.
• Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.
• Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.
• Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.
• Deployment of defect free code while managing the timeline set for the project.

Environment: Tableau, Teradata, Oracle, SQL Server, TOAD, PLSQL Developer, ERwin, SQL Developer, SAS, Informatica, MS VISIO, Microsoft (Word, Access, Excel, Outlook

Confidential, Vienna VA

Sr. BI Analyst/Sr. Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Possess and applied a broad knowledge of principles, practices and procedures of Marketing, Merchandizing subject area to the completion of various difficult assignments.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Performed GAP analysis with Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
• Worked to ensure high levels of data consistency between systems.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Designed complex risk reports, Score Cards, and Dash Boards using MicroStrategy.
• Worked on exploring the dimensions such as Drill Down, Drill Up, Drill down and up on nested categories, filtering the data etc.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Arranged walkthrough sessions with the user group and QA teams to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.

Environment: Micro Strategy, Oracle, MS Access, Teradata, Informatica, TOAD, SQL Developer, PL/SQL Developer, Autosys, HP Open View, Windows 2003/XP, ERwin, and MS Office Suite ( Word, Excel, PowerPoint).

Confidential

Business Systems Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Worked with users and coordinated with actuate developers to understand and capture data/reporting requirements.
• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Worked with Project team to determine technical and development impact of a project.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.
• Modeled use-case diagrams in Rational Rose to show end-user interaction with the personal information, loan information & property information modules.
• Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from the user perspective.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.
• Designed various analytical reports, dashboards in MicroStrategy on Sales, Finance data as per end user requirement.
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues

Environment: Oracle, TOAD, SQL, Share Point, TFS, Agile-Scrum, Informatica, MicroStrategy, Autosys, UNIX, SQL Server (SSIS, SSRS), ERwin, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).