| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateTechnical SkillsMethodologiesAgile, Waterfall, RUP, JAD, RAD.Modelling and AnalysisMicrosoft Visio, Rational Rose UML (Unified Modeling Language), ERWIN, Techno Solutions- Top Team Net Client 6.Street Address , SnagIt 10, MS Office Suite, MS ProjectCandidate's Name
MS Excel, Excel Functions, VBA, SQL, Ab Initio ExpressETL ToolsSSIS, Informatica, MicroStrategy 8.0 Data StageReporting ToolsSAP Business Objects / XCelcius / Crystal Reports Enterprise, Tableau, MS PowerBI, SSRS, CognosDatabasesMS 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.xERP / CRM / MDMSAP, Oracle Apps, JDE, JDA, BPCS, SFDC, SAP MDM / MDGProgrammingSQL, TSQL, PL/SQL, ASP.Net, VB.Net, VBA, C, HTML, XMLOperating SystemsWindows 8,7/XP/2000/98/NT, Mac OSX, Mac OSX YosemiteProductivityMS Office, MS Project, Microsoft SharePoint, VersionOne, HP Quality CenterEducationBachelors from Osmania University, Hyderabad, India 2001Work AuthorizationUS CitizenLinkedinKumar Santosh LinkedInSUMMARY:Over 10+ years of IT experience in System and Business Analysis, Requirement Analysis and Process ManagementMethodologies: 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 Candidate's Name . 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 Access3 years of experience in Candidate's Name 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 storiesStrong experience in gathering requirements and creating functional and technical user stories with detailed acceptance criteriaExperience with showcasing user stories to Product Owner and getting them signed offProficient 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 GroupsExperienced 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 SpecificationsExperience working in a senior role with Project Manager, technical teams as well as the business, coordinating projects from requirement gathering stage until deployment and launchExperienced 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 documentsExperience 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 datesAdept in multi-tasking and handling multiple tasks/projects at the same timeSkilled 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 PresentBusiness Systems Data Analyst / Product ManagerResponsibilities: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 stakeholdersCapture 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 Candidate's Name 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 2020Business Systems Data Analyst / Product OwnerResponsibilities: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 workflowsIdentifying and documenting data standardizations to be performed, data enrichment operations, data validations, data security requirements, and data exception handling processesPrepared 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 SMEs 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 processesPrevious 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 tablesWorked 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 platformExperience 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 RunnerWorked 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 gainsTrack 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 NetworkExperience 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 analystGood overall understanding of Pharmaceutical Development processes.Co-own product vision and strategy roadmapAssist defining solutions with high-value requirements, clear product positioning, priority and strategic impactPartnered with stakeholders to enable successful development, delivery, and adoption of technology solutionsDriven delivery of Agile teams and lead appropriate ceremoniesDiffused conflict by driving consensusLead the product delivery lifecycle using defined processes and industry best practicesUnderstand and implement the what & why of the User Stories & Feature, and how each may impact the CustomerUnderstand a features impact / relationship on other functionalityManaged prioritization and trade-offs between customer experience, business requirements, technical limitations, performance and operationalSupported manage the product backlog and prioritizationCommunicated effectively to build relationships with key stakeholdersSpeaks credibly to both business and technology partners across teams and levelsDrive 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 2017Business Systems Analyst / Data AnalystResponsibilities: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 2014Business Systems Analyst / Data AnalystResponsibilities: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 Physicians 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 Candidate's Name 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 2012Business Systems Analyst / Data AnalystResponsibilities: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 2011Business Systems Analyst / Data AnalystResponsibilities: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 Candidate's Name .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 Feb2009Business Systems Analyst / Data AnalystResponsibilities:Communicated with the vendors through WebEx to understand the business as well as data warehouse structure and designCreated 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 requestsCompletely 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 processTested the table structure and stored procedures involved in the ETL process and sent changed requests to the developer to make changes in case of errorsResponsible for providing the testing team with the testing strategy and documentation required to complete the test process in HP Quality centerCreated test case document and testing scripts to test the staging database and the data warehouseTested 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 warehouseCreated 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 timeUsed 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 warehouseResponsible 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 warehouseAnalyzed 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 2008Business Systems Analyst / Data AnalystResponsibilities:Coordinated projects through all the phases of SDLC as a Senior Analyst and worked with the Development Team, Testing Team, DBAs 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 requirementsAnalyzed As-Is and To-Be states to understand the scope of the project and the volume of dataAnalyzed the Operational and Analytical data from data stores and created Data Mapping DocumentsCreated Requirement Traceability Matrices (RTMs) 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 SnagItOrganized JAD and JIT sessions with business users, development team and testing team to resolve issues and review documentsResponsible for providing Business Requirement Documents and Technical Documents to designers, developers and testersUsed Top Team to create detailed, structured documents and complex use casesCreated testing scenarios for testers to understand testing scope in the Care Advance Project ImplementationConducted sessions with developers and testers to help them understand the Care Advance Product.Used SCM to store and version documentsProvided development\testing support throughout the Software Development Life Cycle (SDLC) processQueried 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 proceduresCreated Various UML diagrams like Use case Diagrams, Activity Diagrams, Process Flow Diagrams and Business Flow Diagrams using MS VisioFollowed HIPAA compliance for Candidate's Name 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, |
