SUMMARY

• About 15 years of experience with all phases of Software Development Life Cycle (SDLC) and development, enhancement and maintenance of complex OLTP, Data warehouse and multi - tier database driven web based projects.
• Experienced relational/dimensional Data Modeller, designer using Erwin, Oracle technology
• Hard core Oracle SQL, PL/SQL, Performance Tuning, UNIX shell script, SAS professional
• Deep knowledge in data integration, data migration and warehousing concept and practices
• Strong ETL experience in both dimensional and relational modeling concepts like star-schema modeling, snow flaking in Enterprise level environments
• Good experience in both dimensional and relational modeling concepts like star-schema modeling, snow flaking, ER modeling at conceptual, logical and physical levels
• Excellent understanding of dimensional modeling concepts and relational database concept normalization, de-normalization, ETL process and moving of data from source to target
• Good Understanding of different change data capture approaches and implementations
• Created and managed Oracle objects including tables, indexes, stored procedures, table spaces, views, users, roles, partitioning and materialized views.
• Extensive knowledge of programming Oracle SQL and PL/SQL, SAS and UNIX Shell Scripts.
• In-depth knowledge of PL/SQL and SAS programming, data processing, data collection, quantitative and qualitative data analysis
• Proficient to implement business rules using Oracle 11g/10g database PL/SQL packages, stored procedures, functions, database triggers, indexing, query handling and reports.
• Excellent coding, troubleshooting and complex problem solving skills in advance SQL and PL/SQL, SAS, SQL Loader, UNIX Shell Scripting and programming JAVA, J2EE, JSP, JDBC.
• Expertise in performance tuning and SQL optimization using TKPROF, Explain Plan, Hints, DBMS PROFILER, restructuring query, materialized views, table partitioning and indexing.
• Exposure to AWR/ADDM, SQL access/ tuning advisors, DBMS ADVISOR, DBMS SQLTUNE
• Strong experience with Oracle Architecture, space management, physical data organization, memory structures and monitoring tools and techniques.
• Experience in database design, data analysis, development, purging and data conversions.
• Strong experience in BASEL-II US rules for bank's regulatory capital requirement and Risk foundation data mart and Moody’s RWA Calculator.
• Strong ability to translate business reporting specifications into complex matrix and interactive graphic reports with drill-down to detail reports on web front presentation layer.
• Prepared documentation and user manuals and involved in validation and UAT
• Demonstrated ability to respond to changing priorities, multiple tasks and demands within short timeframes and excellent client communication skills.
• Team player, capable of working without supervision and effective communicator.

TECHNICAL SKILLS

Platforms: HP-UX, IBM/AIX RISC System/6000, SunOS cbmccus413p 5.10, Windows NT

Databases: Oracle 11g/ 10g/ 9i / 8i, SAS 9.2

Languages: SQL, PL/SQL, Unix Shell script, XML, C, C++, Pro*C, Java, Servlets, JSP

IDE / Tools: Oracle Developer Suite 10g, Oracle Forms/Reports 10g/9i, SAS EG 7.1, TidalErwin Data Modeller 7.3, Oracle Enterprise Manager, SQL*Loader, Export/Import, TOAD, SQL Developer, Informatica Power center 7.1, PVCS, Visual Source Safe, Clearcase, Business Object XI

App Server: Weblogic App server, Oracle Application Server

PROFESSIONAL EXPERIENCE

Confidential

Sr.Application Developer/Data Modeler

Responsibilities:

• Created logical and physical data model to build Data Management and Decision Support DMDS data warehouse.
• Worked with the Application Development team to implement data strategies and build data flowsfrom disparate sources like Mainframe, SAS Data set, Spreadsheet, Flat files to target data warehouse
• Created or updated conceptual, logical and physical data models using best practices and according to bank standards
• Recommend opportunities for reuse of data models where appropriate
• Generated DDL scripts and implement them in the database
• Analyzed business requirements, gathered from various sources like business documents, discussion with functional teams, BSAs and business teams.
• Perform reverse engineering of physical data models from databases and SQL scripts
• Evaluated data models and physical databases for variances and discrepancies
• Perform data model reviews with Data Modeling counterparts and BI team members
• Implemented PL/SQL and Unix Shell scripts in high volume Production database.
• Automated these processes using AutoSys job scheduler.
• Created Technical documentation to outline and communicate solutions
• Produced detailed ETL data mapping and data profilingdesign documents.
• Created control files to load spreadsheet and flat files into Oracle database and automated using Unix shell scripts and Autosys for daily, weekly and monthly load.
• Designed and developed ETL processes using SQL Loader, SQL, PL/SQL stored procedures, functions and packages to extract data and transform loaded data.
• Wrote multiple adhoc queries to produce data set / reports for the business users.
• Improved performance by identifying resource intensive queries using Auto Trace, TKPROF, Explain plan and tuned them using Oracle Hints, MV and restructuring queries.
• Tuned PL/SQL packages, stored procedures and complex SQL queries using DBMS PROFILER to provide optimum solutions.
• Created stored procedures for data cleansing, quality checks, validation and transformation
• Participated in architectural, analysis and design discussions and team meeting.

Environment: Oracle 10g, PL/SQL, SAS 9.2, SAS EG 7.1, SQL Loader, Unix Shell scriptErwin 7.3, SunOS cbmccus413p 5.10, TOAD, Clearcase

Confidential, VA

Application Data Modeler

Responsibilities:

• Worked as part of a dynamic team throughout the software development life cyclein design, build, development and maintenance of Moody’s Risk Foundation Data Mart.
• Analyzed ETL business requirements, gathered from various sources like business documents, discussion with functional teams, BSAs and Moody’s professionals.
• Created logical and physical staging data model to build Moody’s Risk Foundation Datamart
• Generated DDL scripts and implement them in the Oracle database
• Designed process and wrote functional specification to transform staging data into RFDM.
• Developed PL/SQL stored procedures and code from scratch as well as enhanced existing code for better performance.
• Worked with predictive stress scenarios like Moody’s CCAR (Comprehensive Capital Analysis and Review) as Federal Reserve’s requirements.
• Performed data model reviews with Data Modeling counterparts and BI team members
• Presented design solutions to design review forum for the management approval.
• Identified resource intensive queries using DBMS PROFILER, Explain plan and tuned them using Oracle Hints, materialized views and restructuring the queries.
• Coordinated, reviewed and mentored with Offshore development team of 12 members for programming systems, including coding, testing and debugging for a large-scale system.
• Created multiple extracts using SAS Dataset for OBIEE reporting tool.
• Automated using Unix shell scripts for daily and monthly load.
• Collaborate with multiple team, project manager to implement RFDM in Agile environment
• Maintained records to document design, program development and revisions

Environment: Oracle 11g, ERWIN 7.3, SAS 9.2, PL/SQL, SQL Loader, Unix Shell script, TOAD

Confidential

Sr. Application Consultant

Responsibilities:

• Involved in ETL development and maintenance of Tufts Enterprise data Warehouse
• Designed and developed members, member response dimensions and fact less fact tables
• Produced ETL detailed design documentation and test cases for requested changes
• Created database triggers and stored procedures to populate CDC and Version files
• Created PL/SQL stored procedures from scratch for data transformation and validation
• Design and develop SQL Loader control file to load disparate source data into staging tables
• Wrote UNIX shell scripts to run these jobs and schedule them into Tidal for the automation.
• Modified PL/SQL packages, stored procedures and complex SQL queries as per CR
• Maintained and enhanced existing PL/SQL scripts and code.
• Improved performance by identifying resource intensive queries using AWR, TKPROF, Explain plan and tuned them by using Oracle Hints, adding indexes, materialized views and restructuring the queries.
• Presented design solutions to design review forum for the client approval.
• Peer reviewed technical design documents and code changes.

Environment: Oracle 11g, PL/SQL, SAS EG 7.1, Unix Shell script, TOAD, MS Visio, WinCVS

Confidential

Application Modeler/Developer

Responsibilities:

• Analyzed business requirements, gathered from various sources like business documents, discussion with functional teams, business analysts, smart management experts and end users reporting on the database.
• Created conceptual, logical and physical data model to develop branch compliance extract.
• Designed and developed multiple extracts and compliance reports for the management team and branches and automated using Unix shell scripting and cron job.
• Heavily involved in coding scripts and stored procedure to generate multiple extracts for management team and user groups from the head office and branches.
• Created control files and Unix shell scripts to automate loading and processing.
• Identified and tuned multiple poor performing SQL queries and PL/SQL stored procedures
• Cloned multiple RPM objects and tailored to match with BMO specific requirements.
• Worked with a team of 4 members analyzed, designed, developed and advised work.
• Worked with product managers to give work estimates and advised on design, test cases and job scheduling.
• Troubleshot, fixed, and implemented bug fixes and enhancements within the tight deadline
• Created and managed database objects and users with roles and privileges

Environment: Oracle10g. RPM SSUI and Open Admin 9.44, PL/SQL Stored Procedures Erwin Studio, DB Triggers, MS Visio, SQL Loader, Unix Shell script, CRON, TOAD, PVCS

Confidential, Portland, OR

Sr. PL/SQL Developer

Responsibilities:

• Created logical and physical modeling and data flow diagram for warehouse management.
• Developed and implemented complex PL/SQL packages, stored procedures. functions, SQL loader CTL and UNIX Shell scripts to implement complex logistic business rules for extract, transform and loading warehouse and shipment management data warehouse / data mart.
• Optimized packages and stored procedures using advance PL/SQL such as collections, ref. cursors, dynamic SQL, analytical functions and table functions.
• Created API, package, stored procedure and functions to extract, validate, transform and load data from the staging table to warehouse and data mart target tables.
• Created database objects including tables, indexes, views, triggers, materialized views.
• Tuned application performance by identifying and restructuring poor performing queries using appropriate hints, indexing techniques, materialized views and table partitioning.
• Automated SMS database purge processing using PL/SQL, UNIX shell scripts and Cron jobs
• Developed interface for critical data processing to populate inbound and outbound data using PL/SQL stored procedures and Shell script.
• Created summarized (multiple levels) and detail data export in standard (CSV) and formatted (HTML) format for end users and management users for the further analysis.
• Directly worked with end users to collect their reporting and data extraction requirement analyzed and documented business functionality and created prototype for complex reports
• Troubleshot, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Mentored junior programmers in Oracle database design and development.
• Prepared documentation and user manual, trained users and involved in validation and UAT

Environment: Oracle10g DS, PL/SQL Packages, Procedures, Functions, SQL Loader, Business object XI, Pro*C, UNIX Shell script, Erwin, Materialized view, MS Visio, SQL Navigator, PVCS

Confidential, Summit, NJ

Oracle Developer

Responsibilities:

• Collected requirements from the BA and converted into technical specification.
• Wrote PL/SQL packages to calculate missing information, medical history, prescription details and determining eligibility in the processing of a risk management application.
• Developed stored procedures and triggers using ref cursors, collections, objects, Native Dynamic SQL, bulk binds and bulk collects
• Developed and deployed summarized and detail interactive reports for risk management and order processing system using Oracle10g Reports in text, Excel and PDF format
• Created and customized analytical reports for existing system using Reports 10g.
• Designed, Developed and deployed interactive multi-tab, multi-stack, master-detail forms for Order processing and sales system using Oracle Forms, Reports and PL/SQL.
• Created PL/SQL library - PLL, Object library and PL/SQL procedures and packages to manage better functionality across the reporting applications.
• Analyzed and re-wrote PL/SQL packages and procedures which included hints to force execution plans to utilize the cost based optimization for order processing system.
• Designed and created an interface between order processing and accounting application.
• Improved performance of Database using appropriate hints, rewrite poor performing queries and optimized package using materialized view, partitioning and indexing technique
• Created Materialized view with partitioning for better queries and report performance.
• Developed logical and physical data model for Confidential Reporting system and created database objects including tables, indexes, views, triggers and materialized views.
• Supported in trouble shooting production database application and reporting problems.
• Prepared documentation, user manuals, trained users and involved in validation and UAT

Environment: Oracle8i, Oracle Forms and Reports, PL/SQL Packages, Procedures, Functions, Database Triggers, Pro*C, Ref Cursor, Objects, TOAD, Tkprof, Auto Trace.