Technical Skills

Methodologies

Agile, Waterfall, RUP, JAD, RAD.

Modelling and Analysis

Microsoft Visio, Rational Rose UML (Unified Modeling Language), ERWIN, Techno Solutions- Top Team Net Client 6.315, SnagIt 10, MS Office Suite, MS Project

Data Analysis

MS Excel, Excel Functions, VBA, SQL, Ab Initio Express

ETL Tools

SSIS, Informatica, MicroStrategy 8.0 Data Stage

Reporting Tools

SAP Business Objects / XCelcius / Crystal Reports Enterprise, Tableau, MS PowerBI, SSRS, Cognos

Databases

MS SQL Server 2012, 2008/2000/7.0/6.5, Oracle 10g/9x/8.0/7.x, 2000/97/7.0, DB2, My SQL, Teradata, SAP Hana 1.x / 2.x

ERP / CRM / MDM

SAP, Oracle Apps, JDE, JDA, BPCS, SFDC, SAP MDM / MDG

Programming

SQL, TSQL, PL/SQL, ASP.Net, VB.Net, VBA, C, HTML, XML

Operating Systems

Windows 8,7/XP/2000/98/NT, Mac OSX, Mac OSX Yosemite

Productivity

MS Office, MS Project, Microsoft SharePoint, VersionOne, HP Quality Center

Education

Bachelors from Osmania University, Hyderabad, India 2001

Work Authorization

US Citizen

Linkedin

Kumar Santosh LinkedIn

SUMMARY:

Over 10+ years of IT experience in System and Business Analysis, Requirement Analysis and Process Management

Methodologies: 8 years of experience in all phases of Software Development Life Cycle (SDLC) achieving milestone using Agile and waterfall model.

Modeling and Analysis: 7 years of strong experience in UML Modeling, including Use Cases, Activity Diagram, Sequence Diagram, State Chart Diagram, Deployment Diagram, Class Diagram, and Component Diagram. Have extensive knowledge in Data flow modelling and Object modeling, case analysis and functional decomposition analysis. Proficient at drawing Business Process Diagrams and Workflow Diagram.

8 years Database experience using MS SQL Server 2008/2005/2000, Oracle 11g/10g/9i/8i, MS Access, DB2 and My SQL.

6 years of experience using reporting tools such as SQL Server, SSRS, Cognos and MS Access

3 years of experience in Data Analysis and Data Quality Analysis, analyzing medium to large databases through data analysis tools in health care, financial and automobile organizations.

Good understanding of IT service management principles (Incident, Change, Request, Knowledge, SLAs, Performance Analytics, CMDB, etc.,).

Broad, enterprise-wide view and understanding of strategy, processes, and capabilities, enabling technologies, and governance.

Strong business acumen and proven track record for providing innovative solutions resulting in increased business performance.

Strong experience in Agile analysis including estimation and prioritization of requirements and creating user stories

Strong experience in gathering requirements and creating functional and technical user stories with detailed acceptance criteria

Experience with showcasing user stories to Product Owner and getting them signed off

Proficient in SQL querying. Possess experience with programming SQL.

Extensive experience in writing Business Requirements Documents (BRD), Use Case Specifications, Functional Requirement Specifications (FRs), High Level Design Specifications (HLDs), Technical Requirements Specifications (TRs) and Training documents.

Facilitated Joint Requirement Planning (JRP) sessions, Joint Application Development (JAD) sessions with Subject Matter Experts (SMEs), Business User Groups, Top Management Groups and Technical Groups

Experienced in creating Wireframes and Mock Up documents, Data Models for Interfaces, Reports and Extracts using ASP.Net, MS Visio, ERWIN and SSRS and SQL Server.

Experienced in developing and executing Test Approach Documents, test plans, test scenarios, test procedures, test cases, test data and test scripts according to Business and Design Specifications

Experience working in a senior role with Project Manager, technical teams as well as the business, coordinating projects from requirement gathering stage until deployment and launch

Experienced with SDLC for supporting Data Extraction, Transformations and Loading process in corporate-wide Data Warehouse solutions using ETL and BI processes. Proficient in Data Warehouse Best Practices for ETL and BI projects. Experience working with data in large Data Warehouses.

