SUMMARY:

• Over Nine (9) years of experience working with US clients, in various capacities like Business/Data Analyst, Project Lead, Project Manager with focus in the areas of Requirements Development and Management, user requirements and business process analysis, System Integration Testing, Quality Assurance, Data analysis & profiling, Data Warehousing, Data modeling and Database design, Data Visualization & Reporting, SQL, XML, JSON, Project Management, End - user training - documentation, planning/scheduling and execution.
• User requirements management and prioritization, user requirements documentation and traceability, requirements validation and UAT.
• Creating an environment that facilitates communication between the technical team/staff, the vendors (if any), business Subject Matter experts and the end business users.
• Developing solutions to extract data for one-time need or for periodic requirement (using stored procedures and/or jobs), using SQL Scripts from application databases or data warehouses based on platforms like MS Access, MS SQL Server, IBM DB2 and Oracle.
• Developing solutions to analyze and profile data extracted from various data sources (including data-warehouses) and adept at converting the analyses into answers for the business problems at hand.
• Adept at creating and documenting end-user training manuals and job aides that are visually appealing and easy-to-understand for the end business users.
• Project management including developing project management plan, project milestone tracking, project status reporting, project performance measurement, project risks and issues management.
• Planned and executed the end-user training program at the completion of each project.
• Effective facilitator of cross-functional team activities, responsible for making presentations to senior managers, PMs and functional managers; high level of proficiency in verbal communication and presentation, excellent business writing and PowerPoint skills, expert in project, financial and management reporting.
• Action-oriented and open-minded person with good work ethic and positive attitude, outstanding time management and multi-tasking skills, good planning skills with solid workflow management through proactive scheduling and task prioritization, self-starter with strong ability to learn and pick up new skill sets quickly.
• Good problem solving skills, capable of taking a holistic view of the problem and pinpointing the root cause, then creating actionable and user-friendly solutions to solve the issues, in the process achieving high level of efficiency and rigor through continuous improvement and quality control.
• Extensive international exposure of working with geographically distributed teams, excellent team player and consensus builder with good inter-personal skills; strong adaptability and flexibility, capable of working in challenging multi-cultural environment and managing changes.
• Good Understanding of markup languages like XML, JSON.
• Well versed with the Software Development Life Cycle (SDLC) and software development frameworks like Waterfall, Agile - Scrum.

TECHNICAL SKILLS:

Proficient in MS Office Suite: Excel and PowerPivot, Access, Project, Word, PowerPoint, Visio, Microsoft SQL Server 2008 R2 and T-SQL, IBM Rational Requisite Pro (for Requirements Development/Management).

Additional working knowledge: IBM Rational ClearQuest (For Issue/Bug Management), MSBI (SSIS for ETL, SSRS for reporting), Oracle 11g, TOAD for Oracle and PL/SQL, SAS, R.

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Business (System) Analyst

Responsibilities:

• Develop, manage, and execute all phases of requirement gathering, including analysis of business processes, requirement and design documentation, and collaborating with both the business customers and IT development team.
• Develop and maintain a thorough knowledge of business processes supported by software systems/products.
• Analyzing numerous ICDs (Interface Control Documents) to understand the interactions between various system modules in the application landscape.
• Document business requirements and business processes using methodologies like UML; develop training programs, documents, and materials.
• Analyze and document “as-is” and “to-be” scenarios (processes, models, use cases, plans and solutions).
• Lead requirements reviews, design reviews, and change control activities.
• Define and implement standards, methods and procedures for requirements and testing activities.
• Interact with QA to support in the development of test cases.
• Work as part of Agile Development Team, effectively participated in agile development planning and agile ceremony meetings.
• Mentor and coach junior business systems analysts.
• Prepare procedure and narratives for all the different processes that impact the Operations team due to the implementation of the new system.

Senior Business Analyst

Confidential

Responsibilities:

• Interview business owners, ask detailed questions and transition interview findings into high level business requirements. Analyze the high-level requirements and convert them into system functional requirements.
• Conduct Brainstorming Sessions with the business owners to gather user interface requirements and develop wireframes/mock-ups for the various screens in the new application.
• Work with business owners to identify and document the reporting requirements, gather the information to be displayed on the reports, undertake report data mapping exercise to identify the data elements to be utilize to populate the reports and deliver the report specification document.
• Provide periodic updates on status of project to the stakeholders including but not limited to business and project team using project reporting aides like spreadsheets, presentations, etc.
• Create training manuals and/or standard operating procedures for end user that are visually appealing and help in understanding and operating the system.

