PROFESSIONAL SKILLS:

Translating business/IT/scientific objectives into technological solutions

Relational Database OLTP Data Modeling, Development and Reporting:

• Conceptual, logical normalization, 3NF and physical data models
• Development of packages, procedures, functions and triggers
• Data modeling notations: IE, IDEF1X, UML, Barker's
• Reporting tools: Report Server of SSRS, Crystal Reports

Data Warehouse Design and Development with OLAP technology/Business Intelligence:

• Development of Data Warehouses, Data Marts, Cubes and Reporting Solutions
• Working experience with Kimball Methodology and Data Vault Modeling
• Dimensional modeling techniques: Star and Snowflake schemas, type 1-3 slowly changing dimensions, role playing, junk and conformed dimensions, bridge tables, aggregations, hierarchies
• Data Profiling
• Experience with Master Data Management MDM concepts
• Oracle OLAP multidimensional solution
• MS Business Intelligence Development Studio BIDS : SSIS, SSAS, SSRS
• Proclarity software as a reporting tool for multidimensional databases Cubes

Data Modeling Tools:

• Erwin Enterprise Data Modeler Suite Erwin 7x, 8.2, Model Mart CA All Fusion
• MS SQL Server Management Studio, Oracle SQL Developer

Data Analysis packages/skills:

• SAS, Excel
• Exposure to Tableau
• Linear, nonlinear and multivariate regression Principal component analysis

Database Management Platforms:

• Oracle 9i, 10g, 11g
• SQL Server 2005, 2008
• Familiarity with Teradata and data warehouse appliance concept

Related DBMS Tools and Techniques:

• Database and Application Performance Tuning: OEM/SQL Server Advisors, Tuning by Index, Table Partitioning and Storage, SQL Execution Plan, Query Hints
• Oracle Data Migration Tools: exp/imp Utilities, Data Pump, External Tables, SQL Loader
• Oracle Backup and Recovery: RMAN, Flashback
• Oracle Enterprise Manager OEM , TOAD, OEM Grid Control

Programming:

• SQL, T-SQL, PL/SQL - Database back-end and ETL development
• Java - JDBC and modification/implementation of customer Java based data loaders
• Fortran/C - Development of codes for various statistical/scientific packages
• PHP ODBC , HTML, XML - Implementation of dynamic web-based database interfaces

Operating Systems: UNIX, Windows

Collaboration Tools: SharePoint, Clear Case, Clear Quest

MS Office Productivity Suite 2007-2012 including Outlook, Word, PowerPoint, Visio

RECENT EXPERIENCE:

Confidential

Data Modeler

• Conduct requirements gathering and design sessions for Medicaid Management Information Systems MMIS for a number of states
• Analyze business and financial requirements that follow a process model
• Create conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data Mart Star/Snowflake schema implementations
• Use Erwin Enterprise Data Modeler Suite to enforce naming, data type and referential integrity standards, to capture business definition of entities and data element and to maintain versions of the Model Mart
• Generate DDL from a model for RDBMS SQL, Oracle, Teradata
• Develop mapping spreadsheets that provide the Data Warehouse Development ETL team with source to target data mapping
• Use data modeling tools for documenting and publishing data dictionaries
• Prepare and revise data flow and workflow diagrams

Confidential

Sr. Data Analyst

• Create and maintain the company integrated metadata repository for data, business and presentation layers. The repository is used to build the Operational Data Store ODS and to develop web based front end user interfaces for environmental and engineering quality surveys
• Provide expertise to acquire, manage, manipulate, analyze and report data using Oracle, SQL Server, Report Server SSRS and Crystal Reports platforms
• Monitor and manage the company Operational Data Store to ensure data integrity and data quality
• Facilitate modeling and application development sessions and to coordinate the efforts to translate business requirements into IT data system solutions
• Use Rapid Application Development RAD methodology

Confidential

Data Warehouse Analyst/Modeler

• Work on enterprise level in mission critical environment, providing analytics, reporting solutions, handling business and technical metadata and modeling data marts and dimensional databases
• Define, develop and maintain Enterprise Architecture information requirements, models and dictionaries
• Use Master Data Management concepts for data governance and to improve data quality
• Plan, test, and deploy ETL mappings, and database code as part of application build process across the enterprise
• Use Integration Services SSIS , Analysis Services SSAS of MS Business Intelligence Development Studio BIDS and Reporting Services including Proclarity software to develop Data Marts, multidimensional databases Cubes and, consequently, Data Warehouse solutions for a number of Veterans Health Administration VHA related projects that facilitate and speed up data retrieval and data analysis
• Modify, design and create data marts using ERwin data modeling tool. Maintain production models using ERwin Complete Compare and Reverse Engineering options
• Conduct ad hoc queries against large data sets of VHA National Data Systems as requested by Congress and other oversight bodies

Confidential

Development DBA/Staff Scientist

• Database and data warehouse design Oracle OLAP , development and implementation for a number of cancer treatment/drug development projects: user requirements, logical and physical design, implementation in Unix and Windows environments. Logical and physical data modeling was performed with ERwin and Schemester software
• Development, implementation and application of various programming packages, in particular, to model enzymatic reactivity of biological systems using Fortran and C. The results are reflected in number of publications and presentations. Author mainly as the first author of more than 40 publications in computational physics, quantum chemistry and computational biology
• Act as a project manager for a number of designated projects to create and modify project plans, to mitigate risk and to perform final project reviews
• Managing and monitoring Oracle 10g, 11g OEM, TOAD and MS SQL databases, data quality assurance, data security
• Databases tuning, migration/upgrading Oracle version including VLDB , backup, data transfer/loading
• Database/data migration between different servers and platforms
• Analysis of various statistical and biochemical software packages and computational methodologies with the aim to provide recommendations to the management and end users. Beta testing of the software
• Use linear, nonlinear and multivariate regression Principal component analysis for a number of projects including construction of atomic orbital basis in analytical forms
• Based on identifying reporting and analytic needs, conduct data analyses and prepare reports, charts, documentation and manuals
• Involvement in Federal Grants Management Process as a scientific peer reviewer NIH and NSF grant submission with the aim to evaluate innovation, research feasibility, budget restrictions and resources needed
• scrambled and real SSNs
• System Development Life Cycle SDLC of Image database for mouse cancer project. The research project includes planning, analysis, design, implementation of the database, interface and loader, maintenance and customer training
• Database for HIV drug structure and properties consulting, implementation, data integrity . The database is used to answer administrative, pharmacokinetic and clinical outcome questions