SUMMARY

• Confidential has over 15years of experience in analysis, design, development, integration, migration and implementation in the Automotive, Banking, Telecom, Healthcare and Online Gaming Domains.
• Has strong Technical Knowledge in PL/SQL development, performance tuning and database administration on multiple databases like Oracle, DB2, MySQL.
• Experienced in database design and data Modeling using Enterprise Architect (Zachman Framework), Oracle Designer, Erwin data modelling tools.
• Has experience in both OLTP and OLAP environments.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact, Dimensions tables, Physical and Logical data modeling.
• Experienced in Data Quality and ETL transformations using SAP Business Objects Data services which includes Name, Address cleansing and Match processing.
• Competencies in UNIX platforms, which includes Shell Scripting, UNIX commands on Linux, Solaris, AIX platforms.
• Knowledge on the latest technologies like BigData, MongoDB and in Neo4j Graph Database.
• Strong knowledge of Application Development Process and Systems Life Cycle Methodologies including planning, analysis, design, development, implementation and production support.
• Similar expertise in Project Life Cycle including Initiation, Business Function Study, Requirement Finalization, Project Scoping, Task Break down, Effort & Time Estimation, Costing & Project Budgeting, Resource Allocation, Scheduling, Risk Management and Execution Control Planning/Monitoring.
• Adept at Team Management skills like tasking, delegation, monitoring, feedback, skill upgrade, competence management, career planning, motivation & mentoring of the team.

TECHNICAL SKILLS

Software, Tools: Oracle Designer, Erwin 3.5.2, Enterprise Architect 10, Zachman Framework

Languages: Toad, PL/SQL Developer, Data Pump, SQL Navigator, RMAN, Oracle Enterprise Manager, SQL*Loader, UtPLSQL, SAP Business Objects Data services (BODS), first logic Postal soft, Appworx, AM8, Cron, UNIX Shell scripting, System Admin utilities

Databases: Oracle8i/9i/10g/11g, DB2 9.5/9.7, MySQL, Sybase 12.5, SQL Server, MS Access, MongoDB

Hardware &SUN Servers: Storage 6130/6140, Solaris 10/9, Linux, AIX, SCO - UNIXOperating Systems MS Windows

Other: Performance Tuning, Benchmarking, SVN, CVS, MS Visual Source Safe 6.0Remedy Force, Share Point, Large Database solutions

PROFESSIONAL EXPERIENCE

Lead Database consultant

Confidential, California

Responsibilities:

• Designed and created ER Diagram for new business requirements in SETUP Application.
• Developed database package for handling bulk clob text replace for Legal script.
• Created procedures, functions and packages for handling downstream systems and automated validation of different systems.
• Gathered business requirements and involved in data migration from one system to system.
• Designed and Implemented Materialized view logs to capture change records.
• Revamped comparison report with new design in data warehouse system and involved in the defining specification for source and target system.
• Implemented Junk dimensions for customer segmentation report.
• Designed and implemented CDS (Conformed dimensions) Schema specific to Confidential . This schema will be used by multiple fact tables for reporting and also data will be sent in CSV/XML for downstream system.
• Led team of database consultants both at Offshore and Onsite.
• Performed performance Benchmarking for snapshot database.
• Mentored Team members on business functionalities, PL/SQL coding and Standards.
• Conducted Code Reviews, suggested standards, unit testing process .
• Co-ordination with QA team for validation and address issues.

Confidential

Data Architect

Responsibilities:

• Implemented Module Driven Approach using Zach man Framework in four pilot projects.
• Created Conceptual, Logical, Physical data Models through Enterprise Architecture.
• Implemented Graph Theory data model in one of the R & D project.
• Analyzed and reviewed data warehouse database and provided recommendations to improve the performance. Designed and implemented dimensional data Modeling, Star Schema modeling, Fact, dimensions tables, physical and logical data modeling.
• Planned migration strategy; analyzed databases to determine the best strategy for migrating data sets to the new databases.
• Conduct system performance diagnosis and tuning, scalability assessment activities and necessary maintenance.
• Performed performance Benchmarking for multiple projects and provided suggestions to improve the performance of database on Oracle and DB2. Applied different improvement methods, which had improved the performance of databases.
• Designed and Implemented Materialized Views to replicate data across databases, which has increased performance of the Search Module.
• Created procedures to export Images (BLOB) from MySQL database and load into SQL Server.
• Conducted SQL Reviews and suggested to improve the performance of the Queries.

