SUMMARY

• Senior Database professional wif 9 years of experience in Oracle and SQL Server Development (PL/SQL & SQL).
• Extensive experience in Bulk and Batch processing in SQL Server and Oracle Databases.
• Extensive experience in development of Stored Procedures, Functions, Packages and Triggers both at the backend and at the Application level.
• Excellent SQL, PL/SQL and T - SQL skills and expertise in using TOAD and SQL Navigator.
• Extensive experience in developing SQL*Loader control programs and PL/SQL.
• Extensive Experience wif SQL Server ETL tools SSIS and DTS.
• Validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle.
• Involved in Logical & Physical Design, Backup, and Restore, Data Integration and DTS (Data Transformation Services) and creating Database Objects.
• Migrated Data from sources to the required target using SQL*Loader.
• Experience in UNIX Shell Scripting.
• Created Global Temporary Tables, Partition Tables and used it in various procedures.
• Involved in Table Partitioning, Optimizer hints and Query optimization.
• Expertise in creating DDL, DML and Transaction queries in SQL.
• Extensive Experience wif Performance Tuning for Oracle RDBMS using Explain Plan and TKPROF along wif Optimizer Hints.
• Expert in creating process models, data models, ER-diagrams, data Flow diagrams using Erwin and Rational Rose.
• Involved in all stages of Software Development Life Cycle including Analysis, Design, Development, Documentation, Testing, Implementation and Support.
• Experience as a Techno Functional Consultant wif prior experience in the capacity of a BA/PM
• Extensive experience wif Capacity planning, Database design, Failover mechanisms
• Experience wif SQL Server Clustering, Virtualization, Load distribution and High availability solutions.
• Extensive experience wif performance tuning in large data warehouse environments wif billions of rows.
• Experience wif Designing and Optimizing underlying SAN architectures, RAID and disk configurations
• Experience wif Disaster recovery, Replication mechanisms.
• Establishing Benchmarks wif changing environments and data needs to better estimate ma hours and resource allocation; Capacity planning, Budget and Resource allocation
• Extensive experience backing up data, Creating database objects, Object permissions and roles
• Experience wif encryption and security mechanisms at the script level and the package level.
• Coordinating and managing cross functional teams ranging from 4 to 7 resources spanning Operations, Support and Development.
• Proven track records of managing cross functional teams distributed across APAC, EMEA and SAR.
• Establishing and managing regionally distributed IPS Teams.
• Vendor Management and Procurement.
• Tracking, Assigning and Resolution of Service Requests and Emergency requests
• Responsible for production rollouts, SOD Coordination, documentation and audit trails.
• Change Management, Problem Management, Service request tracking and reporting.
• Experience wif High Availability Clustering Solutions.
• Extensive experience in Bulk and Batch processing in Oracle and SQL Server Databases.
• Extensive experience wif 3rd party job scheduling agents such as Cntl + M.
• Responsible for Periodic performance analysis and performance tuning engaging both the user community, technical support and the stake holders.
• Extensive experience in development of Stored Procedures, Functions, Packages and Triggers both at the backend and at the Application level.
• Expertise in SQL Server Performance Optimization.
• Extensive Experience wif SQL Server Clustering and Windows Virtualization Environments
• Involved in Logical & Physical Design, Backup, and Restore, Data Integration and DTS (Data Transformation Services) and creating Database Objects.

TECHNICAL SKILLS

Databases: Oracle 8/8i, Oracle 9i, Oracle 10g,Oracle 11i, SQL server 2000, SQL-Server 2005,MS-Access v7.0

Database Utilities: SQL Loader, SQL* PLUS, Toad, SQL Developer, SQL Navigator

Programming Languages: C, C++, Pro*C, Shell scripting

Developer Tools: Developer 2000, Designer 2000/6i, Discoverer 2000, Forms 4.5, Reports 2.5, Graphics 2.5, Forms 6i, Reports 6i, Crystal Reports 8.0

Operating Systems: Windows 98/95, Windows NT/XP, Linux 6.2 / 7.2, UNIX (Solaris 2.x, HP-UX)