Experienced in OLTP, OLAP databases, Normalization, Star and Snowflake data models, testing data warehouse design, structure and data flow. Proficient in querying and reporting out of data warehouse.

Experienced in functional, regression, end to end, system and use acceptance testing.

Strong Knowledge of the ETL tool Informatica and experienced in preparing ETL design documents, data mapping sheets and test case documents

Experience in Information Security requirements, analysis and knowledge of Information Security controls and measures.

Knowledge of IT compliance and IT Information security procedures.

Strong experience in agile analysis and best practices including estimation and prioritization of requirements and creating user stories. Used VersionOne to manage projects through iterations.

Knowledge of analyses of revenues, profit margins, and close dates

Adept in multi-tasking and handling multiple tasks/projects at the same time

Skilled in managing teams of diverse backgrounds to make sound business decisions based on analyses of short and long term business needs.

Professional Experience:

Walmart, Bentonville, AR Jan 2021 – Present

Business Systems Data Analyst / Product Manager

Responsibilities:

Work within identified scope of project, gathers business requirements by working with business stakeholders, Business Architecture, IT and Vendors (or cross-functional technical teams).

Good understanding of SQL, writing queries, joins, functions creating report etc.

Work to facilitate business requirement, elicitation sessions with multiple stakeholders

Capture and write document business requirements including system application flows and impacts.

Develop new process flows and functionality integration and adding any needed clarity to requirements as well as documenting progress.

Identify potential issues and risks after conducting a gap analysis.

Plan and consults with business stakeholders on data reporting and trending reports as needed.

Act as Single Primary Contact to assist in defining business system requirements.

Work with appropriate departments to assure technical information is accurate and documented.

Create and apply diagrams that represent the flow, the process, and the transformation of data within various systems for current and future state.

Maintain approved project artifacts and follows version control processes.

Has in-depth knowledge in own discipline and basic knowledge of related disciplines.

Work independently; receives minimal guidance and collaborates well with team.

Coach colleagues with less experience and perform peer reviews for requirements.

Support systems’ testing traceability and provide weekend and/or after hour assistance as needed.

Proven effective communication and analytical skills required to address and present most complex ideas and concepts to users, business systems analyst and management.

Worked to facilitation and presentation skills necessary to demonstrate business systems solutions in a clear and concise manner.

Ability to develop, plan, and create timelines for requirements delivery during project life cycle, maintaining project targets and deadlines.

Proficient in Visio to create process flows.

Drive enterprise level complex programs and can engage with business and technical leaders at all levels. You are an authority on managing projects and programs, driving prioritization with product and engineering, and delivering effective execution and communication.

Have a technical background in full stack development, be driven to detail and have problem-solving ability.

Worked to facilitate scrum ceremonies.

Worked to Translate business requirements to development teams.

Partnered with cross functional teams to identify and drive complex technical programs. Actively contribute to design and architecture discussions and documentation on these areas.

Worked to Define program goals and priorities for programs you own, driving data focused analysis and translation of organizational requirements into program goals.

Worekd to Collaborate with others to track, coordinate, and communicate end-to-end project schedules. Help hold stakeholders accountable for following the established schedule and processes. Helps track and manage dependencies and escalate appropriately. Adjusts or course corrections when projects are not aligned to schedules or goals, with consistent communication.

Worked to presenting to large audiences and stakeholder groups.

Environment: MS Word, MS Excel, MS Visio, Oracle, TOAD 12.6, MS SharePoint 2012, Agile SDLC Methodology, VersionOne.

Astellas Pharmaceuticals, Chicago, IL Jan 2018 – Dec 2020

Business Systems Data Analyst / Product Owner

Responsibilities:

Gather business requirements, elicit technical requirements, prepare report specifications.

Modelled the business process flows using Rational Rose, the existing ER diagram and Data Flow Diagram (DFD) and developed UML Use case diagrams, Activity diagrams, Sequence Diagrams, Collaboration Diagrams and prototypes.

