SUMMARY:

• Over 12 years experience on Business /Data Analysis,/Business Intelligence and ETL Applications
• Managed business process, requirements gathering, ROI Analysis, and transformation of functional requirements into technical specifications for solution design such as requirement elicitation, analysis, design, development and testing; Competent in analyzing and creating Narrative User Stories, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio
• Four Years Experience developing Tableau Workbooks, Dashboards, Scorecards, created data extracts for optimized loads, Tuned Server and Dashboard Performances,
• Five Years Experience with SAP Business Objects - Created Business Objects Repositories, Designed Universes
• Developed Full Client reports with multiple Data Providers, free hand SQL,
• Three Years Experience in Pentaho DI / ETL- Extensively used mapping operators (Key lookup, joiner, sorter, splitter, filter, aggregator, expression, mapping sequence, pre-mapping process and post-mapping process).Used Database Lookup & join, generate rows, Calculator, Row normalize & de-normalizers. Add constant and add sequence.
• Proficient in writing SQL queries, QA Testing, Data Quality and Integrity testing, Data warehousing
• Dimensional modeling (Star Schema, Snow flake) and Databases Oracle 8i/9i, SQL Server 2000

TECHNICAL SKILLS:

Software: Tableau 9x,8x, 7, Business Objects XI R3.3,R2, 6.5/5.1

Database: Oracle 11g-9, MS SQL Server 2000, DB2 6.0 /7.0

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta,GA

Technical Business Analyst / BI Tableau Developer

Responsibilities:

• Worked on Customer Care and After sales (CCA) project.CCA makes sure that the parts for services and repairs for every GM vehicle sold in North America are available when they are needed. CCA provides these parts through our two well-known brands: Genuine GM Parts and ACDelco.
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Conducted information-gathering session with subject matter experts and stakeholders, in order to acquire and analyze the business requirements. Documented requirements in the prescribed format and entered data in various data analysis applications while mapping the business process for the recipients
• Interviewed point of contact / stakeholders to learn, identify and analyze the business processes procedures and workflows that are involved in their particular job level and desk function
• Acquired advanced/complex business (workflow) requirements from Process Managers and turned them into less complicated functional workflow depictions while displaying a high attention to detail
• Created, maintained, and adhered to Enterprise Data Modeling Standards while performing analysis of possibly sensitive data, and made recommendations in accord with the objectives of the project
• Worked with IT Project Manager to estimate, plan, schedule, monitor, evaluate, document and direct projects to ensure a complete business solution was implemented during product implementations
• Prepared communications and made presentations on system enhancements and/or alternatives
• Employed various data collection and data-analyzing tool, in order to perform Gap Analysis, Root Cause Analysis, and KPI Analytics for compliance and risk reporting
• Developed Vehicle Profitability and Sales Dashboards, Vehicle Inventory, Vehicle Parts Supersession Workbooks etc
• Worked closely with business and data teams to gather key stakeholder requirements and convert them into technical specifications. Conducted Business Acceptance and user Acceptance testing and sign-off meetings
• Used Table calculations - Window SUM, Window Avg, First(),Running Sum etc
• Developed Dashboards that have different Tableau Features-Reference Lines, Dynamic X and Y Axes, Actions, Calculations, Hierarchies, Sets, Quick Filters, Parameters, Cascading and Context filers, Customized tooltips,
• Used Data blending for getting data from more than 5 data sources
• Extensively used Bar, Bar in Bar, Line Charts, Scatter Charts, Maps
• Tuned Tableau Server and Dashboard Performance-Reduced Tableau Views load times to 5 seconds, Used Incremental Extracts to reduce extract refresh times
• Used Full Set up best practices for Tableau Data Extracts, Tableau Dashboards
• Troubleshooting Dashboards- Fixed Issues related to Datasources, Linking Datasources, Hyperlinks, Data Mismatch, Extract failures, Permission, Tableau Memory Issues, Slow rendering of dashboards on server
• Performed Data Quality testing by comparing report data with source systems data

