SHARANYA SEKHAR

*** ********* **, *** *, Shillington PA 19607

Phone: 484-***-**** Email: addjte@r.postjobfree.com

SUMMARY

Over 7.5 years’ experience as a Technical Business Analyst working in diverse work environment with the Healthcare, Manlog, Banking and Financial industries.

Proficient in all phases of Requirement Management, including requirements gathering, planning, reviewing, analyzing, detailing and tracking requirements, implemented Business Process Re-engineering BPR.

Involved in both High level HLD and low level LLD design phases, Experience in all phases of the Software Development Life Cycle (SDLC) both Agile and Waterfall methodologies.

Created and Reviewed Business Artifacts: Business Requirement Document BRD, Functional Requirement Document FRD and developed Requirement Traceability Matrix (RTM).

Excellent Knowledge of Unified Modeling Language UML and created Data Flow Diagrams, Use Cases, and Use Case Diagrams, Class diagrams, Activity diagrams, Collaboration diagrams, Entity Relationship Diagrams ERD, prototypes, wireframes and UIDD's.

Conducted Gap analysis, Root Cause Analysis RCA, Risk Analysis, SWOT analysis, Cost benefit analysis and ROI analysis.

Expertise in the various phases of the Software Testing Life Cycle that includes but not limited to Script development, Requirement Analysis, Test Estimation, Test Planning, Test Design, Test Execution and Defect Reporting.

Skilled at reviewing test cases making sure they are in accordance with requirements, and assist the overall testing process by activities such as Change and Defect Management and conducting User Acceptance Testing UAT.

Extensive experience in Functionality, Integration, System, Regression and User Acceptance Testing UAT.

In depth understanding of Application Life Cycle Management ALM.

Team player and self-starter with excellent communication, coordination, documentation, project planning and interpersonal skills.

In-depth knowledge of Rational Unified Process RUP and Rapid Application Development RAD.

Hands on experience with configuration and release management.

Excellent analytical, communication and presentation skills and adept at facilitating walkthrough and training sessions. Great interviewing and elicitation skills.

Understanding of BABOK 2.0 standards.

Experience in conducting Joint Application Development JAD sessions, workshops etc. to resolve open issues, and change requests.

Extensive experience with Business Process Modeling (BPM) and Business Processing Modeling Notations (BPMN).

Good experience in writing user stories (agile environment) and use case documents.

Experience in databases like Oracle, SQL.

Knowledge of standards like CMM, Six Sigma.

Worked Extensively on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.

Strong experience in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow-flake Schema, FACT and Dimension tables), Logical and Physical Data Modeling.

Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.

EDUCATION:

Anna University – Chennai, India.

Bachelor of Engineering in Computer Science – April 2010

TECHNICAL SKILLS:

Operating Systems: Windows XP Professional/Home, Windows Vista/Vista Business/Vista Home Premium, Windows 7, Windows 8, UNIX, Linux.

Languages: C, C++, SQL, HTML, XML, VB, BTEQ, MLOAD, FASTLOAD, FASTEXPORT, JCL, COBOL.

Databases: Oracle, MS SQL server, Teradata, Mainframe DB2, Oracle PL/SQL, BPM, and MS Access.

Tools: Rational Requisite Pro, Clear Quest, Clear Case, MS Office Suite, Visio, Rational Rose, ER Studio, Oracle Designer 12.0, ERWIN, Adobe Acrobat Reader, Load Runner, HP Quality Centre, HP ALM, UML, Balsamiq wireframes tool.

WORK EXPERIENCE:

State of NY, Albany, NY-USA (Onshore) Sep 2016- August 2019

Senior Business Analyst Employer: Global Systems LLC

Interact with NYSE-CON business to gather the requirements. Involved in study and analysis of the requirements catalogue and scope specification document for projects.

Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.

Interacted with Business Users and Managers in gathering business requirements.

Facilitated JAD sessions with the management team, IT department and other stakeholders to discuss the requirements, analyze the needs and benefits and discuss the challenges involved.