Studied the business and technical needs and modeled the AS-is and TO-be scenarios. Conducted GAP Analysis, Impact Analysis and Risk Analysis of the to-be model. Created the Business Requirements Document (BRD) from the requirements gathered. Generated the business process model to better understand the business workflows

Identifying and documenting data standardizations to be performed, data enrichment operations, data validations, data security requirements, and data exception handling processes

Prepared Crosswalk documents for developers, referring Interface Record Layout (IRL) obtaining from Medicaid and Medicare Management Information System (MMIS) and Implementation Guide (IG).

Interacted with Project Manager, IT architects and SME’s to get a better understanding of the Business Processes.

Identified and documented Issues, risks and gaps and their descriptions and impact, and provided recommendations and alternatives.

Created AS-IS and TO-BE business process flow diagrams, Integrate process flow diagrams to show one end-to-end business model. Responsible for creating business flow diagrams (using MS-Visio).

Worked in SDLC methodology and validation processes

Previous experience in IT support of R&D development such as Clinical Operations, Regulatory, Data Management, PV/Safety, etc.

Used MS Project to manage schedules, deadlines and resources and collaborate on the project.

Handled / Participated in Data visualization mock-up, report design, and data modeling.

Worked in Data modelling using dimensional modeling, Star schema, and snowflake schema modeling, FACT & Dimensions tables

Worked in UI Expression language and good exposure to Data Modeling (QlikView and Qlik Sense)

Working knowledge on relational database - ability to optimize, analyze, and improve database SQL performance on any platform

Experience in implementing end to end business intelligence and data warehousing projects.

Have working knowledge of industry standard Data Infrastructure (e.g. Warehouse, BI, Analytics, Big-Data, etc.) tools with the goal of providing end users with analytics at the speed of thought.

Worked in ETL / ELT tasks to refresh Data Marts / Data Warehouse from Oracle Applications ERP Systems.

Work on developing, architecting, standardizing and supporting technology platforms using Industry leading BI / Reporting solutions.

Worked in BI Tools, and a Certified Developer / Subject Matter Expert (SME) in QlikSense in an Enterprise Analytics.

Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.

Gathered requirements during inception phase, documented and delivered functional specification documents, and assisted architecture analysis and design using UML and Rational tools.

Conducted UAT. Wrote SQL queries in MS Access and Oracle for data manipulations.

Developed prototype of new information processing application. Helped collect functional requirements and prepared business requirement documents using Rational Requisite Pro.

Strategized implementation of RUP effort throughout SDLC.

Aided management in standardizing Web applications by preparing GUI standards and recommending alternatives for incorporation in phased, iterative manner.

Produced visual models of the system by generating UML use-case diagrams from the requirements. Generated the sequence, state chart and activity diagrams to enable understanding and representation of the business processes for ease of software system development in Rational Unified Process (RUP) methodologies.

Created initial Test plan, and test cases for acceptance test to provide the minimum requirements validation for the business process.

Used Rational Clear Quest to maintain and track the requested enhancements and changes.

Managed / Used internal IT application and cloud based ServiceNow (SNOW) for any IT related requests for the team.

Worked on sourcing data from cloud based applications like ServiceNow(SNOW), Salesforce (SFDC), JIIRA for requests’ analytics.

Wrote unit and systems integration test plans in Load Runner and Win Runner

Worked with Testers in User acceptance testing (UAT), System testing, Integration testing and build verification testing.

Excellent communication, presentation, client interaction, Problem solving, writing skill; works successfully both in teams and independently.

Evaluate and Enhance customers’ management of their Veeva Network investment & identify efficiency and effectiveness gains

Track and Promote awareness of the latest Veeva innovations and releases.

Educate customers of process and/or application best practices and Increase the ROI customers get from Veeva Network

Experience with commercial pharmaceutical / business information (SHS, Veeva CRM, Veeva Network, etc.), Supply Chain, Finance and HR.

Understand regulatory electronic submission requirements and standards (I.e. eCTD, IDMP) processing of documents and data through software and business processes will be a crucial asset to the analyst

Good overall understanding of Pharmaceutical Development processes.

Co-own product vision and strategy roadmap

