Ravi Kiran Draksharam

+1-470-***-****

actp93@r.postjobfree.com

Professional Summary:

* ***** ** ************ ********** as Business Systems Analyst with strong knowledge of Finance, Mortgage and Banking industry.

Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.

Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.

Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.

Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.

Excellent in Developing and evaluating business process Models.

Experienced in developing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 database.

Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents

Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.

Professional experience in business analysis, operations management and development, design, documentation and testing.

Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.

Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.

Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores

Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

Advised management on improvement strategies, Competitive & Profitability Analysis.

Exposure to Client/Server, Web Application developmental tools and Software development and design.

Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.

EDUCATION:

Bachelor in Computer Science Engineering

TECHNICAL SKILLS:

Software/Hardware: OOAD (OOA/OOD), RUP, UML, SDLC, Agile, Waterfall, QA, WAP, CVS, TEAMMATE, MS Access, SQL Server, MySQL, PL/SQL, Oracle DBA, Java, Windows 98/2000/XP/7, basic UNIX, HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, MS Project, MS Visio, Adobe Photoshop, Flash, Rational- Rational Rose, Clear Quest,Rational XDE,Cobol,Requisite Pro, CaliberRM, Omniture, Crystal Reports, various NIKU products, C, C++, Sharepoint, Docushare, BASIC, Intermediate level-Visual Basic

EMPLOYMENT HISTORY:

ELANCO, Greenfield, IN

Jan 15 – Present

Sr. Business Systems Analyst

At Elanco, we provide those who raise and care for animals with solutions that empower them to advance a vision of food and companionship enriching life. We understand the powerful role healthy animals play in making lives better. As pets increasingly become important parts of our families, so too does the need to help them live longer, healthier, higher-quality lives. As the global population grows, so too will the need to meet the demand for safe, affordable food for all.

Responsibilities:

Created business use case, functional (FRS) and technical specifications for trading system.

Extensively involved in the modelling and development of Reporting Data Warehousing System.

Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype, Use Cases, UML diagrams for overall system.

Aggregated financial and product measurements using Cognos to produce express reporting with unique factures that would be used for incentive plan calculations.

Wrote detailed specifications for various reports generated using Cognos.

Identified Data warehouse and staging tables, Informatica workflows/mappings and tasks related to Finance data and customized Informatica mappings to load historical data.

Responsible for the preparation of Project Charter, Business Requirements, the Detail Informatica ETL (Extract Translate Load) mapping specifications document, project planning, testing, implementation and post-implementation activities.

Documented and evaluated test cases/test results/feasibility study of ETL tool Informatica.

Designed, implement, and document new information security architectures, technical control standards and risk analysis methodologies.

Developed strategic plan for information security risk management to meet regulatory requirements and audit recommendations.

Working with business owners, DBAs, and other stakeholders to determine best approach to ensure security compliance on all regulated data

Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.

Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.

Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.

Gathered requirements and modelled the data warehouse and the underlying transactional database

Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.

Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.

Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models

Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them

Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.

Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.

Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.

Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.

Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, RUP, SDLC, UML, Oracle, Informatica, Cognos, TestDirector, LoadRunner.

FANNIE MAE, Herndon, VA

May 12 – Dec 14

Business/ Systems Analyst

As a leading source of residential mortgage credit in the U.S. secondary market, Fannie Mae is supporting today's housing recovery and helping to build a sustainable housing finance system. We exist to provide reliable, large-scale access to affordable mortgage credit across the country at all times so people can buy, refinance, or rent homes. We are working to establish and implement industry standards develop better tools to price and manage credit risk build new infrastructure to ensure a liquid and efficient market and facilitate the collection and reporting of data for accurate financial reporting and improved risk management.

Role & Achievements:

Extensively involved in every phase of the RUP process starting from Inception to Transition

Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.

Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.

Responsible for interacting with business partners to identify information needs and business requirements for Cognos Reports.

Utilized Cognos in conjunction with Excel for reporting and budgetary purposes.

Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Cognos was used for Reporting duties.

Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc, and their mapping to the standard analysis mechanism to enable maximum reuse.

Write Technical System specifications for Operational, Legal and Compliance enhancements or changes in Empower.

Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.

Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them

Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion

