--------------------------------------------------------------------------------------------------------------------------------------------

SUMMARY

• 10 years of experience in Application Design, Development and Production Support in client server , data warehousing
• Over 4 years of Data Warehousing experience using PL/SQL, SQL Loader, Ab Initio, Data Stage, UNIX, Oracle and SQL Server.
• Over 2 years of Business intelligence experience using PL/SQL, Brio, Oracle reports, Crystal reports
• Over 3 years worked on client-server application OLTP development using Oracle11g,10 x, 9.x, 8.x
• Hands on expertise with full lifecycle application development of implementing large client/server solutions
• Extensive Experience in writing Stored Procedures, Indexes, Triggers, Functions and Packages in Oracle PL/SQL and also SQL Queries and scripts.
• Well experienced in Oracle data warehousing features such as partitioned Tables, IOT's External Tables, Files, and CDC Tables etc.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling,
• Experience with analyzing and validating the data, Logical and Physical data modeling using ERWIN and excellent understanding of Normalization and De normalization techniques.
• Team management managing teams and being a team player.
• Strong Experience in convert Business Speak into Technical Code.
• Experienced in application fine-tuning database fine-tuning using Explain Plan and analysis tools.
• Strong Skills in PL/SQL Programming to maintain Entity Data Integrity and -Referential Data Integrity by authoring Database Triggers, Stored Procedures and Functions.
• Having deeper understanding of the software development process, and Strong desire for quality.
• Excellent skills in debugging, fixing the issues by applying delivered patches and upgrades and developing additional features for the missing delivered solutions

TECHNICAL SUMMARY

• OS Windows 2000/NT/98/95, MS-DOS, AIX, HP-UNIX
• Databases Oracle 11g,10g/XE/9.x/8.x/7.x, MS Access, SQL Server, FoxPro
• Languages SQL, PL/SQL,T SQL 'C', C ,Java, XML, JSP,UNIX, PERL
• GUI Oracle Forms 6i/4.5, Visual Basic 6.0 ASP.Net
• BI Oracle Reports 10g/6i/2.5, Brio 6.6
• ETL PL/SQL, Ab Initio, Data Stage, AutoSys
• MDM Siperian MDM
• Design Tools Oracle Designer 2000, Erwin
• Version Control PVCS Manager, PVCS Tracker
• Tracking Toll JIRA , Remedy

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle Developer/Analyst

• Wrote package to monitor the production data issues on daily basis
• Wrote Packages and Procedures and functions for new requirements
• Performed root cause analysis and Enhanced code to Fix the issues
• Performed all sort of Design reviews, Code Reviews
• Enhanced ETL procedures and STAR schemas to optimize load
• Gather requirements from Customer, analyze and understand, and assign the work to offshore team.
• Identified data disturbances and send to Source systems owners to modify the Data values
• Analyzed and Modified and Verified code as per System change Requests
• Resolved Remedy Incidents and Provisioned User Associations to Down stream
• Supported 24X5 production support and provided production system documentation.
• Packaged Oracle Objects Using Unix customized Shell Scripts and Deployed code into SIT,UAT Production
• Tuned SQL statements and PL/SQL packages, triggers, functions and procedures
• Wrote package to add new partition when new month begins and send email to Production support people

Environment: Oracle10g, 11g, UNIX, Toad, Remedy

Confidential

Oracle Developer/Analyst

Responsibilities:

• Wrote oracle Package for each Hedge fund subject area Performance, Fee, Leverages, Redemption, Primary category, Focus Strategy, Asset instruments, Regulatory Bodies, Legal Structures etc. to Move data from Source to Target on Daily Basis.
• Wrote and optimized complex queries and database objects
• Generating source to target data mappings, responsible in the establishment of data standards.
• Supported all database issues starting from initial implementation to production deployment
• Preparing Requirements and Design documents and getting signoff from Business Team
• Requirements gathering from various business users and responsible for creating requirement documents
• Analyzed business requirements and translated them into Transformation Logic for ETL development.
• Read Data from CDC tables and compared data with Target Tables for Delta Processing
• Calculate Net Asset Value NAV based on Client Provided ROR values
• Calculate Rate of Return ROR based on Client Provided NAV values

Environment: Oracle10g, 11g, PL/SQL, ASP.NET, UNIX, PL/SQL Developer

Confidential

Siperian Consultant

• Project requirement is to work on Data cleansing and Match and Merge of Customer Master.
• Designed short and long-term master data management strategies for the client, realizing master data management strategies by serving as the overall Solution Architect for this initiative , gathering functional and technical requirements as inputs into the overall solution design, performed fit/gap assessment of MDM for the future state vision, supervising process and functional design activities, supervising application design, build, test, and deploy activities for Siperian MDM project and all integrating applications.
• Responsible for designing the De-duplication Process.
• Designed the Customer Master Data extraction import and field/value mappings, record matching based on keys.
• Record Matching and resolving data conflicts.
• Designed technical reusable components with emphasis on Siperian MDM
• Defined Transformation rules and strategies, De-duplication and Merging records.
• Designed data synchronization between MDM, CRM, EPSILON and IMS data systems.
• Designed data synchronization between MDM and BI systems.
• Handled 14 millions of records to be matched and merged.
• Enhanced the design of the Territory Management Process, Zip to Terr Process and RxCredit Process.

