SUMMARY

Database modeler/designer/PLSQL expert with 14+ yearsof IT industry experience with 11+ years of Oracle database modeling/designing/development and 4 years of Technical Project Management and Business Analysis experience in full life cycle of projects from inception to post-implementation.

Extensive international exposure having worked on projects in USA, Brussels, Luxemburg, UK, Singapore, Netherlands, Germany and South Africa.

Professional Summary:

Lead Data Modeler/Analyst/Designer

• Excellent experience in RDBMS such as ORACLE
• Expertise in of Entity Relational Models including conceptual, logical and physical data designs.
• Worked extensively on normalization, de-normalization while addressing issues of data integrity
• Played a primary Data Modeler and Designer role on several projects with proficiency in all phases of systems development life cycle, including requirements analysis, systems design, development, testing, deployment and support.
• Expertise in using Erwin and Oracle Designer Data Modeling tool.
• Exposure to MS SQL Server 2000
• Experience in application and database tuning.
• Experience with Dimensional modeling and Data Warehouse Development Methodology.
• Experience in executing end-to-end data migration projects.
• Extensive experience in design, development and maintenance of Oracle 9i database objects, SQL, broad experience in PL/SQL programming, including effective use of Oracle packages, stored procedures, database triggers and tools like SQL*Plus, Data Factory and TOAD.
• Comprehensive knowledge of data-warehousing and performance enhancing tools in Oracle like SQL Trace, TKPROF, Explain Plan, TRCSESS, different types of optimizer hints, indexes, table partitions and sub-partitions, materialized views, global temporary tables, autonomous transactions and bulk binds.
• Experience with file loading using SQL Loader, file manipulation and emailing capabilities of Oracle using in-built packages.
• Hands-on-experience in implementing ETL Extract, Transform and Load process.

Project Manager/Business Analyst

• Hands-on experience in IT Project management with expertise in organizing, planning, and executing large scale Projects from vision through implementation
• Strong foundation in iterative System Development Life Cycle (SDLC) methodologies, in implementing both Client-Server database applications and web applications
• Expertise in identifying and analyzing the business needs of the end users, documenting functional requirements and building a project plan, that translates the functional requirements into technical tasks, and guides the development through the execution phase of the project.
• Managed all kinds of projects that include end to end development Project and Maintenance Projects.
• Experienced in risk management including risk assessment, prioritization and control throughout the project life cycle.
• Managed, led and mentored large groups of software professionals with variety of experience and skill levels, inspiring them to work together and meet aggressive targets on-time and in-budget.
• Worked closely with QA/QC teams for Process Improvement, issue management, change management, configurations management and release management.
• Good SLA Management skills which have been effectively used in Maintenance Projects.

Other Skills

• Highly energetic, proactive, result oriented professional possessing strong leadership, decision making, problem solving, influencing, negotiation, conflict management, issue management, communications and interpersonal skills.
• Excellent oral and verbal communication along with stakeholder management skills.
• Excellent analytical skills, the ability to integrate information from multiple sources to execute effectively and efficiently in a dynamic environment, and the ability to interact with customers independently, along with the ability to route/escalate decisions/questions to the appropriate owner.

Systems Experience:

Microsoft Operating systems/Applications: MS Windows 2000 (Server), MS Windows 2000 (Workstation), MS Windows 2003 (Server), MS Windows Adv. Server 2000/2003, MS Windows XP

Operating System UNIX: HP-UX, Sun Solaris

Messaging: IBM MQ Series

LDAP: Oracle Internet Directory

Methodologies: SSAD, OOAD

Database Systems: Transact-SQL Programming, ANSI-SQL, Database Sizing, Oracle SQL Loader, Oracle V8.x,Oracle V9.x,Oracle V10.x,Oracle SQL-Programming, Oracle PL/SQL,MS SQL Server, Data Modeling, JDBC, RDBMS Design

Case Tools: Oracle Designer 2000, CA Erwin

Database Development Tools: Oracle Developer 2000 Suite, Data Factory, Toad

Function- and Script-oriented Programming: Visual Basic(Basic), C(Basic), MS Transact-SQL Programming, ESQL, Power Builder 5.0