Assist defining solutions with high-value requirements, clear product positioning, priority and strategic impact

Partnered with stakeholders to enable successful development, delivery, and adoption of technology solutions

Driven delivery of Agile teams and lead appropriate ceremonies

Diffused conflict by driving consensus

Lead the product delivery lifecycle using defined processes and industry best practices

Understand and implement the “what & why” of the User Stories & Feature, and how each may impact the Customer

Understand a feature’s impact / relationship on other functionality

Managed prioritization and trade-offs between customer experience, business requirements, technical limitations, performance and operational

Supported manage the product backlog and prioritization

Communicated effectively to build relationships with key stakeholders

Speaks credibly to both business and technology partners across teams and levels

Drive the budget at feature/scrum team level.

Environment: MS Word, MS Excel, MS Visio, Oracle, TOAD 12.6, MS SharePoint 2012, Agile SDLC Methodology, VersionOne.

Johnson & Johnson, Bridgewater, NJ Jan 2014 – Dec 2017

Business Systems Analyst / Data Analyst

Responsibilities:

Interacted with Business Users On-Shore and Off-Shore to understand the financial data collection and data sourcing processes.

Understood Financial data such as Income Statements, Cash Flows, Balance Sheets etc. from Annual, Semi-Annual and Quarterly Financial Statements Provided to S&P Global.

Used Toad to analyze S&P Ratings’ data, its data sources, source to target data flows, data staging areas, master databases and reporting Data Warehouses.

Compared Financial data and data standardization of S&P Ratings with MI using Excel functions to understand the differences/similarities in data collection process.

Created current state as well as future state Business Requirements Documents and Functional Requirements Documents, Epics/ High Level User Stories for data collection as well as data sourcing functionalities.

Created ER Diagrams for S&P Global/s Master and Reporting databases.

Created Data Flow and Process Flow Diagrams for the data collection and data sourcing processes.

Conducted sessions with Business Leaders to review requirements and all created documents to get their sign-off.

Uploaded and managed all documentation in the SharePoint site and made changes as required.

Worked in delivering strategies in Data Governance sourcing data from ERP Systems like SAP ECC, S/4, Oracle Applications, JDE and BPCS.

Worked in handling the Business Intelligence Reporting requirements using SAP Business Objects and Crystal Reports - Enterprise.

Environment: MS Word, MS Excel, MS Visio, Oracle, TOAD 12.6, SAP Business Objects, Crystal Reports - Enterprise, MS SharePoint 2012, Agile SDLC Methodology, VersionOne.

Polo Ralph Lauren, Lyndhurst, NJ Jan 2013 – Jan 2014

Business Systems Analyst / Data Analyst

Responsibilities:

Analyzed the EHR system and its various modules to understand its front end application and usage.

Analyzed and documented the scope of the project, Budget for product implementation and training.

Discussed functionality of the system with the development team lead in Asia Pacific through a number of online meetings.

Analyzed the data model of the system and the data flow into the user interface and GUI.

Documented the working and functionality of the system.

Designed test case documents and scenarios for Unit testing the entire application and entering test results. Updated the test documents and requirements documents based on any changes made.

Tested the application for end to end usage with sample data and logged errors.

Performed regression testing on each module and tested the application for user acceptance.

Queried the system through SQL queries for testing data populated in the application and report validation.

Developed requirements and test documents after discussion with development team.

Developed brief as well as detailed training manuals for all modules of the application. The detailed training manuals were uploaded in the Help section of the application while the brief training manuals will be provided to the Physician’s office when they start using the application.

Developed Wireframes and mockups of the application using ASP.Net and MS Visio for Business Users (physicians and physician assistants) as part of the training manual so they can understand the application easily.

Developed wireframes of reports using SSRS.

Developed detailed business process and documentation, timelines and project scope with Architect for procedure and implementation of the application.

Followed HIPAA compliance for data analysis and security.

Researched the markets for new CRM strategies, techniques, methodologies and terminologies. Keep the organization updated about the same.

Managed implementation of the products at client location and trained them on using the product.

Provided the first line of support for technical and functional issues related to the customers’ system and web portal.

