
Satyateja Adusumalli
- Business Analyst
- Washington, DC
- Member Since Mar 30, 2023
Satyateja Adusumalli
SUMMARY
Over 9 years of IT experience with recent emphasis as a Business Process Specialist and contributing in areas of Business System Analysis, Design and Methodologies, Data analysis/modeling, Quality Assurance Practices and User Training and Support, over complete System Development Life Cycle for legacy, n-tier and web based application systems for following industries:
· Federal and State governments
· Credit Bureau - Business Intelligence, Data Warehousing and Predictive Analysis.
· Insurance – Claims processing (P&C)
· Commercial Banking / Finance
Communicative and Interpersonal skills:
.
SPECIFIC EXPERITISE
· Business Process Analysis: Analyzing business processes in order to understand the activities, their relationships, the values of relevant metrics. Expertise includes defining the process boundaries, constructing process flow diagrams using MS Visio, Determining the capacity of each step in process, Identifying the restricted access and evaluating further limitations, Performing GAP analysis to compare existing performance capacity and its variance with new process requirements. Proper Use of the analysis to make operating decision for process improvement.
· Business Analysis and Requirement Management: Strong analytical skills to derive business requirements and understand application design. Expertise includes interviewing users & stakeholders to gather, write, and manage business requirements. Define business rules, identify functional and non-functional requirements, and create use-cases & activity diagrams. Perform structured system analysis using industry recognized FAST strategies, linear & integrated flow-charting for application architecture, Create and manage documentation using RUP, MS Projects and MS Visio. Perform system evaluation, impact analysis and manage project phases while conforming to RUP, SDLC methodologies using CMM approach.
· User Training, Documentation & Support: Prepare and deliver formal and informal training and instructions to user regarding use of applications. Create and maintain user manuals and technical documentation for developed products. Participate in defining and developing standard operating procedures (SOP) as appropriate. Participate and conduct conference training for users across States and walk them through various components of the application. Act as main point of contact for any training or support issues. Maintain document archeology as per CMM standard.
· Quality Assurance Testing: Manage QA phase using ATLM (Automated Test Life Cycle Methodology) as well as Manual processes. Expertise include writing Test Plan, Test Objectives, Test strategy, and Test environment. Map business requirements to test cases including UI tests, functional tests, database tests, configuration and compatibility tests, performance, load and stress tests. Write detailed test scripts for each test case using Use Cases. Document web security concerns and maintain error analysis checklist. Perform manual QA testing including system integration, unit testing, and regression testing for web applications. Synchronize and Map ATLM activity relationship with SDLC activities.
· System Integration and Data Modeling: Identify data entity types, data mapping, analyze attributes, and identify functional dependencies, primary keys, and non-key attributes. Define relationship types and subtypes (including exclusive, inclusive) and relationship cardinality. Use 3N normalization process to eliminate data redundancy. Build enterprise data model. Identify Domain attributes and Data storage dictionary. Create physical data model, set properties, and attach validation rules and constraint. Review physical data model and maintain document archeology.
EDUCATION
· Bachelors in Computer Science, JNTU, India.
Major: Computer Science
Minor : Engineering
TECHNICAL SKILLS
· Business Methodologies: Business Definition Requirements, Business Process, Analysis and Research, Requirement Gathering, Use Case Modeling, JAD/RAD/JRP sessions, GAP Analysis, Impact Analysis and SWOT Analysis, Waterfall / Iterative, RUP
|
Operating Systems |
MS Windows 98/NT/XP/Vista , UNIX, Linux |
|
Languages/.NET Technologies |
C#, ASP.NET 3.5/2.0/1.1/1.0, ASP 3.0, ADO.NET 3.5/2.0/1.1, ODP.NET, ADO, C, Java/J2EE, VB 6.0, PL/SQL, T-SQL, Java /J2EE, Homegrown MVC, Spring 2.5/3.0, Hibernate 3.0, Struts 2.0 |
|
Internet Technologies |
WCF,WPF, Web Services, JavaScript, XML, HTML, DHTML, VBScript, Ajax, CSS, SOA, SOAP, WSDL |
|
Databases |
MS SQL Server 2005/2008/2012, Oracle 8.0/9i/10g/11g, MS Access 2003/2007/2010/2013, MySQL |
|
IDE |
Dreamweaver, Adobe Photoshop, Macromedia Flash, Microsoft Visual Studio.NET 2008/2010/2012/2013,Eclipse |
|
Software Tools |
Requisite Pro, Rational Rose, Clear Quest, Clear Case, SODA, SQL, Test Director, Quick Test Pro/Win Runner, Load Runner.
|
|
Tools |
MS Visio, MS Project, MS Office Suite, MS SharePoint, MS TFS, MS Dynamics CRM , Balsamiq, Confluence, JIRA, HP ALM, Axure RP |
|
Communication |
MS outlook, Lotus Notes, MS Live Meeting, WebEx, GoToMeeting
|
|
ETL Tools |
Informatica Power Mart 4.6/5.1, Cognos Decision Stream, Oracle Warehouse Builder, Composite Server. |
|
Cloud Computing |
Amazon Web Services (AWS), Microsoft Azure |
WORK EXPERIENCE
Department of Transportation- Washington, D.C. Oct 2016 - Current
Project: New Car Assessment Program (NCAP)
Position: Senior Business Analyst
NCAP rates vehicles to determine crash worthiness and rollover safety. The safety ratings are gathered during controlled crash and rollover tests conducted at NHTSA research facilities. Vehicles with a rating of five stars indicate the highest safety rating, whereas a one star indicates the lowest rating.
NHTSA is an organization under the U.S. Department of Transportation (DOT) whose mission is to save lives, prevent injuries and reduce economic costs due to road traffic crashes, through education, research, safety standards and enforcement activity. The New Car Assessment Program provides consumers with important information in making a new car purchase, and for comparable vehicle models it provides a direct comparison of the crashworthiness of vehicles. Information from this program also exists on the required labels on each new vehicle for sale.
Responsibilities:
Food and Drug Administration- Rockville, MD Oct 2015 – Sep 2016
Project: Center for Veterinary Medicine
Position: Lead Business Analyst
The Food and Drug Administration (FDA) is responsible for protecting our nation’s public health by assuring the safety, efficacy, and security of human and veterinary drugs, biological products, medical devices, national food supply, cosmetics and radiation emitting products
Center for Veterinary Medicine’s (CVM’s) mission is protecting Human and Animal Health through regulation of animal drugs, food additives, and devices. This mission is accomplished through review of new animal drug and abbreviated new animal drug applications (NADA and ANADA), investigational and generic investigational new animal drug files (INAD and JINAD), investigational food additive petitions and food additive petitions (IFA and FAP), generally recognized as safe notices (GRAS), veterinary master files, and minor use, minor species (MUMS) index files.
Responsibilities:
Food and Drug Administration- North Bethesda, MD May 2015 – Sep 2015
Project: Safety Reporting Portal
Position: Senior Business Analyst
The Safety Reporting Portal (SRP) streamlines the process of reporting product safety issues to the Food & Drug Administration (FDA) and the National Institutes of Health (NIH). Organizations and people in certain professional roles like Food Manufacturers, Processors, Packers, Holders, Researchers, Drug Manufacturers, Dietary supplement manufacturers, packers, and distributors may be required by law to submit safety reports under some circumstances. Safety Reporting Portal (SRP) enables all these organizations and professionals to submit reports.
Project Goals:
United States Federal Government is committed to ensuring the safe and healthful use of all products within US borders. The range of products in use, of course, is vast—from all kinds of foods and medicines intended for humans or animals; medical devices, supplies and vaccines; and mechanical items of every sort. Problems of life-threatening potential can arise in the use of any of these items—not only from the composition of the products themselves, but stemming from their packaging, labeling and application. In case of such an incident, a safety report can be provided through the Safety Reporting Portal.
Responsibilities:
State of Pennsylvania- Harrisburg, PA Aug 2012 – May 2015
Project: Probationer KIOSK System
Position: Lead, Business Analyst
The purpose of this project is automation of low-risk probation check-in process using a kiosk technology in a geographical area consisting of several locations. The system typically consists of a set of intranet web application modules that are used by Probation Officers, Kiosk Attendants, Probationers and Application/Business Administrators in order to automate the low-risk Probationer check-in process for a particular geographic area.
RCMS KIOSK (Reusable Case Management System) is designed to plug into an existing case management system or to be run with a stand-alone database schema. These two modes of operation are referred to as CMS-Plug-in and Standalone modes, respectively. In both scenarios, the product can be easily configured to an existing environment and it is modelled as service oriented architecture (SOA) and is made up of a set of services that work together to provide the application business logic.
Responsibilities:
· Gathered requirements using interviews, document analysis, requirements workshops, surveys, site visits,
business process descriptions, use cases, scenarios, business analysis, task, and workflow analysis
distinguished user requests from the underlying true needs
Wells Fargo- Charlotte, NC Aug 2011 – July 2012
Position: Senior Business Analyst
Wells Fargo is a diversified financial services company that provides a broad range of retail banking and brokerage, asset and wealth management, and corporate and investment banking products and services. They are one of the largest providers of financial services in the United States, with retail and commercial banking operations in 21 states from Connecticut to Florida and west to Texas and California, and nationwide retail brokerage, mortgage lending and auto finance businesses. Wells Fargo's Investment Banking unit provides unique financing solutions not offered by traditional lenders.
Prime function of project was to automate the Mortgage Loan Origination Process beginning with the customer initiation to title transfer. The system performs all the business functions of the loan process such as set-up Account Information, New Loan set-up, and the Appraisal, Credit, income and Title functionalities. My primary responsibility was to develop functional specification documents for the appraisal and credit departments by gathering, analyzing and documenting requirements from various Business users associated to the system, analyze external factors and the third party data sources such as regulatory agencies and credit bureaus and document the constraints.
Responsibilities:
· Worked as business analyst to support the re-design of the Mortgage Asset Management System. Extensively involved in the development of Reporting Data Warehousing System.
· Designed the business requirement collection approach based on the project scope and SDLC Methodology.
· Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
· Conducted interviews with key business users to collect requirement and business process information.
· Developed business process models in RUP to document existing and future business processes.
· Performed extensive requirement analysis including data analysis and gap analysis.
· Designed and developed project document templates based on SDLC methodology.
· Developed business requirement specification documents as well as high-level project plan.
· Comprehensively work with requirement gathering for Enterprise reporting system using RequisitePro.
· Designed and developed all Use Cases and UML models using Rational
· Developed Sequence Diagrams, OOD using UML.
· Designed and implemented basic SQL queries for QA testing and report / data validation.
· Established a business Analysis methodology around the RUP (Rational Unified Process). Helped develop use cases, project plans and manage scope.
· Developed requirement reports for day-to-day retail banking needs for opening account, online baking using rational SODA.
· Developing strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, process and revenue streams.
· Played a key role in the planning, testing, and implementation of system enhancements and conversions.
· Worked with marketing team in knowing what exactly bank’s client wants.
· Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
· Partnered with the technical areas in the research and resolution of system and process problems.
· Analyzed research on operational procedures and methods and recommend changes for improvement – with an emphasis on automation and efficiency.
· Conducted benchmarking activities to identify best practices.
· Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data.
· Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
· Performed User Acceptance Testing (UAT)
· Provided guidance to the teams in base lining, version control, and configuration management in Rational Clear Case.
· Full knowledge of most phases of the Systems Development Life Cycle.
· Ability to work with all members of the project team, following the project through the Systems Development Life Cycle and ensuring business objectives are met (extensive project life cycle experience).
Blackstone Real Estates, MA Jan 2011 – June 2011
Position: Business Process Analyst
Blackstone is a Real estate company which is maintaining their Financial Reports on Cognos 7 and Epicor systems. LXR (Luxury Resorts is one of their main Divisions of business. Aptech is the Vendor who is managing the DataMart and Cube build for Luxury Resorts. This project is mainly concentrated on building and managing of daily reports. There are lot of Properties (Hotels & Resorts) using these reports on their daily verifications. The project is mainly concentrated on moving reports from Cognos 7 to Cognos 8 up gradation and managing the Portal for each property. Role involves aligning various properties acquired by Blackstone group to the Enterprise architecture. This involved analyzing the gaps between current and future state using UML, perform cost benefit analysis to assess return on investment, propose integration strategy and architecture, finalize vendors, and execute and manage the project till deployment. The projects are executed based on six sigma based project execution methodology. The team is spread over US including project being executed by EDS (My parent company), and other vendors of Blackstone. I report directly to IT advisor of Blackstone and interacts with EVP and CTO level to advise them on how to realize their business goals using technology. On the other side responsible to stake holders for end-to-end delivery of various projects.
Responsibilities
· As a Business Process Analyst, responsible for working with the manager and other users and creating Work flow diagrams as per the data analysis.
· Interacted with various cross-functional teams on building business Use Cases, and understanding expenses and revenue stream.
· Interacted with developers, discussing the specifications provided by the Analysts and also the changes and the inconsistency in the application.
· Involved in gathering user requirements, coordinating business meetings, and generating monthly status reports etc.
· Involved in re-defining business process, documenting enhancements.
· Created Use case scenarios and writing use cases as per the specifications and requirements Analysis.
· Involved in testing on all stages of System Development Life Cycle. Performed Integration testing, Build Verification testing, System testing manually.
· Involved in generating Test Plan and Test Specifications as per user’s Business requirements.
· Performed back end testing by writing SQL queries to extract the exact data from the database.
· Reported and tracked testing progress in the customized bug tracking system
· Worked with developers to fix the problems.
· Advised client to maximize their net worth by giving proper assets allocation
Rational Clear Case
EDS Inc. – Boston, MA. July 2010 – Dec 2010
Position: Business Process Analyst
EDS provides a broad portfolio of business and technology solutions to help its clients worldwide improve their business performance through information-technology, applications and business process services, as well as information-technology transformation services. EDS was working on NewMMIS project for Commonwealth of Massachusetts. I was working as application/business process specialist on MMIS application (Massachusetts Medicaid Information System). This is a large sized project to transform MMIS (legacy based system) to newMMIS (Web based application) under HIPAA regulations. System caters the needs for Massachusetts State Medicaid customers and providers. Being a part of BPR (Business Process Re-engineering) team for newMMIS, the main purpose was to map MMIS processes/system to newMMIS processes/system (94 in totals), to define any gap between two applications and document gap for newMMIS design team and user training team. The product helps companies of all sizes m