SUMMARY:

• Seasoned IT Professional with comprehensive Business/Technical skill set and more than 7 years of experience.
• Strong experience with business requirement gathering and analysis, business process re - engineering, object-oriented design, SQL, PL/SQL and ETL.
• Well versed in SDLC methodologies such as Waterfall, Agile, Rational Unified Process (RUP), Object Oriented Analysis and Design (OOAD) and UML.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Skilled at performing GAP analysis, SWOT analysis, Cost benefit analysis and Feasibility Analysis.
• Proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements using User interviews, Workshops, Observation, Existing systems documentation/procedures, JAD, JAR, and Brainstorming sessions to identify Functional, Non-Functional, and Business Rules, and subsequently model them.
• Dexterous in analyzing and preparing Project Deliverables such as Business Requirement Document (BRD) and Functional Requirement Document (FRD/SRS), system documentation, end-user training manuals, and proposed changes for process improvement.
• Experience in writing SQL queries to manipulate Oracle database and performing manual testing.
• Efficient in preparing Requirement traceability Matrix.
• Expertise in Informatica 9.x, PL/SQL, SQL* Plus, Stored Procedures and good knowledge of UNIX shell scripts.
• Strong understanding of the concepts of QA and testing using Quality Center.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Excellent analytical, organizational, communication, and documentation skills along with process management skills to gather requirements to produce high-quality deliverables.
• A proficient problem solver who envisions multiple perspectives to develop technical and business solutions.
• A Team Player with excellent communication, analytical, verbal and writing skills

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000, 2003, XP, Seven, Vista

Tools & Technology: Oracle PL/SQL, MS SQL Server, Data and system Analysis, HP ALM, Jira, Sharepoint, ServiceNow, Data Validation, Data Quality, Data Warehouse and Informatica

Document Processing: MS PowerPoint, MS Access, MS Project, MS Visio, MS Office Suite, MS Excel

Quality Management: Test Director\ Quality Center, Win\ Load Runner

Methodologies/Framework: Software Development Life Cycle (SDLC) - AGILE, Waterfall, Testing Life Cycle, Rational Unified Process (RUP), Mercury Test Director, JAD, Workflow storyboards, Data Modeling, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, and Class Diagrams.

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

Business Systems Analyst

Responsibilities:

• Worked with the IAM team to document existing processes.
• Developed requirements for access certification through user interviews and analyzing current state processes.
• Worked with the team in Gap analysis by comparing current state processes to future state processes.
• Analyzing existing document templates and recommending improvements.
• Analyzing existing processes and recommending process improvements.
• Analyzing the data for frequency of access and certifications in Identity IQ tool.
• Worked on Sailpoint-Identity IQ IDAM tool generating reports for access reviews, certifications and other identity certification processes.
• Created system access catalog in MS excel using pivot tables, V lookups, macros and formulas
• Used MS Access db for reconciliation reporting
• Worked with the analysts in creating access requirement matrix.
• Worked on User Acceptance testing for the applications part of access certification
• Creating and distributing reports for access certification in Identity IQ tool.
• Created the application review documents using MS Access.
• Worked with the analysts in identifying the sensitive data and tagging it.
• Created presentations in MS PowerPoint for access certification and presented the findings.
• Working on the pharma modernization program
• Requirements gathering and analysis for Manhattan.
• Requirements gathering and analysis for SalesForce.
• Developing requirements for monitoring and alert capabilities using tools like Splunk.

Environment: HP ALM, Visio, ServiceNow, SailPoint, Sharepoint, Oracle 9i, SQL Server, PL/SQL, Windows 2000, MS Access, MS Excel, MS PowerPoint.

Confidential, Buffalo, NY

Business Systems Analyst

Responsibilities:

• Defined various processes for Banking Domain such as Account Opening for Savings Confidential, Credit card Services including overdraft protection in relation to capital markets and securities lending.
• Participated actively in BRD inspections to satisfy the defined standards and methodologies from the policy Software Development Life Cycle.
• Included building the reconciliation reports for the OPS portal for ecommerce platform for system to system reconciliation.
• Developed requirement for building wire transfer capability for making payments using SWIFT message format MT103 using fund transfer.
• Developed requirements for building a chat message functionality using SWIFT message format MT199 for fund transfer.
• Developed requirements for building source to target mappings for ETL Data warehouse (Extraction, transformation and loading the data) staging and loading of dimensions (Star Schema)
• Conducted interviews and workshops with Subject matter experts and business user working groups to gather requirements.
• Creating RTM (Requirements traceability matrix), mapping Requirements to Design Artifacts and UAT Cases.
• Incorporated agile methodology (Scrum) to create Workflow storyboards, BRD, FSDs, using MS Visio and MS Word.
• Conducted Business requirement documents review with project team and stake holders to get sign offs; published and communicated them to various other IT and business teams to follow up on project dependencies using cost-benefit analysis.
• Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document.
• Worked on requirements for converting MS access db to MS SQL server.
• Actively supported the goals and activities of the Business Analysis Center of Excellence.
• Worked in Agile environment