Environment: SQL Server 2012, SSRS, ASP.Net, MS Word, MS- Visio, MS Project, Windows 7, Windows 8, HIPAA, HL7, Clinical EHR, Agile.

Carrier Corporation, Farmington, CT Jan 2011 – Dec 2012

Business Systems Analyst / Data Analyst

Responsibilities:

Responsible for delivery of Business and functional requirements of the project to Business Users.

Good understanding of Power Grids, Power Transmission and Utilities Adjustment and Billing.

Understood the system, its business users and how they manage the system with their clients.

Understood the systems technical Requirements and front end Java application.

Worked with Business Users of the system to understand the systems modules and features being used on a day to day basis. Facilitated user stories workshop. Documented User Stories and facilitated Story Point.

Analyzed the existing reports in the system, their structure and data used to generate the reports.

With all the information gathered, created Business Requirements Document and Functional Requirements document for the existing system.

Created mapping documents for data flow from the database for existing reports.

Reviewed the documents with business users and gathered their sign off on the requirements documents.

Dumped the existing data in the Oracle system to Excel files for data mapping and definition.

In the second phase, conducted white board discussions and meetings with business users to understand their requirements to create a new billing system from the existing system.

Created mock ups for reports in the new system using MS Visio and SSRS.

Created a new set of Business and functional requirements document and mapping documents for the new billing system to be created and handed them to the development team after sign off from the business.

Environment: MS-Word, MS-Excel, MS-Visio, Oracle, Oracle Forms, SQL Server, SSRS, Windows 7, Agile.

Chruch & Dwight, Princeton, NJ Feb 2009 – Feb 2011

Business Systems Analyst / Data Analyst

Responsibilities:

Communicated with business users, date architects and developers to identify needs, define project scope and detail functional and non-functional requirements.

Gathered and documented requirements throughout the Software Development Life Cycle (SDLC).

Understood and formalized the requirements with various Subject Matter Experts at various phases of the Development Life Cycle, discussed open issues and resolved them.

Stayed abreast on Global 'Sales Force Effectiveness' and CRM strategies and the impact to the countries and regions.

Worked with the Delivery Lead and Project Manager to define the scope of the project for each agile implementation.

Analyzed and mapped the data required for reporting.

Tracked project iterations through agile tracking system VersionOne. Also Interviewed clients/business partners, defined functional and non-functional requirements, and captured them in VersionOne.

Worked with the Data Architect and Technical Team to analyze data in the Operational Database and created technical design documents and mapping documents for reports design.

Conducted the AS-IS and TO-BE analysis of the business process using GAP analysis.

Driven daily stand up meetings offshore, iteration planning meetings and requirement gathering meetings.

Responsible for providing data to the developers/testers for development as well as testing.

Responsible for Extracting and Cleaning data from the database as per the requirement using SQL.

Responsible for updating the database tables with sample data to query and analyze data flow.

Conducted meetings and project discussions using Web Ex or Net meeting with global users in Asia Pacific.

Created Mockups and Wireframes for reports and presented to business for approval.

SME to the development and testing teams in North America and Asia pacific.

Assist developers in data cleansing and extraction, report design, implementation and unit testing.

Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.

Coordinated with QA teams with the aid of HP Quality Center for the bug tracking and for test case management.

Developed test plans, test scenarios and test data analysis.

Worked with the development team to create and implement Information Security Policies and Procedures.

Analyzed, recommended, and coordinated the installation of security software.

Followed agile methodology and agile best examples throughout the project.

Tracked project iterations through agile tracking system VersionOne. Also Interviewed clients/business partners, defined functional and non-functional requirements, and captured them in VersionOne.

Environment: Agile, MS-Word, VersionOne, Advanced Excel, MS Access DB, SQL Server 2008, Cognos, Power Point, HP Quality Center, Windows XP, Windows 7, MS Visio.

Delta Dental, San Francisco, CA Jun 2008 – Feb2009

Business Systems Analyst / Data Analyst

Responsibilities:

Communicated with the vendors through WebEx to understand the business as well as data warehouse structure and design

