Abhishek Narra

PROFESSIONAL SUMMARY:

 Over 10 years of IT experience as a Business Analyst in infrastructure planning, design, implementation,

support and user training for various business applications, and good experience in Business Intelligence
Reporting using several tools like Tableau, PowerBI, MicroStrategy, OBIEE and Crystal Reporting.
 Solid understanding of Business Requirements gathering, Business Process flow, Business Process
Modeling, and database/data warehouse experience.
 Strong knowledge of System Development Life Cycle including analysis, design and review of business
and software requirement specifications, development and Testing Methodologies and Techniques.
 Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions
to extract data from different databases (Oracle, SQL Server) for timely reporting and Validations.
 Extensive hands on experience in reports Design, Development and maintenance of business applications
using Tableau 10.0/9.2/9.0/8.3, MicroStrategy 11.1.0 and Tableau.
 Created Roles, assigned privileges to Users, Folders, Process Groups and scheduled reports by
management console.
 Created Tableau reports using Trend lines, bar, Line, donut, Bubble and Pie charts, area graphs, side-by-
side, gantt charts, Scatter, Whisker plots, Pareto charts and Dual axis graphs.
 Published Tableau data source, workbooks with extracts and live connections to the Tableau server based
on the user requests.
 Generated Dashboards by using Quick filters, Cascade filters, Context filters, Parameters, groups, action
and dynamic sets.
 Working experience in Agile environment and Scrum framework.
 Thorough understanding of testing for the entire software lifecycle and across legacy, client-server and web
platforms, including Version Control in new software rollouts.
 Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit
analysis and ROI analysis.
 Performed tool evaluation and feasibility to help in selecting suitable Automation tools for implementation.
 Expertise in Relational Data Modeling with very good focus on creating physical models and Dimensional
Data Modeling in designing Data Marts and Data warehouse
 In depth understanding of the AS-IS and TO-BE business processes and experience in converting these
requirements into technical specifications for preparing test plans.
 Created technical design, Mockup data, Object mapping document, based on the requirement document.
 Configured Tableau server for automatic email alerts for extract failures, DB connection changes and
repository backups.
 Interacted with ETL team to incorporated necessary changes in data model for MicroStrategy Reporting.
 Created Schema objects & Public objects based on the requirements.

TECHNICAL SKILLS:

 Performing Business Analysis acting as a bridge between engineering teams and client leadership group.
 Reporting in Tableau, PowerBI, MicroStrategy, Cognos, SSRS, Power Builder, Crystal Reports.
 Database experience in Oracle, Hadoop, MySQL, SQL Server, Teradata, Netezza, DynamoDB, Sybase
and DB2, Hive.
 Disaster Recovery strategies and execution.
 Agile Scrum and Waterfall SDLC Methodologies

Languages : Java, Shell Scripting, Visual Basic, ASP, JSP, JavaScript, HTML, DHTML, Python, SQL,
PL/SQL, XML
GUI Tools : Maximo 5.2, MS Visual Studio 6.0, WinRunner6.0, Microsoft Site Server 3.0, TOAD,
 SSIS, Benthic, Teradata SQL Assistant 7.1, WinSCP, Eclipse
Version Control : SVN Tortoise, Clarity, Perforce, Git
Cloud Computing : Amazon Web Services
Operating Systems : Windows, UNIX, IBM AIX, Sun Solaris, Red Hat Linux, HP-UX
Web & App Servers : IIS, Apache, WebLogic

Academic Career

 Bachelors in Electronics & Communication Engineering (2005-2009) JNTUHYD GPA 3.85

 Masters in Computer Science and Information Systems (2010-2012) SAU Magnolia GPA 3.72

PROFESSIONAL EXPERIENCE:

AT&T/Tech Mahindra – Richmond, VA (Remote) Apr ’22 – Present

Technical Business Analyst

