Professional Experience

• More than 12 years of experience in all phases of Software Development Life Cycle (SDLC). Involved in delivering applications, systems analysis, design, and creation of decision support systems (DSS) utilizing DSS tool suites. Integrate and administer applications such that they meet organization requirements defined by business needs, SLAs, and IT governance policies.
• More than 5 years of experience to provide architecture design, which includes logical and physical design of data warehouse, data marts, staging area, etc. Provide technical expertise for data warehousing, OLAP technology, and data management including data extraction, transformation and loading processes (ETL).
• Develop applications, implement, integrate and administer applications such that they meet organization requirements defined by business needs, SLAs, and IT governance policies.
• Experience with various architectural and methodological approaches in BI infrastructure development, including star-schema modeling, ODS development, conceptual and logical modeling, control table data management and rapid-iteration development.
• Certified Oracle/Developer 2000 Programmer from Brain Bench

OPERATING SYSTEMS

Sun Solaris 2.7/2.7, HP-Unix, Windows XP/2000/2003/Advance Server

ORACLE 10g/9i/8i/7.x, DB2, SQL Server 7.0, MS-Access, IDMS

Handling Oracle Installation and Configuration, Migration, Partitioning, Tuning, User/Space management, Backup/recovery techniques, SQL*Net configuration, SQL Loader, Export, Import

OEM (Oracle Enterprise Manager), TOAD, SQL Lab, SQL*Navigator, SQL Developer.

ETL/DATA MODELING/ DATA MIGRATION TOOLS

Informatica, OWB (Oracle Warehouse Builder), Pentaho, ERWIN, VISIO, ER/Studio

GUI TOOLS

Oracle Developer 2000 (4.5 - 9i)

REPORTING TOOLS

Business Objects XI , COGNOS, Crystal Reports, Developer 2000 (Reports),

WEB TECHNOLOGIES

HTML, ASP

WEB SERVERS

IIS, Oracle 9iAS

OTHER SKILLS

Rational Tools, Clear Case, Clear Quest , Autosys

Project Details

Reston, VA

• Provided technical expertise for data warehousing, OLAP technology, data management, data extraction, transformation and loading process (ETL)
• Configured OLAP to employ and perform a multidimensional analysis of business data and provide the capability for complex calculations, trend analysis, and sophisticated data model and allowing for complex analytical and ad-hoc queries with a rapid execution time
• Design and Implement ETL (Extract, Transform and Load) BO Data Integrator / Pentaho handling large amount of data. Creating Reports using Business Objects Web
• Proactively identify opportunities to improve the quality, scalability or usability of data warehouse applications
• Analyzed and determined information needs and elements, data relationships and attributes, data flow and storage requirements, as well as data output and reporting capabilities
• Familiarity with telecommunications based data models and third party databases

Environment: Oracle 10G, SQL-Server, Sybase, Informatica 8.1, Pentaho (Data Integrator/Kettle), Business Object XIR2, ERWIN 7.1, Windows 2003, XP, SQL and PL/SQL.

Laurel, MD

• Create and test backup and recovery processes for all TDS, ODS and Production environments. Test, implement, and integrate DSS reports and make modifications as required and provide data warehouse architecture design, which includes logical and physical design of data warehouse, data marts, staging area, etc.
• Perform tasks relating to data extraction, data scrubbing, data transformation, maintenance of metadata and data dictionaries.
• Define metadata standards for the data warehouse and direct the data warehouse meta data capture and access effort.
• Create logical universes and work with OLAP reporting technologies.
• Work as BI developer and SQL developer to deliver the appropriate BI solutions for the businesses requirements.
• Provide performance analysis & tuning to ensure DSS software is working to enhance the interaction between user applications and the databases.
• Provide technical expertise for data warehousing, OLAP technology, and data management including data extraction, transformation and loading processes (ETL).

Environment: Oracle 10G, Oracle Financials, SQL-Server, IDMS, Business Object XI, Crystal Reports XI-8.5, Informatica 8.1.1, ERWIN 7.1, Linux, Windows 2003, XP, SQL and PL/SQL.