Environment: Tableau 10/9x, Windows 2008 server, SQL Server 2012,Teradata

Confidential, Alpharetta, GA

Technical Business Analyst / BI Tableau Developer

Responsibilities:

• Assisted in designing and developing of project document templates based on SDLC methodology.
• Conducted interviews and focused group discussions to gather high level requirements.
• Worked closely with SME’s for CRS and ORS to provide functional specifications for CRS evolution.
• Maintained meeting minutes, meeting agenda and communicated them with the SMEs and the stakeholders on timely manner using MS Word, MS PowerPoint and created reports using MS Excel.
• Performed extensive Gap analysis and identified functional gaps between them.
• Documented business requirements and functional requirements for product development using agile methodology.
• Created Use-cases, activity diagrams, sequence diagrams and class diagrams using Rational Rose.
• Interacted with the developers to identify and document possible impacts to the enhanced CRS system
• Participated in User Acceptance Testing (UAT) for the product using Rational Clear Quest.
• Executed multiple queries in SQL using Toad Application.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach
• Worked as a Release Managers with the list of backlog items being released to production with the upcoming sprint
• Designed Dashboard Landing Page where most of the metrics are grouped into Customer, Operational, Employee and Financial planks.
• Developed Tableau Views/ Vizs for over 30 metrics for Call Handling, Customer Satisfaction and Time to resolve metrics (Customer plank), Utilization, Effectiveness, Compliance metrics(Operational plank),Operational Costs, Service Cost metrics(Financial plank), Skillset Development And Employee Satisfaction (Employee Plank)
• Created Executive Scorecard that provides information about how agents of a Functional group have performed with respect to various metrics for an year and month . Key metrics like Avg Talk Time, Cases Per Head, Training Compliance, First Visit fix rate, OT Percent etc are shown on the scorecard
• Utilized the power of Microsoft Visio to (visually map) the data flow, procedures and processes of a job or desk function from beginning to end, and the stages involved in performing those procedures or processes
• Spearheaded meetings with Department Heads, Process Managers, VP’s, and IT personnel to give status or results of acquired workflow analysis
• Served as a Subject Matter Expert on the Implementation teams, in order to maintain Enterprise standards, and influence the achievement of the correct work-method and process improvements
• Prepared procedural documentation and Management Reports for Training & Implementation teams to utilize as training, and auditing documents
• Set up Tableau Server in Cluster Configuration-One Primary and 2 nodes, Installed and Configured Tableau Server, Performed Upgrades to 8.0 from 7.0,
• Set up Projects, Groups, Users and set up Permissions
• Used Full Set up best practices for Tableau Data Extracts, Tableau Dashboards
• Tuned Tableau Server and Dashboard Performance-Reduced Tableau Views load times to 5 seconds, Used Incremental Extracts to reduce extract refresh times
• Used tabadmin for Tableau data backups and restores

Environment: Tableau 8/ 7, Windows 2008 server, SQL Server 2008

Confidential, Rockville, MD

BI Architect / Pentaho Developer

Responsibilities:

• Created transformations that involve configuring the following steps: Table input, Table output, Text file output, CSV file input, Insert/Update, add constants, Filter, Value Mapper, Stream lookup, Join rows, Merge join, Sort rows, Database Lookup, Set Environment Variables
• Used Agile Methodology: Involved in Weekly meetings to streamline and define requirements and business rules to arrive at a general consensus between the analysts, business users, and software development team.
• Worked with business users on getting specifications for reports and build prototypes developed for implementation on Pentaho Enterprise Server for User Acceptance Testing(UAT).
• Made use of different transformations in PDI designer to cleanse and manipulate source data e.g. Database Lookup & Join, generate rows, Calculator, Row normalizer & de-normalizers, Add constant, Add Sequence etc.
• Implemented Slowly Changing Dimension Type 1 and Type2 in ETL jobs for certain Dimensions.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.
• Created single value as well as multi-value drop down and list type of parameters with cascading prompt in the reports.
• Implemented security in Pentaho reports by assigning permission to specific users to view the reports.
• Implemented data level security by creating database tables to store usernames, user groups and their allowable permissions, and joined those tables in the report queries to make sure each user should be able to see only the permissible data.
• Used Spotfire to develop dashboards, Used Python scripting to automate dashboard opening and refreshing process
• Deployed reports on Pentaho BI Server to give central web access to the users.
• Created several dashboards in Pentaho using Pentaho Dashboard Designer.
• Used Pentaho Schema Workbench to create Cubes, Dimensions and fact tables in Pentaho.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Provided CSV and Excel files to managers for particular records they wanted to look at in different meetings.
• Tested Pentaho ETL jobs, reports and database stored procedures being called in the reports.

Environment: Spotfire, Python, Javascipting, Pentaho DI, Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer, Pentaho Dashboard Designer, Pentaho Analyzer, Windows 2008, oracle 11g,Oracle AERS, TOAD

Confidential

Responsibilities:

• Worked with various PDI steps in the transformations and jobs like Table input, Get data from XML, DB look up, Dimension lookup, joins, row normalizer and denormalizer, Data grid, csv file, Table output, Insert update, JSON output, Java scripting.
• Used Pentaho Report designer to create various reports having drill down functionality by creating Groups in the reports and drill through functionality by creating sub-reports within the main reports.
• Created custom reports, conditional formatting and aggregation in reports using Pentaho BA server
• Created different date dimensions and facts and performed different transformations and loaded in data warehouse
• Created different parameters and variables in transformations. Implemented a daily ingestion jobs for dimensions and facts
• Interacted with users and Gathered, addressed business and technical requirements; translated business requirements into technical requirements and specifications
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Prepared operation instruction manuals to business users
• Set up best practices for all Business Objects development and administration
• Prepared Test Data and Validated programs and the reports against the oracle 9i database
• Created, and optimized Business Objects Universes for Financial, Procurement and Fixed Assets using Designer
• Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up Categories using Central Management Console
• Created Financial, Procurement and Fixed Assets reports and Xcelsius Dashboards.
• Created HR Reports like Grant Certification, Leave Accruals, W2 Audit, Payroll, CIGNA, Retirement Projections, Pension Enrollment etc
• Use advanced Business Objects techniques to present data including contexts, drill downs, hierarchies, advances functions, predefined conditions, prompts
• Tuned Universes, created Contexts and Aliases for resolving Loops, Fan Traps, Chasm Traps, and checked the Integrity of the Business Objects Universes
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure
• Created Indexes and Summary tables for improving the performance of reports
• Designed and Developed Datamarts using Star Schema and Snow Flake Schemas

Environment: Business Objects(Designer, Desktop Intelligence, Central Management Console, Web Intelligence, Xcelsius, Websphere), Windows 2003, oracle 9i, Pentaho BI Server, Pentaho Data Integration (PDI/Kettle)

Confidential, New York

Business Analyst

Responsibilities:

• Generated, published and scheduled reports in Web Intelligence..
• Interviewed different departments Claims, Medical Management, Sales & Marketing, Training, Finance to assess the impact of ICD 10
• Involved in the planning phase with respect to Business areas and created Work Breakdown Structure” for them (Claims, Customer Service, Operations, Medical Management)
• Collected production reports and identified various reports currently in use and validated the need for field length changes for the core and custom reports
• Involved in tuning performance of reports by creating aggregate tables
• Created various templates such as Business Requirement Document (BRD), Technical Requirement Document (TBD), Requirement Traceability Matrices (RTM)
• Provided End-user support and training.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Environment: Business Objects 6.5, Oracle 8i,Informatica,Crystal Reports 9.0