Project Description: The objective of REX (Personalization & Recommendations) is to create a single order
repository to capture all the order events across various systems and to build omni-channel experience. The order
modification orchestration updates the order and notifies the customer on the order status while also triggering
appropriate actions by the system.

Responsibilities:

 Collaborated with the Lead Developer and Scrum Master during Sprint Planning to set priorities for sprint
 Understanding and articulating system level impacts to realize user stories written by Product Manager
 Responsible for all aspects of the Scrum team’s output – UX, technology and user story
 Breakdown Epic to features, Understanding integration points, technical dependencies
 Decomposed features from Sr. Product Manager into user stories. Stories broken down into bitable size
based on Solution Architect’s high-level design
 Hosted User Story Refinement with the entire scrum team and answer questions, communicated stories to
Dev and QA
 Collaborated closely with product manager for user story acceptance
 Prioritize stories according to technical design. Accept user stories which meet definition of Done
 Align Features in a Product Roadmap and manage the lifecycle of features while continuing to iterate
 Designed working sessions as needed to clarify customer experience
 Defined and documented interaction experience requirements, Assisted Dev to understand the design for
Sprint x
 Design for Sprint x+1, Prepare stories to be ready for grooming session. Plan for SPIKE sessions
 Leveraged all available data, journey mapping, research and ideation in designs
 Producing new or modified system specifications to be used by Developers
 Conduct QA from leftover from Sprint x-1. Build QA baseline document
 Documented process flows and system context diagrams for complex business scenarios and system
interactions. Maintained Micro Service documentation on SharePoint
 Conducted sprint ceremonies (Daily Stand up, Sprint Demo, Sprint Retrospective, Sprint Planning)
Enforcing timelines and operational rigor within Pre-Build teams
 Organize and coordinate demo including agenda, owning velocity and capacity calculations for the team in
iTrack.
 Manage Jira board and reporting ensuring the sanctity of stories in appropriate status and a steady burn
down
 Collaborated with other technical teams for seamless delivery (scheduling & code review)
 Point of escalation for any blockers or dependencies for Prebuild teams, lead Pre-Build standups
  Working closely with DevOps to ensure stories are deployed properly. Update Wiki page in process space
 Participated in PI Showcase and prioritize feedback

Environment: REST, JSON, SOAP, DevOps, MS Visio, MS Excel, Agile/Scrum, Jira iTrack, SharePoint

Ecolab/TCS America – Dallas, TX (Remote) Mar ’21 – Apr ’22

Technical BA/Project Coordinator

Project Description: As a platform manager, I want to translate the fiscal, scored, non-scored, mobile PowerBI
dashboards to the region-specific language so that the local customers can view it in their language

Responsibilities:

 Working with business partner/Product Managers to elicit requirements and capture business needs
 Lead analysis of business process for Industrial business units
 Implementing and supporting embedded Power BI and Power BI services
 Acting as a liaison between business units and development teams; bridging requirements and solutions,
assessing levels of customer satisfaction, and confirming expectations
 Articulating and documenting business requirements. Drafting User Stories, maintain backlogs and
product/solution roadmaps and communicates status updates to stakeholders
 Experienced in creating reports, dashboards using PowerBI Desktop and Server and maintaining PowerBI
dashboards on servers
 Formulating and defining systems scope and objectives based on both user needs and a thorough
understanding of business systems and industry requirements
 Developing complex requirements for process or system solutions within the business domain, leveraging
multiple business requirements and gathering methodologies to identify business, functional, and non-
functional requirements
 Maintaining expert product knowledge and use on Quick Serve Restaurants (QSR) and Food Retail Service
(FRS) dashboards of varying metrics
 Creating multiple kinds of PowerBI Reports and Dashboards, Building data models on PowerBI
 Basic CRM configuration, workflows, and report writing within MS Dynamics 365
 Assess the risks of various solutions and prioritizes competing business demands
 Manage ongoing relationship with business partner to drive satisfaction with various stakeholders
 Data analysis and design within CRM and integrations
 Assist and/or lead coordination of testing cycles
 Ensuring business alignment between Industrial businesses on CRM platform
 Participate in prioritization and scope for release management
 Monitor and track the success metrics around projects and platforms
 Obtaining key inputs from architecture leads and identifies solution inter-dependencies
 Engage with the business and various users to incorporate usability and user interface needs when
