SUMMARY:

• Over 12 years of experience as Lead Business Systems Analyst, and Solution Architect in the domains of Confidential, Health Care, Insurance
• Retail, Banking, and Credit Card in various types of information systems like Online Transaction Processing System, web application, Data warehouse and Business Intelligence Reporting Systems.
• Have extensive experience with the entire software Development Life Cycle SDLC viz. Requirement Elicitation, Gathering, analysis, design & Development, testing, implementation, production support, change management etc and experienced with Water Fall, RAD, Agile and Rational Uniform Process RUP models.
• Experienced in Business Process Management (BPM’s) activities like Process Modeling, Automating, Monitoring, Analyzing, improving, and Re - engineering.
• Having excellent inter-personal, communication, problem solving and analytical skills with ability to interact with all levels from business end-users, technology team, project management professionals and all Project stakeholders.
• Have extensive experience in documenting business, system and data requirements such as Business Requirement Document BRD, System Requirement Document SRD, Functional Specification Document FSD, Logical Solution Design LSD, Data Requirement Document DRD, and Traceability management & Matrix Reports.
• Experienced with performing various requirements elicitation techniques like interviewing, questionnaires, brainstorming, group discussion, reverse engineering from system documentation, prototyping, and in conducting Joint Application Development JAD sessions.
• Have extensive experience with UML modeling such as creating workflows, Use Cases, activity, logical, class, Sequence, activity and Collaboration diagrams.
• Proficient in manual and automated testing using several testing tools for various testing purposes.
• Proficient in creation of Conceptual Data Model (CDM), Logical data model (LDM), Physical Data Model (PDM) for various types of information systems like OLTP and OLAP.
• Experienced in multi dimensional data modeling techniques like star schema in building Data Warehousing and worked with data quality and governance team for master data management.
• Experienced in analyzing and designing Source to target (STM) mapping documents for Extraction Transformation and Loading (ETL) Applications & Processes for Data Mart and Data Warehousing Systems with working knowledge and experience in Structured Query Language (SQL).

TECHNICAL SKILLS:

Operating Systems: Windows, Linux and UNIX.

Databases: MySQL, Oracle, MS Access, MS SQL Server, DB2, and Teradata.

Data Modeling Tools: Toad, MS Visio, S-designer, and Erwin.

ETL/ Analytical /Reporting Tools: Web focus, Business Objects, SAS, and Crystal Reports, Congo s, Informatics Power center, and Data Stage.

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, and silk test.

Office Suite: MS Office suit, Share Point server, Star Team, and Lotus Notes.

ERP: SAP, PeopleSoft HR, CRM and Accounts .

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Senior Business Systems and Data Analyst

Environment: Oracle, Toad, Sim corp, Bloomberg and MS Office tools.

Responsibilities:

• As part of BOT (Business Operational Testing) Data team, is responsible to pull data from the legacy system to provide input data to new future state system.
• Perform detailed analysis of complex business processes and data analysis.
• Work with key stakeholders to elicit, identify, analyze, validate and manage data requirements for new securities accounting systems
• Coordinate and perform Business Operational testing, integration testing, and user acceptance testing.

Confidential, NY

Senior Business Systems Analyst.

Environment: MS Access 2010, MS Office Suite 2010, Optum and Edifecs.

Responsibilities:

• Analyze mapping data; identify the discrepancies, document and Provide recommendations and alternate solutions based on the analysis and Co-ordinate the project team to successfully update the data mapping.
• Performed impact analysis on all the impacted systems due to ICD10.
• Worked on the system interface to update internal systems with the external vendor software and data for claims processing.
• Gathering requirements for implementing the vendor software solutions.

Confidential, Beaverton, OR

Senior Business System Analyst.

Environment: Oracle 10.g, Informatica, Cognos, Omniture, SAP, ATG, IBM Sterling Commerce Order Management, and MS Office Suite 2010.

Responsibilities:

• Collect requirements by recognizing the difference between business requests and underlying true needs, via partnering with customers, researching and analyzing present solution working closely with technology team.
• Analyze process and data flow to identify the latency, data quality, sourcing, logical and discrepancy issues in present systems to design new solution by development of business requirement document and report design functional document, and obtain sign-off from clients.
• Coordinate data mart ETL, reporting development and other activities between IT and the business.
• Provide testing assistance, review and approve the test plan, test cases, test scenarios and assist in UAT.

Confidential, Bellevue, WA

Senior Business System Analyst.

Environment: Tera data, Oracle 10.g, Toad for data analysis, Business Objects, Requisite Pro, and MS Office Suite 2010.

Responsibilities:

• Identify, document and analyze business requirements and business intelligent reporting needs, contribute in the design of solutions by delivering Functional Specification Document FSD and Business Intelligent Reporting Requirement Document BIRRD .
• Analyze complex business processes for both existing and new systems and deliver the Source System Analysis SSA document.
• Assist in the implementation of solutions focusing on data integrity across the Data infrastructure to insure data quality of mapping, translations and testing in the new Warehouses and data marts with a focus on data consistency and clear definitions of all data elements used by business partners.
• Worked on Information Security to implement information security guidelines when moving data between vendors and TMO.

