SUMMARY

• Over 6 years of experience in implementing/supporting Vertica Database, Confidential Infosphere Optim and performed roles as a Vertica Developer, Data Solution Architect and PeopleSoft
• Certified Vertica Developer with hands on experience on setting up the environment and building use cases.
• Experience with setting up multi node Vertica Cluster.
• Experience with migrating data to Vertica from Oracle, Teradata and Sql Server Database.
• Experience with developing scripts with loading Vertica and using ETL tools to perform the load.
• Experience in Implementing Vertica 6.0/6,1
• Worked on the performance improvements of the Vertica load process.
• Experience in complete Database Archiving solution using Confidential Optim or PeopleSoft archiving.
• Experience creating testing deliverable's that included Test Strategies, Cases and Scripts for large scale, complex cross - functional projects.
• Experience with using Confidential Optim for Data Privacy and Test Data Management.
• Expert in setting up Optim environment and implementing Optim security.
• Designed and developed archival solutions (Entity Relationship Diagrams) for PeopleSoft HCM Applications (Benefits Administration, North American Payroll) and PeopleSoft Campus Solutions (Campus Community, Recruiting & Admissions, Student Records and Academic Advisement).
• Reviewed & Created Functional Specifications like ERD, Criteria for archive, Test Data, Test Plan.
• Design and Implementation of Transparent Access architecture for accessing the Archived Data.
• Experience in providing support for technical issues encountered by users with PeopleSoft/Optim.
• Identifying requirements for performance improvements/enhancements.

TECHNICAL SKILLS

ERP - PeopleSoft: Confidential Infosphere OPTIM 7.3/8.1/9.1, Optim Connect

PeopleSoft 8.9/9.0 (FSCM): People Tools 7.x/8.1x/8.4x (Application Designer, PS/Query, nvision, Tree Manager, SQR, Application Upgrade, Workflow, Import Manager)

Databases & Tools: Oracle 11g/10g/9i, Vertica 6.0/6.1, MYSQL, DB2, SQL Server 2008 and Teradata

Programming Languages: People Code, SQL, PL/SQL, C++, C and Java

DBMS Query Tools: TOAD, SQL Navigator, SQL Developer

Testing Tools: HP Quality Center 9.2, Test Director, QTP v10

Version Control Tools: Rational Clear Case

Operating Systems: Windows NT, Win 95/98/2000/XP, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential

Sr Database Engineer/Database Team Lead

Responsibilities:

• Design and implementation of data warehouse/operational data store strategyensuring rapid delivery while taking responsibility for applyingstandards, principles, theories, and concepts.
• Responsiblefor design and delivery of data models which power BI initiatives,dashboards, reporting, and ad-hoc data exploratory canvases for Confidential solutions.
• Design logical data models and physical database designs optimized for performance, availability, reliability, tuning and optimization of backend and frontend data operations.
• Design and develop ETL and master data management tools and processes.
• Scripting and automation to support development, QA and production database environments and deployments at client sites.
• Define and help enforce data governance and security policy.
• Proactively help to resolve difficult technical issues.
• Provide technical knowledge to development teams during project planning phases.
• Keep management informed of work activities and schedules.
• Assess new initiatives to determine the work effort and estimate the necessarytime-to-completion.
• Documentnew development, procedures or test plans as needed.
• Participate in data builds and deployment efforts.
• Participatein projects through various phases.
• Performsother related duties as assigned.

Confidential, Cupertino, CA

Responsibilities:

• Analyzed their current workflow in Teradata and oracle.
• Gathered requirements, performed Data profiling on their data and designed the data model.
• Ran the Vertica Database Designer for Projection recommendations for queries.
• Analyzed their current SQL’s and tuned them for Performance improvement.
• Gathered stats on the queries ran to fine tune the projections like explain plan.
• Tuned the Projections and deployed the projections to address queries which ran very slow.
• Co-ordinated with HP Vertica Engineers to perform health check on the cluster.
• Worked on writing scripts to perform Data loads.
• Worked with Service Layer and ETL teams in integrating the Vertica Database with the respective layers.
• Performed concurrency tests on the Vertica Database.
• Increased the nodes during the development and performed rebalancing on the nodes.

Confidential, Boston, MA

Responsibilities:

• Analyzed their existing work flow and gathered requirements.
• Installed and configured Vertica on their 3 node cluster environment.
• Analyzed their SQL Server cubes and picked an analysis to do the POC.
• Performed data profiling on their application data.
• Created data model in Vertica database by defining objects like tables by mapping the Vertica supporting data types.
• Implemented the workflow in Vertica.
• Performed the data migration from SQL Server to Vertica manually with Microsoft Excel.
• Ran the Database Designer to improve the data load.
• Analyzed the queries to run performance tests in Vertica.
• Performed Performance tuning to handle the high cost queries and did query optimization.
• Ran the Database Designer to improve both load and query in Vertica.
• Written shell scripts to perform testing to simulate multi users.

Confidential, Palo Alto, CA

Responsibilities:

• Configured and Installed Vertica on their environment
• Created data model in Vertica database by defining objects like tables by mapping the Vertica supporting data types.
• Testing the data model with sample data. Fix in case of any issues and finalize the data model built
• Work with Informatica team and make sure the data mapping has been done between SQL server and Vertica database
• Performing loading of data using Informatica from SQL server to Vertica. Worked with Informatica team to load the data
• Health Checks and Performance tuning for the data loaded and develop the query specific projections if required
• Development and deployment of query specific projections depending on customer requirement
• Testing of the developed solution across the multi node Vertica cluster

