Priyanka Pandey

Email: pp1.priyanka@gmail.com

Mob No: +918882495755

Work Experiences:

Working as a Software Engineer in Amtex systems from August-2014

COMPANY NAME DURATION

ProGen Business solutions APRIL -2013 to August-2014Shotformats Digital Production PVT LTD MARCH -2012 to MARCH-2013

Profile summary:

Overall 2+ years of work experience in IT Industry. Possesses Data Warehousing experience using Star Schema, Snowflake Schema,

Oracle 10g, Fact and Dimension table’s identification. Used ETL process to Extract, Transform, Joiner update strategy and creating

mappings/workflows to extract data from Oracle, SQL Server and Flat File sources, Legacy systems and load into various Business Entities.

Knowledge in the field of Data Warehousing, System Analysis, SQL Server 2008, MSBI (SSIS, SSAS, SSRS), BI environment, this includes Business model, Data Model, Data Sources, ETL Tool and Reporting Tools.

2 years of programming experience as Oracle PL/SQL developer in coding, designing, implementation of business applications using the oracle relational database management system (RDBMS).

Proficient in database activities like database Creation, Maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore.

Written numerous Procedures, Functions, Triggers, Created indexes and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.

Efficient team player with excellent communication skills and interaction with customers.

Adaptable to any working environment. Ability to meet deadlines of projects. Developed Reports and Dashboards and oneview with different Analytic views using

BI. Designed different type of Query for displaying value in Reports. Hands on Experience in ETL tools i.e. in SSIS tool for loading data. Used ETL process to Extract, Transform, Joiner update strategy, and Load data into

stage area and data warehousing.

Educational Qualification:

Qualification

Category

Board/University Subject Year

Postgraduate (MCA) Gautam Buddha Technical Computer Applications 2012

University

Graduate (B.Sc) Agra University Computer Science with

Mathematics

2009

Intermediate (12th) Ajad Hind Inter College P.C.M 2006

High school (10th) Ajad Hind Inter College P.C.M 2004

Technical Skills:

ETL Tool BI and Pi tool, MSBI (SSIS, SSAS, SSRS) Languages T-SQL, PL/SQL, JAVA DBMS Oracle 9i, 10g, SQL Server, My SQL Operating System Linux Ubuntu/redhat Windows XP/2000/Windows 7 Application Servers Apache Tomcat 6.0/7.0, 2000 Server SP2 Other Tools Toad 10.5, SQL Developer, MS Office, Sqlserver VAS Development VXML and CCXML with jsp (OCMP) IDE Eclipse, Net Beans 6.0, Microsoft Front Page Reporting Tool Pi

Pi Business Intelligence Platform:

Pi is a comprehensive Business Intelligence & Analytics platform in the lines of BO/Cognos/Micro Strategy etc. pi has been built from scratch by us and it has various features like Query Studio, Dashboards, Portals, What If Analysis, Statistical Analysis, Scorecards, Sentiment Analysis, and Stick Notes etc. I have been involved in development of the following features in pi

Significant Project Experience:

(1) Project: Market Share Data Analysis (NIVEA Ltd.) (MAY 2013 to TILL DATE)Client Nivea India Ltd.Platform Oracle 10g PL/SQL, Tomcat 7.0 Tools Sql DeveloperRole PL/SQL Developer, Report/Dashboard creation, OneView CreationTeam SIZE 3

Description: This Project has been developed to keep the details of all the Nivea product their sales and Market share analysis based on various categories for the different retailers (Reliance, Big Bazaar, Wal-Mart, D-Mart, ABRL Super/Hyper, Tesco, Hyper city, Health & Glow, Spencer’s etc. ) across the country.

Responsibilities: Requirement specification & Analysis, Managing, Maintaining, Developing & Deploying applications and databases in response to business needs.Writing of PL/SQL Procedure, Functions and Cursors.

Handling Technical and Functional problems of user and inconsistency of Reports. Interaction with end user to develop new requirements in various Reports and Dashboards.

(2) Project: Pressto (Jan 2014 to till date)

Client Pressto Platform Oracle 10g PL/SQL, Tomcat 7.0 Tools Sql Developer Role PL/SQL Developer, Report/Dashboard creation, Oneview Creation Team SIZE 3 Reporting Tool Pi

Description: Pressto is Spain originated company. It provides Dry Cleaning & laundry services to the customers, We take customer service data of the Pressto in India, By analyzing the particular data, We created star schema with multiple dimensions in BI Tool PI, created the reports as per the client requirement. After that daily taking the data from the client and loading the data in base tables. If client facing any issue or problem, we talk with clients & resolve the issues.

Responsibilities: Involved in creation of star schema. Involved in configuration of dimensions and facts in Bi Tool PI. Created reports by using Bi Tool PI. Involved in daily ETL Process. Developed procedures to load the data into staging tables to base

tables.

(3 & 4) Project: Dialogbazi and Assmes Portal (MARCH 2012 to MARCH 2013)

Company Name Shotformats Digital Private Limited, Noida Role Developer, Tester Platform: Java, jsp, vxml, ccxml, linux Tools Netbeans 6, Notepad++, Ocmp, Putty Database: Oracle 10g Web Server Tomacat 6

Description: It is an IVR (Interactive voice response) based application that play different type of content when we dial a short code. This application is deployed on Airtel, Tata, Vodafone, Uninor, and Aircel operator.

Responsibilities: Accountable for all areas of the system development life cycle

including: requirements gathering and review, design, build, testing, implementation, maintenance and support.

Perform functional and regression testing to verify the logic of new modified programs.

Create appropriate documentation in work assignments such as program code, and technical documentation.

Work with other team leaders and supervisors to ensure project and organizational deadlines are met.

Defect tracking, maintain testing schedules and issue logs. OCMP HP Platform

SOFT SKILLS:

Interpersonal communication skills, Motivated and optimistic, Flexibility

learning from others and impart knowledge to others.

Personal Details:

Father’s Name Late Mr. Suraj Prasad Pandey

Date of Birth 10th Dec 1989

Marital Status Single

Nationality Indian

Language English & Hindi

Present Address Noida Sector 49

DECLARATION: I hereby declare that above information is true best of my

Knowledge.

Date

Place: Delhi (Priyanka Pandey)