Mayuri Joshi

Email: acwnr0@r.postjobfree.com Phone: 309-***-****

Address: ****,*.****** ***, ***********,IL

Experience Summary:

A Software Engineer with 4.5 years of experience with an understanding of Business Process Flows, Case Tools and Business Analysis.

Expertise in conducting requirement gathering sessions, feasibility studies and Impact Analysis, Risk analysis & management, base lining acceptance criteria.

Understanding of Context Diagrams, Process Flow Diagrams, Collaboration Diagrams, Class Diagrams, Data Flow Diagram, ERDs.

Experience in managing several projects simultaneously for the whole project life cycle.

Good business communication and presentation skills.

Strong knowledge of Business Intelligence, User interface development, EDI and Business Architecture with expertise in grasping transaction flows and process management.

Experience in Creating and Analyzing Dashboard.

Experience of IT experience which includes Analysis, design, development, Testing and Implementation of complete Software development life cycle and all aspects of gathering Business Requirements.

Core competencies include data modeling, design and development of ETL Data mart, Informatica and OBIEE repositories, and building OBIEE Dashboards/Reports.

Developed and implemented the coding of Informatica Mapping for the different stages of ETL.

Excellent knowledge about Scrum and Agile Practices.

Self-motivated, responsible and proper time management with good Written, Verbal and Listening skill, commitment to co-operative teamwork.

Technical Skills:

Operating System

Windows 7 vista/XP/2000/NT/9x/Apple

Languages

C, C++, Core Java, SQL, PL/SQL

Web Technologies

HTML,DHTML,XML

RDBMS

Oracle, SQL

BI Tools

OBIEE10g/11g (Oracle Business Intelligence Enterprise Edition)

ETL

Informatica 7.0 (Power Center),

Data Modeling:

ER Diagram, Entities, Attributes, Cardinality, Relational Modeling

Incident Management Tools

HP Service Manager,BMC Remedy

Educational Qualification:

MS in Management Information System, University of Illinois Springfield. (August 2015-Dec 2016)

BE in Computer Science, University of Amravati, MH, India

Projects done during MS:

Prediction of flight delays due to Airport Operations (June 2016 – July 2016)

This was a data mining project. The flight delays are caused due to various reasons such as weather, Air Carrier, National Aviation System, Late-Arriving Aircraft and Security. These include one that could be controlled and also the one which are not controllable such as weather. The controllable variables such as NAS (National Aviation System) and Security was our focus of the project as it can be associated to an airport. In our study we considered 29 Major airports of USA. Our analysis involved understanding the data, and finding the possible factors that would cause the flight delay. Once the factors are set they are used in predicting the flight delays using the SAS enterprise Miner 13.2

Analysis and Design of an e-commerce website (September 2016 - )

Purpose of this project is design a reliable, secure and user friendly e-Commerce website which will enable sales and marketing of products and services online. The main objective is to attract the customers with the design of website and make profits with offering best customer services. One of the ideas of designing the e-Commerce website is to expand the business demographically and reach out to larger number of customers. The online marketing strategies will be utilized for the acquisition of new users and retention of existing users.

This system will store detailed information of products, customers and orders and also offer more flexible and easier methods of payment.

Professional Experience:

Project Name : FXM (Foreign Exchange Manager) (Production Support) Duration: September 2012 – June 2014 Client: HSBC Bank Role: System Analyst

Foreign Exchange Manager is a service that provides foreign exchange deal booking functionality to other HSBC internal systems. It provides below features for the customers. A consistent way for a customer to book a rate online from HSBC (local or central) treasury when they create an online payment for either same day processing or forward dated value. Customers are able to see the rate before they accept it and, once accepted, the rate is used for the transaction on the value date. Allowed business to define tiered preferential rate segments based on different criteria, including transaction amount, transaction type, currency type and customer type.

Responsibilities:

Analyze system inaccuracies and defects to determine the root causes and appropriate solutions.

Understand business logic for each type of foreign exchange.