designing solutions
 Providing platform management and leadership for mature applications
 Negotiate SOWs, manages relationships, and monitors vendor performance against SLAs

Environment: PowerBI, Azure DevOps, Salesforce, CDS Analytics, JIRA Align, Visual Basic, SharePoint.
Beacon Health System/HCL America – Granger, IN Oct ‘18 – Feb ‘21

Senior Business Analyst

Project Description: Simultaneously working on Cognos to MicroStrategy migration and U-MART to Power BI
migration projects to primarily help with the BI Development team from requirement gathering till managing end user
feasibility

Responsibilities:

 Lead discovery into specific capabilities in high-priority areas, cultivating buy-in from key stakeholders and
business owners.
 Conduct ad hoc analyses to prioritize, evaluate and assess performance against internal and external
performance benchmarks.
 Partner with various business units to facilitate healthcare budget ideation and ultimately to define
appropriate quantitative performance metrics, serve as an analytical resource for cross-functional initiatives.
 Develop dashboards and other internal tools to provide the leadership group with visibility into key
performance metrics.
 Support analysis of healthcare programs to identify key cost and quality drivers and trends across all
healthcare products in all markets.
 Working in Capital Project rapid development teams (RDTs) as BA and intermediate project manager to
help with the day to day tasks and project tracking.
 Knowledge and understanding of value-based reimbursement contracts, ACO, PHO, CTMS, EDI in
insurance industry and healthcare delivery systems.
 Manage Care Coordination, Value Based Care, Accountable Care Organization, Medicare Shared Savings
Programs, Bundle Payment Programs, and Finance.
 CTMS quality metrics and HEDIS measures. Payor contract analysis and value-based contract analysis.
 Procedure and Diagnosis Coding: CPT, ICD-10, EDI, APR-DRG and MS-DRG with financial and medical
record systems in a healthcare setting supporting the healthcare revenue cycle.
 Support the creation of presentation materials to communicate critical strategic findings to diverse
audiences, from leadership team to engineers.
 Provide analyses around product engagement including how customers engage in content across all
viewership platforms.
 Coordinate with onshore and offshore teams and help them have system accesses and permissions to get
them started.
 Ability to interact with all levels of healthcare professionals and staff in one-on-one and group settings.
 Provide analytic support for Retention operations and offer optimization via OR processes and leveraging
1:1 model as well as targeted micro segmentation.
 Analyze and provide analyses to support proactive retention including the impacts of false-positives and
optimization opportunities to improve targeting.
 Forecasting with respect to healthcare resource allocation, Budgeting, Funding, Timelines for deliverables.
 Budget allocation for each sprint for both on-shore and off-shore teams.
 Tableau tool analysis and providing POC to clients.
 Migrating SSRS Reports and Asp.Net reports to PowerBI replicating the same report functionality.
 Design holistic and integrated high-level solutions that fit customers' business needs, production operability
and budget.
 Participate in and lead formal and informal design reviews with stakeholders providing technical perspective
and support.
 Support your projects through their entire life cycle, incl. scoping, design, development, testing deployment,
post-production and information management.
 Facilitate and support design, development, testing and delivery planning in my domain.
 Knowledge of healthcare data, including medical and pharmacy claims, EMR data, HIE data, UM data and
demographic data.
Environment: Cognos EBP, MicroStrategy, U-Mart repository, PowerBI, AgileCraft, SVN Tortoise, Visual Basic,
SQL Server 2014/2017

GM Financial/TCS America – Philadelphia, PA Jun ‘16 – Oct ‘18

Credit Risk Analyst

