OBJECTIVE: Seeking a challenging position in the industry, which will utilize my skills suitably.

SKILLS :

Operating systems: Windows 95/98/NT/2000/XP,VISTA,UNIX Databases: Oracle, Access, SQL Server 2000, 2005 and 2008 SQL Server Management Studio, Oracle SQL Developer
Applications: Microsoft Office (Word, Advanced Excel 2007, 2010, Outlook, Access, Powerpoint), Project, Adobe, Crystal Reports 2008, SAP, BEx Analyzer, Talend Open Profiler and MS SharePoint.
Technologies: Java, HTML programming, XML

PROFESSIONAL EXPERIENCE

Confidential, Plainsboro, NJ Data Integrity Specialist August 2011- March 2012 Responsibilities:

• Responsible for preparing, maintaining and auditing the integrity of all data to be converted into the R12 environment.
• Involved in developing Data Readiness Assessment and Data Conversion Strategy documents for the planning and initiation phase of Delphi project.
• Responsible for legacy system data profiling(Customer, Supplier and Item) and data analysis using Talend open profiler tool to produce the accurate estimate of the data that needs to be converted into R12.
• Coordinate with different business and technical teams within project Delphi to assist in master data mapping and data conversion process.
• Responsible for writing SQL queries for data manipulation and validation from SQL staging server.
• Identifying data defects for supplier master data, gap analysis and involved in the data reconciliation /validation activities for the data to be converted into R12.
• Responsible for continuous improvement related to core data quality and communicating with the owners of the legacy systems to cleanse and prepare data prior to the conversion.

Confidential Database Management System Specialist Princeton,NJ June 2009-July2011
Responsibilities:

• Responsible for NERC CRATS(Compliance Reporting Analysis and Tracking System) administration. Responsible for regional compliance data verification, data analysis and loading excel workbooks, Access DB with the regional violation information into SQL Management Studio using Data Importer.
• Involved in Functional testing, Regression testing, Sync Engine Testing and User Acceptance Testing with the development team and system users during SDLC phases for the Compliance Reporting and Tracking System. Involved in developing Test Cases, Test Plans, Test data and system GUI and database backend testing.
• Responsible for developing SQL queries, Stored Procedures, Tables, Views, Functions for report development and backend testing. Responsible for designing Crystal Reports and generating Ad hoc reports for internal teams using SQL 2005 Management Studio and Access 2007 Database as backend .
• Coordinated with Compliance enforcement team and Legal team. Provided day-to-day support for all system users including internal, regional, external users in the collection and tracking of Violation and Mitigation information.
• Assisted in the development and maintenance of Compliance Monitoring Enforcement SOP, Procedures and creating business rules for the new CRATS system. Developed recommendations to improve reporting processes and involved in preparation of various statistical and qualitative performance reports using advanced Excel and Access (using Vlookups, Pivot Tables, Charts and Access Forms)
• Responsible for generating and distributing monthly BOTCC reports for the senior management and Board members. Analyzed regional violation data and developing PowerPoint presentations and compliance trending charts. Analyzed violation data and determined root causes of exceptions.
• Responsible for reporting and tracking bugs, issues to the development team. Acted as a liaison with IT regarding system hardware, data and database access, security issues and performance etc. Provided system training to the internal users as required.

Confidential, Plainsboro, NJ Metrics and Data Analyst April 2009 – June 2009
Responsibilities:

• Responsible for Analyzing performance results and develop into PowerPoint presentations. Analyzed report data and determine root causes of exceptions.
• Responsible for UAT(User Acceptance Testing) for newly developed BI reports. Develop training materials and review procedures.
• Generated reports using SAP and BI (BEx Analyzer). Analyze data using Excel and prepared user manuals using Word, Snagit and PowerPoint.

Confidential, Lawrenceville, NJ Customer Data Manager June 2006 –June 2007
Responsibilities:

• Responsible for 1SYNC Siebel CRM tool administration. Collaborate with all departments within the company to maintain the Customer, Prospect and Partner Data.
• Created processes and set up Data Quality Management (DQM) rules. Validated all the data to be entered into database meets the standards and requirements.
• Created complex SQL queries to select appropriate individuals for inclusion and exclusion of marketing campaigns. Created control groups within each campaign to measure overall effectiveness of database marketing efforts .
• Developed employee appraisal forms with MS Access backend. Later ported database to SQL Server 2005 using Microsoft SQL Server Migration Assistant (SSMA).
• Created data extracts of various formats and complexity for use by Mail and Telemarketing vendors. Created and coordinated weekly and daily select seasonal direct marketing activity reports using advanced Excel and Powerpoint. Extracted and input data from multiple internal and external data sources and generated key metrics for program performance.
• Conducted due diligence on external sources or prospect data for quality levels. Ensure the proper disciplines and procedures are adhered to when importing data into the customer database tools.
• Responsible for adding new users and set upnew fields in the CRM tool in accordance with business requirements. Created new customer relationship records and contacts within 1SYNC Siebel CRM tool, IMIS database.
• Acted as a primary Liaison with all lines of business and all departments within the company to ensure a single source of truth across the organization in accordance with business requirements
• Created 1SYNC business data processes and procedures to ensure standardization of documentation maintenance and deletion and/or archiving. Responsible for conducting audits to ensure adherence to established regulatory data guidelines for 1SYNC CRM data management processes and procedures are met.

Confidential Database Maintenance Technician Feb 2004 – May 2006
Responsibilities:

• Responsible for maintaining the IMIS Database and Siebel CRM tool. Developed SQL queries to retrieve customer data from IMIS. Created tables in the SQL server using DTS(Data Transformation Services) with excel spreadsheet as Input.
• Responsible for Importing and exporting 1SYNC Customer, Prospect data into Upshot CRM tool.
• Developed reports such as Daily Revenue Reports, Event Reports, Annual Revenue Reports, Subscriber reports and Pivot tables using Upshot and Advanced Excel, PowerPoint.
• Interacted with Business Development, IT, and Marketing teams to accurately load the 1SYNC Supplier/Retailer data into Siebel Upshot CRM Tool.

EDUCATION
Oracle Database: SQL and PL/SQL Fundamentals.
Advanced Quality Assurance Training
Crystal Report Development Training
Bachelors Degree (BCA in Computer Applications)
Diploma of Science-Commercial and Computer Practice