Created detailed documentation explaining the ETL process, structure and design of the staging database and data warehouse and the various stored procedures involved to transfer data from the operational database to the data warehouse.

Created Mapping Documents in MS Excel to map data from the operational database to the data warehouse. I am modifying the mapping documents as I am adding/updating/deleting new fields as I am receiving change requests

Completely tested the ETL process of extracting data from the application tables and loading them into the staging area for transforming the data and then loading the data into the data warehouse.

Created scripts in Sql Server to manually test the data flow process

Tested the table structure and stored procedures involved in the ETL process and sent changed requests to the developer to make changes in case of errors

Responsible for providing the testing team with the testing strategy and documentation required to complete the test process in HP Quality center

Created test case document and testing scripts to test the staging database and the data warehouse

Tested the staging area and data warehouse for possible errors and created an Error Handling Document to detect and correct errors when the ETL process fails.

Created batch processes and SQL scripts to automate the ETL process as a daily process that would extract delta records out of the operational database and load them into the data warehouse

Created document for the DBA to add/update/delete fields, records when change requests come in from the Business. The document also includes the process for catching up data from the operational database into the data warehouse if there has been a time lag in running the ETL batch process or if the data warehouse has not been active for a period of time

Used Microsoft Visio for creating Process Flow Diagrams, Use Case Diagrams and Activity Diagrams.

Modified, tested and generated the reports that are currently being processed out of the operational database to eventually report out of the data warehouse. I have compared and analyzed reports and their reporting time in the operational database and the data warehouse and modified the reports to efficiently extract data from the data warehouse

Responsible for resetting the data warehouse in the testing and development environment before production data comes into the data warehouse and making sure that the ETL process is working efficiently for loading the production data into the data warehouse

Analyzed and compared data extracts sent by the Business in the form of CSV files and Excel files to determine data consistency through the environments and sent back reports with results. I have used MS Excel, MS Access and Sql Server for data comparison.

Created Excel Macros to compare large data sets and reported results to the business.

Environment: SQL Server 2008, Advanced Excel, Excel VBA, MS Access, MS Visio, MS Word, Citrix Platform, HP Quality Center, Windows XP, Ally Team Room(site to upload/share documents)

Carrier Corporation, Farmington, CT Oct 2006 to June 2008

Business Systems Analyst / Data Analyst

Responsibilities:

Coordinated projects through all the phases of SDLC as a Senior Analyst and worked with the Development Team, Testing Team, DBA’s and Business for successful completion of the project.

Communicated with business users by organizing In-Person or WebEx meetings to define project scope, detailed functional and non-functional requirements

Analyzed As-Is and To-Be states to understand the scope of the project and the volume of data

Analyzed the Operational and Analytical data from data stores and created Data Mapping Documents

Created Requirement Traceability Matrices (RTM’s) to Track, Document, Manage requirements and define each requirement as a testable requirement.

Created Mock Up documents for Business Users and Technical Team for Reports and Extracts using Microsoft Visio and SnagIt

Organized JAD and JIT sessions with business users, development team and testing team to resolve issues and review documents

Responsible for providing Business Requirement Documents and Technical Documents to designers, developers and testers

Used Top Team to create detailed, structured documents and complex use cases

Created testing scenarios for testers to understand testing scope in the Care Advance Project Implementation

Conducted sessions with developers and testers to help them understand the Care Advance Product.

Used SCM to store and version documents

Provided development\testing support throughout the Software Development Life Cycle (SDLC) process

Queried the Operational Database, Data Warehouse and Data Marts for gathering required data, analyzing data patterns and preparing mapping documents for the technical team.

Created complex Sql and PL/Sql queries and stored procedures

Created Various UML diagrams like Use case Diagrams, Activity Diagrams, Process Flow Diagrams and Business Flow Diagrams using MS Visio

Followed HIPAA compliance for data analysis and security.

Environment: Agile, FACETS 4.7.1, Care Advance 4.7, Oracle 10g, SQL Server 2008, Sybase, Informatica power center 9.1, Windows 7/XP, MS Word, MS PowerPoint, MS Excel, MS Access,

Contact this candidate