Database Administration: Database Administration General, Database SW Installation

Data-warehouse: Exposure to Oracle Discoverer and Oracle Warehouse builder, Informatica

Web-based Programming: Exposure to HTML, XML, XSLT, XML Schema, Web Services

Development and Runtime Systems: Bugzilla, MKS Source Integrity

Office - Applications: MS Office, MS FrontPage, MS Outlook, Acrobat, MS Excel Macros, MS Power Point, Designer / Visio

Software Analysis and Design: Function Point Analysis, Rational Rose(Basic)

Version/Configuration Management: MS Visual SourceSafe, MKS, ClearCASE

Middleware & Application Server: ORACLE 9iAS, Tomcat, Jboss, Apache Web server

Confidential,USA Oct 2009 to Till Date
Senior Oracle Database Consultant

• The company needs to campaign to get new customers. For this, they have to identify prospects within the state of TEXAS to whom they can target for new services. The customer data is received from various vendors, address standardized and business rules applied so that campaign can be generated for the business users. The scope of this project is to re-engineer the existing system, the legacy data migration, data mapping, data integration with different vendors and standardization of data.
• Technology used - Oracle 10g, PL/SQL and Unix shell scripting
• Involved in complete life cycle of the project starting from gathering of system requirements, designing, modeling, development, performance tuning, testing and finally user acceptance.

Confidential,USA April 2008 to Sept 2009
Data Designer/Modeler/DBA/Lead Database Developer

• The company has data flowing from diverse systems which have their own sources of data. The main problem is standarization ofthe data forthe company. I was part of this group that was involved in making a central repository of standarization.
• Involved in defining and managing enterprise-widedata semantics
• Involved in transforming inconsistent data into one common product representation
• Troubleshooting performance issues: performance monitoring, fine tuning stored procedures and SQL and application performance optimization.
• Performed data modeling, logical and physical database design based on modeling tools available on the project, and business functions of the system.
• Single Handedly scripted the migration of voluminous data from current production to new re-engineered database
• Involved in fixing data issues between the legacy and the current databases.
• Involved in defining the ETL process flow from the OLTP to the reporting database.
• Involved in data profiling of the legacy and the re-engineered database.

Environment: MS Project, MS-Excel, MS Visio, JCAPS, Oracle 9.x, Oracle 10.x, CA Erwin, Informatica 8.1

Confidential, Sept 1998 to Feb 2008
Lead Data Modeler/ETL Designer/Analyst/ Project Manager

Clients

• European Union - Brussels, Luxembourg
• Department of Labor, South Africa
• Department of Work and Pension, UK
• Medscheme, South Africa
• Office of National Statistics, UK
• Netherland Railways, Holland
• Verkehrsverbund Rhein-Sieg (VRS) - Germany
• Siemens VT27 - Switzerland

Lead Data Modeler/Designer/Analyst

• Contributed to the overall software development lifecycle including requirements gathering/analysis, design, information modeling techniques and methodologies, development technologies, release/version control, testing, and deployment.
• Developed the Enterprise Data Model for Department of Labor and extending it through all of its projects as needed
• Developed and communicated naming standards for logical and physical data models
• Performed data modeling, logical and physical database design based on modeling tools available on the project, and business functions of the system.
• Utilized several different industry standard case tools such as Oracle Designer and Erwin.
• Involved in database design for both online transaction 3rd normal form and dimensional models, Data Warehousing, Data Migration, Data Staging, Applications Design and Business Process Re-engineering.
• Assisted in source to target mapping
• Used function based indexes to implement selective uniqueness.
• Used Normalization as well as De-normalization techniques to process the records depending on the data record structure of the source and target tables.
• Implemented Oracle table partitions and sub-partitions, materialized views, global temporary tables, autonomous transactions and bulk binds in various projects of DOL, South Africa.
• Performed Reverse Engineering of the legacy application using DDL scripts in Oracle Designer
• Maintained versions of Oracle Designer objects by using Oracle Software Configuration Manager (SCM)
• Troubleshooting performance issues: performance monitoring, fine tuning stored procedures and SQL and application performance optimization.
• Performed tuning and optimization on SQL queries using SQL_TRACE, Analyze, Explain Plan, TKPROF, runstats, TRCSESS utility and optimizer hints.
• Implemented both pessimistic and optimistic locking in the application.
• Developed ETL type processes using bulk processing
• Development of backend and front end components using Pro*C, Oracle Developer Suite, Oracle Portal, Oracle Internet Directory
• Designed and developed complex interfaces with external systems using Oracle PL/SQL
• Conceptualized, designed and developed a generic customizer module - a tool with which all the controls and values to be displayed on the screen were are defined inside the database outside the scope of the program.
• Conceptualized, designed and assisted in development of a tool - eIntegrator. This tool is a Java application that uses XML to convert flat files from one format to another.
• Developed Oracle external procedures that called routines written in C language to carry out file operations like copy, purge and rename a file.
• Designed and developed various backend components, which were executed on the client using ADO
• Designed and developed the complex back end claim processing module using Oracle PL/SQL advanced features like table functions, ref cursors, bulk processing, packages etc.
• Prepared test plans and test data and performed unit testing as well as integration testing of the system with full load

