SUMMARY:

• Information Technology professional with full life cycle IT project experience.
• 15 years of experience designing and developing Online Transaction Processing and Online Analytical Processing Systems.
• 9 years of experience in the Data Architecture and Design - Conceptual, Logical, Physical Data Modeling.
• 10 Years Data-warehousing - Dimensional Model, Extract Transform Load (ETL), Business Intelligence, Analytical reporting.
• 12 Years - Business/Technical Requirement Analysis, Testing and Deployment.
• 10 Years Transaction System Design and Development.
• 5 Years - Metadata management.
• Data/System/Business analyst with successful experience in eliciting, analyzing, and documenting the requirements for business processes and information systems. Worked as a liaison among business stakeholders to understand business problems and opportunities in the context of requirements and recommend solutions that enable the organization to achieve its goals.
• Excellent facilitation skills in conducting walkthroughs, interviews, JAD and JAR sessions. Comprehensive knowledge of RUP, Waterfall and Six Sigma methodology.
• Strong experience in conducting UAT and documentation of test cases. Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions. Well versed in Change Control, Defect tracking, System Integration and scheduling.
• Database Design for various databases - Oracle, Sybase, IBM - UDB, DB2, MS SQL Server.

TECHNICAL SKILLS:

Databases: Oracle 10g/9i/8i/7.x, DB2, Sybase, FOXPRO, dBase, MS Access.

CASE tools: ERStudio 7.5, Erwin 3.2, & 4.1, BPwin, Rational Rose, Designer 6i, Designer 2000 2.1/1.2 Oracle Products Developer 2000 2.1/1.2, SQL, PL/SQL, OWS 3.0, OAS 4.0, PL/SQL Web Development Toolkit, Oracle FINANCIALS 10.7.0(General Ledger, A/r, a/p, Fixed Assets)

Operating Systems: HP UNIX, Sun Solaris UNIX, Windows NT 4.0, Windows 98/95/3.1/3.11

ETL: Informatica, Power Center 4.x/5.x/6.x/7.x, Power Mart 1.7/5.x/6.x, ACTA.

OLAP: Business Objects XI 3.0/6.5/5.x/4.x, WEBI, Hyperion SQR 8.x, Cognos Impromptu 6.x, Power Play 6.x, Crystal Reports 8.5, Microstrategy 7,Oracle Express, Oracle Discoverer.

Languages: SQL, PL/SQL, HTML, Java Script, C, COBOL, XML

Other Products: Microsoft Office 2000,Viso 6.0, Dream Weaver, Microsoft Visual Source Safe, FTP Voyager, Homesite 4.0, POWERBUILDER 4.0

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr. Data /Business Analyst (Business Intelligence)

Responsibilities:

• Requirement analysis, data analysis, data mapping (source to target) and interfacing with business users.
• Conceptual, Logical and Physical Data Model design for Enterprise Data Warehouse, Operational Datastore and Datamart.
• Prepare Technical Specification Document, Conduct and participate in status meetings to collect data from business users.
• Performed GAP and impact analysis, solution documents, helped Project manager in preparing project plan and coordinated with multiple IT teams to ensure the delivery of product within tight deadlines. Facilitated User Acceptance test (UAT) for Data Warehousing applications.
• Mentoring team members and done the data models reviews.
• Worked with the very large volume of Credit Risk and Credit Enhancement Data loading into Enterprise Data Warehouse.
• Worked with the business users & development team to resolve data issues in production systems.
• Designed, developed and maintained Business Object - Universes. Created and reviewed the high level and detail level ETL design documents.
• Created various Data Quality Rules using Data Insight, this sends email notifications to business users when there are any exceptions to the Credit Enhancement Data.
• Working with the Application Architects, Data Architects, Sr. Developers and Business Analysts to determine the impact analysis and data dependency. Coordinating with the Data Analysts, DBA and Technical Analysts.

Environment: Abinitio, Sybase 12.5.1, UNIX, Oracle 10.0g, SQL, Business Object Data Insight XI 3.0, ERStudio 7.1, Rational Clear Case & Clear Quest, DOORS 8.1, Business Objects XI R2, RUP (Rational Unified Process), MS Access

