SUMMARY

• Experienced as a Lead Business Intelligence Business Analyst with Project Management Skills over 9Years of practice in planning, managing and initiating current & future projects, Gathering Business Requirements, Providing Solutions for the client, Sales team and development teams, Translating Requirements into Specifications and Testing of Business Intelligence Projects\ Products & .Net technology.
• Experience in working with various Business Intelligence tools like QlikView 9, 10 & 11, TIBCO SpotFire 3.2.1 & 5.5, Tableau 8.0, IBM Cognos, SAP Business Objects, BO - Xcelsius, MSBI - 2008 R2 & 2012 (SSRS, SSIS, SSAS with Tabular Modeling)
• Proof of Concepts in tools like Qlikview, Tibco SpotFire, Tableau, JasperSoft - iReport, IBM Cognos\Mobile, MS SSAS.
• Implemented end-to-end Data Warehouse\Business Intelligence solutions.
• Experience in implementing, documenting and providing effort estimation for end-to-end DW\BI solution.
• Experience working in SDLC models and agile methodologies.
• Business Intelligence Analysis - feasibility Study for Product development.
• Research on Product development using different BI tools.
• Analyzing the efficiency of the current BI tools and their gaps in the current market.
• Contributed in conducting JAD Sessions, Gap Analysis and Cost Benefit Analysis.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery.
• Experience in creating UML Diagrams like creating Activity Diagrams, Use Case Diagrams, State Diagrams, Sequence Diagrams and Class Diagrams.
• Expanded expertise in writing Use Case Narratives, System/Process/Business Flow Diagrams, and Business Modeling by using tools such as MS Visio.
• Tracked the Requirements using Requirements Traceability Matrix.
• Expertise in preparing and responding to Business Proposals, Estimations, Tenders and RFP & RFI for BI - Schools, Universities, Healthcare and Construction as a Technical Pre-Sales.
• Excellent working experience in writing test scenarios, test cases and analyzing test results.
• Involved in Test Planning, Test Preparation, Test Execution and Report Generation to ensure features’ compliance with the Business Requirements.
• Performed User Acceptance Testing (UAT) and documentation of Test Cases.
• Ensured the quality and timeliness of delivery of testing assignments.
• Prepared Newsletter and Technical Bulletins for the sales team.
• Documentations such as Technical Pre-Sales, Case Studies, Write-up’s, POC’s, PPT, Approach Document’s, Use Cases.
• Experience in documenting about products and mobile app’s and maintenance of content in company portals.
• Involved in providing training about products and documented user guides for training purpose.
• Attended workshops, training, and classes to keep abreast of trends and tools in technical communications.
• Experience in preparing Estimation documents.
• Expertise in communicating effectively with upper management and End User.
• Experience in executing 2D and 3D animation projects.
• Played a huge role for initiating and closing the lead for the sales team.
• Interaction with the BD/Sales team and proposing input’s\Solution’s and problem solving based on the requirement through Email, Phone and on - site visits.
• Involved in Resource Allocation\Recruiting and Training for all type business and technical users.
• Strong working relationships with Clients, business units and technical team members.
• Highly motivated team player with excellent Interpersonal and Communication skills. Organizational, Problem Solving, Analytical, and Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Operating System: Windows Server 2003, XP, Vista, 7

BA Tools: MS Visio, IBM Rational RequisitePro, Paint.Net, Snagit, JIRA, HP Quality Center 10

BI and Reporting Tools: Qlikview 9, 10 & 11, TIBCO SpotFire 3.2.1 & 5.5, Tableau 8.0MS BI - SQL Server 2008 R2 & 2012 (SSIS, SSRS, SSAS with Tabular Modeling)IBM Cognos 8.3, 8.4, 10, IBM Cognos Mobile, BO-Xcelsius, BO XI R2, XI R3.1

Programming Languages: Dot Net

Animation Tools: Story Board, Photoshop, Dreamweaver, Swift 3D, Flash

MS Office Suits/applications: MS Project 2007, SharePoint Workspace, MS Office Suite

Database: SQL Server 2005, 2008 and 2012

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn,NY

Lead Business Intelligence Business Analyst

Responsibilities:

• Contributing as a Project Manager and a Lead Business Analyst in a rapid changing Business Intelligence environment.
• Performed project management responsibilities in monitoring, reporting key milestones and deliverables in coordination with the business intelligence, quality assurance and analytics teams.
• Planning and monitoring the tasks and accordingly creating tasks and assigning it to team members.
• Responsible in leading the effort in business intelligence solution design and recommended best practices in providing data visualization and data discovery capabilities in Qlikview which was utilized by both the GRA project team and external end-users which included senior managers in Underwriting and Risk Management.
• Responsible for transition from Waterfall to Agile methodology project planning.
• Responsible for initiating meetings with Team, Business Users and everyday BI Huddle meetings with all Team Members.
• Proof of Concept in Business Intelligence analytical tool Qlikview.
• Gathered requirements from business users\underwriters and created requirement specification, Presentation Specs., business case scenarios and workflow analysis.
• Involved with business users to understand the business logic and implemented the same for BI dashboards.
• Created Requirements Document, Technical Spec. Document, Unit Test Document, UAT Test Plan, UAT Test Cases, Issue Tracking Log, for Cognos Development and Qlikview.
• Responsible in creating and maintaining the artifacts for deployment Project Checklist along with Change Management Team.
• Responsible for defining and documenting the Qlikview Process such as QV Migration Procedure for different environments (Dev to Prod), QV Applications Access Request, Steps for QV Application Refresh.
• Involved in analytical tool decision making, recommending along with business users and management.
• Documented the business case into technical specification and approach documents.
• Involved in testing the Qlikview applications along with the QA Team and Business Users.
• Responsible for preparing the overall Business Requirements Document for the entire Project which involved Application Team and BI Analytics Team.
• Prepared Release Notes for the Support Team.
• Performed knowledge transfer and service level agreement confirmations with the application support team as part of overall release process of Qlikview application.
• Responsible for maintaining the GRA SharePoint Support Site and Change Control in SharePoint.
• Designed the overall structure and added contents for QV in Support Site such as Qliki-Wiki which contains QV Getting Started, Basic User, Power User and Developer Access, steps to set up the QV Environment, Framework Model, Standards and Best Practices, Deployment Procedures, Data Release Notes based on each application.
• Responsible for preparing User Guide, Run Book and Disaster Recovery Plan for Cognos and Qlikview.
• Participated and Involved in quality assurance such as test plan, test case generation and defect management utilizing HP Quality Center for Qlikview.
• Involved in preparing presentations for the User meetings.
• Responsible to schedule UAT with Business Users and Analytics Team members.
• Prepared UAT Plan, Regression Test cases for Qlikview and performed the regression testing along with the Business Users.

Environment: Cognos 10, Qlikview 11.2 SR6, Oracle, MS Office Suite, MS Project, HP Quality Center 10, Snagit, SharePoint, MS Visio, Service Now.

Confidential, San Francisco,Ca

Lead Business Intelligence Business Analyst

Responsibilities:

• Contributing as a Project Manager and a Lead Business Analyst in a rapid growing Business Intelligence environment.
• Proof of Concept in Business Intelligence analytical tools like Qlikview, Tibco Spotfire and Tableau & Modeling tool like SSAS (Multidimensional and Tabular Modeling)
• Involved in immediate development of Proof of Concepts with the development and production environment.
• Gathered requirements from business users and created requirement specification for Proof of concept.
• Involved in preparing understanding document based on user input.
• Involved with business users to understand the business logic and implemented the same for BI dashboards.
• Involved with DW team to understand the data structure.
• Development of Sales and Claims dashboards using Qlikview, Tibco Spotfire and Tableau as a POC and documented the same.
• Implemented security features using section access for dashboards in qlikview.
• Data and Application Security for Area Business Managers, Rep’s and in-house business users.
• Two-Tier Architecture was used for Qlikview POC.
• Involved as an Admin using Qlikview and Tableau Server’s.
• Provided authentications and permissions for dashboards and users using Qlikview Management Console.
• Analysis on Qlikview Publisher.
• Development and POC for Integration of Qlikview Dashboard with Orbit Portal using iFrame.
• Involved in analytical tool decision making, recommending along with business users and management.
• Installation and configuration of Qlikview Client and Server.
• Involved with system admin team to setup the server for Qlikview (Dev, Prod & Test)
• Involved in the process of Resource Allocation and Recruiting of Qlikview resources.
• Involved in analysis and providing Qlikview architecture based on various Confidential business.
• Documented the business case into technical specification and approach documents.
• Development of Qlikview Sales dashboard using production data for Portal Integration.
• Development of different set of Qlikview Sales and Claims dashboards using production data.
• Prepared Test Cases and involved in testing process.
• Proof of Concept in SSAS using Multidimensional and Tabular Modeling.
• Development of Cubes using SSAS.
• Documenting the technical designs and logic for SSAS.
• Involved in Onsite Offshore model and Agile methodology.
• Responsible for creating and managing the project plans.
• Planning and monitoring the tasks and accordingly creating tasks and assigning it to team members.
• Responsible for meetings with business users and Rep’s to identify the requirement and improve the process to ensure a stable and accurate solution.