Confidential

Responsibilities:

• Understanding the customer environment to setup the multi node Vertica cluster.
• Understanding of the customer requirement on the Vertica cluster like number of users, recovery plan, backup and restore plan
• Installation and configuration of multi node Vertica cluster. Setting up of the backup and disaster recovery strategy for the Vertica cluster.
• Monitoring of the Vertica cluster in their environment and providing the support in case if cluster has to be backed up or restored
• Analysing the default resource pools and setting up or managing the resource pools parameters based on the environment
• Monitoring the Vertica cluster and network in the real time environment when it is being accessed by multiple users.
• Managing the Vertica database cluster by making sure the projections has been defined properly and database is consistent across the nodes

Confidential

Responsibilities:

• Installed Optim 9.1 and configured the development and test environments.
• Performing customizations to the PeopleSoft Application based on the customers’ requests.
• Analyzed the tables and their relationships of PeopleSoft 9.1.
• Analyzed the customization implemented on the application to add the tables to the templates.
• Developed Archive requests and Restore requests necessary for the data archiving and restoring into target and production databases.
• Migrated the development to their testing and then to Production.
• Performed Knowledge transfer.
• Created documentation on Installation, Configuration and Issues faced during the implementation.

Confidential, Houston, Texas

Responsibilities:

• Analyze the tables and their relationships of the Data Warehousing application.
• Identify the relationships which have to be created to complete a meaningful business object.
• Analyze the Confidential environment for the installation and configuration of Optim.
• Identify the selection criteria for the tables.
• Develop Access definitions, Archive requests and necessary definitions to complete the development.
• Perform unit testing on the Optim Development.
• Perform Performance testing on the Optim Requests.
• Migrated the development to their testing and then to Production.
• Created documentation on Installation, Configuration and Issues faced during the implementation.
• Performed Knowledge transfer to the Confidential resources.

Confidential, Princeton, New Jersey

Responsibilities:

• Analysis of functionality of the PeopleSoft Financials 9.1 Inventory & Order Management.
• Identifying the functional test case scenarios for the PeopleSoft Financials modules.
• Development of Access Definition (AD), Archive request, Delete request, Restore Request, Table map for the PeopleSoft Financials 9.1 Inventory & Order Management.
• Once the development process is completed, unit testing and functional testing for the PeopleSoft Financials modules specified.
• Preparing the functional, technical, unit test case documents for the PeopleSoft Financials modules specified.
• NAA level testing for the PeopleSoft Financials modules Inventory & Order Management (9.1)

Confidential, Princeton, New Jersey

Responsibilities:

• Creating the Analysis document identifying the core tables in Contracts module to be archived.
• Functional Specification and Archive table list.
• Creating Access Definition diagram to enable the technical team to develop the build.
• Identifying the processes in Contracts Module.
• Test data creation for Amount based and Rate based contracts.
• Performing Oracle Validation test plans, system test plans and Functional test plans.
• Data creation steps for the technical team.
• Performing the Functional and System testing.
• Performing the Archival and Restore after the build in QA environment.

Confidential, Sunnyvale, California

Responsibilities:

• Analysis, Estimation, Design, Development, Testing, Implementation of data masking & Archive solutions.
• Interact with application SME's to understand data model and business objects for reporting requirements.
• Analysis of functionality of the Peoplesoft Financials 9.0 Inventory & Order Management.
• Identifying the functional test case scenarios for the PeopleSoft Financials modules.
• Application tables archiving using third party tools like Optim to improve performance
• Setup Transparent access between queries to archive to view all data through PIA browser.
• Created Optim directories, dbalias and install database clients used by Optim.
• Created Optim access definitions, table mappings and columns mappings and apply transformation functions.
• Configured Optim Archive / TDM environment in both windows and UNIX environment.

Confidential, Pleasanton, California

PeopleSoft FSCM Functional Tester /Business Analyst

Responsibilities:

• SCAL Pharmacy Deployment and Testing: (Worked on Project called OneLink)
• Worked with the Deployment team on supporting the OneLink Pharmacy users.
• Supported the users with Ordering, Receiving through OneLink.
• Worked with the Users in supporting them with Par Maintenance, KP MassPar Update and OneLink customizations.
• Worked with the Users in supporting them with Hand Held Device's for Ordering and receiving.
• Troubleshooted Deployment issues with the Production support team.
• Worked on supporting the users with the Crystal Reports for OneLink.
• Worked on improving the Job Aids for Pharmacies.
• Worked on Security related issues with OneLink Support.
• Worked with the deployment team by participating in Daily Team Huddle in which day to day Pharmacy issues are discussed for better solutions.
• Created and executed System Integration & Regression test scripts based onthe business requirements.
• Manually performed Ad-Hoc testing, end-to-end testing, System Testing, Regression Testing, Smoke Testing and Functional Testing.
• Optimized QTP scripts for Regression testing of the application with various data sources and data types.
• Mapped the custom objects to the standard objects where necessary, and inserted GUI, Bitmap and Text checkpoints where needed, to compare the current behavior of the application being tested to its behavior in the earlier version using Quick Test Pro (QTP).
• Worked on Production Support SRs for Accounts Payables, General Ledger, Inventory, Purchasing and EPM(BRPT).
• Tested Various Materials Inventory & Purchasing SRs as part of Production Support.
• Tested Various BRPT Reports like Pharmacy Reports, AP Reports, GL Dashboards
• Worked on Treasury wave 1 and wave 2 project as well as Production support work.
• Worked Treasury users during system Integration testing and Regression testing.