OBJECTIVE

To seek a challenging career as a Database Architect/ Data Modeler in a competitive and challenging work environment offering growth and opportunities.

SUMMARY

• 12 Years of IT Industry experience in Business Applications Development, System Analysis, Software Design Data Modeling and Architecture, Development and Implementation of Software Applications.
• Extensive experience in normalization of databases, Large-scale logical and physical data modeling, ER modeling using ERwin, Toad Data Modeler and Designer-2000 Analysis, design, and development of data Extraction, Transformation, and Loading ETL using Informatica.
• Extensive experience in conducting requirements analysis and architecture design of OLTP.
• Experience in creating Entity Dimension relational data models with Dr. Ralph Kimball Methodology.
• Strong understanding of the principles of Data warehousing using Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Excellent experience in system and database design using UML, coding and production support.
• Extensive Experience in writing system specifications. Created/maintained/modified data base design document with detailed description of logical entities and physical tables.
• Performed source system analysis, data profiling, data cleansing, metadata creation and management, and data integration of Data Warehouse systems.
• Strong experience in back-end programming with Oracle 10g/9i/8i.
• Hands-on experience in Data Warehousing, Performance Tuning, Business Intelligence and reporting.
• Designed ETL scripts, did data loading and extracted data by using Informatica and other ETL tools and utilities. Scheduled and managed ETL jobs by using UNIX scripts and scheduling tools.
• Proficient in Oracle AS Portal, Oracle Developer 2000 and Designer 2000.
• Experience in Oracle Warehouse Builder 10g, Informatica Power Center 8.x.
• Well versed with creation of materialized views, bitmapped indexes and table partitions.
• Experience in UNIX/LINUS Shell Scripting.
• Good understanding of Object Oriented Programming OOP practices.
• Performed and Excelled in various roles like Data Modeler, Data Architect, Software Designer, System Analyst and Module Leader.
• Participated in pre-sales activities such as customer interactions, proposal preparation estimations for the projects.
• Proven expertise in all phases of Software Development Life Cycle SDLC of various projects.
• Effective Team Player with excellent written and verbal communication skills.
• TECHNICAL SKILLS
• Data Modeling Tools: ERwin 7.x, Oracle Designer 2000, Toad Data Modeler
• ETL OLAP Tools: Oracle Warehouse Builder, Informatica Power Center
• GUI Tools: Developer 2000, Oracle Designer 2000, Oracle AS Portal
• Databases: Oracle 8i/9i/10g
• Development Tools: Oracle AS Portal, jDeveloper, Oracle Forms 6i, Oracle Reports 6i, Crystal Reports 11, Webfocus, Oracle BI Discoverer, Oracle APEX 3.x, TOAD, SQL Loader, PL/SQL
• Internet: HTML, XML, XSD, Java, Webservices using jDeveloper, Oracle Internet Directory, J2EE, SOAP, Spring
• Operating Systems: Windows 2000/NT/95/XP/Vista/7, Unix
• Languages: PL/SQL, C, C , C , Java, UML, Unix shell scripting
• Other Tools: Data Warehousing, Oracle Enterprise Manager, SQLNet, Import/Export Utililties, PVCS, VSS, SVN, Edit Plus, MS Visio, Active Directories

PROFESSIONAL EXPERIENCE

Confidential

Database Architect

Social Interest Solutions SIS is a mission-driven, nonprofit organization dedicated to leveraging technology innovation to improve consumers' quality of life. The signature One-e-App technology platform enables individuals and families to efficiently identify, access, and enroll in eligible public and private health and social services. It is also an IT systems integrator connecting Arizona to the Federally Facilitated Exchange and is working with the State of Arizona to leveraging the eligibility and enrollment functionality of the Health-e-Arizona system.

Responsibilities:

• Understanding the Health-e-Arizona application and auditing the data model and data flow for efficient storage of data in the existing table structures and reporting discrepancies.
• Suggest improvements in the data model in terms of normalizing or denormalizing table structures as required.
• Identify tables that need to be partitioned.
• Evaluate top slow queries and top most time consuming stored procedures.
• Run data profiler on key tables to identify correct data type and size of columns.
• Identify over-engineered database triggers and make suggestions for improvement in performance.
• Perform reverse engineering to create a physical data model from database and SQL scripts.
• Identify problematic queries in the backend on the heavily used tables.
• Suggest improvement with various indexes in the database.
• Creating a logical and physical data model from the database using Erwin.

Environment: SQL Server 2012, Management Studio, Erwin 7.3, Spotlight, New Relic.

Confidential

Database Modeler