Environment: Qlikview 11.2 SR3, MS SSAS 2012 (Multidimensional and Tabular Modeling), SpotFire 5.5, Tableau 8.0, SQL Server 2008 R2 & 2012, MS Office Suite

Confidential, Atlanta,Ga

Lead Business Intelligence Business Analyst

Responsibilities:

• Contributing as a Project Manager and a Lead Business Analyst for the Business Intelligence Team with Agile methodology.
• Gathered requirements, interacting with users and created requirement specification artifact.
• Planning and monitoring of the tasks and accordingly creating tasks and assigning it to team members.
• Prepared Users Requirements document based on the requirements gathered.
• Facilitated the discussions with the business users to arrive at the list of features of the application to be developed.
• Provided necessary coordination to Associates, contractors and subcontractors.
• Worked with business support and technical experts for design of the dashboards.
• Analysis and Feasibility study for the new requirements from VMS Dashboards.
• Requirement gathering and Prepared Use Cases for the VMS Dashboards.
• Developed dashboard which gives 360 degree view of the Vendors and their performance with the Company to estimate future packages.
• The data used for the development of dashboard were retrieved from SQL Server Database.
• Pie, bar charts, drop down, text box & a list view were used with the calculations based on the tabs used in the application.
• Was involved in comparing the data between the application and the dashboard.
• Signed off Minute of the Meetings.
• Prepared Approach Documents for all the change requests in VMS modules like Auto Triggering, Property Details, etc…
• Worked with the test team to review Test plans and Test Cases, further participated in solution testing.
• Created Release Notes to support the monthly releases.
• Collaborated with the production team to facilitate hassle free release.
• Developed Proof of Concept in SSRS and Qlikview such as dashboards using Drill Down features.
• Involved with the .Net team to implement user Security features for the dashboards.
• Did the Integration with other applications and developed dashboards.
• Conducted clients' communication sessions to evaluate client needs & ensure timely project delivery.
• Worked with the manual testing techniques like Unit Testing and System Integration testing.
• Examined the unit test plans, and directed the onshore/offshore testing team’s work on user acceptance test cases.
• Performed User Acceptance Testing (UAT) and documentation of Test Cases.
• Coordinated the integration test plan execution.
• Created Use Case Diagrams and Sequence Diagrams in MS Visio.
• Also worked with Change Management in order to review and rectify the changes caused due to problems or externally imposed requirements.
• Created Change tickets to manage changing requirements in the management tool called JIRA.

Environment: Dot Net, MSBI - SSRS, Qlikview 11, SQL Server 2008, MS Visio, MS Office Suite, JIRA

Confidential, Irvine, Ca

Lead Business Intelligence Business Analyst

Responsibilities:

• Participated in Business Intelligence project Planning, Estimation and process documentation with Agile methodology.
• Installation/Configuration of Tibco SpotFire.
• Prepared Users Requirements document based on the requirements gathered.
• Converted the Functional Requirements (FRs) into System Specifications (SRSs) and SRSs into Process Flow Diagrams.
• Developed Analytics using the Functionalities like Filters, hierarchies, Marking, Drill Down and Coloring in SpotFire.
• Developing the Analytics based on functional specification.
• Involved in interacting with users, gathering and analyzing requirements, logical and physical design of the Analytics.
• Understood and analyzed the dashboards which were developed in BO and was responsible for the design and development of new spotfire reports.
• Changed the Universe name manually & checked data matching between reports in BO and spotfire.
• Web Services (XML) were used to pull the data to BO and Spotfire.
• Interacted with the Informatica team if there were any issues with the data when developing the dashboards.
• Involved in modifying the universe whenever required.
• Created Dashboards style of reports using SpotFire components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Developed Analytics using all the available visualizations (i.e. Bar Charts, Pie Charts, Line Charts, Scatter Plots, Tree map, Map Chart, Heat Map, Combination Chart, Tables, Summary tables, Crosstab Tables, Box Plot, 3D Scatter Plot, and Parallel Coordinate Plot).
• Created Functional Specs and Report specification Documents.
• Knowledge in Pharmacy benefit management - Electronic prescribing (E-prescribing), Clinical management & Mail service pharmacies.
• Knowledge in HIPAA and its Securities.
• Facilitated JAD sessions with the management team, stakeholders and the team.
• As a liaison between the Developers and Clients, was instrumental in resolving conflicts between user and technical development teams.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Performed business process mapping for change requests and new requirements, created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Generated weekly status reports and Adhoc reports to monitor the progress of the project and to identify critical points at which resources are reallocated.
• Involved in writing test scenarios, test cases and analyzing test results.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in MS Visio.
• Involved inUnit Testing and System Testing in BO XI.
• Created PowerPoint presentations to demonstrate project-wide work flow management and to conduct walkthroughs for end-users.
• Responsible for maintaining the minutes of all the requirement gathering sessions.

