Jayanta Paul E-mail: acpes7@r.postjobfree.com

Senior Database Engineer Phone: 650-***-****

(Data Modeler and Oracle PL/SQL developer)

Professional Summary

* More than 10 years of experience as a database professional, specializing in the Analysis, Design/Modeling of databases and implementation (Oracle database) and Application Development using PL/SQL technologies.

* Experienced in implementation and support of business components including operations, program management and project execution using information technology in the database domain - both in OLTP and DW systems.

* Executed software projects for various industry verticals – Consumer Products, Transportation, Pharmaceutical, Banking and Telecom – with customers being Heinz, Altria, Enterprise Fleet, Johnson & Johnson etc.

* Experience of working in heterogeneous project/team structure and as Individual Contributor ; Experience with Agile Scrum methodology.

* Highly approachable team-player and motivated with strong commitment to quality.

* Activities in current project/role (database analyst with Google Fiber since July, 2014)

* Working as part of the client's program management and implementation team, focusing on writing PL/SQL scripts for various business processes which include : (1) setup automated data I/O pipeline ; (2) screening of data for adherence to prescribed quality standards ; (3) converting multiple disparate applications that are used by network and field deployment teams of Google Fiber into one unified source ; (4) reporting needs including adhoc production-based summary-detail views and BI reporting using Oracle Analytic functions.

* Working on Salesforce.

* Application development using PL/SQL & support activities – Salient points

* Exposure to overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support

* 8+ years experience in Oracle server side programming using PL/SQL technologies which include SQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialized Views, Temporary tables, Oracle Parallel Queries, Bulk Collects, Bulk Load, Regular Expressions, FORALL, MERGE, Object-Based PL/SQL Programming (TYPE), Oracle AQ and Oracle Advance Security (Oracle Wallet, TDE), Oracle Analytic functions etc

* 1+ years experience in developing client side applications using tools like Oracle Forms 6i, Oracle Reports 6i, Crystal Reports, Microsoft Excel macros

* 4 years experience with ERWin tool in creating Relation database design for OLTP applications and Dimensional Model (Star Schema) and working knowledge of Datastage and OWB (Oracle Warehouse Builder). Experience with Star & Snowflake Schema, Fact, Fact-less fact and Dimension. Implemented Slowly Changing Dimensions in database tables

* 1+ years experience with TWS (Tivoli Workload Scheduler) for managing workflows and jobs in data warehouse environment

* Very strong hands-on experience (on Oracle database platforms) in identifying performance issues, debugging and performance tuning using AWR report, SQL Trace, Explain plan, Indexing, Hints, Partitioning, TKPROF, Profiler

* Executed several projects related to cross-system and cross-platform data migration and database refresh techniques using SQL* Loader, Import/Export (exp/imp), Data Pump (expdp/impdp), Transportable Tablespaces, RMAN and writing ETL Procedures using PL/SQL

* 6 months experience in conversion from MS-SQL to Oracle SQL

* Experience in shell scripting - file/process/memory monitoring, data manipulation & loading, and DBMS cron job

* Strong knowledge of Oracle database architecture and working knowledge of 11g RAC involving the following aspects – regular database monitoring activities, User/Access management, space management, Audit etc

* Implemented Oracle database security (using features like Roles & Profiles, FGAC, Transparent Data Encryption, Database Wallet)

* Experience in writing Functional and Technical design specifications, Test Plan Preparations, Unit Testing, System Integration Testing and documentation of database modules

* Working knowledge of configuration management tools (ClearCase & ClearQuest, VSS) and ticketing tools (Maximo, Remedy)

* Active participation in multi-vendor governance meetings to strategize/solve issues related to production support. Communicated with software vendors about software issues and bugs.

* Experience in on-call and 24*7 support for production systems

Educational Qualification

Master of Computer Applications (MCA)

B.S. (Mathematics major)

Technical Skills

Database systems : Oracle 9i, 10g and 11g

Programming language : SQL, PL/SQL, Shell Scripts

Operating Systems : Oracle Linux 6, Unix, Windows 2008 R2

Tools : Salesforce.com Enterprise Analytics

Primavera P6 EPPM, Tivoli Workload Scheduler (TWS),

ErWin Data Modeller, Oracle Developer 6i, TOAD

Crystal Reports, Business Objects XI

Detailed description of Projects Activities

Database Consultant

July, 2014 - present

Google Fiber

Oracle Database

* Setup data IO pipeline and translate ORACLE procedures for spreadsheets data in existing / historical fiber market data

* Developed QC framework - Wrote scripts to do quality check and enforce data standards on staging data and co-ordinating the effort in getting the same corrected by the suppliers of the data

* Worked with spatial objects ; Writing QA and Data load scripts

* Designed and Implemented a bulk data load framework for external vendors to load engineering+layout and address data into Google Fiber staging database

* Wrote scripts for generating layout spreadsheets used by the field technicians for connecting the network hub with the home

* Wrote scripts to load, clean, assess, verify and report on addresses bought from external sources

* Designed and developed in-house MIS scripts

* Working on modifying the data model to suit changing business needs for different markets across the nation.

* Writing scripts for custom BI reporting using Oracle’s analytic functions.

Salesforce.com

* Creating and enhancing the org structure in Salesforce.com

* Designing the Analytics Infrastructure – Reports & Dashboards – and developing a deployment and clean-up strategy for the reports.