Project Description: BI Team working in association with sales and marketing to analyze the customer loan data
according to business requirements

Responsibilities:

 Designed the business requirement collection approach based on the project scope and SDLC
Methodology.
 Partnering with stakeholders from Finance, GPOs, IT, EDA, Operations, Revenue, FP&A, Product
Management, to support a reporting requirement.
 Developed business requirement specification documents as well as high-level project plan.
 The scope of the project was to enable a customer to apply for a fixed rate home equity loan or a home
equity line of credit.
 Integral part of the team assigned the task of carrying out certain project management responsibilities and
thus obtained a grasp of the entire project.
 Ensured timely completion of project tasks and deliverables with a high degree of quality by prioritizing
tasks appropriately and resolving issues along with the project manager.
 Followed a structured approach to organize requirements into logical groupings of essential business
processes, business rules, and information needs, and insured that critical requirements are not missed.
 OTC Derivatives experience - CDS/CDX Swaps, Total Return Swaps, FX options, Interest Rate Swaptions,
Equity Swaps, and Collateral Management.
 Worked to create Data Mapping Documents and worked with business to write transformation rules
 Facilitated and managed meeting sessions with committee of SMEs from various business areas including
using Calypso application for Mortgage Servicing, Loan Monitoring and Asset Management.
 Performed Data cleansing to detect and correct corrupted data and responsible for creating and maintain
end-to-end data mapping and data conversion spreadsheet.
 Business knowledge of Capital Markets Fixed Income Derivatives with experience with Reg Reporting.
 Understanding the trading lifecycle - New trades, amends, terminations, cash flow, and coupon payments.
 Summit, Calypso, and/or Murex, XML to map to downstream to AIP and Netsuite ERP - Pricing,
Confirmation, and Settlement.
 Conducted interviews with key business users to collect requirement and business process information.
 Performed extensive requirement analysis including data analysis and gap analysis.
 Used RUP iterative process to conduct Data Analysis on the client profile data to find missing data fields in
the database and customize them.
 Comprehensively work with requirement gathering for Enterprise reporting system using RevPro.
 Understanding of accounting department functions, preparing GAAP financial statements and footnotes on
Netsuite and internal controls Create, maintain, and run financial models, Monte-Carlo simulators, financial
forecasters, and ROI systems and practices best suited for decision making.
 Designed and developed all Use Cases and UML models using Rational.
 Experience with the Program Budget Information System, Automated Funding Document System, Standard
Accounting Reporting System.
 Helped in creating of data-mapping best practices document including visual processes and trained team
members on data mapping process and tools
 Designed and implemented SQL queries for QA testing and report / data validation.
 Developed requirement reports for day-to-day retail banking needs for opening account, online baking using
Rational SoDA.
  Played a key role in the budget planning, testing, and implementation of system enhancements and
conversions.
 Responsible for coordinating Joint Application Development (JAD) sessions with business users, technical
team, DBAs, testing team to analyze and validate the requirements, application lifecycle, gather and define
the KPI’s, document and present the requirements specifications.
 Research and prepare responses to financial data calls from various organizations, including, the
comptroller, the Chief Financial Officer, and resource sponsors.
 Maintained the Traceability Matrix table to uniquely trace the identified business requirements to general
design to testing as proof that requirements requested have been developed into a solution and that it has
been tested and tracked.
 Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data.
 Experience with large scale ERP (Oracle, NetSuite), SaaS applications (Coupa, Concur, RevStream,
RevPro, Workday, Intacct) with strong financial modeling and financial analytics skills.
 Used Rational ClearCase and ClearQuest as Configuration Management and Change control tools.
 Work with development team during release shake outs, and UAT for Micro Strategy dashboards.
 Understanding Core Financial processes, accounting practices, Revenue Accounting, Data analysis and
reconciliation.

