Project Data

*************@*****.***

Ph: 860-***-****

Rocky Hill, Connecticut

SWETA MISHRA

PROFESSIONAL SUMMARY

Highly analytical, detail oriented professional with 5 years of experience in Business Systems

Analysis, Data Analysis, Data Modelling, SQL and Reporting with expertise in, requirements

gathering & analysis, cross functional communication and documentation.

EDUCATIONAL PROFILE:

• Masters in Computer Information Technology (Dec, 2014), Central Connecticut State

University, Connecticut.

GPA 3.91

Relevant Courses:

Object Oriented Programming with Java

Data Structure and Algorithms Application of Stacks, Queues

MIS: Managing IT value preposition: Supply chain management, CRM, ERP Business,

Process Management, Business Payoff Info and Systems.

Software Engineering Requirement Engineering, Agile Methodology, UML

Database Management with specific focus on SQL queries, Data Modelling, Entity Relationship

Diagrams, UML Diagrams, relational Mapping.

• Master’s in Business Administration (MBA), Institute of Public Enterprise, India

• Diploma in Computers, NIIT, India

SOFTWARE SKILLS:

• Software Tools: Sage, 100 ERP,, SAP, Crystal Reports, Logicity,MS Visio, UML, Quality

Center (QC), Weka (Data Mining)

• Methodologies: SDLC (Waterfall Method, Agile Methodology), Rational Unified Process

(RUP),

• Programming Language: Java, Java Script, VBA, SQL, SAP R3,PHP

• Database: SQL Server Management Studio(SSMS), My SQL, MS Access, ODBC, Relational

database, Data Modelling, Relational Data Mapping, Data Flow Diagrams, Process Flow

Diagrams, Work Flows,

• Office Tools: MSWord, MS Excel with (Macros, Pivot tables) Power Point, MS Access, MS

Outlook

• Use Case, UML diagrams, Documentation

EXPERIENCE:

Organization: Progressive Specialty Glass Company, Inc. (November 2013 Till Date)

Designation: Programmer

Responsibilities:

• Capturing requirements from business users Coordinate/facilitate the projects (up

gradation, enhancement and customization of SAGE100ERP) releases.

• Conducting JAD sessions.

• Working extensively with SAGE ERP 100, AR, AP, GL, PO, IM, RMA, Bills of Materials,

Creating Visual Integrator jobs, User Defined fields in MAS database, customizing screens,

User maintenance, Role maintenance, importing, exporting data to the MAS database etc.

• Transform the business requirements to system requirements specifications.

• Designing, building and, testing Crystal Reports for users based on reporting needs from

SQL or MAS database.

• Working with SSMS, creating views, stored procedures, and retrieve data through SQL

queries.

• Building solutions in Logicity and scheduling tasks.

• Creating Excel applications for users using advanced excel features such as V Lookups, H

Lookups, pivot tables, macros and integration with other data bases.

• Querying and maintaining database in MS Access.

• Participates in user acceptance testing and testing of new system functionality.

• Process mapping and documenting business functions and processes.

• Coordinating with 3rd party consultants and project management.

• Perform a key role in communicating status and other information required by business/IT

team

Organization: Infowave Systems Inc. (January 2013 September 2013)

Business Analyst

Infowave systems deliver Enterprise Data Warehouse (EDW) and Business Intelligence (BI)

solutions to Healthcare Industry particularly for Health Informatics Departments.

Designation: HR Executive

• Handled end to end Internal HR processes including Payroll, Immigration and

administration.

• Requirement analysis, process mapping and creating logical and physical database for HR

application for client.

Organization : Synerite Solutions, India (Oct 2006 to Jan 2009)

Designation : Business Analyst

*************@*****.***

Ph: 860-***-****

Rocky Hill, Connecticut

Project: Payroll implementation for Life and property casualty Insurer AXA, India. Involved

implementation of payroll administration for Asia, addressing unique requirement across countries.

HR module of SAP was used a platform to run payroll.

Responsibilities:

• Actively involved in gathering, defining and teamed with staff to document

requirements as Business Requirement Documents (BRD) and Functional

detailed requirement documentation (FRD),Use Cases and UML diagrams Flow charts and

Use case Utilized corporation developed SDLC methodology and prepared mock screen

using Microsoft Visio.

• Prepared and used RTM for effecting tracking of project requirement throughout the

Software development.

• Successfully conducting JAD sessions to gather project requirements and help synchronize

the different stakeholders on their objectives in order to provide the developers a clear cut

picture of the project.

• Analyzing Business Requirements and segregated them into high level and low level

Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according

to UML methodology thus defining the Data Process Models.

• Extensively used SQL scripts/queries for data verification and Validation.

• Supervised preparation of test cases. Authored and reviewed user acceptance test plans

(UAT), interim and final test reports

• Communicated extensively with end users any issues or clarifications throughout the

project.

• Proactively discuss critical issues with other functional consultants for timely Resolution

• Realization – System Configuration, Final Preparation including test, training methods/

material and finally Go Live, involved in end user training.

• Providing solutions to tickets raised by end users.

Current Projects:

1. Capstone Project

Organization: Curious Rubik.

Curious Rubik is developing ERP HR product to be implemented on cloud with Net suite

technology.

Business Analysis and technical design for Leave Management Application for the ERP HR

module being developed with Net suite cloud.

Deliverables: Functional Requirement Document, System Requirement specification and technical

design.

2. Project as a Course Requirement for Software Engineering

Organization: Stanley Whitman House, Farmington, CT.

Working as a part of a 3 member team to develop an interactive historical map for Farmington

Museum.

Deliverables: Project Proposal, Requirement Specification Document, Architecture Design

Document, Development Plan documentation, Application development, deployment, testing and

support.

Software tools used: MySQL, PHP, HTML, JQuery, JSON, Google API.

Work Authorization: Authorized to work.

Contact this candidate