Environment: Oracle Database - 8.x/9.x/10.x, Oracle Designer, CA Erwin, Case Studio 2, Quest Toad, Quest Data Factory, Oracle 9i Developer Suite, Oracle 9iAs, Oracle Internet Directory, Oracle Portal

Data warehouse/ETL Designer

• Participating in the development of Data Warehouse, star schema dimensional models.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Conducted Design discussions and meetings to come out with the appropriate Data Mart
• Developed detailed ETL Plan for loading the staging area from the Oracle database and then from Staging area to the Data Mart.
• Participated in developing and implementing Data Staging/ETL strategies to migrate data from legacy data stores. Such strategies included the analysis and documentation of data quality issues and the development of extraction and transformation techniques.
• ETL plan included populating the dimension and fact tables, sequencing the loads to maintain referential integrity and data cleansing.
• As an ETL Architect, designed the ETL process for data validation, transformation and data flow into the data warehouse
• Prepared the technical design document for the complete ETL process and provided the same to the development team to work on.
• Identified and included the reusable components in the ETL design and devised the standards and naming conventions
• Created and used Stored Procedures in the mappings for dropping and re-creating indexes on the target tables while inserting records and for truncating staging tables.
• Analyzed the data in the data warehouse after the ETL process to ensure if all the data has been captured and also to ensure the accuracy of data
• Involved in implementing the ETL process using PL/SQL and participated in discussions on the data requirements for business
• Used oracle analytical functions to compute running totals, cumulative totals, TOP N queries.

Environment: Oracle Database - 9.x, Oracle Designer, CA Erwin, Oracle Warehouse Builder and Oracle

Project Manager

• Managed/Lead a team spanning from 4 to 20 people, placed both offshore and onsite.
• Estimating projects using Function point or Use Case estimation models
• Creating the Project Plan in MS Project and tracking the project till its closure
• Resource planning after scope finalization after consultation with the stake holders
• Active management of Onsite-offshore communications
• Served as a liaison between the business users and the technical team
• Monitoring and reporting the performance of the project
• Tracking and controlling the project activities against the established project metrics to make sure all the project activities are in synch with the plan.
• Interacting and managing communications with the Business owners, Team members and other stakeholders of the project.
• Calculating the Risk in the project and planning mitigation strategies.
• SLA Management in the maintenance projects.
• Scope Management for the project dealing with change requests.
• Providing Quality Assurance to the Business users by closely working with the testing team during the QA process.
• Management of development and support activities in parallel by effective resource allocation.
• Configuration Management of the various releases of the code using Rational Clear case.

Environment: MS Project, Rational Clear case, MS-Excel, MS Visio, J2EE, Oracle, SQL Server, Weblogic, Oracle 9iAS, JBoss, Apache, Microsoft Visual Source Safe

Technical Lead and Business Analyst