Develop process flows to define system functionality in order to provide training to team. Streamline operations to create efficient work flows between communicating systems.

Create team performance report out of remedy for Management.

Working as a system analyst.

Working with team and make sure team is on track and help to solve difficult tickets.

Make sure team is updating remedy tickets on time and closing the tickets as per SLA given.

Project Name: Enterprise Incentive Management System

Duration: August 2011 – December 2012

Client: HSBC Bank

Role: Support

Project Details:

In Enterprise Incentive Management System project, we worked on Truecomp and Informatica evergreening. Earlier we were using Truecomp V5 and Informatica V7 which we upgraded to V7 and V9 respectively. Acquired knowledge regarding ETL tool (Informatica) establishment how it works through pipeline processing.

Responsibilities:

Creation of its Repository

Working on Control M batch management system and script automation

Alteration of job properties and creation of its condition dependencies

Checking script run on production server and monitoring them through Control m batches

Project Name: Qatar Information Exchange

Duration: April 2011 – August 2011

Client: Qatar Information Exchange, Doha (UAE)

Role: Trainee Business Analyst

Project Details: Objective of this project is to build report on Qatar information in English and Arabic Language like Reports Related to Births, Death, Education, Population, Marriages, and Census, Labor Force, Foreign Trade for Qataris and Non Qataris. As per requirement for project client want to see me onsite for project coordination

Responsibilities:

Understand the requirement from client and Based on the requirement create high level design Document.

Gather high level requirement documents for all the external projects in a release (averagely 70-80) and work on project prioritization and management.

Analyze the requirement documents gathered.

Keep track of the changing requirements of projects

Involved in Risk Assessment for each project as well as management of the impacting projects.

Setup JAD sessions with representatives and stakeholders for a detailed analysis.

Setup the JADs aimed at functional requirement walkthroughs for all the impacting projects and update the documents based on recommendations (if any).

Performed the testing results review and coordinated the fixing of issues with testing and development team in line with the business rules defined.

Developed timelines for project delivery, managed projects and resources to successful completion. Played major role in the risk analysis team.

Project Name: DC7 Metrics and Reporting and ECS Financials

Duration: December 2009 – April 2011

Client: State farm Insurance, Bloomington, IL

Role: Software Engineer

Project Details:

The client is US Based Fortune 500 Company working mainly in Auto, Fire & Life insurance domain. The goal of the project is to create application for claim system. This application uses AICS architecture for development.

Claim Financials manages claim-related financial transactions necessary for claim handling processes. All financial transactions are generated from a Cause of Loss which is tied to a claim. The core financial processing includes reserving, payments, and recoveries. Various payment methods are supported including manual, recurring, Electronic Funds Transfer, and automatic payment generation without user interaction. Additionally, there are a set of administrative functions that support the core financial processing. These functions include such features as Authority, Financial Log, Financial Summary, Limit Checking, Interest calculations, Wage Loss Calculator, and medical bill calculations.

Develop Metrics and reporting for customer communication in various services like Deliver, Capture, Design/Manage, and Store/View. Work with EPMA (partner) to capture date from each data source for reporting needs.

Responsibilities:

Responsible for creating and reviewing business requirements, functional specifications, project.

Involved in requirements discussions with business units, ensuring all business requirements were met.

Gathered user/business requirements by meeting with business users and generated business models and use case analysis.

Interfaced with internal clients and technical vendors on new feature requirements and conducted a thorough analysis of the system features to assist project team with implementation of new features.

Conducted JAD sessions with business and technical units

Coordinated with onsite/offshore teams by transferring knowledge supporting business-critical applications and meeting stringent service levels.

Created use case document to elaborate user experience taking into account the mission statement and the business objective

Prepared the Functional Requirements Specification (FRS) Document using Requisite Pro for the application based on business user information.

Designed and implemented SQL queries for QA testing and report/data validation.

Involved in capturing requirement from different stake holders and involved in drawing high level timeline and design documents.

Conduct analysis of business and user needs to develop requirements documentation for Customer Communication Services

Contact this candidate