Environment: SAP ECC 6.0, SAP CRM 4.0/2007, Siperian MDM Hub, IMS, Epsilon, HOBART, IntraMED, and SAP BI 7.0, SAP NW EP, Track Wise, BMC Remedy and Incident management.

Confidential

Sr. Oracle Developer

Responsibilities:

• Designed ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Trend DB Using PL/SQL
• Wrote optimized complex stored procedures for crystal front end
• Contributing to the overall analysis, design, and implementation of the data Warehouse and other data structures
• Created Tables , Indexes in Development data base.
• Designed and developed tables, views database packages, stored procedures, functions and triggers
• Successfully implemented session based flashback technology and wrote point in time queries
• Wrote UNIX shell scripts for batch process.
• Involved in Database Daily Backup Using RMAN Utility.
• Wrote SQL loader scripts to load data from fixed length flat to tables
• Supported all database issues starting from initial implementation to production deployment

Environment: Oracle10g, PL/SQL, SQL Loader, Crystal, Windows, UNIX, TOAD

Confidential

ETL Consultant

Responsibilities:

• Designed ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the
• ODS
• Wrote 12 optimized complex Views for each subject area using analytical functions to eliminate join logic in ETL toll
• Production Support by Performing Tests, Tuning, Trouble Shooting and Bug Fixing
• Implemented Physical Design along with DBAs.
• Designed and developed database packages, stored procedures, functions and triggers
• Involved in Performance tuning, database monitoring activities using STATSPACK.
• Involved in DBA activities including: Query Optimization, Performance Tuning, Database creation, Database Maintenance, Management of standby databases
• SQL tuning were done as needed using index, statistics, hints, list/range partitioning, Parallel queries etc.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation
• Using the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Create and generate Complex SQL scripts to query data from tables and database Objects
• Organized data in the report Inserting Grouping Filters, Sorting, Ranking Implemented industry standard best practices, build reusable components
• Collaborated with BAs and users to develop system requirements and accordingly design the database

Environment: Oracle 11g, Oracle 10g / 9i, PL/SQL, SQL Loader, DataStage7.5, Erwin, Windows, UNIX, PERL,TOAD

Confidential

Sr. Oracle Developer /Modeler

Responsibilities:

• Developed and customized PL/SQL packages, procedures, functions and triggers
• Worked with Java developers to repair/ enhance current base of PL/SQL packages to fix production issues, build new functionality and improve processing time through code optimizations and indexes
• Erwin is used to define Logical Model
• Wrote automated test clients for procedures, functions to confirm code works correctly Functionally , and technically
• Modify Models using Erwin
• Tuned SQL statements and PL/SQL packages, triggers, functions and procedures
• Wrote backend procedures and packages for Java front-end
• Wrote automated test clients for procedures, functions to confirm code works correctly Functionally , and technically
• Coordinated with Java team leads for tuning Oracle procedures written in database
• Interacted with BAs in developing/modifying packages or procedures
• Created user defined data types and collections
• Analyzed and Modified and Verified code as per System change Requests

Environment: Oracle 10g, XE, PL/SQL, SQL Server, PVCS, Seibel, JIRA, SQL Loader, Java, JSP, Windows, HP-UX, TOAD, PERL

Confidential

Oracle Developer/ Architect

Responsibilities:

• Involved in development, debugging, deployment and implementation of Oracle for various projects
• Worked with Business and Technology staff to understand, define, and model data structure at the Enterprise level
• Maintain logical models and documentation for interface translations within ER/Studio.
• Requirements gathering from various business users, and responsible for creating requirement documents.
• Prioritized requirements for incremental development and implementation
• Analysis, requirement gathering, documentation, business requirements, functional requirements, development, deploying and testing
• Evaluate business requirements by interacting with cross-functional people and create estimates for database operations.
• Designed and developed reports for the data in the Data Warehouse using Brio Hyperion
• Generated matrix reports for business operations, status and Asset Management reports using Oracle Reports
• Ralph-Kimball approach, Bill-Inmon approach
• Developed PL/SQL procedures, triggers and packages
• Developed star schema data model using suitable dimensions and facts

Environment: Oracle 10g, Oracle 9i, PL/SQL, SQL Loader, SSIS, Reports 10g

BRIO, Erwin, Windows, UNIX, TOAD

Confidential

ETL Developer

• Wrote complex stored procedures, triggers and functions in PL/SQL and optimized for maximum performance
• EDW is a star schema model, Developed Type II SCD in order to track the history and Surrogate
• keys have been created for each dimension table and are linked to the Fact tables based on these
• keys
• Extensively worked with Ab Initio database and data set components
• Designed and developed database packages, stored procedures, functions and triggers
• Wrote and optimized complex queries and database objects
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation
• Wrote UNIX and Perl scripts for Ab Initio pre post session operations and database administration activities
• Involved in administration tasks such as creating tables, indexes, views, synonyms, partition based tables and Indexes
• Worked with DBA's to build Dimension Tables and Fact Tables.
• Supported all database issues starting from initial implementation to production deployment
• Involved with testing team in integration testing

Environment: Oracle 8i/9i, 10g,Sql Server, Ab Initio GDE 1.11/1.13.7, Co-op 2.11/2.13.1, UNIX,PERL, Windows NT/2000.