PRIYA WADHWA
acq0s3@r.postjobfree.com
Address: **** ***** ******, ***** ******* Pur
New Delhi-110003. Nr. South Ex Part-I
CAREER OBJECTIVE
To get a challenging position where I can put my all experience and knowledge to give a significant growth to the organization.
Career Summary:
5 years of experience in Database Analysis, Data Mining, Data Migration, Reporting, Database Design, Development, Testing and Support in Production Environment.
Good experience with Analysis and Reporting Services.
PROFESSIONAL CERTIFICATIONS
Microsoft Certified Professional (MCP) in SQL Server 2005.
TECHNICAL SKILLS
Database
:
Tableau, Microsoft Excel, MS Access, Oracle 10g, SQL SERVER 2005, MySQL
Language(s) Known
:
C, C#, JAVA
Scripting Language
:
HTML, Javascript, Actionscript
Technologies
:
J2EE, ASP.Net, Flex
Development Tools
:
Eclipse, Spring Source Tool, Microsoft Visual Studio 2008, Adobe Flex Builder 3, Sqldeveloper
Application Server
:
BEA Weblogic, Glassfish Server
Operating Systems
:
Windows XP and 7, Linux
WORK EXPERIENCE
Hindustan Times Media Ltd
: Data Analyst
December 2014 – Till Date
Tactical Value Technology Solution Pvt Ltd, Noida
: Senior Data Management Executive
April 2010 – November 2014
PROJECTS UNDERTAKEN
Hindustan Times Media Ltd (HT SEAL)
Project Summary:
HT SEAL is an In-House advertisement agency of Hindustan Times.
HT Seal Data management services to support our sales team for providing effective data for calling.
Roles and Responsibilities:
Preparation/Maintaining, Compiling data, filtering DND, splitting data category wise / Region wise for campaigns.
Sending data to our technical support team.
Run Database queries as per the requirements from ops team.
Customer communication & conversion analysis for various segments.
Sharing daily / weekly / monthly feedback report to senior management.
Project Name
Client
Environment
Team Size
EMEA Data Migration
AVAYA
Aprimo, Eloqua, MS Excel, SQL Server, CuroVindico (Ticketing System)
1
Project Summary:
Analysing the method of transforming existing data into a format for the new environment and the loading of this data into other database structures.
Providing necessary changes and support documentation:
Data discovery – accessing the data sources, tables and fields, whatever the data type or platform
Data profiling – understanding the structure and content of the data sources
Data cleansing – defining rules to ensure the data migrated is consistent and valid
Data transformation – defining rules to map source data onto the data migration target tables
Data validation – defining rules for checking the migrated data.
Roles and Responsibilities:
Deal directly with our client, understand their requirements and provide the output within deadlines.
Project Name
Client
Environment
Team Size
APAC Data Migration
AVAYA
SalesForce, Eloqua, MS Excel, SQL Server, CuroVindico (Ticketing System)
1
Project Summary:
Analysing the method of transforming existing data into a format for the new environment and the loading of this data into other database structures.
Providing necessary changes and support documentation:
Data discovery – accessing the data sources, tables and fields, whatever the data type or platform
Data profiling – understanding the structure and content of the data sources
Data cleansing – defining rules to ensure the data migrated is consistent and valid
Data transformation – defining rules to map source data onto the data migration target tables
Data validation – defining rules for checking the migrated data.
Roles and Responsibilities:
Deal directly with our client, understand their requirements and provide the output within deadlines.
Project Name
Client
Environment
Team Size
Data Management Services
AVAYA
Aprimo, Eloqua, Salesforce, MS Excel, SQL Server 2005, MS Access, CuroVindico (Ticketing System)
5
Project Summary:
Data management services to support local, regional and global demand generation / nurturing needs for our multi-national clients. Utilising client data sources, data management service incorporate:
Segmentation
Analysis and matching
Improved of data
Data cleansing and de-duping
Data augmentation (imports, transformations and updates)
Import of new contacts
Proactive data source identification and segment identification
Roles and Responsibilities:
We deal directly with our client, understand their requirements and provide the output within deadlines.
Project Name
Client
Environment
Team Size
CuroVindico
AVAYA
J2EE framework, Glassfish 3.2, MyBatis, Free Marker, Javascript, Dojo1.6, MYSQL
4
Project Summary:
CV is a web based management tool for supporting SWAT’s managed services portfolio. This tool is presently used for the provision of for servicing Data Management and Publishing services to raise & monitor service requests. The tool has a multi-tenant architecture and allows for user administration, Graphical Dashboards (showing ticket status, resource utilization graphs), ticket lifecycle management. Email integration allows for a cohesive aggregation of all ticket related communication. This tool is supported across multiple browsers and devices.
Roles and Responsibilities:
Generating reports for client based on their requirements (Resource utilization report, Workload assessment report etc from MySQL.
Project Name
Client
Environment
Team Size
Pending Log Tool
VMWARE
J2EE framework, Weblogic 10.2, Adobe Flex 3,
IBatis, JExcel, Free Marker, Javascript, Oracle 10g
4
Project Summary:
It is web application for VMWare Manager’s team. This application is used by VMWare Managers of different region to view and analyse the Pending deals and the reason. Each Region has a team which contains one Manager and few Operators, Operator inserts pending records information in centralize database and Manager will only view the records of their specific region and see reports in customize format and graph.
Roles and Responsibilities:
Data Migration from SQL Server 2005 to Oracle 10g in new Pending Log version.
Working as a support executive for creating new users, generating reports based on the requirement.
Involved in development of the application.
Project Name
Client
Environment
Team Size
Deal Discount Tool
VMWARE
J2EE framework, Weblogic 10.2, Adobe Flex 3, IBatis, JExcel, Free Marker, Javascript, Oracle 10g
4
Project Summary:
It is web application for VMWare Sales team. This application is used by VMWare sales team for selling their products (VMware License and SnS). Each deal comes in predefined work flow depending on deal size and it requires different level of approvals for completion the deal. This tool provides automated workflow for supporting the approval process for License and sends an Email notification to Approver.
Roles and Responsibilities:
Data Migration from SQL Server 2005 to Oracle 10g in new DDT version.
Working as a support executive for creating new users, generating reports based on the requirement.
Involved in development of the application.
Project Name
Client
Environment
Team Size
Maintenance Pricing Automation (MPA)
AVAYA
J2EE framework, Weblogic 8.1, DOJO 1.4,
IBatis, JExcel, Free Marker, IText, Javascript, Oracle 10g
8
Project Summary:
Maintenance Pricing Automation (MPA) is a tool on Avaya Portal Environment (Enterprise and Business Partner), integrated to SSO, to facilitate and simplify the true up, renewal and telesales process and to be later deployed to and used by Business Partners themselves. The tool will configure the Partner Support Services (PSS) and Support Advantage (SA) products via uploading a flat system generated file or by the use of simplified intuitive manual product configurators. The application will establish, and validate platform, release and quantities and convert/map this live system data into applicable price able SAP material codes. The application will allow the user to then configure the maintenance PSS, SA offers and save as a customer quote in PDF format. As on date 4 phases are delivered and live.
Roles and Responsibilities:
Involved in Coding, Testing, and debugging of the application.
Implementing project within pre-set deadlines.
Writing required sequence, stored procedure, views, triggers and user defined function in database end.
ADDITIONAL QUALIFICATION
2yrs Diploma in Software Engineering from APTECH.
ACADEMIC QUALIFICATION
MBA from NIMS University.
Graduation from Delhi University.
Higher Secondary from C.B.S.E Board.
Senior Secondary from C.B.S.E Board.
PERSONAL VITAE
Name
:
Priya Wadhwa
Languages known
:
Hindi, English
Nationality
:
Indian
Marital Status
:
Single