ETL tools: Informatica

Applications: MS Office 2000, MS Word, MS Excel, MS Access, MS PowerPoint, MS Project

Tracking Tools: Rational Rose Clear Case/Clear Quest

PROFESSIONAL EXPERIENCE

Confidential

Compliance Project Lead

Environment: Oracle 11i,SQL Server 2012, SQL Server 2008, SSIS, SSRS, Informatica, Micro strategy

Responsibilities:

• Responsible for all Auditing and Reporting Projects of the Compliance Unit for the Credit Division
• Leading the BackOffice Product Development team encompassing SQL Server and Oracle Database and Reporting Personnel.
• Task prioritization, Estimation, Scheduling, Resource planning, Change Management and Release Management.
• Planning and scheduling new CRs and RFCs based on pre-assessment of Development Efforts and available release buckets
• Tracked and reported project actual expenditures as compared to the budget and TEMPeffectively managed the project to successful completion wifin tolerances. Monitored the project direction, ensured the project scope is maintained and ensured appropriate change control procedures were followed, along wif other PMO standards and guidelines.
• Reviewed, analyzed, and evaluated user needs. Gathered and defined requirements, created business and functional requirements documentation (included screen mock ups and data flow diagrams), participated in the technical design, tested planning and user documentation processes, and developed training material for the business. Developed functional design specifications and impact analysis for system enhancements in support of gap analysis.
• Overhaul of the existing reporting architecture by Migrating Oracle Solutions to Micro-Strategy and SQL Server.
• Streamlining and building a framework for SQL Server deployments.
• Responsible for Database Design, Architecture,
• Extensive Database Batch development using PL/SQL, UT PL/SQL frameworks and MS SQL BI tools.

Confidential

Regional Operations lead

Environment: Oracle 9i,Oracle 10g, SQL Navigator 6.1,5.5,TOAD,PL/SQL, Linux, Win 2003, Win 2008, Informatica, Web Methods, SQL Server 2005,SQL Server 2008,SSIS, DTS, VB.Net

Responsibilities:

• Coordinated and facilitated the requirements elicitation sessions wif international business representatives and technical design team members.
• Managed defect tracking and resolution along wif change request identification, documentation, impact assessment, prioritization and implementation.
• Integration Testing and Coordinating UAT between the stakeholders and key Developers.
• Validation of large amounts of data averaging 5 or 6 files each week, spanning several million records sourced from affiliate POS Systems.
• Extensively used PL/SQL and T-SQL in Writing database packages, Stored Procedures and Triggers in Oracle 10g Database and SQL Server 2005
• Involved in Data flow analysis, Data Modeling, Physical database design, design and development, Data conversion, Performance analysis and Tuning
• Supporting the project from feasibility, analysis, development, testing, Implementation.
• Building SQL*Loader scripts and IZ stored procedures to load XML files, Flat files and Excel Files into tables.
• Developed detailed ETL Plan for loading the staging area from the Oracle database and then from Staging area to the Data Mart.
• Migrating the Data from Legacy systems to Oracle Database
• Analyzed the data in the Data Warehouse after the ETL process to ensure if all the data TEMPhas been captured and also to ensure the accuracy of data.
• Involved in database Performance Tuning (cost, index Tuning).
• Solid Experience analyzing functional requirements and data flows and translating them to data models.
• Experience working wif object modelers and other design/Development resources to solve problems.
• Involved in database development by creating PL/SQL Functions, Procedures, Triggers, Materialized Views, Packages, Records and Collections.
• Used Oracle features like Global Temporary tables, External Tables, Analytical functions, and Table functions.

Confidential

Consultant

Environment: Oracle 9i/ 10g, TOAD,PL/SQL, Eclipse 3.2, SQL, PL/SQL, UNIX/ Windows NT

Responsibilities:

• Identified and fixed production data inconsistencies dat heavily affected the inventory and financial reporting wifin the company
• Extensively used of PL/SQL Procedures, Functions, Form Triggers and Packages.
• Used Materialized Views and collections to improve the performances of the jobs.
• Used SQL Loader utility to load data into oracle tables.
• Used SQL LOADER to read the FLAT files from the operating systems.
• Designing reports dat had complex SQL, PL/SQL code and Stored Procedures.
• Creating Batch jobs, daily jobs, one time jobs and queue.
• Performing SQL performance tuning.
• Developed entry screens, Purchase order Entry, Purchase Order Amendment and issue adjustments.
• Used KORN Shell scripts to automate Oracle script execution.
• Involved in successfully upgrade of database from Oracle 9i to 10g.
• Fine Tuned Oracle Applications for the maximum efficiency and fast response using Oracle Hints, Explain plans and Trace sessions wif Cost and Rule based optimization.
• Created Test environment for data staging using SQL & PL/SQL scripts and optimized critical queries to eliminate Full Table scans & reduce Disk me/O.
• Used packages like DBMS JOBS to schedule running of certain stored procedures
• Proficiently developed Functional Requirement Documents, Design documents, Test Cases and project documentation (user guides, standard report instructions, demos).

Confidential

System Consultant

Environment: Oracle 8i/ 9i Database Enterprise Edition, Oracle Discoverer 9i, Oracle 9i Application Server, SQL Navigator

Responsibilities:

• Extensively used PL/SQL in writing database packages, stored procedures and triggers in Oracle 9i database.
• Significant experience wif developing Oracle PL/SQL stored procedures and anonymous blocks for data conversion/Transformation purposes.
• Conversion and transfer of Data between existing databases.
• Writing SQL*Loader scripts for uploading data from several flat files.
• Creation of data staging tables.
• Used KORN Shell scripting and DBMS JOBS package to run several jobs.
• Designed captured updates the module definition using Oracle designer 2000.
• Developed and optimized SQL queries using SQL Navigator and Explain Plan utilities.
• Imposed business rules through a custom developed library of PL/SQL functions and procedures.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 8i.
• Created partitions on the tables to improve the performance.
• Involved in database performance tuning and monitoring.
• Enforced database integrity using Primary keys and foreign keys constraints.
• Assisting other developers for the application performance tuning using TKPROF.
• Worked on the Email notification programs to notify the users of recent load information.
• Developed UNIX scripts to create FTP Jobs

Confidential

Consultant

Responsibilities:

• Imported data from Legacy system to current one using SQL*Loader and validated them using PL/SQL Procedures.
• Design, develop and implement Transformation and Load processes, programs and scripts using structured software development method.
• Create documentation of implemented conversion processes for knowledge sharing and hand-off.
• Reviewing and developing data models and database designs wif development teams; entity-relationship models are used wif relational databases, normalizing, de-normalizing, indexing, and defining views.
• Developed SQL Loader scripts, conversion scripts for the conversion of the data to the custom new Schema.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into application tables from old system
• Provide timely Production Support by quickly analyzing the root cause and by providing alternatives to resolve issues.
• Ensured dat weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
• Identified performance bottlenecks, tuning queries, database tuning, suggesting and implementing alternative approaches like range partitioning of tables, use of global temporary tables.
• Extensively developed Pl/SQL procedures using collections wif bulk binds to insert and update millions of rows into target databases.
• Extracted Data from flat files and various relational databases to Oracle Data warehouse Database.
• Performed various update strategies using Lookup and Update Strategy transformations.
• Creating Stored Procedures to populate sample data and carrying out test load.

Environment: Oracle 9i, Informatica 7.1, PL/SQL, Toad 6.5, Cognos 7, Win 2000.

Confidential

Consultant

Responsibilities:

• Using Erwin to design Fact and Dimension Tables.
• Involved in writing and executing Stored Procedures, Functions, and Packages in PL/SQL.
• Automated the data loading using UNIX shell scripts, SQL*Loader, SQL and PL/SQL.
• Designed and Developed Oracle database tables, views, indexes etc.
• Extensively involved in re-formatting and re-programming the Reports corresponding to the updates on the client requirements.

Environment: Oracle 9i, SQL* Loader, SQL*PLUS, TOAD, Erwin, Sun Solaris, Informatica PowerCenter 6.1