SUMMARY

• 9+ years of working experience in different LOB like Financial, Insurance, Retail and Airlines with extensive knowledge in functional and technical domain of Business Intelligence, Business Analyst, ETL tools, creating reports, dashboards through Tableau, Excel identify trends and processing mapping.
• Proficient in Tableau 7.2/8.1/9.2 (Desktop 7 Server) and Business Objects
• Experience in Software Development Life Cycle (SDLC) that includes responsibilities like documentation, testing, process maps and migration from development to production in Waterfall and Agile methodologies.
• Excellent in creating reports, dashboards, standardize templates setting up new parameters and implementing the reports in different process with writing observations, insights, recommendations in the reports
• Expert in Data Visualization development using Tableau to create complex, and innovative dashboards.
• Notify admin team for changes in user, user groups, and scheduled instances for reports in Tableau reports
• Experience in reports validating and modeling data with the purpose of understanding or making conclusions from the data for decision making
• Experience including technical support (L - 2, L-3), troubleshooting, report design and monitoring of system usage,
• Experienced in running SQL queries and using MS Access to extract data from various databases for data analysis and generating reports as per business needs.
• Experienced in forecasting workload in different techniques like liner, seasonal methods and Calculating manpower requirement based on forecast
• Analyzing at a transaction level information develop Data flow diagrams to evaluate the entire process.
• Good knowledge Data Mapping, process mapping and doing Gap Analyses, Risk Identification and Risk Assessment.
• Experience in working with business and IT team to identify and define the business needs and understand technical requirement to fulfill business needs.
• Experience in conducting group discussion / Training sessions as per business needs.
• Experience in supporting project managers and project in reporting and manpower calculation purposes
• Well versed in project management tools like MS Project for planning, status reporting, and making presentations.
• Excellent oral and written communication, troubleshooting, analytical and interpersonal skills.
• Ability to quickly grasp, work independently and master new concepts and technologies

TECHNICAL SKILLS

BI: Tableau 7.x/8.x,, CMS, Planner and Forecasting, BO

Databases & Related Technologies: Oracle 11g/10g/,Exadatabase MS Access, DB2 MS excel 2010

Operating Systems: Windows 8/7/XP/2003

Modeling Tools: MS-Visio, Word Doc

Languages: SQL, PL/SQL, VB, MS ACCES

Office Tools: Microsoft Office 2003 / 2007 / 2010

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Analyst / Lead

Responsibilities:

• Worked on Market Risk projects for creating interactive dashboard at site and global level by using technology like Tableau, Excel-Pdf and HTML5
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and hierarchies, Sets to create detail level summary report and Dashboard.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards in Tableau and Excel
• Was involved in the creation of test cases of reports and at a step level activity
• Publishing customized interactive reports and dashboards, Tableau server and shrepoint for Excel
• Customized training session for Tableau desktop for focus groups in each verticals
• Phase wise parallel one week reporting was done in each line of business when new system was aligned in deployment stage and change / challenges was managed according to the BRD.
• Conducted meetings /JAD sessions with process owners, SME in each line of business and understand their reporting parameters/ KPI’s and how are they helpful to take business decisions.
• Performed Gap Analysis to check the stakeholder requirements of the project and of the existing process to identify changes or improvement in the process for better results.
• Validated SQL queries to filter data for reporting and Performed Data mapping and report creating steps in MS Visio for documentations.
• Experience in working on Agile methodology for implementing this standardize reporting system.

ENVIRONMENT: Tableau Desktop 8.0, Tableauserver, Excel, Administrator, SQL, MS Project.

Confidential

Business Planning and Management Information Analyst - (BPMI Analyst)

Responsibilities:

• Administered Tableau servers and involved in POC project for mortgage business unit.
• In charge of the team that built the shared Tableau Platform over the virtual environment.
• Working with User for requirements and part of the team developing the software.
• Training sessions to the employees on the tools
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Defined group level security standards for Tableau
• Designed the strategy for Automated Software Delivery through Silent install for Tableau.
• Worked on Tableau, Dashboard and report development team under Performance management
• Took part in the requirement gathering for thereport development from the clients and created reports on par with the requirements.
• Took some sessions for the employees coaching them in Tableau development.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Writing PL SQL quires to support reporting requirement in Tableau
• Documented the entire reporting process and took final sign-off from all the business heads
• Daily reporting of Executive Summary Report for previous day which gives performance level report for all process’s across organization.
• Designed Predicted vs. Actual or GAP analysis report for all the forecasted parameters like workload, resources, time estimates to help track variances on monthly and YTM basis across sites and help key stakeholders for business decisions.
• Scheduled special trainings for loaned manpower for special projects in organization.
• Built multiple “what-if” on resources requirement scenarios for project team to understand the requirement on PERT and created benefit release plan to meet targets identified by the client
• Created or updated existing process maps in Visio and documented process to understand risk and benefits of process integration.
• Subject Matter Expert for Process flow software which records transaction level details along with time information for multiple process.
• Created UAT testing plans and conducted training across process’s for new telephonic systems.

ENVIRONMENT: Tableau Desktop 7.0 Tableauserver / Administrator, PL SQL, Microsoft Excel 2008,MS Access, Microsoft office 2007, Business Objects.

Confidential

Reporting and Workflow Analyst

Responsibilities:

• Developed agent level Call mix based sale report of the architects to alien their individual targets as per workload they have handled which helps the team leader to identify the performance level of their agents.
• Representing HP-sales Analyst team in the Client Management every week call pertaining to variances in the planning along with business justification and improvement measure and discussing any upcoming foreseen or unforeseen event related to business that could hamper performance of the process
• Established team of four real time analysts to monitoring the Queue on various parameters like Average handling time, Absenteeism, Schedule adherences and manage Real-time Breaks and report performance level every two hour to the operations team to understand and take corrective measures to improve the performance level
• Responsible for identifying the training requirements of the team members a vis. the process and individual up-skilling by looking at the skill based sales reports
• Excellent Knowledge of Avaya CMS Software and generating customized reports for the floor with respect to call handling and abandoned rate

Confidential

Reporting and Workflow Analyst

Responsibilities:

• Standardized reporting structure of the Delta process across sites bench marking them against the outsourcing industry standards.
• Scheduling agents on the floor for training by identify the idle time in the queue and for back-office creating new schedules
• Developed a report that calculates the login time and overtime that had ensure that we do not payout any staff that has not completed their target hours for the week. Which helped in reduce the overtime expenses and created a process in which where reporting team will authorize the overtime in the process looking at the workload and overtime required in the team.
• Dashboard reporting structure created and reporting at a site level resources like FTE’s, seats and its availability.
• SLA monitoring process was put in place to track SLS’s at interval levels and find proper reasoning in place for missed SLA’s and incorporated actions in future planning.