Confidential

Data Architect

Responsibilities:

• The primary database contact for database related tasks, including attending all project meetings, representing the project architectural concept and interfacing with the client managers and project team.
• Led the team of offshore Data Architects and Co-ordinate with Onsite DA Manager,
• Implemented Business rules into ER Diagram, physical models through Oracle Designer.
• Build batch jobs in the scheduler, which processes data feeds, cleanse and load into Oracle stage tables.
• Created Data service job, which will cleanse data and also build Match transform to identify duplicate customers in BODS.
• Create, maintain, and document all database objects and in corporate new objects in Oracle Designer. Defined and maintained database object naming convention.
• Developed generic validation package for validating incoming data on Stage.
• Created generic/standard packages, SQL scripts, shell scripts.
• Mentored Team members on Data Services, Design, PL/SQL coding and Standards.
• Effort estimate, Budget tracking, weekly status report, Metrics Collection and PMP for Data Architect Team.
• Created the template jobs in SAP BO data services, so we do not have to write a job for every Appworx chain that calls Data Services to standardize name and address. Created the scripts that call these template jobs from the command prompt so Appworx can call them.
• Integrated Scheduler Appworx with Data services server through SSH script. Data services Jobs are executed from Appworx server through SSH call. Created a common module for execution of data service job from appworx.
• Created standard Chain, UNIX scripts, and control files in appworx Scheduler. Those can be used by any chains, which require data cleansing, and loading output file generated from Data services server into tables.
• Identified USA/CAN address directories for Dataservices4.0 and update in server every month.
• Identified process for rolling jobs from Development to Production through Central Repository.
• Database design for all Oracle new development, enhancements and maintenance.
• Developed and implemented database designs that minimize data redundancy.
• Implemented Business rules through Oracle Design, ER Diagram and Entity model diagram for different applications through Oracle Designer.
• Ensure that database design and names follow Confidential standards.
• Analyze, cleanse, and compile internal and external sources of data before they are loaded into a database. Created different data flows in Appworx for report generation.
• Manage 3rd Party Common data i.e. VIN decoder, NCOA processing, Address libraries.
• Developed common validation package for validating incoming data on Stage.
• Created standard procedure for loading XML files into Oracle tables.
• Preparation of test case document and process of testing on Dev/Test and then roll to production.

Confidential

Database Administrator and Developer

Responsibilities:

• Developed Oracle Packages, procedures for complete business functionality. These packages will be called from PHP for mobile and web channels.
• Created ER Diagram and Entity model diagram through Oracle Designer and generated Db Scripts.
• Created Packages for PHP call, as well as APEX call.
• Generated Email Notification through Oracle Packages.
• Developed packages for payment module.
• Debug, log messages framework are created in oracle packages.
• Responsible for the complete backend development.
• Packages and SQL are created by Oracle Best practices.
• Created databases for development, test and production environment.
• Established backup plan for Oracle Databases.
• Responsible for the installation of Oracle Apps R12 and Apex through mod plsql.

Confidential

Senior Software Engineer

Responsibilities:

