Data Sales

Rupali Patra Nutley, NJ 201-***-**** ******.*********@*****.*** *****@****.***

Professional Profile DATA Analyst Business analyst

Aspiring for Full time / contract position as Data Analyst / Business Analyst in your organization. Have strong working knowledge of data mining / analytics / ETL projects across SDLC phases in Waterfall/Agile/Hybrid environments. Self-motivated and collaborative professional with 1.5 years proven track record of understanding business requirements, translating functional goals into technical language, working on ETL development projects and provides technical solutions around business needs.

Technical skills

Languages

SQL, Unix

Database

Teradata 14, Oracle 10g

DW Tools

Informatica Power Center 9.x, ALM, Rapid Miner, Tableau

Development Tools

SQL Developer

Miscellaneous

Word, Visio, Excel, PowerPoint, Axure UI design

Soft Skill

Requirement Elicitation, Functional and Business Requirement, UML Diagrams

WORK PERMIT: L2 EAD. No sponsorship required.

Education & Academic Project Highlights

NEW JERSEY INSTITUTE OF TECHNOLOGY, Newark, NJ

Master of Science (MS), Information Systems (IS); GPA 3.75, (Jan, 2016 – May, 2017)

Data mining & analysis for managers: Analysis and forecast for supermarket transactions: Introduction to Data mining with an emphasis on large scale databases as a source of knowledge generation and competitive advantage. It also includes expertise in data modeling, inferential data mining techniques and evaluation and deployment of data mining systems.

data analytics for information systems: detection of chronic kidney disease using data mining technique: Introduction to data analysis, probability and statistics from an Information Systems perspective, including many other techniques that are most relevant to the profession of data scientist for business, data and web analytics, as well as current data sets.

Systems Analysis & Design: Online Banking System Design: Developed working prototype/wireframes for online banking system in Axure. Project scope encompassed design and delivery of comprehensive design document including user interface (UI) design; user journey/site navigation; detailed Visio diagrams of data class/attribute/operation; and integration maps between banking applications.

Enterprise Data Management: Air Quality Data Analysis: Examined data set comprising 2 million air quality data points from EPA’s Air Quality System. Established table structure and relational schema, verified database accuracy using Excel queries, and prepared Enterprise Relationship diagram in Visio.

User Experience & Design: Professor Selection Application Design: Established and applied evaluation metrics to assess integration of UX/UI best practices for different websites, and leveraged findings as foundation to optimize design for next-generation professor evaluation app.

Customer discovery: Introduces to the concept used by lean startup companies to directly connect with customer to discover new products. Such evidence based entrepreneurship guides the potential for new product ideas early in development process.

information system principles: Introduces to the field of Information Systems; also study the role of Information systems in organization and how these systems support organizational objectives and organizational structure, as well as providing competitive business advantage.

Business process innovation: Introduces the approach to Business Process Innovation (BPI) that includes both incremental improvements as well as re-engineering. It specifically examines the concept of Service oriented Architecture (SOA) and the use of web services as a way to build scalable and adaptive business processes.

EASTERN ACADEMY OF SCIENCE & TECHNOLOGY, India

Bachelor of Technology, Applied Electronics & Instrumentation Engineering

Professional Experience

SYNERGY TECH, LTD., Toronto, Canada – Business / Quality Analyst 4/2015 – 9/2015

Test Strategy Test Plan Development Test Case Validation Defect Management Data Aggregation ALM

The aim of the project was to develop a cutting edge reporting and analytics application for a leading University in Toronto. I was involved in testing the Informatica ETL that was developed to pull data from different department databases and transform the data for reporting purpose. Below were my roles and responsibilities.

Engaging in test strategy preparation and test plan development.

Run UNIX scripts to execute Informatica ETL and validate the test results.

Write complex SQL queries to validate the result

Interacted with Business, development team and project management team on defect resolution and tracking them to closure.

Log defects in HP Quality center and manage their status.

Involve in Defect Triage meetings & defect life cycle.

Excelled in documenting the test case results and making sure all the relevant test cases were run for each component.

TECH MAHINDRA, Mumbai, India – Informatica Developer 7/2012 – 4/2013

ETL DEVELOPMENT Unit testing Unix scripting offshore coordination

The Sales reporting platform (SRP) project was aimed at developing a new platform for collecting sales data, aggregating and creating new sets of reports for higher management. This was done so that Management executives can create custom reports and measure the performance of Sales team. This project enhanced the reporting mechanism for client and helped higher management with better decisions making. Also this project enhanced the functionality to support sales team in the field by providing almost real time feedback on their performance and promoting peer competition among them.

System Analysis, Design, Coding, Testing, Development and Documentation.

Gather the requirements from the users and analyze their business needs and created Functional specification documents.

Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 8.0

Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

Performed Unit testing, Integration testing and System testing of Informatica mappings

Developed several reusable transformations and mapplets that were used in other mappings.

Contact this candidate