Confidential, Hartford, CT

Assistant Manager (Lead Business/Data Analyst)

Responsibilities:

• Worked directly with the Actuarial Research Business Partners (Data Scientists, Director-Actuary level) of the Commercial Auto line of business (under P&C - Commercial Lines division) on multiple initiatives aimed at supporting the end customers (Actuaries, Product Managers, etc.).
• Interviewed business area experts (e.g. Actuaries, process owners, etc.) and asked detailed questions and transitioned interview findings into business requirements.
• Analyzed the business requirements and turned them into technical requirements.
• Developed Business/Data Requirement Documents and Solution Specifications for the stakeholders using best practices from UML.
• Facilitated walkthrough meetings with Business Users/Directors.
• Analyzing and understanding different data sources to be utilized that meet the requirements, including but not limited to internal sources like Actuarial DataMart, Commercial Lines Data-warehouse and external sources like HLDI, VINtelligence (POLK), MVR (Motor Vehicle Report), etc. SAS as an ETL platform, was utilized to integrate the data sources for the analyses.
• Designing, developing and implementing the solution using different platform (SAS/R/SQL) that aided in generating analyses to solve the business problems at hand.
• Creation of end user reports / views / exhibits using advanced analytics tools like SAS and/or BI tools like Excel/R-Shiny/SSRS depending on project deadlines and priorities to provide enhance data visualization aides to the business users as a solution to their business problems.
• Partnered with the Actuarial research business partners in strategic process/product improvement initiatives like Model refreshes, external data source analyses and their impact on existing models, etc. using the right business and technology knowledge/mix to improve existing processes/modules in the Model Refresh methodology.
• Creating necessary project documentation (specifications/design document/wireframes, etc.) to support the design, construction and testing.
• Also responsible for managing 3 junior analysts in the team who had direct interface with the Advanced Analytics (Actuarial Research) team and responsible for that work-stream’s project management activities.
• Documenting and developing visually appealing job aides, training manuals for the business users.
• Responsible for providing updates on project/progress through project reporting aides like project plan, milestone meetings, presentations, etc. to ensure all stakeholders were on the same page.

Confidential, Cedar Rapids, IA

Project Lead (Technical Business Analyst)

Responsibilities:

• Gained business and system understanding of the conversion project. Client was integrating the Payout systems by migrating from home grown systems to a modern application (wmA) and independently ramped up knowledge of the database structure of the existing payout system of the client in a short span owing to aggressive delivery timelines. Worked on the Extract and Transform phase of the ETL strategy for the conversion project.
• Responsible for Developing the Extract and Transform Layer for the Migration Project.
• Policy Data from erstwhile system (LAVA) being migrated and converted to new platform (wMA).
• Responsible for analyzing source system data & data elements and data mapping documents.
• Designed logic of Extract Layer to transform the data as per wMA standards/ structure.
• Developed, Tested and Executed the solution for migrating the data from source-to-target in MS SQL Server using SQL - Stored Procedures.
• Prepared the Technical Specifications document for the ETL Solution.

Assistant Manager (Senior Business & Data Analyst)

Confidential, Appleton, WI

Responsibilities:

• The goal was to provide staff augmentation support to the client to enhance their business intelligence and analytical capabilities.
• This was an Onshore-Offshore based (20%-80%) project, requiring the initial phase to be spent at client location.
• Elicit and understand the scope of the project and the business needs through meetings with SMEs, Stakeholders and collaborated with business users to understand and document key requirements.
• Responsible for creating a solution that would gauge the effectiveness of the Outbound Campaigns executed by the client’s operation team.
• Worked with the client’s reporting team, business team and management to elicit the key performance metrics that would provide insights (both qualitative and quantitative) on the campaign team’s performance.
• Worked with the client’s business users to refine the campaign’s process to ensure process standardization, data integrity and quality.
• Developed ad-hoc or automated solutions for Data extraction, analysis and reporting using stored procedures, complex SQL Scripts and created reports using platforms like Access.
• Developed complex SQL Scripts that extracted data from varied sources (internal and external) to be fed into the periodic reports consumed by senior management.
• Created detailed and visually enriched end user training manuals/documents to enhance the business user’s experience with the delivered product/service.
• Responsible for providing updates on project/progress through project reporting aides like project plan, milestone meetings, presentations, etc. to ensure all stakeholders were on the same page.