• Designed and developed Customized Data Export Packages for Bharti Customer.
• Developed Load Procedures, which will load data from CDR files.
• I created packages for ETL process.
• Developed migrated scripts from CS3.0 to CS4.0 product, using Procedures called by shell scripts.
• Created shell Scripts for enhancements of data backup in Tapes.
• Performed performance Tuning on SQL Queries, DB Environment changes and Memory settings.
• Created Partition Maintenance for product using Packages.
• Responsible for Migration/Upgrade Activities respective of Sybase to Oracle
• Developed Scripts for migrating data from Sybase to Oracle.
• Developed Stored Procedures on Sybase and Oracle.
• Involved in Migration Sybase from 12.5 to Oracle 10.2.0.3 on Solaris platform
• Actively involved in Requirement Analysis for DB Model and Suggested DB Changes Involved in Estimation, Test plan reviews.
• Responsible for Migration/Upgrade activities respective of Oracle and DWS application.
• Created Scripts during Oracle Migration from 10.1.0.4 to 10.2.0.3 on Solaris platform
• Performance benchmarking at SUN Labs.
• Was actively involved in requirement analysis, PC Estimation and Project Plan.
• Performed R&D Lab Setup for Chennai, which includes Sun Solaris Installation, Storage 6130/6140 configuration, Oracle and VERITAS Configuration.
• Created Customer Production Information and Implementation proposal documents for Data Exports.

Confidential

System Analyst

Responsibilities:

• Created the Development set up for Database (DB Scripts).
• Converting the Existing SQL code in PowerBuilder into Oracle Packages.
• Testing the created packages with UTPackage tool.
• Coordinating with Onsite for quality delivery of stored procedures, packages and Database Scripts.
• Performed Database Setup, Responsible for administration of offshore database servers and instances.
• Was actively involved in Requirement analysis, Estimation and Project Plan.
• Performed Migration of Access Queries into Oracle Stored Procedures.
• Wrote optimized SQL and tuned SQL Queries to bring down the process time to meet client expectations.
• Implemented partitioning to allow handling large volumes of data.
• Performance tuning on SQL Queries, DB Environment changes, Physical Structure and Memory settings.
• Performed Database Setup, Performance Benchmarking Responsible for administration of offshore database servers and instances.
• Was actively involved in Requirement analysis and Estimation.
• Performed Database Setup, Integration and Performance Testing Environment.
• I was responsible for administration of offshore database servers and instances.
• Performed Analysis and Table Design for Change Requests.
• Developed Stored Procedures using xmlgen packages for Reports, workflow and letter screens. Performed Impact Analysis and Table Design for Change Requests.
• Actively involved in Requirement Analysis for DB Model and Suggested DB Changes Involved in Estimation, Test plan reviews.
• Performed Oracle Migration from 8i/9i using response file.
• Developed batch files to avoid manual interpretation during installation.
• Responsible Installation of Security Alert Patch on Oracle 9.2.0.5.
• Performed Oracle Client installation using response files.
• Involved in Estimation and SQL optimization to decrease the time taken for Reports.
• I was responsible for optimizing SQLs for time taking reports.

Confidential

IT Officer

Responsibilities:

• The Products set up at Global Level in Flexcube Retail for various banking products.
• Test cases prepared and tested the functionality of the software.
• Prepared document for job card.
• Based upon the Banking products the parameters are entered into the spread sheet as per our requirements.
• Based on the spreadsheet the products will be created in the Flexcube software for a testing purpose.
• Once the products created and all the parameters set then we will do the User Acceptance Test (UAT).
• During this UAT all sorts of Testing will be done once it satisfies all the conditions then that product will be created in the Production Site.
• Creating the Job Card for the end user who is using the products at the branches.
• Installed and configured Oracle8i & AIX4.3, Transaction servers, Terminal servers.
• Wrote script to automate Backup plan and make the database recovery ready in case of downtime.
• Responsible for Import/Export Database, Security Administration, Monitoring Table space usage, Space Optimization, Management in AIX, Maintaining Archived log files.
• Involved in Performance Tuning and Monitoring. Performed User Management and User access in both application and Database.
• Performed Database Migration from Oracle8i to Oracle9i.
• I was responsible for SCO UNIX & database creation.
• Conducted Audit on the different branches.
• Performed administration of Sybase & performing tuning.
• Implemented and troubleshoot the Banking Software.
• Provided technical support to end users.
• Modified Remittance modules and performed rectifications in Report modules as per requirement.