Capital One is a diversified bank that offers a broad array of financial products and services to consumers, small businesses and commercial clients. A Fortune 500 company, Capital One has one of the most widely recognized brands in America. As one of the nation's top 10 largest banks based on deposits, Capital One serves banking customers through branch locations primarily in New York, New Jersey, Texas, Louisiana, Maryland, Virginia and the District of Columbia.

Responsibilities:

• Understand and translate business needs into developing the logical data model LDM and assists the DBA in developing the physical data model PDM while working in sprints Agile methodology .
• Facilitate JAD sessions Joint Application Design to determine data rules, and hold LDM and PDM Reviews with Data SMEs Subject Matter Experts .
• Develop implementation logical data models according to different platforms like operational models in environments like DB2, Oracle and SQL Server while analytical models for data warehouse in Teradata etc.
• Maintain enterprise level conceptual and logical data models along with the corresponding metadata.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Optimize and update logical and physical data models to support new and existing projects

Environment: ERwin 7.x, Oracle 10g/11g, Teradata, SQL Server, DB2.

Confidential

Database Architect / Modeler

MDdatacor is an IT solution provider in healthcare, which specializes in combining claims and clinical data from electronic medical record, practice management, registry and lab systems from any vendor into a HIPAA-compliant database and provides useful patient data to the physicians. It currently serves more than 7,000 physicians representing over seven million patients. The application is used by Blue Cross Blue shield of North Dakota, Minnesota, Kansas, Wellmark and others.

Responsibilities:

• Requirement gathering, Analyses and Design.
• Experience in designing Conceptual, Logical and Physical Data Model to support business needs using Toad Data Modeler.
• Hands-on experience in designing and writing PL/SQL procedures and functions for all back end processes.
• Extensive experience in using REF CURSORs and XMLs through PL/SQL procedures for fast access from the Flex application.
• An expert in designing the complex Reporting Engine as a series of PL/SQL procedures.
• Proficient in partitioning tables using hints for SQL queries, global temporary tables, creating indexes and materialized views for fast access from screens and performance tuning. After the product went live, it improved the performance of the screens from more than 1 min loading time to 2-5 seconds and hence enhanced user experience.
• Competence in using Data Pump to migrate data from Production to development and staging environments.
• Extensive experience in designing Data Flow Diagrams using UML.
• Expertise in Toad Data Modeler for configuration management of the database model and in generating scripts from the Modeler to create various database objects.
• Prepared Proof of Concepts during the inception of various projects.
• Experience in Data conversion, Migration and Data messaging using Pervasive Data Integrator.
• Extensive experience in Data Profiling on key data elements and business rules for clinical data.
• Assisted Project Managers and Business Analysts during Plan, Analysis and Design phases of each project.
• Integrated and implemented several applications in different projects that went live with zero defects in the fastest and efficient manner.

Environment: Oracle 10g, SQL, PL/SQL, .NET, Adobe Flex, IIS, Oracle Enterprise Manager , SVN, XML, SQL Developer, TOAD, Toad Data Modeler, TKPROF, UML, Pervasive Data Integrator, Editplus, Bugtracker, Unix, Oracle APEX 3.1.

Confidential

Database Modeler/ Designer

Responsibilities:

• Understanding and analyzing requirements interacting with the business users.
• Expertise in designing the system logical data model ER model to meet requirements, applying the Data Modeling Standards and the logical Data Naming Conventions
• Applied the same enhancements in the physical data model, using the Data Modeling Standards and the physical Data Naming Conventions appropriate for the specific back-end database.
• Resolved data issues and assisted in data cleansing.
• Hands-on experience in designing and developing User Registration Screens using Oracle Portal.
• Expertise in creating PL/SQL packages to be used for Webservices.
• Excellent experience in creating web services using jDeveloper and deploying them on the Application Server.
• Experience in creating End user layers using Discoverer and creating reports based on the EULs.
• Expertise in integration of reports and Webservices through Oracle AS Portal.

Environment: Oracle 10g, LOG4PL/SQL, Oracle 10g Application Server, Oracle AS Portal, Oracle Internet Directory, jDeveloper, Oracle BI Discoverer 10g, UML, Webservices.

Confidential

Database Modeler / Designer

Responsibilities:

• Conducted requirements definition meetings with end users and document system/business requirements.
• Analyzing requirements for each reconciliation process and working closely with the functional leads.
• An expert in writing Technical Solutions for the reconciliation processes.
• Expertise in different degrees of normalization and in designing Business Data Model conceptual , Entity-Relationship logical data model ER models using ERwin to support business needs.
• Excellent experience in creating the Enterprise Business Data Dictionary and associated metadata.
• Obtaining complete knowledge of the relational physical database schema Oracle 10g and creating and maintaining database scripts using UNIX/LINUX.
• Established role based data security and encryption of sensitive data.
• Used Object Oriented Programming OOP for JAVA programs and used Spring technology for establishing communication between various programs.
• Conducted interviews, brain storming discussions with the project team to get additional requirements for various processes.
• Collaborated with project manager for project plan and acted as liaison between business and technical team.
• Mentored data stewards for completeness, accuracy, embedded data, data integrity, custom query and sample data profiling techniques.
• Proposed methodology for data cleansing of master data in oracle database by using data services and PL/SQL stored procedures.
• Identified the high level data cleansing requirements that informed the teams as to the steps that will have to be made to facilitate the enterprise-wide solution.
• Developed the migration plans from development to test to production.
• Programming the data acquisition tool with the rules to be applied to the data.
• Conducted and produced a proof of concept for Data Integration and online analytical processing.
• Reviewed and documented policies on PK, FK, related indexing, naming conventions, data typing, defaulting and the consistency of their implementations.
• Excellent experience in SQL and in performance tuning
• Expert in creating PL/SQL packages, procedures, functions and triggers.
• Performed in-depth data analysis on oracle data warehouse for data conversion project.
• Defined database design standards for whole application. Knowledge transfer to the developers.
• Expert in reviewing the code both functionally and technically.
• Working with JAVA team and Webfocus team for implementation strategies such that the user requests are processed in an optimised way and for creating various table structures required by them.
• Designed and Developed web-based reports using Oracle APEX.

Environment: UML, Oracle 10g, LOG4PL/SQL, UTPL/SQL, Business Intelligence and Reporting, Informatica Power Center, Webfocus 7, J2EE, Spring, VSS, SVN, ERwin, Oracle APEX.

Confidential

Solutions Designer / Data Modeler

Responsibilities:

• Performed role of an implementation lead.
• Work with the source system analysts to understand the windows available for data extraction.
• Program, test, implement and maintain data extraction programs necessary to extract the data from the operational systems needed to be moved to the Data Warehouse using Oracle Warehouse Builder.
• Participation in design sessions chaired by data stewards and/or IT personnel where decisions are made involving the transformation from source to target.
• Ensuring the correct application of the business rules through data query after the data is loaded into the Data Warehouse.
• Preparing the files needed to load each table that has been designated to receive files from operational systems rather than direct input from data stewards.
• Programming the data acquisition tool s with the tables to load the files into.
• Working with the Data Warehouse Database Administrator to ensure the file loads properly into the Data Warehouse.
• Performed Data analysis work for new and existing business requirement.
• Excellent experience in normalization and designing and developing the Business Data Model conceptual ER model for rules engine for Document Management System using ERwin.
• Proficient in creating Data Flow Diagrams using UML.
• Designed and developed the Rules Engine PL/SQL packages and Physical Data Model in the form of a chain of stored procedures and functions which is the heart of DMS project, as the reports are generated dynamically based on the rules defined in the rules engine. The total number of reports affected by DMS is about 120 including Front Office and Back Office areas.
• As a Support Analyst at onsite ensuring the successful implementation of DMS project. The system consisted of an Oracle Server sending data in an XML format to the IIS Server where a residing .NET code in C using Object Oriented Programming invokes a concerned crystal report dynamically and merges its layout with the data coming from XML to generate documents in a PDF format or a CSV format at another server.
• Ensuring the complete migration to the new system of reports generation using crystal reports as compared to the earlier system of generation using Reports 6i with performance gains and also implementation of layout changes for rebranding in the new system.

Environment: Oracle 9i, ERwin, BI Tools, Oracle Warehouse Builder 10g, SQL, PL/SQL, UML, Crystal Reports 11, .NET, C residing on IIS Servers, XML, Reports 6i, PVCS

Confidential

Database Designer / Developer

Responsibilities:

• Hands-on experience in Data profiling and Data cleansing strategy for the operational data. Extraction, Transformation and Loading of the operational data into the staging schema using OWB. Creation of supporting PL/SQL stored procedures for data cleansing activity and transformation of data.
• Experience in organizing and analyzing data using Zachman Framework.
• Participated in Web sphere and Informatica tool review for Data Profiling and Data Cleansing.
• Proficient in creating Fact tables and related Dimension tables in the warehouse schema using star schema modeling and populating these tables using ETL processing and rolling up data wherever required.
• Extensive experience in designing sample tables into staging area based on the raw data provided by GOIC from various sources.
• Developed sample Data Marts for analytical processing.
• Expertise in Oracle BI Discoverer as a reporting tool creating master detail reports, matrix reports from the data marts.