Understood all the system requirements within deliverable and provided feedback to the stakeholders and state executives.

Analyzed functional, non functional and technical requirements and prepared deliverables such as User Interface specifications, data mapping screen mock-ups, report mock ups and prototypes.

Performed UAT along with the QA to assess the final implementation and functionality of the new system.

Documented the UAT plan, provided input for application process flow and worked with the QA team to ensure every acceptance criterion have been met for the effective operation of the system.

Conducted weekly meetings with team leads from QA and Development team to explain functional requirement and answer any questions.

Planned and tracked the status of the project by using HP ALM. Managed and tracked the Requirements, defined the Test Scenarios.

Developed detailed Use cases and User Interface specifications for the features implemented, Prepared Activity Diagrams (UML) as a part of the Use case specification in MS Visio.

Created and developed pre-implementation plans to assess the workflow process.

Conducted the GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system. Assisted in modeling the AS-IS and TO-BE business workflow

Documented a high level Business Requirement Document and System Requirement Document based on the information gathered through work flow analysis and JAD sessions.

Developed Requirement Traceability Matrix (RTM) to trace and link requirements, design specifications, test requirements and code files.

Tracked and reported project milestones and presented status reports to senior management using MS Project.

Excellent knowledge of planning, estimation, project coordination and leadership in managing large scale projects.

Experience in testing coordination, writing test cases and executing test scripts, and logged defects in Quality Center (QC).

Discussed the implementation challenges with the management team and staff and recommended possible solutions.

Conducted training sessions using techniques like “train the trainer” for the NYSE-CON staff and program heads.

Environment: MS Project, MS Visio, Balsamiq, MS Excel, Red Mine, SharePoint, JAD, HP ALM, UML, SQL, Risk Management, MS Office.

British Gas, United Kingdom & Chennai, India (Offshore) June 2014- Jan 2015

Technical Business Analyst Employer: Cognizant Technology Solutions

Responsibilities:

Participated as an active member in the Campaign-Smart Meter management team.

Created and developed pre-implementation plans to assess the workflow process.

Conducted a work flow analysis to assess the current and future states of workflow and identify the best implementation process for campaigns in each department.

Assisted in creating WBS using MS Project to identify and allocate resources for the project

Collected, documented and managed business requirements, functional requirements and non-functional requirements using MS Word.

Created Data Validation document, Unit Test Case Document, Technical Design Document and Knowledge Transfer Document.

Excellent knowledge of planning, estimation, project coordination and leadership in managing large scale projects.

Conducted weekly meetings and technical reviews with team leads from QA and Development team to explain functional requirement and answer any questions.

Performed Risk Analysis to identify any potential risks involved in installing and collaborating the existing system with the new system.

Worked with the Product owners and developed User Stories for the respective sprint backlogs..

Worked with the IT, management team and vendors to obtain the necessary bandwidth and establish a WAN connection for integrating the system.

Tracked and reported project milestones and presented status reports to senior management using MS Project.

Prepared Business Process Models (BPM) that includes modeling of all the activities of the business from the conceptual to procedural level.

Identified Defects using Defect Tracking tool, i.e. JIRA and captured them into defects tracking log-identifying priorities.

Assisted in conducting Automated Regression Testing using Win runner tool to verify the functionality of the system.

Performed UAT along with the QA to assess the final implementation and functionality of the new system.

Discussed the implementation challenges with the management team and staff and recommended possible solutions.

Monitored the implemented system for effectiveness and accuracy and provided status reports to upper management and stakeholders.

Documented the UAT plan and worked with the QA team to ensure every acceptance criterion have been met for the effective operation of the system.

Environment: MS Project, MS Visio, MS Excel, JAD, BPM,JIRA, UML, SQL, ERWIN,MS Office, Win runner.

Sainsbury’s Data Warehouse, UK & Chennai, India (Offshore) Sep-2010 - May-2014

Business/Data Analyst Employer: Cognizant Technology Solutions

Responsibilities:

Interact with Sainsbury business to gather the requirements for the new RFQs and cascade them to the team members.

Involved in study and analysis of the requirements catalogue and scope specification document for projects.

Functioned as a primary connection between the business, operations and technical team throughout the project.

Interacted with stakeholders to get a better understanding of client business processes and gathered requirements. Followed top down, leveled technique for building Business Process Models (BPM).

Conducted JAD session involving the stakeholders, project manager, development & QA team along with senior executives to discuss and gather the actual requirements for the project and prepared Business Requirement Documents and Functional Specification Documents.

Coordinated Requirement Gathering sessions for gaining detailed business and system requirements and maintained a Requirements Traceability Matrix to track them.

Facilitated team meetings to coordinate activities for project schedules with the management, senior executives, and SME’s and technical managers

Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.

Created data model diagrams using Visio and Erwin for EDW and data marts.

Collaborated with data modelers, ETL developers in the creating the Data Functional Design documents.

Free hand SQL, reports with calculation context, data analysis, reconciling data and drill down features.

Development of scripts for exporting reports from the warehouse to third party using Fast Export utility for business purposes.

Assisted in process of extracting data from the Sainsbury’s Data Repository (SDR) into the centralized system using ETL tool Teradata.

Wrote SQL queries for data mapping and data integration into the new centralized system

Strong efficiency in Teradata utilities like BTEQ, FastLoad, Multiload and Tpump.

Development of Teradata SQL scripts for creating MI reports with data from the warehouse to meet business needs.

Developed Project Glossary, Project Scope Document, Business Requirement Document.

Participated in user acceptance testing to ensure the requirements

Performed mapping of data models, analyzed data content and tables.

Responsible for mapping documents, test plan, test scenarios, test cases for unit, system and system integration testing.

Used the Agile methodology to build the different phases of Software development life cycle.

Trained and acted as point of contact for new employees.

24/7 production support, troubleshooting and resolution.

Developed SLA’s and metrics to measure and increase database production.

Experience in Application support and worked in SM7 tool.

Involved in solving incidents, problem records and business queries under the Application support part of the project.

Monitor and provide support to workflows and provide expert knowledge on all workflow designs.

Analyze the data in Teradata tables and check the validity of the scripts if the data is being fetched as expected. Error handling the Teradata scripts and mainframe jobs.

Monitor all alerts and escalate all issues for all procedures and systems.

Maintain logs of all issues and ensure resolutions according to quality assurance tests for all production processes.

Involved in Query Level Performance tuning using Explain Plans, SQL Trace utilities to pin point time consuming SQL’s and tuned them by creating indexes and forcing specific execution plans.

Environment: UML, Load Runner, MS-Project, MS Visio, SQL, RTM. BPM, Microsoft Word, ER Studio, Microsoft Excel, Microsoft Visio, MS Access, Teradata, Mainframe, SM7, Agile methodology.

Blue Chip Technologies, Chennai, India Sep 2009- May 2010

Software Development Intern College Intern

Responsibilities:

Understanding the scope specification and requirements catalogue and worked with product groups to enhance the application performance.

Responsible for gathering requirements, documenting the Business Requirements Document, maintaining the project plan and vision document.

Conducted JAD sessions with the Stakeholders and Business Owners, defined the scope of the project and project objectives including specific requirements of the system application.

Adopted the Waterfall methodology for the software development throughout the project life cycle.

Created UML diagrams to effectively demonstrate the functional and non-functional requirements using MS Visio

Monitored and tracked the project schedule, status using MS Project and generated reports to analyze the progress of the project.

Assisted the design team in creating GUI interface and develop Mockup Screens.

Implemented using JAVA and Oracle 9i.

Implemented various normalization techniques to enhance the application performance.

Performed various testing methods like unit testing and functional testing to test my application.

Reviewed and tuned SQL,T-SQL queries, PL/SQL stored procedures, nested procedures, views, triggers and joins.

Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.

Environment: Waterfall methodology, UML, MS Office, MS Project, JAVA, SQL.

Contact this candidate