Environment: VB/JavaScript, Calypso, ASP.NET, XML 1.0, Microsoft Office, Netsuite, Microsoft SharePoint, SQL
Server 2008, UML2.1, SDLC, Rational Rose, RevPro, UAT, Rational Test Manager

Otsuka Pharmaceuticals Inc – Princeton, NJ Jul ‘14 – May ‘16

QMS Business Analyst

Project Description: Engineered for design and delivery of SABER, SABER2 reports that display the audit and
control package details of work streams such as Wholesale, Retail, Equity, Market Risk, Consolidation that are
consumed by Internal stakeholders

Responsibilities:

 Identified the requirements of the stakeholders and created Business Requirement Document (BRD) and
Functional Requirement Document (FRD).
 Expert in creating high level requirements from requirement gatherings while following various elicitation
techniques like Interviews, Workshops, Procurement and Document Analysis with experience in process
modeling in regulator pharma domain.
 Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new
business requirements.
 Followed solely RUP methodologies during the course of the project.
 Accumulated system requirements from various departments through surveys and interviews.
 Involved in prioritizing the defects and writing business requirements to resolve them.
 Conducted JAD sessions with management, EIR, SME, vendors, CTMS users and other stakeholders for
open and pending issues.
 Define future procedure to implement out of the box Pharmaceutical Supply Chain packaged solutions
 Developing medical and pharmacy prior authorization rules based on CTMS parameters and coordinating