Confidential,Salt Lake City, UT

Responsibilities:

• The goal was to develop a tool which would enable the client to predict spot pricing for any quote given to their customer. The exercise involved developing an integrated database strategy, a user-friendly graphical-user-interface and a statistical predictive model for spot pricing.
• This was an Onshore-Offshore based (50%-50%) project, with substantial time spent at client location before work was carried out offshore.
• Elicit and understand the scope of the project and the business needs through meetings with SMEs, Stakeholders, etc.
• Actively interacted with the Client’s analytics team and management for insights into the project.
• Undertook a detailed data analysis for both external and internal sources.
• Devised a Database strategy to integrate the external and internal data sources (including their Data warehouses / Data Marts). Carried out the Design, Development and execution of the Database Strategy
• Developed numerous ETL jobs through SSIS and automated the jobs to be executed at predetermined schedules.
• Developed automated scripts that would update data in the database specifically for the predictive model.
• Carried out a detailed analysis of the SAS Codes created for the predictive model and single-handedly implemented and automated it in the database (SQL Server).
• Executed End-to-End Testing of the solution exhaustively to ensure all requirements had been covered by it.
• Created detailed and visually enriched end user training manuals/documents to enhance the business user’s experience with the delivered product/service.

Confidential, Madison, WI

Responsibilities:

• The goal was to provide staff augmentation support to the client’s workforce management team.
• Elicit and understand the scope of the project and the business needs through meetings with SMEs, Stakeholders and collaborated with business users to understand and document key requirements.
• Support the operations Customer Contact Centers for the different lines of business by accurately forecasting the different metrics that enable in staffing and scheduling of the contact centers.
• Develop the forecasts for different future time periods like 30-days, 60-days and 90-days forward looking and determining the FTE forecast using the NICE IEX Tool.
• Preparation of periodic updates for the Senior Management on PowerPoint templates with call-outs that provided the stakeholders with a summary on the forecast accuracy and the actual volumes. These updates were an opportunity to gauge the effectiveness and accuracy of the Forecast models for the Contact Centers.
• Worked on ad-hoc requests received from the Contact Center Managers through the onshore business partner. RCA of the unusual call volume spikes, drops, etc.
• Preparation and presentation of work during the Quarterly Business Review with the CUNA Senior Management and gathering their feedback on the unit’s performance.

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Worked on multiple projects with geographically distributed teams in tight deadlines. HCL is the Application Development Partner for the Client and is engaged in implementation of various Variable Annuity Products (New and Enhancements) launched by the Client.
• Worked with the US based clients on the various projects on Onshore-Offshore mix (20%-80%) and on multiple occasions, visited client locations as part of project requirements.
• Gathered and reviewed requirements from the End Users to understand the application.
• Designed, Development, Implementation and Documentation of the application.
• Conducted Meeting with developers and data team to talk about defects.
• Analyzed data requirements and controls, to develop technical requirements for the internal control and analytical reports.
• Interfaced with Subject Matter Experts to document business processes and systems features/function
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Created Business Procedure Documentation to depict Business process flow.
• Provided extensive walkthroughs to the developers and data team around the requirements to ensure they understood the expectation out of the initiative before proceeding into the development phase.
• Provided support to the Project Managers in effective and efficient reporting of project status especially before key milestone deliverables.
• Worked with the QA to develop Test Plans and Test Cases for functional and integration testing.
• Maintained the requirements traceability matrix to track requirements coverage.
• Worked closely with the stakeholders to analyze complex business processes and business requirements.
• Documented any issues or defects and eventually got the sign off from the right parties.
• Manually verified the validity of the failed test cases. Performed Positive, Negative and Black Box testing on the application.
• Designed and developed test scenarios and test cases based on business requirements, technical specifications, and use cases.
• Scheduled and attended internal team meetings with developers and data team to talk about defects.
• Trained users on how to operate the application and go through with the Functionality of the application, facilitated using visually-enriched training manuals and job aides.
• Responsible for providing updates on project/progress through project reporting aides like project plan, milestone meetings, presentations, etc. to ensure all stakeholders were on the same page.