Confidential

Data Architect

Responsibilities:

• Design and Development of data warehouse and data marts.
• Requirement analysis and data analysis of source system and target systems.
• Dimensional Data Modeling(STAR Schema Ralph Kimbal Methodology), ETL(Informatica, PL/SQL store procedures and Packages) Design and development.
• Extracting data from OLTP and Legacy system into Oracle 10 g Data Ware house.
• Designed and developed Business Object Universe and Adhoc Reports using WEBI.
• Provide expertise in the integration of data and data quality issues. Developed utilities to reconcile or compare source and target data.
• Responsible for ETL design documentation, version controlling of schema and version releasing.

Environment: Oracle 10 g, PL/SQL, SQL, ERStudio 7.x, SQL Server, Unix, Informatica Power Center 8.0, Windows NT and 2000, IBM Compatibles, Business Objects 6.5

Confidential, Herndon, VA

Sr. Data Modeler/Data Architect (Consulting)

Responsibilities:

• Large system database design (400 new tables, 200 changes to existing tables).
• Transaction System Design - Normalized 3rd Normal Form Database Design.
• Analytical Reporting System Database Design - Hybrid Approach (Ralph Kimbal/ Bill Inmon)
• Business Intelligence - Designed the Business Object Universe (Metadata Layer) and design of reports.
• Data Flow diagrams, ER diagrams, forward and reverse engineering, complete compare, reporting.
• Analysis and Review:
• Business and Application Use Case Analysis and Review
• Design Documentation Review of Data Models, Report Designs, Detail Designs, System Architecture.
• Large Multi Terabyte Data analysis using SAS
• ETL Design.
• Change Management, Impact Analysis and data dependency across multiple applications.
• Resolve database design issues in production systems.
• Maintaining the Metadata portal/data dictionary in collaboration with the Enterprise Metadata Repository Management Team.
• Cross-functional Team consisting of - Business SME’s, Enterprise Architects, Application Architects, Data Architects, DBA’s, Developers and Business.
• Provide design/development and testing guidance for ETL processes.

Environment: Oracle 10.0g, SQL, ERStudio 7.1, Rational Clear Case & Clear Quest, DOORS 8.1, Business Objects 6.5, RUP (Rational Unified Process), Ab-initio, SAS, MS Access

Confidential, McLean, VA

Sr. Data Analyst (Consulting)

Responsibilities:

• Application use case, business use case and data models reviews.
• Metadata repository management/data dictionary management.
• Worked with the Business Engineers and Business Analysts to determine the data dependency, data consistency and database changes to TDS and ODS to CDW.
• Reviewed logical and physical data models for TDS, ODS, CDW.
• Designed and developed normalized base tables that captures audit trail level history for Corporate Data Warehouse
• Developed data mapping and transformation documentation (business rule spreadsheet) for data movement from TDS to ODS to CDW to data marts.
• Maintained Metadata repository for all the new objects, which were designed.
• Participated in the enterprise change management meetings to ensure and review the impact of changes made to existing structures on the data warehouse and marts.
• Prepared requirements for data quality jobs that includes source to target technical data quality and reconciliation. Assisted the Project Manager in project estimation.
• Guiding the Technical Analysts to design, code and test ETL processes.

Environment: DB2, UDB, Rational Clear Case & Clear Quest, SAS, Erwin 4.1, Windows NT and 2000, RUP, IBM Compatibles, DOORS 7.5, UNIX, RUP (Rational Unified Process)

Confidential, VA

Systems Analyst

Responsibilities:

• Interacted with business customers, collected business requirements and performed requirement analysis.
• Designed and developed logical & physical data models using Erwin.
• Maintained Metadata information related to data models in Erwin.
• Designed and developed mappings, mapplets and Informatica Sesions.
• Designed and developed data marts for reservation, marketing and finance systems.
• Designed and maintained components of MicroStrategy Metadata and Logical Model layer.
• Designed, developed and implemented MicroStrategy reports used for analytical reporting.
• Designed and developed databases, VB applications and Unix Shell Scripts to build and support preventive maintenance applications of commercial jet liners and passenger aircrafts.
• Supported, maintained and performed issue resolution of Maximo ERP.
• Worked as a team member of a team of 7-10 Software Engineers.

