Data Analyst

Amee Parmar

**********@*****.*** 267-***-****

Objective

An enthusiast, dedicated, analytic and self-motivated individual who is eager to start, and currently looking for a position as Data Analyst in an organization where I can apply my knowledge and skills to success of an organization.

Education

MASTER OF BUSINESS ADMINISTRATION JAN-2017 NEW JERSEY CITY UNIVERSITY

Major: Organizational and Leadership Management

BACHLOR OF ENGINEERING JAN-2013 R K COLLEGE OF ENGINEERING

Major: Electronic and Communication Engineering

Skills & Abilities

TECHNICAL SKILLS

Operating Systems

Windows NT/98, XP, 2000, Unix

Application Software

MS Office suite, Rational Suite, MS Project

Databases

SQL Server, Oracle, MS Access, SPSS, DB2, Mainframe

Web Technologies

HTML, XML

Methodologies

RUP, OOAD, UML & Business/Data Modeling, ER modeling

Requirements Management Tools

Requisite Pro, MS Visio

Testing Tools

Test Director, Quality Center, Quick Test Pro, Load Runner

Process Modeling

MS Visio, Rational Rose, Virtual User Generator

Programming Languages

Java, J2EE, SQL, ASP.NET, UML, Visual Basic, C, C++

Documents & Processes

SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modeling, .Net Project Planning & tracking

Financial Systems

Charles River, Calypso Trading Suite, Bloomberg terminal, Loan Origination and Servicing platforms

MANAGEMENT

Ability to initiate, manage cross functional teams and multi- disciplinary projects

Critical thinking, decision making and problem-solving skills

Planning and organizing- organizational abilities

Result oriented: Ability to achieve the target within given time

Conflict resolution

Adaptability – Efficient under pressure, always meet deadline

COMMUNICATION

Excellent written and verbal communication skills

Good communicator and Strong networking skills

Experience

DATA ANALYST VASTEK INC APR’16 – CURRENT

Duties are Assist the decision- making processes for various needs

Researched data issues and identify the root cause in source systems, data warehouse and data marts using various data analysis techniques, data profiling and data mining activities.

Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.

Expertise in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), and System Requirement Specifications (SRS).

Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, Visio, Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, Power Point, technical assessment tools, Data Warehousing concepts and web design and development.

Thorough knowledge in UML Modeling, including Activity Diagram, Sequence Diagram, Use Cases, State Chart Diagram, Deployment Diagram, Class Diagram, and Component Diagram.

Experienced in conducting JAD sessions meeting reviews and walkthroughs.

Experienced in creating Test Cases, Test Plan, and Test Data. Performed User Acceptance Testing (UAT) working with team members.

Experienced in the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Informatics Power Center.

Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions

Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.

Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.

Transformed project data requirements into project data models.

STUDENT ASSISTANT NEW JERSEY CITY UNIVERSITY JULY’15 – DEC’16

Site administrator for social media sites

Assist in organizing student events

Helping to maintain Department Computer lab and network

Data entering, maintaining inventory logs

Prepare signs, posters and mailings and assist with other projects assigned

Collaborate with faculty and staff, College Council and Curriculum and other standing committees to oversee and enforce academic policies consistently and accurately

Ability to work in a high paced environment with attention to details and adherence to standard administrative procedures

Experience with class scheduling or Academic Advisement Reporting in PeopleSoft

Ability to design and execute effective and creative solutions to problems

PART- TIME DATA ANALYST JYOTI CNC AUTOMATION LTD JUNE’09- JUNE’14

Successfully interpreted data to draw conclusion for managerial action and strategy

Used Statistical techniques for hypothesis testing to validate data and interpretations

Prepare financial analyses on various aspects of the financial operations of the company including revenues, expenses, utilization and membership

Used Microsoft Excel to create pivot table, used VLOOKUP and other functions

Manage the planning and development of designs and procedures for metrics reports

Highly worked with USE cases, activity diagrams, sequence diagram, wire frame

Perform daily involved in working with business users and understand business need and objectives

Prepare and maintain project plans and work breakdown structures

Prepare briefing documents, reports, meeting agendas and presentation as directed

Extraction of test data from tables and loading of data into SQL tables.

Used Reverse Engineering to create data models of existing databases.

Conduct Data Mapping sessions, and write the required business requirements documentation including use cases.

Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.

References

Available upon request.

Contact this candidate