• Assisted the project manager in project scheduling, tracking and risk analysis.
• Understanding the current business process by meeting the SME\'s to determine user requirements
• Prepared and analyzed AS IS and TO BE scenarios and performed Gap analysis
• Identified Use cases from the requirements and assisted the team in writing Use Case Specifications
• Prepared the detailed Software Requirements Specifications
• Participated in conducting proof of concepts for the customers
• Created different Traceability views to maintain the Traceability of the requirements.
• Prioritizing requirements, specifying timelines, reporting and interacting with clients and end users.
• Demonstrated and explained buqsiness requirements/specifications to IT team. Worked closely with developers for translating business requirements into design artifacts/documents.
• Held regular meetings with the system architects, developers, database developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.
• Participated in meetings with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Developed test scenarios and implemented test plan. Tested the application and reported the bugs to the development team.

Environment: J2EE, Oracle, Websphere MQSI, Websphere MQ, UML, Rational Rose, Win NT

Confidential, Nov'1995 to Sept 1998
Oracle Data Modeler and Lead Oracle Programmer

Clients

• Sony System Design International (SSDI) - Singapore
• Ministry of Defense-Singapore

Responsibilities

• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, tablespaces, triggers, db links and privileges.
• As a Data Modeler, worked closely with the Business Analysts in gathering the requirements, applied Entity-Relationship modeling technique and prepared the Logical Data Model (LDM) and Physical Data Model (PDM) using Erwin and Power Designer
• Work with Data Analysts to understand Source Entity names, Descriptions, Primary and Foreign Keys, Source data navigation rules, Implicit / Explicit Data Hierarchies, Source Attribute names, descriptions, Null indicators, valid values, data granularity, and formatting.
• Performed Reverse Engineering of the legacy application using DDL scripts in Erwin
• Participate in data and process optimizations, provide DDL and Database Alter Statements
• Designed and Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, triggers, C, Pro*C, K-Shell scripts
• Developed screens and reports using Oracle Forms/Reports 6i/9i. Also developed reports using Pro*C and PL/SQL
• Utilized SQL*Loader to load flat files database tables.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan, TKPROF utility and optimizer hints.
• Normalized the new tables to 3 NF, standardized the table and column names as per the ORGANISATIONS standards.
• Involved in the implementation of the physical model on the database, designing the tables, enforce the referential integrity constraints among the tables, design triggers and write SQL stored procedures
• Creating databases, tables, views & schemas,
• Performance tuning of the database, which includes indexes, and optimizing SQL statements
• Maintaining, data repositories and data naming standards. This entailed identifying and documenting, business functions, activities and processes, data attribute and table meta-data, and general and detail design specifications.
• Developed reports both in on line mode which are triggered by user request on the front end PC client using the GUI tool (PowerBuilder ) and in batch mode by scheduled batch jobs (using Pro*C).
• Part of Technical Support Team for Backend Pro*C and developed Pro*C templates, Standards and Guidelines for assisting the development process
• As a lead programmer, reviewed the PL/SQL code written by other members to assure that it was modular, object-oriented and efficient and followed programming standards.
• Instrumented the code using dbms_application_info and debug utilities.

Environment: Pro*C, Oracle 7.1 on HP-UX, Power Builder 4.0, Visual Basic, Oracle Developer 2000, UNIX shell Scripting

Confidential, Oct'1993 - Oct'1995
Oracle Programmer
Responsibilities

• Gathered and analyzed the requirement specifications provided by the clients.
• Developed back end interfaces using PL/SQL packages, stored procedures, triggers and Pro*C
• Developed / modified scripts to create tables, views and executed them using SQL Plus
• Ran batch jobs for loading database tables from flat files using SQL Loader
• Developed screens and reports using Oracle Forms/Reports.
• Involved in Unit and Integration Testing.
• Developed modular, object-oriented and efficient code which followed the programming standards set by the project
• Extensively used PL/SQL to implement cursors, triggers & packages.
• Performed performance tuning on SQL Queries using EXPLAIN PLAN to improve the efficiency.
• Involved in development of Marketing Information System, which was primarily responsible for the order fulfillment and billing cycle for the company.
• Involved in development of Payroll System, which fulfilled the requirements of the Human Resources Division like calculation of tax, leave management, payroll calculation and so on.
  

Environment: Pro*C, Oracle 7.1 on HP-UX, Oracle Forms