Environment: Oracle 10g, SQL, PL/SQL, Oracle Warehouse Builder, OracleBI Discoverer.

Confidential

System Analyst

Responsibilities:

• Expert in detailed analysis and design for Change requests impact assessment and estimation of the development work for various packages, stored procedures and functions required for the front-end screens developed by a third party.
• Hands-on experience in designing PL/SQL stored procedures and functions common to internal users using Forms and Reports and Web-based users using Java screens.
• Lead integration of back-end packages with the front-end screens developed in Java and designing wrapper procedures wherever required.
• Extensive technical support during the testing of JAVA applications.
• Provided solution for the Active Directory structure creation while creating new driver users.
• Delivered analysis of 55 Change requests amounting to a total of about 645 person days with an overall impact accuracy of more than 90 .

Environment: Oracle 9i, SQL, PL/SQL, PVCS, UML, Active Directories, JAVA 2.

Confidential

System Analyst / Module Leader

Responsibilities:

• Proficient in designing various Forms and Reports and data model for the Change requests. Also impact assessment and estimation of the development work.
• Extensive experience in developing complex stored procedures using TOAD for quote calculations and contract amends as well as back-end overnight batch jobs for price guides and shoppers.
• Lead in the development of stored procedures involving amendment of contracts, modification of Agreements and implementation of these amends for more than 10000 HSBC owned vehicles.
• Expertise in detailed analysis, solution and technical design based on OOP object oriented programming concept of the Data Abstraction Layer PL/SQL packages for Document Management System DMS for a complex and most important functional area called Products. Based on this design other TA members followed the concept and design for other functional areas.
• Ensured the integration of crystal reports with the Data Abstraction Layer.
• Maintenance of the Menu .MMB file using Forms 6i, which also involved user role based access to menu items.
• Involved in creating and maintaining Shell Scripts using Unix/Linux.
• As a Module Leader, responsible for planning, scheduling, and monitoring deliverables and resources.
• Accountable for the functional and technical performance of my team the team comprised 2-4 developers .
• Awarded a Green Belt for successful completion of the Six-Sigma project that involved bringing down the overshooting of targeted person days to 10 in the team.

Environment: Oracle 9i, SQL, PL/SQL, PVCS, Oracle Developer 2000 Forms6i, Reports 6i, Crystal Reports 9, Oracle Designer 2000, TOAD.

Confidential

Senior Developer

Responsibilities:

• Expert in using Oracle Designer and creating table structures, generating SQL scripts and ensuring they are implemented in the database correctly.
• Extensive development experience in complex PL/SQL stored procedures and functions and modularizing them into packages based on the functional requirements.
• Ownership of Change Control Notes, which included all stages of the SDLC from Impact Analysis to Unit Testing.
• Designed and Developed web-based reports using Oracle APEX.
• Hands-on in developing key complex Forms using Designer, Form 6i PL/SQL stored procedures and functions in packages using TOAD creating libraries which would use these procedures/functions attaching these libraries to the correct form deploying the executables at proper locations and testing through menu to ensure integrated working of these modules.
• Expertise in developing Complex batch jobs as stored procedures for Price Guides using PL/SQL packages.
• Maintenance of Repository through Oracle Designer for tables/view/modules. Merging of two repositories into one for more than 20 modules in Designer.
• Expertise in creating and testing medium to complex reports using Reports 6i.
• Proficient in developing complex scripts to load data from input CSV files into various tables based on business requirements.
• Conducting Training functional and technical sessions for the team.

Environment: Oracle 9i, SQL, PL/SQL, PVCS, Oracle Developer 2000, Forms 6i, Reports 6i, Oracle APEX, Oracle Designer 2000, TOAD.

Confidential

Developer

Responsibilities:

• Expertise in generation of Forms using Oracle Designer and linking various pre-defined generic libraries to it.
• Developed new forms and modified existing forms created through Designer using Forms 6i.
• Hands on experience in PL/SQL stored procedures and functions and modularizing them into packages.
• Hands on experience in using Forms 6i creation of generic as well as specific libraries .PLL files and attaching them to various modules .FMB files .
• Demarcating code to be written in libraries .PLL files and PL/SQL packages based on the thin client policy.
• Experience in creation of reports using Reports 6i.
• Creating Unit Test Plans and ensuring the working of these modules Forms and Reports through the Menu.
• Creating SQL scripts for loading data, DDL scripts to be executed in the database.

Environment: Oracle 8i, SQL, PL/SQL, VSS, PVCS, Oracle Developer 2000, Forms 6i,Reports 6i, Oracle Designer 2000, TOAD.