Environment: TIBCO SpotFire 3.2.1, Business Objects XI R3.1, Oracle, MS Office Suite, MS Visio

Confidential, NJ

Lead Business Intelligence Business Analyst

Responsibilities:

• Participated in Brain storming sessions in order to prepare the initial requirements draft for the Telecomm business line.
• Involved in requirement gathering and data analysis, coordination with business users for their understanding of data and reporting needs & preparing data flow diagrams.
• Installation and Configuration of QV10.
• Experience in project Planning, Estimation and process documentation.
• Performed GAP analysis and documented the gaps from the previous release of the reports.
• Analysis of Tele - Communication KPI’s for the development of cubes in SSAS.
• Signed off Minute of the Meetings.
• Developed reports & dashboards using all the Sheet Object Properties in QV.
• Based on the Wi5 KPI’s the reports & dashboards are developed such as Enquiry Management, Installation Work Order and Payout Processing.
• Used MS Visio to create Class diagrams.
• Developed reports using Functions and variables based on the requirement.
• Understanding of existing reports and addition of new features for the proposed reports and implementation of prototypes for an initial look/feel of the report.
• Developed interactive dashboards, gauges and indicators for decision making.
• Experience in Using QlikView Functions like Date and Time, Keep, Join, Mapping.
• Implemented user Security features & involved in Deployment of QlikView reports and dashboards.
• Worked with business support and technical experts for modification/Enhancement of the report modules.
• Extensively created test plans and developed test cases and mapped them with the appropriate requirements for debugging purposes.
• Worked with the manual testing techniques like Unit Testing, Load Testing, Smoke Testing and System Integration testing.
• Performed User Acceptance Testing (UAT)
• Created tickets to manage changing requirements in the management tool called JIRA.
• Contributed to Project Management responsibilities in Schedule and Staffing plans.

Environment: Dot Net, Qlikview 10&11, MS BI - SSAS & SSRS, SQL Server 2008, Excel, MS Visio, JIRA

Confidential

Sr. BI Business Analyst

Responsibilities:

• Feasibility study for the new suite\Product.
• Analyzing the efficiency of the current BI tools and their gaps in the current market.
• Analysis, design, development, implementation of BI reports & mobile frameworks.
• Experience in guiding the team with the development of Flex application - Media Player.
• Experience of streaming the video files over TCP/IP for the video source, video source with webcam.
• Used MS Visio to create Use Case diagrams.
• Distributed and shared our analysis with users in the full client through Web Player.
• Installation and Configuration of IBM Cognos.
• Development of Cognos Reports in Report Studio and Query Studio.
• Coordination with the .Net team for deploying the reports in the application.
• Work closely with the data warehouse development team to ensure user requirements and issues are being addressed as per the scope.
• Developing the attractive interfaces and charts for presentation.
• Analysis of the InfoR database and the respected tables for report generation.
• Extensively created test plans and developed test cases and mapped them with the appropriate requirements for debugging purposes.
• Development of Proof of Concepts for Mobile BI.
• Installed the IBM Cognos Mobile software (Blackberry and Android).
• Worked on Simulators to test the developed reports in mobile app.
• Interacted with the Blackberry and Android Development team and provided the inputs for the development of mobile reports.
• Experience in preparing & executing demo’s for the clients.
• Prepared Documentations like Case Studies and Write-up’s.
• Prepared and responded to Business Proposals, Estimations, Tenders and RFP & RFI’s.
• Interaction with the Sales team and proposing input’s\Solution’s based on the requirement.

Environment: Dot Net, Cognos 8.4.1, Cognos 10 Mobile, SQL Server 2008, MS Office Suite, MS Visio