SYNOPSIS:

• Assertive professional with over six years of IT experience, specializing in Data Modeling of Oracle, PL SQL & , Business Intelligence Data Warehousing, excellent people skills, high-caliber analytical, documentation with substantial experience in testing.
• Dimensional Modeling (Data Marts, Facts and Dimensions) in both Star Schema and Snowflake Dimensional modeling using Erwin.
• Expertise in development, care, and maintenance of logical and physical ERWin data models, along with corresponding metadata.
• Experience in developing DDL scripts to create and alter Oracle Objects and upgrades.
• In-depth knowledgeof Software Development Lifecycle (SDLC) and AGILE software development methodologies adhering to best practices and industry standards.
• Experienced in ETL, data transformation, conversion and interface.
• In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, collections, functions, collections, user defined datatype, procedures etc.
• Involved in Performance tuning, database monitoring and Capacity Planning, SQL Tuning using optimization (Analyze, Explain Plan, TKPROF), snapshots, data archiving, Hints, tablePartitioning and Indexes.
• Developed approaches and frameworks for the enhancement of data quality and integrity.

RDBMS: ORACLE 10G/9I, MySQL, DB2, HPX, MS ACCESS
LANGUAGES: PL/SQL, SQL, JAVA,HTML, BOURNE SHELL, K SHELL
DATABASE TOOLS: ERWIN 10, MS VISIO, TOAD, SQL NAVIGATOR,
PL/SQL DEVELOPER, SQL*Plus,
BI TOOLS: CRYSTAL REPORTS XI/10i , BO XI R2/6.1X, COGNOS 7/8.
UCM: SOURCE FORGE, MKS INTEGRITY, CLEARCASE,
CLEARQUEST , DOORS.

Experience:

Confidential,09/08-to date
Sr. Oracle Data Modeler,
INDUS is an IT solutions company to Federal Civilian, Homeland Security, Defense and Intelligence organizations based in Vienna, VA.
The Environmental Protection Agency project objective is to re-engineer the existing Facility Registry Systems (FRS) so as to have Locational Reference Tables (LRT)-Data Warehouse that has real time data. Data updates was to be visible within 24 hours such that business users and public can access the most accurate information/data to make timely and informed decisions.
Achievements.

• Actively involved in colleting, analyzing, reviewing and documenting business requirements from the client (EPA) and created tickets if more reviews are required.
• With architects, assisted in development of current and target LRT data architectures.
• Designed Conceptual Model as an architectural migration target for new LRT ODS model and redesigned the key structures of the Data Warehouse (tables, MVs, Indexes).
• Developed Data Analysis for Erwin Logical and Physical model design, Oracle (PL SQL packages, triggers) development, UAT for Oracle objects (Tables, MVs, Views).
• Worked with EPA project team representatives to ensure that logical and physical ER/Studio data models were developed in line with EPA standards and guidelines.
• Developed and delivered LRT data warehouse classes in beginning, intermediate, and advanced logical and physical data modeling and the use of the ER/Studio modeling tool.
• Conducted FRS Systems Analysis, Feasibility Studies, computer programs design reviews, plan reviews, implementation, and post implementation surveys.
• Developed complex PL/SQL functions, procedures and packages, Triggers to update facilities overnight, weekly and capture duplicate EPA facilities and create a flag.
• Worked with Oracle DBA\'s in extracting and loading LRT fact and dimension tables.
• As a system support executed daily PL SQL jobs andrefreshed Materialized Views (MVs) to update data processes to both development and production environments.
• Coded UNIX shell scripts to execute various Oracle jobs, SQL/DDL scripts, MVs refresh etc and capture all errors related to the Server and Oracle.
• Used SQL loader and Oracle Import/Export utilities to load data from regional Data stewards to generate monthly LRT data refresh.
• Prepared technical and functional specifications documentations and diagrams, and develop coding logic flowcharts for new LRT ODS system.
• Documented charts and diagrams (flow diagrams) to assist in problem analysis, system designs, and development for the junior data analysts and developers.

Environment: Oracle 10g, Toad 9, SQL Navigator, Erwin 7, MS Visio, Unix, Source Forge.

Confidential,12/07-08/08,
Sr. Data Architect (Oracle Developer),
The objective of the project was to re-design and develop the Sales and Invoice (SAVIs) environment to make it more efficient for timely execution of quality reports and eliminate any redundancy.
As a member of BI team, carried out extensive system analysis, design, development and documentation of a cutting edge Business Intelligence solution for faster execution of reports and optimization of BI (Cognos) reporting system.
Achievements.

• Worked on Erwin and Data Warehousing to Extract Transform and Load from legacy system to new SAVIs system and develop detailed documentation of metadata for future support.
• Collaborated with business and reporting users to gather requirements, develop functional and technical specifications for SAVIs data marts and reports.
• Used Erwin relational tool for logical and physical model for target ODS model.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Developed detailed conceptual model for the company\'s sales and Invoice arm using Erwin and MS Visio; modeling sources were existing reports, data structures, and XML schemas.
• Mapped conceptual model concepts to existing systems and data structures, as well as to the new SAVISs system.
• Developed and maintained SAVIs business and systems data and information standards, working with project teams to develop business solutions in line with those standards.
• Modeled aggregated Sales, Invoice Data Model and inter-relationships for development of enhanced Global Data Warehouse Architecture Repository, Services and reporting system.
• Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL for new ODS reporting model.
• Extensively tuned SQL queries written in procedures/functions at the back end which are called from the front end reports using EXPLAIN PLAN, SQL-TRACE and TKPROF.
• Was part of BI and Oracle DBA support team that constructed reporting application that distilled 2 terabytes of data to prepare data for loading into new sales and invoice model.
• Creating and executed the test plans, test cases, unit and integration testing for all PLSQL.
• Performance tuning of DB and Cognos reports using table partitioning and Aggregation.
• Analyzed DB,job scheduling system (JTSS), Maestro and designed a more efficient system.
• Environment: Oracle 10g, PL/SQL, Toad 9, SQL Navigator, Erwin, JAVA, Cognos 7/8, MKS Integrity, MS SQL Server, Windows NT/2000, Unix, Linux, MS Office suite.