Environment: Jira, HP ALM, Visio, Oracle 9i, MS SQL Server, PL/SQL, MS Access, MS Excel, MS VS Platform.

Confidential, OH  

Business Analyst

Responsibilities:

• Worked with business users to elicit and document requirements using agile methodology.
• Participated and lead JAD sessions.
• Worked with the Business users and SME’s to understand and document current business processes.
• Built use cases and user stories and worked with business users to prioritize the user stories.
• Worked in Agile environment using MS VS Platform
• Created and managed user stories and traceability matrix.
• Conducted gap analysis.
• Worked as a liaison between the subject matter experts and the development team to clarify requirements and document business rules and transformations.
• Worked with the QA team on test plans and test cases to ensure that the user requirements are understood.
• Conducted meetings with developers to set priorities in the bug tracking process.
• Created Defect reports for UAT testing.

Environment: Quality Center 9.x,QTP 9.x, Oracle 9i, SQL Server, PL/SQL, Windows 2000, MS office, MS Visio.

Confidential, IL

Business Analyst

Responsibilities:

• Worked with business users to elicit and document requirements using Agile methodology.
• Built use cases and user stories and worked with business users to prioritize the user stories.
• Prepared and analyzed AS IS and TO BE workflow scenarios, designed new process flows and documented the business process and various business scenarios, activities of the business from the conceptual to procedural level.
• Used pivotal tracker to manage user stories and traceability matrix.
• Worked with the team to define sprint scope.
• Conducted gap analysis.
• Worked as a liaison between the subject matter experts and the development team to clarify requirements and document business rules and transformations.
• Worked with the QA team on test plans and test cases to ensure that the user requirements are understood.
• Conducted meetings with team lead to set priorities for user.
• Analyzed the business requirements and functional specification documents to come up with test cases and stored them in Quality Center.
• Worked in Agile environment using MS VS Platform

Environment: Quality Center 9.x,QTP 9.x,Oracle 9i, SQL Server, Jira, PL/SQL, Windows 2000, UNIX, MS Access, Visio, MS Excel, MS VS Platform.

Confidential, IL

BA Analyst / Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Involved with end users and analyzed the business process and technical process.
• Designer for mappings and coding it using reusable mapplets using from various sources involving flat files and oracle tables(both for EDW and Star Schema).
• Scheduling the session’s tasks comprising of different mappings in order to load data into oracle database.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Worked on functional, and integration testing.
• QTP Helped in defect tracking and resolution with interacting with business users.

Environment: Quality Center 9.x,QTP 9.x, Informatica Power center 8.x,Oracle 9i, SQL Server, PL/SQL, Windows 2000, UNIX, Shell Scripts, MS Access, MS Excel, Visio.

Confidential 

BA Consultant

Responsibilities:

• Worked independently on multiple initiatives collaborating with all levels of management within Pay Roll, Human Resource, Ombudsman and Social Workers.
• Acted as liaison to identify critical process improvements and eliminate duplicity within current processes and State system.
• Engaged in interview sessions to document current workflow processes.
• Identified and gathered application requirements to draft Invitation to BID (ITB) for outside vendor bids.
• Performed thorough analysis on technical documents and vendors materials to write and formulate application requirement.
• Utilized strong analytical skill to evaluate and interpret concepts and information mandated by Federal and State Governance.
• Created and drafted over 50 reporting requirements and specification for Management teams to reduce dependence on outside vendor and reduction in DCF reporting budget and State budget.

Environment: Informatica Power Center5.0, Oracle 8i, MS Word, MS Excel, SQL Server, DB2, PL/SQL, Windows NT

Confidential, Rosemead, CA

Data Warehouse Developer

Responsibilities:

• Used Informatica - repository manager to give permissions to users, create new users, repositories.
• Designer for mappings and coding it using reusable mapplets using from various sources involving flat files and oracle tables (both in 3NF and SnowFlake).
• Scheduling the session’s tasks comprising of different mappings in order to load data into oracle database.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Involved in versioning the whole process and retiring the old records using the built-in’s DD UPDATE, DD DELETE, and DD INSERT.
• Major involvement in tuning the mappings, to perform maximum efficiency and performance complete knowledge of session properties in server manager.

Environment: Informatica Power Center 5.0, Oracle 8i, SQL Server, DB2, PL/SQL, Windows NT