Confidential, Richmond, VA

Senior Business System Analyst.

Environment: Tera data, Oracle 10.g, Sql Server 2000, Business Objects, Requisite Pro, Quality Center, Erwin, and MS Office Suite 2003.

Responsibilities:

• Worked closely with different business groups to determine their business, system, data, and reporting needs for various levels of management across the enterprise.
• Worked with the IT, technology, environment, and infrastructure teams to determine the impact to the end state enterprise bank data warehouse.
• Developed the end to end Source to target mapping (STM) containing the business and transformation rules for data transformation from source to target database.
• Closely worked with the quality assurance team to formulate the test strategy, test case design, validation and implementation of test cases.

Confidential

Lead Solution Analyst

Environment: People soft HCM, MYSQL, Oracle 10.g, DB2, Cognos, Crystal Report, Caliber, Star team, Quality Center, Erwin, Toad, MS Access 2003, MS Vision 2003, and MS Office Suite 2003.

Responsibilities:

• Worked with the business users and technology team to analyze, design and implement the re engineered, improved automated business processes through the new portal based application solution.
• Prepared the logical solution design document LSD that contains use cases, various types of flow chart diagrams, data modeling, User Interfaces, System Controls, and source to target mapping documents.
• Analyzed, designed and delivered the conceptual and logical data models and created source to target (STM) mapping document to load the operational data in to the data mart.
• Involved in end to end testing including the unit test, system test, regression test and facilitated the user acceptance test.

Confidential, Philadelphia, PA

Lead Business Systems Analyst.

Environment: Teradata 7.2, TOAD, SAS/BASE 8.2, SAS/ACCESS, SAS/SQL, SAS/STAT, and Web Focus.

Responsibilities:

• Interacted with the stakeholders to get a better understanding of client business processes and to gather business requirements.
• Studied the “as-is” system and performed a complete Gap Analysis to identify “to-be” system.
• Designed and drafted including the technical specification for the data transformation ETL process to populate the target data base from the source data and worked with the data acquisition team to execute the ETL application.
• Developed the detailed report design specification for the BI reporting and supported the development team to gain the business and technical knowledge to develop the report.

Confidential, Union, NJ

Lead Business Systems Analyst.

Environment: Erwin 4.0, SQL Server 2000, Oracle 10g, Windows 2003Server, linux RH9, SAS 8.2, Informatica, Congo’s 8, and SAS.

Responsibilities:

• Interviewed client employees and application owners from different business lines to gather information, understand the user’s needs, define requirements, and develop specifications.
• Created data model that visually represents the nature of data, business rules governing the data, and how it will be organized in the database.
• Assisted business intelligence team to develop the reports for various management levels related to past business as well to predict the future expectation.
• Assisted in the development of quality assurance activities including Quality Assurance Plan, Product Acceptance Plan, Test Plan, Test Cases and worked with the end users for User Acceptance testing.

Confidential, NJ

Senior Business Systems Analyst.

Environment: MS Project 2000, MS Visio 2000, TOAD, SQL Server 2000, Oracle 8i, Teradata, Informatica, and Cognos.

Responsibilities:

• Generated requirements while interacting with users and created requirement specification documented (RSD) on Test Director and converted in to System Specification Documentation (SSD).
• Prepared the activities chart to depict the process flow Diagram (PFD) and data flow diagram (DFD) for all functions.
• Worked in data mapping, transforming from different sources including flat files, databases and RDBMS in to the target data source.
• Translated all the user level analytical requirements in to technical design documents for BI reporting purpose.

Confidential, New York, NY

Business Systems Analyst.

Environment: MS office suite, MS Project, 2000 MS Visio 2000, ASP .NET, MS IIS, MS Windows 2000 Server, SQL Server 2000, and Oracle 9i.

Responsibilities:

• Followed a structured approach to organize requirements into logical groupings of essential Business Process, Business Rules, and information needs, and insured that critical requirements were met.
• Documented business rules, Process Flows, Policies and Procedures.
• Involved in the migration process of the disintegrated application software running under different database and operating system to web enabled central database application system.
• Analyzed and design solutions to integrate and automate the process of loan process right from application to final stage of either sanctioning or declining and intimating to the customer.

Confidential

Quality Analyst.

Environment: SQL Server, Oracle, and Skill test.

Responsibilities:

• Involved in strategic planning activities for establishing standardized QA practices for product development and performance testing and monitoring.
• Performed different testing like unit, integration, system, user acceptance test, functional, performance, security, usability, stress, and load test.
• Involved in preparation of complete test data, test cases and test coverage matrices.
• Communicate performance test results and feedback on how to tune the environment for optimal performance, both verbally and in written reports.