* Designed the Executive/Sales Manager and Sales Person Dashboard with Pipeline Analysis Reports, Top 10 Deal reports, Deals by market report, Closed Business report, Deals/Wins by size and by sales person report, Lead Analysis report (campaign and lead conversion), Opportunity Snapshot etc

* Worked with all types of reports – Tabular, Matrix, Joined, Aggregate – and chart objects

* Created Web-to-Lead and Web-to-Case forms

* User administration and access management

Data Architect, Primavera P6

Nov, 2012 - July, 2014

Oracle

Data Analyst

* Collaborated on multiple projects with different business units at different stages of project life-cycle : Requirement Analysis, Development of Logical Model and Implementation of the Physical model, Developing modules for loading data (ETL) using PL/SQL scripts, manage different aspects of the database, work on support and enhancement of the application.

* Worked with business to design the Data Model/Database schema for new requirements by integrating the existing system into the new requirements.

* Manage the information architecture for the data warehouse, including all information structures i.e. staging area, data warehouse, data marts, operational data stores

* Implemented Star Schema with slowly changing (Type 1 and 2) dimensions in tables, with particular attention to reporting (Cognos) requirements

* Develop and maintain custom PL/SQL program to Extract, Transform & Load the data sent by the regional offices and Heinz manufacturing facilities daily. These data were related to sales, inventory, marketing planning and HR.

* Worked on enhancement of the dimensional model of the data warehouse with Heinz based on new BI (Cognos) reporting requirements, using Erwin tool.

Oracle DBA (Logical/Development DBA)

* Managing Users through Profiles and Audit/Report database access.

* Performance Tuning.

* Design, execute and support the daily batch jobs using Tivoli Workload Scheduler

* Prepare implementation plan for the Setup and Upgrade of Tivoli Workload Scheduler server

* Daily monitoring of database instances which include checking for fragmentation and monitoring disk spaces in various tablespaces, log files, and the space availability for archiving Files, checking backups etc.

* Rebuilding the indexes

* Analyzing the Database and Schema Tables.

* Monitoring the Database health Checks.

* Monitoring the tablespace

* Creating the Table partitions.

* Install in the application specific data build release patches.

* Taking Data Export and create the environments for new releases.

Data Analyst and DBA

Oct,2009 – Feb,2011

Altria

* Worked with Business Analysts for implementation of new requirements under existing BI framework

* Performed reverse engineering of physical data models from existing code base and physical database structure

* Worked with application teams for data migration

* Implemented Oracle Advance Security (Oracle Wallet)

* Managing Users, Password Security, Roles, Privileges and Resources

* SQL and Instance tuning.

* Daily monitoring of database instances which included space checking for fragmentation and in tablespaces, log files, and the space availability for archiving Files, checking the backups etc.

* Develop, schedule and maintain necessary database and crontab jobs and providing various daily, weekly and monthly reports to the business team

* Maintain the validity of database objects

* Monitoring the Database health Checks.

* Regular maintenance of the alert log files, trace files and listener log files.

* Schedule database backup

* Taking Data Export and create new environments

* Perform database upgrade and patching

* Work with application team on data migration and performance issues

Database Architect & Developer

Feb,2009 – Oct,2009

Enterprise Fleet

* Collaborated with business for requirement analysis, finalizing technical specifications for custom application called EDGE (a fleet-management, inventory tracking, customer management and reporting system).

* Worked on design, development, implementation and support of logical and physical data model for an OLTP application for Enterprise Fleet using ERwin

* Developed the logical data model for EDGE and implemented the physical model in Oracle 10g

* Wrote code (PL/SQL) for implementation of modules for data exchange between the primary application database and the various other external systems (Financial, HR etc), including reporting systems.

Developer

May,2007 – Jan,2009

Johnson & Johnson

* Worked on custom software (GXRS) development. GXRS is a custom enhancement to an IBM tool (WWER) that is a gateway application for managing employee claims and reimbursements across different geographies, replacing multiple systems in vogue across different zones

* Application development using PL/SQL and Oracle Forms.

* Developed custom reports on the GXRS system using Oracle Reports and MS Excel. These reports included reports for SOX compliance and other governmental statutes, custom global MIS reports for the business, helpdesk performance reports and for region-wise financial reporting.

* Transitioned into the DBA team in the support phase where my main activities involved monitoring crontab and database batch jobs, writing PL-SQL program for loading card transaction files sent my American Express, performance tuning.

* Worked on tools like TOAD, Developer 6, PL-SQL, Excel macros

Developer

Sep,2005 – May,2007

ABN AMRO Bank

* Team member for Basel-2 implementation.

* Write technical specifications and develop codes in PL/SQL for the development, deployment and support of DLU (Delivery & Load Unit), which is a custom application for calculating risk-weighted assets per Basel-2 recommendations.

* Perform functional, acceptance and load testing of the DLU module.

* Developed custom financial and data-integrity reports using Oracle Reports 6

Developer

Jan,2004 – Aug,2005

UshaComm

* Team member for convergent billing database and customer care system implementation for a telecom firm

* Coded (in PL/SQL) for the data migration into the new system. The coding effort involved all steps required in the standard best practices in data migration – checking for completeness & consistency, transform metadata as required in the new system, generate parallel invoices to check for correctness, establish a bin for rejected records.

* Design and develop reports for multiple modules – financial, customer care, network traffic etc.

Page of

Contact this candidate