Home

Naren R - Lead Business Analyst

[email protected]

Location: Denver, Colorado, USA

Relocation: YES

Visa: H1B

Resume file: Naren_Lead Func BA with D365_1752673571944.doc Please check the file(s) for viruses. Files are checked manually and then made available for download.

NAREN VARMA Email: [email protected] SUMMARY: Exhibiting proficiency with precision and expertise: Drawing upon an extensive IT background, I have successfully fulfilled the role of a Business/Data Analyst, demonstrating proficiency across all phases of the Product Development Life Cycle (PDLC). These encompassed requirement gathering, rigorous analysis, meticulous testing, and precise implementation. With overall 12 years of comprehensive experience as a Technical Business Analyst in the fields of Information Technology & Service industries. Experience in SQL, MS-Project, Rally and Jira for status reporting and planning. Strong skills in user research and analysis of existing systems. Proficient in understanding business/customer needs and technology. Strong knowledge of SDLC, project life cycle, and Project Management including Agile, Scrum and Waterfall. Interact with End Users, Investigate, analyze, and troubleshoot the issues raised, track up to closure. Proficient in Eliciting and Analyzing Requirements using techniques such as Document Analysis, Stakeholder Interviews, Joint Application Development Sessions (JAD), Questionnaires, Focus group sessions, Gap Analysis, Risk Analysis, Impact Analysis, Root-cause Analysis, and Interface Analysis on projects. Extensive experience in data mining, data warehousing, and advanced data analysis. Proven track record of leveraging large datasets to drive strategic business decisions and optimize processes. Expert in designing and maintaining data warehouse structures, conducting complex data queries, and visualizing data to uncover insights. Strong skills in SQL, Python, and ETL processes Maintain Documentation and relationship with technical teams and Business Owners. Creating UML Diagrams including Use Cases Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio. Experience in writing BRD, functional specifications based on user requirements. Extensive Experience with Agile (Scrum, Kanban and Hybrid) and water fall methodology. Exposure in collecting Raw data and processing it according to the client requirement. Experience in Defining Test Plan, Test cases and Timelines for UAT and Performance Testing Hands on experience in SQL Queries, UNIX commands. Ability to interact with individuals at all levels with exceptional skills in forming and facilitating Joint Application Development (JAD) and Rapid Application Development (RAD) teams. Analytical, methodical, and resourceful approach to problem solving, identifying root causes (RCA) and corrective actions to meet short and long-term business, financial, and system requirements. CERTIFICATIONS Certified Scrum Master (CSM) Sep.23 TECHNICAL EXPERTISE Languages C, HTML, Java, Python, R, .Net RDBMS Oracle 9i, MS Access, SQL Server Methods SDLC, Waterfall, Scaled and Scrum Agile. Software Application Microsoft Office, PEGA, Tableau, Big Data, SASS, SPSS IDE & Tools PyCharm, Python Notebooks, MS Office Suite Robotic Process UiPath, Blue Prism Other Microsoft 365, Adobe Products (Premier Pro, After Effects, Photoshop) EDUCATION: Bachelor of Science Degree from, Andhra University, India Jun.09 Master of Business Administration, Christ University, India May.13 MS in Management and Information Systems, Northern Illinois University, USA May.18 PROFESSIONAL EXPERIENCE Carelon Behavioral Health Lead Business Analyst Oct.23 - Current Project: FTP File Server Update/Migration As a Lead Business Analyst, act as a liaison between the SMEs/End Users and the team, communicating the requirements and assisting the developers to understand the needs of the end users. Created Business Requirement documents (BRD) and Functional Requirement Documents (FRD) and translated those requirements into User Stories for development. Conduct initial testing of all developments prior to user testing. Assist in bug identification and resolution. Determine and develop user requirements for systems in production. Performing regression and user acceptance testing. Implementing and maintaining procedures. Environment: ServiceNow, SQL server, SharePoint, MS Office Suite Constellation Energy, DC Business Analyst Jun.22 Aug.23 Project: Product Management/Project Management As a Business Analyst, acting as a liaison between end users and developers on the Azure DevOps and Stasis platform to generate, modify and update User Stories for sprints of the scrum cycle. Conduct weekly Refinement sessions to have the stories ready for Sprints. Assist the Product Owner in developing stories and in turn making sure the team has a healthy backlog. Implemented Agile methodologies to manage projects, ensuring timely delivery and alignment with stakeholder priorities. Assist Product Owner in developing mockups/prototypes of end products and reviewing the same with SMEs. Act as a liaison between the SMEs/End Users and the team, communicating the requirements and assisting the developers to understand the needs of the end users. Update internal documentation, and formally initiate and deliver requirements and documentation. Maintained organized documentation of requirements, user stories, and project progress, facilitating effective communication and collaboration across teams. Conduct initial testing of all developments prior to user testing. Assist in bug identification and resolution. Determine and develop user requirements for systems in production. Gathering critical information from meetings with various stakeholders. Performing regression and user acceptance testing. Implementing and maintaining procedures. Updating and modifying Themes/Epics/Features for the Sprint process. Environment: SQL server, Azure DevOps, SharePoint, MS Office Suite Mission Square, DC Business Analyst/Data Analyst Jan.21 Jun.22 Project: Product Management/Project Management As a Business Analyst, acted as a liaison between end users and developers on the ServiceNow platform to generate, modify and update User Stories for sprints of the scrum cycle. Updated internal and external documentation, and formally initiated and delivered requirements and documentation. Determined and developed user requirements for systems in production. Evaluated business processes, uncovering areas for improvement, and developing solutions. Assisted in reviews of business processes. Conducted meetings and presentations to share ideas. Performed requirements analysis along with managers to better elucidate end user needs. Effectively communicated insights and plans to the team. Gathered critical information from meetings with stakeholders of a particular product. Performed user acceptance testing. Monitored deliverables and timely completion of projects. Delivered on ServiceNow dashboard mockups based on end user requirements. Documented Sprint Retrospectives and Sprint Planning sessions. Updated and modified Themes and Epics for the Sprint process. Developed Project Plans, Project Charters, and Project Management timelines. Unit tested the IVR platform of Mission Square Retirement Assisted the team in the rebranding process of ICMA-RC to Mission Square Retirement. Worked on Vendor Requirements Matrices. Data mapping based on disparate sources of tables and views using Excel and Oracle SQL Developer. Environment: ServiceNow, SQL server, SharePoint, MS Office Suite USAA, TX Business Analyst/ Data Analyst Jan.19 Jan 21 Project: Product Management/Competitive Intelligence & Analysis (Insurance) Worked as a Tableau Developer for the project which consists of multiple teams from both offshore and onshore in an agile environment through iterations for each program increment. Created a Property & Casualty Competitiveness platform using multiple data sources (Cube & Hadoop) with 8.5 billion+ rows of data and numerous dimensions which consists of information from various teams/divisions under P&C and outside sources. Incorporated data from market, financials, and Ad Spend to compare the competitiveness of USAA. Used Tableau to create executive dashboards, scorecards, and weekly/monthly reports on the status of key business measurements. Collected and analyzed large data sets from internal systems. Developed interactive Tableau dashboards by utilizing Tableau features such as parameters, sets, calculated fields and table calculations, user filters, action filters and applied advanced technical charts. Implemented ETL processes to extract, transform, and load data from various sources. Developed and maintained data warehouse structures, ensuring data integrity and accessibility. Collaborated with users to define requirements for Tableau reports and support the implementation and customization of Tableau reports. Defined retrieved and analyzed large datasets using SQL, and Excel to drive and define operational solutions and approaches. Developed mockups and prototypes of dashboards for clients based on best design practices in data visualization. Managing other smaller projects and deliverables to clients, coordinating with teams offshore and onshore. Performed GAP analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements. Assisted with User Acceptance Testing (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place. Responsible for identifying and documenting business rules and creating detailed Use Case Conduct User Acceptance Testing. Performed Manual Testing on different modules of the application. Performed IST (Integrated System Testing) Regression Testing online on different operating systems and browsers. Used detailed knowledge of application features and functions to assess scope and impact of business needs throughout analysis and completion of all enhancement specifications. Responsible for project documentations Business Requirement Document Scope Document Project Approximation Estimations Meeting Minutes and Timeline documentation, Gap and Impact Analysis, Visual Basic Flow diagrams, Mapping documentation, UAT test case Documentation, Operation support plan. Environment: Big Data, SQL server, Tableau Desktop 10.5, Tableau server, SQL Server, SQL 2008, SharePoint, MS Office Suite, Clear Quest. ICMA-RC, Washington Business/Data Analyst Jun.18 Jan.19 Project: ICMA-RC Data Dictionary Participated in designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints. Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats. Consolidated 17 Data Glossaries having 47k attributes and compiled a single Data Dictionary All element info is available in a table/excel, csv - except ~300 which are in various other document structures. Facilitated Joint Application Development (JAD) sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business users and technical teams. Involved in Requirement Scoping and analyzing high priority requirements for implementation. Participated in Design walk-through with SMEs to baseline the business architecture. Analyzed Requirements and created Business Requirement Document (BRD), Current business process flow, Future business process flow, Use Cases, Use Case Diagrams, and Activity Diagrams, mockups using Microsoft Visio. Created and managed project templates. Prepared Test Concepts like Test plan, Test cases for UAT and Performance Testing and owned it till signoff are completed. Identified risks and escalated in timely manner. Timely Identified and escalates environment issues, data gaps and appropriate administration Coordinated between offshore and onshore project teams regarding proper test procedure, review techniques for test basis testing, test case definition, use Quality Center, use of other test services, test automation, load and performance tests etc. Defines / selects test-KPIs for the project reporting. Environment: Windows, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS Access, MS Project, SQL, SQL server, Rally, Agile (Kanban). Northern Illinois University, IL Business /Data Analyst Jun.17 May.18 Graduate Research Project: Social Media Analytics Performed Twitter Data Scraping using different APIs in R Studio, related to Facebook and twitter for over a span of 5 months. Generated word clouds, dendrograms, histograms using the data extracted from respective streams. Analyzed twitter and Facebook customer data, by performing sentiment analysis using R-Studio and visualized the data using Tableau. Developed dashboards which included geographical mapping functionalities and data visualization features of Tableau involving multiple dimensions and measures. Project: E-Commerce Website Assisted professor in building an e-Commerce website using .Net application in visual studio. Identified both Functional and Non-Functional Requirements. Created process Flow diagrams, Functional requirement documents, High Level and Low-Level Design Documents. Designed the User Interface of the website using bootstrap and CSS. Built a relational database model, entity-relationship modeling in the MS SQL Server and linked it to the E-commerce website to store the data coming from the said website. Environment: Python, R, Tableau, MS Office, .NET Fluentgrid Limited, India Business Analyst May.13 May.16 Analyzed the business need and Request for Changes (RFC) and worked with stakeholders in scope definition. Prepared, analyzed As-Is and To-Be of existing architecture and performed gap analysis. Worked with Subject Matter Experts (SMEs) and stakeholders to gather, analyze and document all business and non-functional requirements for the project. Created Business Requirement documents (BRD), Functional Requirement Documents (FRD) and translated those requirements into User Stories for Scrum Process in JIRA. Developed Process Flow Diagram/Activity Diagrams, Test Cases, Use Cases. Responsible for developing and maintaining requirements documentation including Proposed solution documents (PSDs), System requirement documents (SRDs), system process flows and story board for user interface changes. Participated in RFP/RFI/EOI analysis to provide key inputs for the management towards go / no-go decisions. Involved in development, systems testing and reporting activities to define scope, purpose, requirements, and the solution. Provided cost/benefit analysis and enhancing the effectiveness of the business. Implemented SDLC which included requirements specifications, design, analysis and testing. Involved in GAP analysis both at the time of requirement gathering and later after development with the Testing team to identify areas and possible scenarios that might have been overlooked. Facilitated collection of functional requirements from system users and preparation of functional specification documents that provided appropriate scope of work for technical team to develop prototype and overall system. Environment: SQL, MS Office Suite, MS Access, MS Project, Share point, Oracle DB, Tableau Fluentgrid Limited, India Business Analyst May.10 May.11 Created Business Requirement documents (BRD), Functional Requirement Documents (FRD) and translated those requirements into User Stories for Scrum Process in JIRA. Developed Process Flow Diagram/Activity Diagrams, Test Cases, Use Cases. Responsible for developing and maintaining requirements documentation including Proposed solution documents (PSDs), System requirement documents (SRDs), system process flows and story board for user interface changes. Designed use cases, activity diagrams and sequence diagrams as per the requirements. Validating QMO defects and conducting a breakout session with SMEs to provide solution. Provide KT for testing teams on the Baseline & Actuals data model. Presented/Conducted multiple MRO sessions to the team to get an insight on power sector domain. Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), MS Access, MS Project, Share point, PL/SQL, Oracle DB, Tableau, Ab initio Micro labs, India Data Analyst Jan.09 May.10 Designed use cases, activity diagrams and sequence diagrams as per the requirements. Performed GAP Analysis. Working with various stakeholders and creating STTM (Source to Target Mapping) with both technical and non-technical details. Worked on analyzing the downstream data based on back end. Performing Data Profiling for various business meetings and completing POC s for business meetings. Created AS-IS and TO-BE flow diagrams for user manual/ training support. Review test cases of three different testing teams and providing approval. Participating in the MOB sessions to resolve the open ALMs with the business. Keywords: cprogramm database active directory rlang information technology golang microsoft procedural language Illinois Texas