Mclean, VA

• Designed, constructed, modified, integrated, implemented and tested data models and database management systems in OLAP system
• Define technical requirements for the data warehouse and recommend/select data warehouse technologies (e.g., ETL, DBMS, Data Quality, BI)
• Define and direct the information access, delivery effort and implementation of security requirements for the data warehouse.
• Responsible for data modeling and participated in data acquisition and access analysis and design, and archive, recovery, and load strategy design and implementation.
• Published standards and procedures for data analysis and design activities.
• Coordinated with Operational Data Store (ODS) and Corporate Data Warehouse (CDW) data administrators to determine associated changes to the Integrated Data Model.

Environment: AIX, UNIX, Windows 2000, DB2 8, Oracle10G, ERWIN, Clear Case and Clear Quest

New York, NY

• Owns the enterprise logical model, defines standards, drives consolidation of redundant data, enforces the strategic vision through data models and performs data analyst and data modeling roles for highly complex or critical projects
• Performs the data analysis activities to capture data requirements clearly, completely and correctly, and represent them in a formal and visual way through the data models.
• Fine-tuning of SQL queries and views by passing hints and analyzing them using plan_table
• Assist in the ETL development efforts, making sure that the business rules are implemented correctly and clarifying issues as they arise. I often even participate in the testing efforts.
• Needs to drive not only data modeling but also needs to make sure that data integration is based on a common metadata framework and that the integrated data is presented to the business as valid information." Other terms gleaned across responses include "holistic," "future," "politician," "long-term vision," and "enterprise information model."
• Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.

Environment: LINUX, Windows 2003, Windows 2000, Oracle 10G/9i/8i, ERWIN and SQL Navigator, Crystal Reports, OWB (Oracle Warehouse Builder), Oracle, SQL, PL/SQL and TOAD

Salem, OR

• Analyze and document the data received from each county and identified the relevant data and complexities of the data.
• Install, Configure OWB development/QA environments for different state projects on Windows and Install and setup OWB clients on developers desktops
• Extract, transform, and load data (ETL) from heterogeneous state/county systems to new state repository using Oracle Warehouse Builder 9.2/10g, UNIX script, and PL/SQL.
• Develop ETL mappings using OWB 9i/10g by Designing, creating, deploying and execute process flows. Use Runtime audit browser for auditing the maps and processflows
• Document and create internal QA packages by writing complex SQL and PL/SQL sub-programs.

Environment: HP, Windows 2000, Oracle 10G, OWB (Oracle Warehouse Builder), Oracle, SQL , PL/SQL, TOAD and ERWIN

Bangalore, India.
ROLE: Data warehouse Consultant

• Performs the data analysis activities to capture data requirements clearly, completely and correctly, and represent them in a formal and visual way through the data models.
• Responsibilities include project management, developing best practices and repeatable procedures for deploying databases, day-to-day operational activities including break/fix, space management, backup and restore, replication management, performance monitoring and tuning.
• Responsible for extracting data from source systems, transforming the data (i.e. standardizing, cleaning, de duping, etc), and then loading and mapping the data into the corporate data warehouse (CDW).
• Establish database change control and versioning procedures and work with data architects and developers to migrate database changes into test, acceptance, and production environments.
• Responsible for analyzing, solving and creating solutions to very complex performance tuning issues and queries.

Environment: Sun Solaris, HP UNIX, Windows 2000, Oracle 9i/8i, ERWIN, VISIO, Autosys, Timbuktu, Oracle, SQL, PL/SQL, Business Objects v5.1.7 (Designer, Supervisor, Broadcast Agent), Cognosv6.5 (Impromptu, Transformer, power play) & Informatica.

Reliance (APR 03 - JUL 04)

Confidential
Reliance, India

