EXPERIENCE SUMMARY:

• Professional experience as a Business Analyst with excellent understanding, analyzing and documenting
• Business Requirements, Functional Specifications, Business Process Flow, Business Process mapping using BPMN (Business Process Modeling Notations) and modeling.
• Extensive experience with Business - to- consumer (B2C) sales of tangible goods/online services and Business-to- business (B2B) scenarios, such as e-procurement
• Conducted Joint Application Development (JAD) sessions and interviewed Subject Matter Experts (SMEs), asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.
• Experience in Retail, B2B e-commerce domain as BusinessAnalyston requirement gathering, documentation and process analysis improvement.
• Proficient in transforming business requirements into functional specifications, focusing on workflow analysis and design, business process reengineering, user interface design, portal design, and process flow modeling
• Experienced in working with UX designer team to create Mockup Screens or WireFrames for the project to be built.
• Experience in preparation of Deliverables, Business Requirement Documents (BRD), detailed Functional
• Specifications and Non-Functional Specifications, developing Use Cases and Test Cases.
• Conducted GAP Analysis, SWOT Analysis, and Impact Analysis, modeling Businesses Processes, and prepared Training Manuals and Knowledge Transfer manuals.
• Tracing requirements throughout the development process and verifying adherence using the Requirements Traceability Matrix (RTM).
• Good experience in anchoring the User Acceptance Testing and performed Database Testing Manually using
• SQL Queries.Proficient at creating detailed Use Cases and Activity Diagrams.
• Experience in developing web-based applications wireframes, mockups etc

TECHNICAL SKILLS:

Management Tools: MS SharePoint, PeopleSoft (8.8,9.2)

Modeling Tools: MS Visio, Rational Rose, UML, iRise

Utilities & Tools: MS Office Suite - (Word, Excel, PowerPoint, Outlook), MS Project, OLAP - IBM Cognos 8, SAP Crystal Reports, ETL tool - SSIS, SRSS

Methodologies: Waterfall, IBM Rational Unified Process (RUP), Agile

Relational Databases: Oracle 11g, MySQL, SQL Server 2005, MS Access

Testing & Defects Tracking Tools: HP ALM 11.0, Quality Centre (QC) 10.0, LoadRunner, QuickTest Pro (QTP), JIRA

Languages: C#, C++, Visual Basic (VB) 6.0, PHP, SQL.NET, Java, XML, HTML, Visual studio, ASP.Net

Operating Systems: Windows NT / 2000 / XP / 7

Applications & Software’s: Tableau 9.0, ETL Informatica, Toad, JIRA, Axure RP

PROFESSIONAL EXPERIENCE

Project Manager

Confidential, New York

Responsibilities:

• Working on upgrading an existing legacy application with CAS and PSY to score the needs of Stakeholders and Psychologists.
• Technical solution design for functional requirement.
• Conduct feasibility analysis and design integration of PeopleSoft with legacy systems.
• Reviewing Technical Designs, build and applying fix if applicable.
• Conducting Interface Workshops and finalizing the interface layouts.
• Developing Solution Design based on the Client’s Business Processes and Requirements.
• Functional Testing - Preparing & Reviewing Test Scripts.
• Supporting Conversion development and testing life cycle.
• Processing conversion files and Confirming conversion file layouts
• Was responsible to report to the Product Manager about the Status Update
• Responsible for Database Documentation & Production Data Documentation & Data Analysis
• Responsible for the Entire Screen Analysis of all the components of the legacy system (Web portal,
• Coordinate efforts across legacy Horizon Business/Patient Folder and IT management and staff to maximize EPIC Implementation data conversions.
• Collected business requirements to set rules for proper data transfer from Data Source to Data target in Data Mapping.
• Developed Mappings for a new Database using various transformations and analyzing the existing Database.
• Collecting business requirements based on Data Analysis for the Upgrade.
• Used UML to produce AS IS and TO BE models.
• Responsible for Screen writing, Spec writing and plan the daily routines for the upcoming deliverable.
• Extensive Web and In-house applications screen analysis for existing enhancement to the Referral portal for the Government of USA and the city of New York.
• Meetings with stakeholder from private Information systems team to the strategic team stakeholder to discuss system requirements of encapsulating specifications, costs and timelines for the next deliverable.
• Responsible for Screen writing, Spec writing and plan the daily routines for the upcoming deliverable.
• Authorize and assign daily task to team member and correspond to the stakeholder development of applications and services
• Worked with the UX design team to make sure all the UI mockups are up-to-date as per the requirements.
• Interacted with Business Owners, Users, and Stakeholders to identify Business System Needs, evaluated solutions for business problems, and prepared Business Requirements Document (BRD) and later translated them in to Functional Requirements Document (FRD).

Business Analyst

Confidential, New York

Responsibilities:

• Fulfill the change requests from the users and gather the requirements of the functionality in CCAR regulatory reporting
• Interact with user groups to derive the Business Requirement Documents and turn into Functional Requirement Documents
• Discuss with PM and Stakeholders from business unit to define the scope of the project
• Perform extensive requirement analysis including data analysis and gap analysis to create and develop new functionality to meet business needs
• Use Axiom software to check on the workflow and data feed of CCAR reporting
• Turn business requirements into detailed FRD on those data and get sign off from users
• Assist in creating Test Plan and Test Cases based on BRD, FRD and product knowledge and create test queries to automate migration test
• Assist in performance tests, reviewed test results with development team and found solutions to improve applications & performance
• Work with QA team on conducting user acceptance testing (UAT) and involved in preparing a detailed user manual for all the applications
• Conduct the change request and defect tracking using Bugzilla for utilization by the developers and the QA team
• Tracing requirements throughout the development process and verifying adherence using the Requirements Traceability Matrix (RTM).
• Coordinate with development team to Track change requests and monitored workload and schedule
• Attend weekly status review meeting with PMO team to report latest progress and issues found in the project.
• Creating technical specifications based on functional designs and subsequently building them.
• Developing various enhancements interfaces or customization's requested by the client based on Application engines, PS Queries, component Interface, BI Publisher and People Code.
• Working on various break fix issues cross domain.
• Warranty support for implementation.
• Design Application Workflow Engines.
• Unit Testing - Preparing & Reviewing Test Scripts to be used for Unit Testing.
• Conducted Gap Analysis to define the impact of the new requirements on the existing GUI and further prepared Business Impact Analysis Reports.
• Responsible for Interacting with the Developers to explain the proposed changes and ensure understanding of the system requirements to handle these changes.
• Analyzing raw data, drawing conclusions & developing recommendations
• Performing daily system checks
• Developing data analytical databases from complex financial source data.
• Designed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams to define the Business Process.

Data Analyst

Confidential

Responsibilities:

• PeopleSoft Financials 8.8 Support
• Handling Production support and maintenance for the Accounts Receivables and Billing module.
• Working on various bug fixes issues mainly based on Application engines and People Code.
• Identifying & analyzing gaps; identifying solutions for such gaps (if possible). Subsequently creating Functional specifications for them.
• Defining Business Processes, by interacting with the client, for the purpose of gathering detailed business requirements.
• Testing - Preparing & Reviewing Scripts to be used for Unit Testing, System Testing & User Acceptance Testing.
• Responsible for gathering and documenting Legislative, Business, Functional requirements for all the provisions and their impact on the existing products and systems to help leverage new and existing application tools, web technologies and databases.
• Using Tableau and third party tools ensured Platform monitoring, availability and performance management, and service reporting (KPI)
• Build dashboards and reports such as master/detail and cross tabs for trend analysis.
• Developed complex SQL queries and functions to fetch data for reporting and accomplished improved traffic reliability by 28% through distinct channels.
• Designed and deployed Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.
• Actively participated in meetings with Business Analyst and Architects to identify the scope, requirements and architecture of the project.
• Writing T-SQL scripts to manipulate data for data loads and extracts.
• Involved in the creation of Informatica mappings to extracting data from oracle, Flat Files to load in to Stage area. Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
• Responsible for Collecting, collating and carrying out complex data analysis in support of management & customer requests.
• Involved in reporting statistical findings to work colleagues and senior managers.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Liaising with end-users and 3rd party suppliers.

Jr. Java Developer

Confidential

Responsibilities:

• Worked on requirement gathering and business artifacts using AGILE methodology.
• Used Eclipse IDE for developing the applications.
• Extensively worked on developing UI components using JSON to interact Restful web services.
• Used JBOSS Application server for deploying web and business components.
• Implemented Web Services to integrate between different applications (internal and third party components) using SOAP services.
• Involved in pre-testing the Web-services calls with SOAP UI using end-points.
• Used JIRA for bug tracking, issue tracking and defect tracking.
• Maven tool has been used for the build and deploy procedure scripts in Windows environment.
• Used JUnit for Unit Testing of the developed code for testing accuracy of the code.
• Tested the code using tools like Junit Developed Spring RESTful web services to deliver both XML and JSON content using Jackson Spring implementation
• Designed& developed JSP pages and XML reports which included development of servlets and custom tags for JSP pages
• Integrated Spring MVC and Hibernate to access the database. Used DAO pattern to decouple and control the access to the database
• Extensively used Criteria classes and HQL for accessing Database through Hibernate
• Configured persistence-Context in Spring JPA and Hibernate as a persistence provider to interact with Oracle database
• Created POJOs as Spring JPA entities in an Object Relational Mapping Architecture
• Designed, developed and deployed the EJB components using Session beans, DAO objects for database access. Used Session facade and Business delegate design patterns
• Refactored legacy stored procedures, extracted and converted logic from stored procedures into java components for better reusability
• Use OOP features such as polymorphism to implement factory design pattern solutions to provide the system the right objects for the product related methods