Environment: MAXIMO 5X, Oracle 9i/8i, VB 6.0, Erwin 4.1, HP UNIX, PL/SQL, SQL, Teradata, MicroStrategy 6.x, Windows NT and 2000, IBM Compatibles, Informatica 7.0

Confidential, VA

Systems Analyst

Responsibilities:

• Designed and developed dimentional data models, data warehouse, ETL, database and PL/SQL objects to pull data from various legacy and relational databases into an Oracle 8i warehouse and marts.
• Worked on Informatica tool - source analyzer, data warehousing designer, mapping designer, mapplet and transformations.
• Created and maintained MicroStrategy Metadata Objects. Created reports using MicroStrategy.
• Maintained existing models including model synch up with the existing databases, forward and reverse engineering of the existing databases and standard data modeling functions.

Environment: Oracle 8i, Teradata 4.0, Erwin 4.0, Unix Informatica Power Center 6.2, PL/SQL, SQL, Windows NT and 2000, IBM Compatibles

Confidential, MD

Senior Data Analyst

Responsibilities:

• Requirements analysis and interface with business areas. Followed RUP standards to prepare and analyze use cases. Interacted with business customers to collect business requirements.
• Designed and developed logical and physical data models - star schema
• EDI support and central resolution logs. Web report analysis and design.
• ETL Development - Informatica source analyzer, data warehousing designer, mapping designer, mapplet and transformations.
• Designed and developed simple and complex mappings by extracting, cleaning, scrubbing and transforming data from Oracle Financials (Aries) on Oracle database, client information from Sybase and transaction information from DB2 and loading the clean transformed data to the warehouse on an Oracle Database via the ODS.
• Wrote complex stored procedures and triggers and optimized for maximum performance.
• Generated reports using Business Objects 5.1, utilized Business Objects Developer Suite (Supervisor, Designer, Info View), BO Query Designer and Report Designer.

Environment: Informatica Power Mart 4.7/5.0/6.2, ETL, Sybase 12.0, Oracle Financials 10.7, Oracle 8i/8.0/7.3, DB2, Erwin 4.0, Unix Shell Scripting, PERL, PL/SQL, Business Objects 5.1, Sun Solaris 2.6, AIX 4.3, Windows NT 4.0, IBM Compatibles, RUP (Rational Unified Process)

Confidential, MD

Data Architect/Data Modeler

Responsibilities:

• Identified business and data requirements.
• Performed requirements analysis and documentation to provide guidelines to the software development team.
• Analyzed and studied SAP R/3 Modules (FICO, HR, Sales & Distribution) to identify business requirement.
• Created ER diagrams, database design and data modeling using Erwin.
• Prepared the logical and physical database designs and performed forward engineering of the DDL scripts.
• Designed, analyzed and developed models for transactional databases, operational data stores and data warehouse.
• Worked on Informatica tool - source analyzer, data warehousing designer, mapping designer, mapplet and transformations. Defined data volumes and per year data growth for the designed data warehouse schemas.
• Performed extraction, transformation and loading of SAP/R3 and Vantive CRM data into the Oracle data warehouse tables. Fine-tuned existing processes to improve efficiency.
• Managed the complete phase of transformation of data using Informatica as lead of 3-member team.
• Designed and developed PL/SQL procedures for cleaning and scrubbing the existing data before extraction.
• Analyzed the mapping requirements and created suitable transformations to execute the job.
• Designed and developed various processes to load the data from source from ODS to DDS.

Environment: Informatica, Power Center 5.1, ACTA Works, Business Objects 5.0.2, HP UNIX, Windows NTErwin, Oracle 8i, OAS 4.0, SQL, PL/SQL

Confidential, Walnut Creek, CA

Data Architect

Responsibilities:

• Analyzed, designed and developed OLTP and OLAP applications.
• Interacted with Business Analysts to understand the business requirement.
• Interacted with the end users to gather requirements and design technical and functional specifications.
• Performed logical & physical database design and generation using Erwin.
• Created star schema data warehouse model for various business requirement. Setup the data warehouse.
• Generated and sequentialized batches to run batch sessions one after the other and concurrent batches to start all the sessions in the batch at once. Maintained the Metadata on the model mart.
• Prepared test plans and reviewed the test results to review the performance of the system.
• Created a CRON jobs to execute the batch jobs using UNIX Shell Scripts.
• Extensively used SQL, PL/SQL & SQL*PLUS. Coded Javascripts and PL/SQL for developing PL/SQL cartridges.

Environment: HP UNIX, Windows NT, Erwin 3.5.2, Oracle 8.1.5, SQL, PL/SQL, PL/SQL Cartridges, Oracle Application Server 4.0

Confidential, New London, CT

Lead Analyst

Responsibilities:

• Performed requirement analysis and generation of functional specification documentation.
• Analyzed existing ER-diagrams and incorporated changes as per client’s requirement.
• Worked on Informatica tool - source analyzer, data warehousing designer, mapping designer, mapplet and transformations. Created snowflake schema data warehouse model for various business requirement.
• Performed development and maintenance of data warehouse applications using Informatica Power Center and Business Objects.
• Designed and developed complex mappings using expressions, aggregators, filters and procedures to develop and feed data marts.
• Accessed data from relational tables that are not sources in mapping using lookup transformation.
• Created sequential batches to run batch sessions one after the other and concurrent batches to start all the sessions in the batch at once.
• Interacted with the end users in requirements gathering and designing technical and functional specifications.
• Created detail design of the stored procedures, database objects, nested tables, packages and user roles for the system. Coded Javascripts and PL/SQL for developing PL/SQL cartridges.

Environment: Sun Solaris UNIX, Windows NT, Erwin, Oracle 8.0.5, Informatica Power Mart 4.5, Oracle

Confidential, Lansing, MI

Data Architect/Lead Analyst

Responsibilities:

• Identified the business and data requirements. Performed requirement analysis and documentation. This documentation provided guidelines to the software development team.
• Performed system study and customer requirement study to develop ER diagrams, process flow diagram, and function hierarchy and data flow diagram using Designer 2000.
• Wrote stored procedures, C programs (embedded SQL and DB-library) and Shell Scripts.
• Created user groups and user profiles with administrator privileges within repository manager.
• Performed data conversion from Access 2.0 to Oracle 8.0 using SQL Loader.
• Performed forms module development and coding using Designer 2000.
• Improved application performance by SQL & PL/SQL tuning.
• Wrote various PL/SQL scripts on the back end to maintain data integrity.

Environment: Oracle 8.0, Designer 2000 RELEASE 2.2, PL/SQL, SQL 8.0, Forms 5.0 and Reports 3.0, SQL

Confidential

Project Leader/Data Modeler

Responsibilities:

• Prepared high level design documentation.
• Prepared OLAP application by maintaining data warehouse of the HRMS for analytical purposes.
• Set up functional work flow/process flow diagram and created process specifications for both client and development team. Created data warehouse ER-diagrams using Designer 2000 data modeling tools.
• Interacted with the end users for requirements gathering and designing technical and functional specifications.
• Prepared test plans and review of the test results to review the performance of the system.
• Managed and mentored the development and testing team consisting of 6 engineers.
• Managed the launching of the complete HRMS system onto the intranet.

Environment: Oracle 8.0, SQL, PL/SQL, SQL Loader, Designer 2000, Developer 2000, Crystal Reports, MS

Confidential

Module Leader/Lead Analyst

Responsibilities:

• Performed system study, analysis and database design using Designer 2000.
• Utilized Informatica Power center for extraction, transformation and loading of the data into the target tables. The source database was COBOL, FoxPro, Oracle 6.x, Oracle 8.0 and the target was Oracle.
• Interacted with upper level management to map their requirements of sales and marketing reports.

Environment: Windows NT, Oracle 8.0, Oracle web server, SQL 8.0, and PL/SQL CARTRIDGES, JAVA Development KIT 1.1.5, HTML, Developer 2000(Forms5.0, Reports3.0), Designer 2000, Javascript, Crystal Reports