changes with the clinicians ensuring all changes are tested and documented, CTMS operations
management, bio sample management, Clinical Systems (EDC, Clinical Trial Management System (CTMS)
 Answering incoming written or verbal inquiries from internal and external clients
 Coordinating inquiry responses with CTMS and other appropriate departments
 Day to day production support for EDI (US) application for trns 850, 810, 812, 844, 849, 845.
 EDI Implementation of strategic projects like procurement of free/Commercial goods, new drug launches
like Tysabri, Plegdry, Spinraza and new trading partners Smith drug, McKesson, Dakota drug.
 EIR Mail order project implementation for Accredo, Acaria, US Bio and Walgreen.
  HP ALM testing (EQMS) for testing, documenting defects and triaging the defects related to EDI, Denodo,
LMS, OBIEE projects.
 Experience enforcing and adhering to GXP system and processes and managing defect remediation
process for pharmaceutical systems.
 Strong Experience in Test Plans development, Test Conditions and Test Cases, test data creation and
analysis, interaction with the development team for error detection and correction as per the defect lifecycle.
 Hands on implementing Web, Portal, Web-Services and Enterprise Applications using Object Oriented
Analysis and Design (OOAD) Methodology.
 Developed process and design documentations for US EDI Applications.
 Gathered user requirements for EIR using JAD sessions and documented user requirements for Supported
HP ALM testing at Otsuka for verification and validation under guidelines of 21_CFR_part_11 for GXP
applications related to FDA.
 Used Track wise for Deviation corrective and preventive action (CAPA).
 Used my CTMS (DMS) for documenting EIR project requirements.
 End User testing and Migration of modules to procurement. Verification and validation of user requirements.
 Coordinated efforts with Vendors like IBM, ABC, McKesson, Cardinal, Smith drug, Dakota drug etc for joint
development, testing, verification and validation.
 Working knowledge of regulatory requirements pertaining to pharmaceutical industry, including OIG
regulatory guidance, Pharma, and FDA regulations.

Environment: MS Project, MS Access, MS office 2016, SQL Server 2012, Waterfall, SharePoint, Visio, OKTA,
Tableau, Dell/Quest One Identity Manager, Excel, Power BI, SDLC, UML, Swim Lane, Sequence Diagram, MyCIMS

American National Bank & Trust – Wichita Falls, TX Dec ’13 – Jun ’14

IT Business Analyst

Project Description: FIMM project is to develop, acquire, and operate a safe, legal, reliable, and cost-effective
supplemental banking site interfacing when and where our customers demand

Responsibilities:

 Responsible for integrating the bank's Online Banking portal with the backend servicing systems ensuring
compliance with bank policies and applicable regulations.
 Interacted with Users and Stakeholders to identify business system needs, evaluated solutions for business
problems
 Worked with SME’s of different groups to gain detailed knowledge of Investments and Capital Market and to
understand the cross impacts of the system
 Analyzed and documented information system requirements and the corresponding impact on business
processes. Provide analytical consultation for various assigned areas of Premier Bankcard.
 Studied the Business Requirement Document (BRD), supporting documents containing essential business
elements, detailed definition, and description of the relationship between the actors
 Designed and developed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams to define the
Business Process.
 Provides high-level customer communication experience for business banking requests, including
assessing and implementing appropriate response with various banking teams as appropriate.
 Assisted in updating error report job aid as well as current release documentation on Netsuite for UAT Test
Plan.
 Analyzed the data entity relationships and worked on multiple short-term projects in between.
 Worked as a team with other business analysts to make an object-oriented model of the application and
created use cases
  Conducted JAD sessions to allow different stakeholders to communicate with each other, resolve problems
at early stage.
 Experience with core banking deposit accounts, loans and digital banking channels online account opening,
online and mobile banking, etc.
 Hands on experience in working with active directory, to give privileges and access to the users according
to their roles and designations
 Analyzed Business Requirements documents to get a better understanding of the system on both Technical
and Business perspectives.
 Creating a robust analytical framework for evaluating banking performance in an economic downturn.

Environment: SQL Server, Maximo 5.2, PL/SQL Developer 7.0, JSP, Java 1.5, Netsuite, JavaScript, WebLogic
Server 8.1 SP6, Oracle 9i, HP-UX, Windows XP

Cerner Health Care – Kansas City, MO Aug ’12 - Nov ’13

Business Data Analyst

Project Description: Cerner’s clients manufacture and markets a wide range of pharmaceuticals in India and
overseas. The company has over 190 medications, 60 active pharmaceutical ingredients (APIs) for drug
manufacture, diagnostic kits, critical care, and biotechnology products

Responsibilities:
 This project involved sharing and maintaining the knowledgebase from R&D and EIR CTMS amongst
various departments through a portal system.
 Respond to ad-hoc requests from Network Management, Provider Organizations and physician groups. The
requests include, but are not limited to, claims reports, Primary Care Physician Excess Medical Revenue
(EMR) reports, and regulatory reports.
 Assist projects to integrate clients claims data (Medical & Pharmacy) into the data warehouse in conjunction
with the Sales Analytics and Client Analytics teams.
 Familiarity and exposure to the healthcare industry including managed Care Coordination, Value Based
Care, Accountable Care Organization, Medicare Shared Savings Programs, Bundle Payment Programs,
and Finance.
 Responsible for defining the scope and implementing business rules of the EIR project, gathering business
requirements and documentation, Oversee Medicare and Medicaid cost report audits and appeals
 Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification
(URS).
 Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity
Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the
Data Process Models.
 Experience in the Healthcare Industry in payer, provider, and/or vendor organizations using Medical Claims
data (medical cost, utilization, cost benefit analysis, etc.) to perform claims/prior authorization-based
cost/quality of care analytics.
 Performed extensive Requirement Analysis including data analysis and gap analysis in a complex
healthcare setting.
 Successfully conducted JAD sessions, which helped synchronize the different EIR stakeholders on their
objectives and helped the developers to have a clear-cut picture of the project.
 Developed medical and pharmacy prior authorization rules based on CTMS parameters. Coordinated
inquiry responses with clinical and other appropriate departments.
 Wrote Test Cases and performed User Acceptance Testing, documented the in-detail defects using the
Defect Tracking report.
 Up-to-date technically and regulatory changes and apply new knowledge to preparation of business and
specification documents.
Environment: OBIEE, PL/SQL, SQL, Python, Oracle 10g, Windows 2000, JSP, JavaScript, Java Runtime
Environment (JRE)