SUMMARY:

• Over 30 years of IT experience which includes data architecture, database and data warehouse design, modeling, development, testing and programing.
• Over 20 years of Oracle experience.
• Data Warehousing design and modeling
• Database design and modeling
• Data architecture
• Processes design and implementation
• ETL processes design and implementation
• Algorithms design and implementation
• Data conversion, cleansing, and migration
• System design and implementation
• Systems integration
• Data analysis
• Data Quality
• Functional analysis
• Performance tuning
• Computer programming
• Problem troubleshooting
• RICE development
• Database Administration
• SQL
• PL/SQL
• Ad - Hoc reporting
• BI
• Non-standard solutions approach
• Data Volt

TECHNICAL SKILLS:

Oracle Products: Oracle Federal Financials Application (Release 10/11) (Modules PO, FA, AP, HR, INV), Oracle Discoverer, Developer 2000 (Reports (6i, 6.0, 3.0, 2.5), Forms (6i, 6.0, 5.0, 4.5)), SQLLOADER, Oracle Data Integrator (ODI)

Programming Languages: SQL/SQL+, PL/SQL, Powerbuilder (5, 6.0, 6.5), JAVA 1.3, Java Script HTML, PL/1, FORTRAN IV, ALGOL 60, Assembler, Basic

Data Modeling Tools: ErWin, ER Studio (Embarcadero), IBM InfoSphere Data Architect (IDA), Microsoft Visual Studio, Powerdesigner, Qdesigner

Other Software: TOAD, Tableau, Sunflower Fixed Assets, Prism, Developer 2000 (Reports (6i, 6.0, 3.0, 2.5), Forms (6i, 6.0, 5.0, 4.5)), Polyanalyst 6.0, Infomaker, Jbuilder (3, 4), Excel, Jdeveloper 10g, JIRA, Tortoise CVS, Eclipse

Technology: Programming Languages SQL/SQL+, PL/SQL, Powerbuilder (5, 6.0, 6.5), JAVA 1.3, Java Script, HTML, PL/1, FORTRAN IV, ALGOL 60, Assembler, Basic

Databases: Oracle 5/6/7/8i/9i/10g/11g, Ms SQL Server, Sybase, DB2, Watcom, Access, Dataflex

Operating Systems: Windows, OS X, MS-DOS, OS/2, OS/390, Solaris, UNIX

Life Cycle Expertise: Requirements Analysis, Design, Development, Conversion, Testing

Specialty Skills: Data Architect, Conversions, Interfaces, Database Development, RICE Development, Database Administration

CHRONOLOGICAL EXPERIENCE:

Confidential, Alexandria, VA

Sr. Data Architect/ Sr. Data Modeler

Responsibilities:

• Worked on existing PALM System Analysis
• Learned business rules
• Analyzed existing processes and data flows
• Analyzed and troubleshot existing codes mostly written in PL/SQL language
• Created multiple complex SQL queries
• Proposed the changes needed for the system to satisfy new requirements, including the changes in the data flows
• Analyzed performance problems and suggested the ways of performance increase
• Designed the document offering the ways of fixing data inconsistencies
• Created multiple design documents
• Performed conversion from IDA to ER Studio tools
• Worked on some changes in Data models
• Worked on creation and management of data dictionaries
• Created multiple reports based of Microsoft Macros to support DDL extraction out of ER Studio and manage Data Dictionaries

Confidential, Arlington, VA

Sr. Data Architect/Sunflower Integration Lead

Responsibilities:

• Analyzed existing System
• Analyzed existing databases
• Performed data integration Analysis
• Designed new data integration process
• Created data integration document
• Worked on implementation plan
• Worked on implementation process design document
• Assisted in organization and design of staging tables to migrate and integrate the data from multiple sources
• Worked on data migration
• Worked on data mapping
• Worked on data flow diagram
• Created advanced SQL queries for data analyses
• Assisted in creation of PL/SQL packages for data migration

Confidential, Gaithersburg, MD

Sr. Data Modeler/Sr. Data Analyst /Sr. Oracle Developer

Responsibilities:

• Analyzed existing financial systems, engaged in various Confidential activities such as Confidential (Comprehensive Automated Risk Data System), STAR (Structured Trading Aggregate Report), etc.
• Worked on Data Models gap analyses
• Created conceptual Data Model for new system
• Was involved in data mapping
• Performed deep data analysis involving complex SQL queries
• Tuned queries for performance increase
• Suggested parallelization strategy
• Worked on Enterprise Logical Data Model
• Worked on Data Volt concepts and modelling
• Worked on data warehouse schema improvements
• Was involved in data profiling
• Architected and designed several processes consolidating the values from different data sources into one data source
• Developed packages to support the processes above
• Design and developed Materialized views for better system performance
• Designed and built database to support the processes above.
• Created Data flow diagrams
• Designed and developed ETL processes
• Created multiple procedures involved in ETL processes
• Was involved in data quality testing
• Worked on fixing existing code errors
• Created Oracle PL/SQL packages, functions and procedures to support and enhance existing processes
• Was involved in creation of Tableau visual reporting and analysis

Confidential, Baltimore, MD

Sr. Datawarehouse Consultant/Sr. Data Architect/Sr. Data Analyst /Sr. Oracle Developer

Responsibilities:

• Was involved in data analyses of existing data sources for Data warehouse
• Was working on Data warehouse Model
• Analyzed source data and suggested the loading and other concepts for Data warehouse
• Created multiple complex SQL queries to analyze the data and to support ETL process
• Created multiple complex PL/SQL packages, procedures, functions to support ETL process
• Designed and developed ETL processes
• Was involved in data quality testing
• Supported development and test database instances by performing DBA functions
• Worked on data dictionaries
• Worked on Data Integration
• Was involved in Data Validation
• Worked on Database performance
• Tuned queries for better performance
• Worked on BI concepts

Confidential, Washington, DC

Sr. Data Architect/Sr. Data Analyst

Responsibilities:

• Developed multiple SQL queries of a very high complexity for data analysis
• Analyzed and evaluated existing multiple data sources for the integration possibility
• Participated in business and functional system analysis
• Created integrated physical/logical database model
• Normalized database design
• Participated in Data Validation

Confidential, Annapolis, MD

Sr. Oracle Programmer/Sr. Analyst

Responsibilities:

• Analyzed existing System
• Participated in Business Analysis
• Developed new and enhanced old code for back-end processes in PL/SQL
• Supported Production Application by troubleshooting production issues on the database side
• Created multiple complex SQL queries for the data analysis purposes and data quality tests
• Created processes and PL/SQL packages to fix and improve existing problems
• Created series of Materialized views to monitor the data
• Performed multiple DBA functions by creating many database objects including partitioned tables, indexes and sequences, etc.
• Analyzed, fixed and expanded legacy systems back-end complex PL/SQL procedures, functions, and packages
• Analyzed existing PL/SQL codes for reverse engineering processes
• Worked on improvements of slow performance
• Tuned existing queries for better performance
• Worked on the enhancements to the data warehouse schema
• Tested and debugged codes
• Worked with data quality issues
• Worked on data Mapping
• Was tasked with Data Validation

Confidential, Washington, DC

Sr. Data Architect/Sr. Data Warehouse Architect

Responsibilities:

• Analyzed existing System
• Analyzed existing Reports
• Advised on the database and BI Tools products
• Worked on BI concepts approach
• Designed the data architecture for new system
• Participated in Business Analysis
• Designed the process and the dataflow
• Created Data Warehouse prototype
• Created Data structure diagram
• Created on Data flow diagram
• Was involved into integration, conversion, and migration discussions
• Was involved in discussions on cloud connected new system design
• Created multiple SQL queries for data analyses
• Was participating in data quality checks and Data validation
• Worked on database queries tuning

Confidential, Washington, DC

Sr. Data Architect

Responsibilities:

• Analyzed existing User Requirements documents
• Advised on the database and COTS product
• Prepared Migration Strategy and Migration Plan Document
• Participated in creation of Use Cases
• Participated in Business Analysis
• Designed the data architecture for new system
• Designed the process and the dataflow
• Designed the database in accordance with the requirements
• Architected, designed and modeled Data warehouse
• Created complex SQL queries for data analyses
• Created on Data flow diagram using swim lanes
• Normalized database design

Confidential, Arlington, VA

Sr. Data Architect

Responsibilities:

• Analyzed existing data using SQL+ and BI Tool PolyAnalyst
• Prepared data analysis result documentation
• Recommended data integration approaches to perform data mediation between a data source and a destination
• Involved in research for selection of data management tools
• Re-developed and fixed some problems in data models and data architecture
• Worked on data warehouse model
• Participated in alteration of data management standards and conventions
• Worked on cleansing concepts
• Worked on data migration plan
• Worked on conversion business rules document
• Worked on Data Mapping
• Created on Data flow diagram
• Was involved in data validation

Confidential, Arlington, VA

ERP Product Principal Consultant/Sr.Architect

Responsibilities:

• Analyzed existing business rules on the project
• Designed business process
• Created all necessary database objects
• Created all grants on the objects to run the process from APPS schema
• Developed the interface using PL/SQL
• Tuned the process for faster performance
• Created multiple SQL queries for data analyses and data quality tests
• Developed the process flow using DOS commands
• Conducted unit and regression testing
• Created all appropriate reports to provide administrator with current information on the users as well as an error report
• Created all appropriate documentation
• Created Data structure diagram
• Created on Data flow diagram
• Improved slow performing queries

Confidential, Falls Church, VA

ERP Product Principal Consultant

Responsibilities:

• Analyzed existing business rules and requirements on the project
• Designed business process according to MD-50 requirements
• Created all necessary database objects
• Created all grants on the objects to run the process
• Developed all codes using PL/SQL and SQL queries
• Tuned the process for faster performance
• Incorporated the package into the application
• Conducted all unit and regression testing
• Participated in data quality testing
• Created all appropriate reports according to the customer requirements
• Created all appropriate documentation, including MD-70, Release Note
• Created on Data flow diagram
• Worked on improvement of slow performing queries

Confidential, Washington, DC

Senior Oracle Software Engineer/Database Analyst/Testing Analyst

Responsibilities:

• Analyzed existing business rules on the project
• Created testing scenarios and test cases
• Programmed existing business rules into Oracle SQL statements
• Conducted data quality tests using SQL statements
• Automated testing procedures
• Participated in BI development
• Participated in Data warehouse enhancement
• Worked on data warehouse model
• Developed SQL statements for Hyperion analytical reports
• Tuned created SQL statements for performance increase
• Developed full testing documentation
• Created database functions and packages
• Created complex SQL queries for OLAP Hyperion reports
• Created SQL queries for Informatica development