• Duties include database creation, database tuning/reorganization, SQL statement tuning, general troubleshooting, performance monitoring, backup/recovery and security of production database applications to ensure maximum availability and reliability.
• Design and create database schemas, Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements
• Design data modeling with data integration based on a common metadata framework and that the integrated data is presented to the business as valid information for their long term vision and meet the Enterprise Information Model of the company.
• Promoted physical sharing of databases.
• Published data dictionaries that facilitate communication about all corporate business models through the Meta Data Repository.

Environment: Windows 2000, Sun Solaris, UNIX, ERWIN, Oracle 8i/9i, OEM, TOAD, ER/Studio & Crystal Reports.

Confidential
Reliance Energy, India
ROLE: Technical Consultant

• Requirement Gathering, Analyzing and Designing according to the requirements.
• Implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, and other distributed data issues. Maintain and utilize policies and procedures for ensuring the security and integrity of the databases.
• Responsible for optimizing any processes, programs, and functions to improve data quality, data security, and data consistency. Develop data collection and reporting applications using Oracle 8i & 9i.
• Create and update the prescribed and necessary documentation (e.g. release notes, Designer repository) during all phases of the projects for the modules assigned.
• Support all areas of database development including table architecture, database optimization, data import/export, data migration, production updates and rollout onto a live DB, Reporting, SQL development, development of schema and scripts as needed for business application integration and reporting.

Environment: Windows 2000, Solaris, UNIX, ERWIN, Xwindows, Oracle 8i/9i, Developer 2000 (Forms 6i & 9i, Reports), Crystal Reports, Oracle 9iAS, ER/Studio.

Confidential, (MAY 00 - MAR 03)
Rath Tours & Travels, India.
ROLE: Senior Software Engineer

• Research new features and product capabilities and provide guidelines and procedures for use as appropriate. Recommend process improvements and enhancements to policies, standards and procedures.
• Responsible for requirements analysis, design, development, testing, implementation, and documentation of the system design, system configuration and test results.
• Support all areas of database development including table architecture, database optimization, data import/export, data migration, production updates and rollout onto a live DB, Reporting, SQL development, development of schema and scripts as needed for business application integration and reporting.
• Provide architectural design, oversight, direction, and review of all database schemas, stored procedures, scripts and layout of all tables, storage, and optimizations across all product lines, Responsible for coordinating between client and the development team.

Environment: Windows 2000, Oracle 8i, ASP, Flash, ERWIN, Adobe PhotoShop and Developer Forms 6i & 5, Reports), IIS, ER/Studio

Confidential
Mumbai, India
ROLE: Senior Software Engineer

• Migration from SQL Server 7.1 to Oracle 8.
• Altering, modifying and creating tables, tablespaces, indexes and other database objects
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Created Stored Procedures and Functions to call various oracle developer modules.

Environment: Windows NT, Oracle 7.X-8, SQL Server 7.1 & Developer 2000 (Forms 5 & Reports)

Confidential, (AUG 98 - APR 00)
Mumbai
ROLE: Senior Developer

• Create and implement PL/SQL packages, stored procedures, forms, triggers, tables and views. Optimize code performance by analyzing indexes, joins and views.
• Recommend security models in Oracle, Develop Oracle forms.
• Altering, Modifying and Creating tables, tablespaces, rollback segments, partitions, indexes and other database objects, created database triggers for data security.
• Statistical reviews, Integration testing and Acceptance testing, Building Program Units, Standard Libraries, Property Classes, Visual Attributes, tab canvases, Standard toolbar in Forms.
• Create standard Error messages specific to application that made the application more use friendly, Preparing test plans and testing Units based on test plans and perform System Testing, Preparing Implementation Documentation and user support documents

Environment: WinNT, ERWIN, Oracle 8 & Developer (Forms 4.5 & Reports)

Confidential, (AUG 97 - JUL 98)
Dharwad, India
ROLE:Developer

• Designed, Developed, Tested and Maintenance of the Application.
• Solely responsible for implementation of the application.
• Involved in developing logic by writing Stored Procedures and Functions.

Environment: Windows 95, ORACLE 7.3 and Developer (Forms 4.5 & Reports)

• Executive MBA (Master in Business Administration)
• B.S. in Computer-Science