• Fannie Mae- Herndon, 08/07-12/07 ,
• Oracle Data Modeler,
• Worked on the Financial Services team project responsible for analyzing, designing, developing and providing Test and Production for Accounting and Cash Processing business functionality for loans and securities in Fannie Mae’s Single Family portfolio Data Warehouse. Also worked in Servicer and Investor Reporting (SIR) Parallel Comparison and Performance team. Parallel Comparison compares the legacy data with the SIR transactional data for each of the Fannie Mae processes for a particular period of time.
• Achievements.
• Involved in requirement Analysis, review, design and developed ETL files to get data from staging tables and batch files, transform that data and load into the fact tables and data marts to populate parallel and attribute changes reports.
• Define and document ETL process and data flow and scheduling capabilities.
• Developed the technical architecture and design for SIR reporting systems including data structures, application interfaces, ETL specifications, and underlying technical infrastructure.
• Developed an integrated and aggregated supply SIR data and process model using Erwin 6.
• Assisted project managers to ensure conformance to the opmitimized Oracle systems design.
• Performance tuning by table partitioning, archiving, indexing and creating aggregated MVs.
• Designed and implemented batch processes with PL/SQL and optimized the existing PL/SQL packages for faster retrieval, transactions and updates of online and bulk processes.
• Wrote PL/SQL Packages, Procedures and Functions to implement the business rules and to generate the attribute corrections and parallel comparison reports.
• Wrote and executed the automated Unit Testing (UT/PLSQL) and String Testing scripts for the ETL files and PL/SQL Reports files that I developed.
• Wrote Detail Level Designs, High Level Designs and respective Unit Testing Scenarios for all ETL and PL/SQL and Crystal Reports that I developed and delivered.
• Optimized expensive queries by creating indexes, hints and partitioning of tables.
• Developed on-demand, scheduled Reports for Invoices, Loans, Cash Transactions, Mailing labels and Used E-portfolio for accessing Crystal Reports via Crystal Enterprise.
• Used CC and CQ to manage code and documentations changes and traceability. Environment: Oracle, PL/SQL,JAVA, Developer 9, Toad 9, Crystal Reports 11 Xi, Erwin.

Confidential,09/05 08/07,
Data Modeler, (Data Migration and Reporting) ,
The project involved loading the new data into existing Decision Support System with migrated data from external sources. Consolidating old and new VOIPs customers and market from different carriers into different data marts and developing Business Objects reports.
Achievements.

• Developed modules that were part of the solution to meet the reporting requirements of finance team for the sales of various Pay per View and Video On Demand events for TWC.
• Developed data mapping for migration of data and loaded the data warehouse using SQL loaders and Export/Import Oracle utilities.
• Designed, Implemented, and Automated elements of an extraction, transformation, and loading architecture for a two-terabyte data warehouse.
• Involved in Data Analysis and Dimensional Modeling of target system.
• Involved in developing Data Mapping from source to target with intermediate staging area.
• Implemented DBA meta-data for auditing, and created materials for vendor sessions.
• Created DDL, PL/SQL, SQL scripts for Oracle db, the Oracle DB size was about 4TB.
• Performed tables tuning, created Hints, partitioning, parallel job processing at OS level.
• Wrote PL/SQL blocks, Procedures, Functions and Packages for Migration of flat files and to transfer in exact format in Database Tables.
• Logged all transactions and generated exhaustive reports to identify process performance ratio, errors prioritized, and percentage of success and failure reports etc in an understandable cross-matrix layout enabling Business Intelligence staff to perform gap analysis.
• On site Unix, Linux and Windows systems Administration Support.

Environment: Oracle, DB2, MS SQL Server, Unix, Windows NT/2000, SQL, PL/SQL, SQL*Plus, Toad 9, BO Xi/6.1, Rationale Clear Case, Clear Quest and Telelogic DOORS.

Confidential,01/04 08/05,
Crystal Systems Analyst,
Reuters is global enterprise that deals with equities, fixed income, foreign exchange, money, commodities and energy markets around the world use Reuter’s products. The project involved extraction of information from ERP system, providing timely and accurate production. Achievements.

• Involved in gathering, analyzing, documenting business requirements, and functional requirements and data specifications.
• Designed, developed and documented a module for extracting data from TRIMS systems for sending to the financials data to general ledger system.
• Responsible for data analysis, transforming and loading data from vendors like Reuters partners, Compustat and Thomson Financials and other flat data files sources.
• Developed views, functions, procedures and packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Wrote SQL queries and PL/SQL procedures to validate reports.
• Troubleshooting, Optimizing, and fine-tuning the SQL Queries for efficiency.
• Did transformation and calculation of Scorecard metrics using SQL scripts, PL/SQL procedures for various financial markets.
• Involved in Design, Implementation and Testing of Financial and other products Data Marts.
• Migrated BO Enterprise from 6.5 to Xi migrated .

Environment: Oracle, Business Objects Xi/6.1b, PL SQL, Windows XP, MS SQL Server.

EDUCATION:
MSc.-Information Systems Technology, University of Confidential
BSc. Mathematics (Statistics) and Computer Science, Confidential, University.

PROFESSIONAL CERTIFICATIONS:
Oracle 10g DB - Currently pursuing.
Project Management Professional Certification-Currently pursuing.