Evaluated business process requirements to ensure proper system configuration (i.e. identifying key decisions, process changes, pain points, interface issues, training considerations, etc.).

Create and maintain requirements, test cases and defects in Mercury Quality Center

Working with clients to better understand their needs and present solutions using structured SDLC approach.

Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.

Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.

Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Windows, Oracle/SQL Server, PL/SQL, Mercury Quality Center, Informatica, Cognos, RUP, UML, MS Visio, MS PowerPoint.

CABOT Corporation, Atlanta, GA

Aug 10 – Apr 12

Business Systems Analyst

Our businesses deliver a broad range of products and solutions to customers in every corner of the globe, serving key industries such as transportation, infrastructure, environment and consumer. We provide performance solutions that solve customers' challenges today while preparing them to meet tomorrow’s needs. Our commitment to innovation is driven by a passion to advance our customers' businesses through our deep understanding of their industries and the global trends that impact their operations.

Responsibilities:

Involved in all phases of software development life cycle.

Followed the RUP (Rational Unified Process) methodology for elicitation and representation of requirements.

Conduct kick off meetings using the approved IT security framework to categorize information and information system.

Consulted with internal clients on design and development best practices while keeping the focus on risk areas regarding information security and privacy.

Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.

Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Contributed in defining the scope of the project and defined functional specifications.

Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.

Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.

Responsible for daily status meeting to discuss development plans, quality assurance test plans, and user documentation with developers, users, and the product management.

Worked with MS Project (MSP) to distribute the tasks and keep track of status.

Develop & execute test cases and test scripts designed to ensure application quality

Responsible for numerous decisions in respect to business policies, procedures, methods for implementation.

Formulated project plans including staffing, analysis, development, testing and implementation.

Used UML to produce Use-Cases, Use case diagrams and Activity diagrams to explain process flows and functional specifications.

Involved in identification of business rules, business and system process flows, user administration, requirements and assumptions.

Regularly interacted with onshore and offshore teams to communicate requirements and review test cases and test plans.

Used Mercury Quality Center to look up defects and issues raised by testing activities.

Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Produced and managed documentation on release activities to support problem resolution.

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows, Oracle, PL/SQL, SQL, SQL Server, Sybase, SharePoint, Unix, Agile/Scrum, C#. NET, Business Objects, Test Director, Load Runner.

Stanford Healthcare, CA

Nov 08 – Jul 10

Business Systems Analyst

At Stanford Health Care, we seek to provide patients with the very best in diagnosis and treatment, with outstanding quality, compassion and coordination. With an unmatched track record of scientific discovery, technological innovation and translational medicine, Stanford Medicine physicians are pioneering leading edge therapies today that will change the way health care is delivered tomorrow. As part of our spirit of discovery, we also leverage our deep relationships with luminary Silicon Valley

companies to develop new ways to deliver preeminent patient care.

Responsibilities:

Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.

Analyze and manipulate a large data sets, trading, orders and allocation data.

Created a test plan and a test suite to validate the data extraction, data transformation and data load and used SQL and Microsoft Excel.

Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.

Created reports and Dashboards utilizing Excel and Cognos.

Directly involved in discussions with financial engineers as well as traders on the Fixed Income Trading Desk to conceptualize their needs.

Worked with developers to make sure that they understood the Use Cases.

Worked with the Business, Operations, and Engineering stakeholders to define the functional integration and end-2-end test cases for the CRM project.

Monitored Performance measurement, Risk Management and Asset management.

Conducted current state study which included data collection methodologies, data quality and data integration problems, data storage and infrastructure related issues.

Used Microsoft Visio for Business Process Modelling and Data flow diagrams.

Involved in Managing Data modelling project from Logical design and implementation of Sybase Database

Worked on data modelling and produced data mapping and data definition documentation

Used Informatica to extract and transform data from various DB2 database to the data warehouse.

Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows, Oracle, SQL, SQL Server, Sybase, EVPN, RUP, XML, VBScript, CRM, SharePoint, Informatica, Unix, DB2, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, Business Objects, TestDirector, LoadRunner.

Contact this candidate