EXPERIENCE SUMMARY:

• Over 9 years of experience in the field of Information Technology with expertise in Data warehouse architecture, Data Modeling and Business Process Designing.
• A diversified spectrum of Data Management & Data Modeling experience in support of Enterprise OLTP applications and Supporting OLAP in Health and Life Insurance, Finance and CRM domains.
• Expert at gathering Business requirements by organizing and managing meetings between clients, third party vendors, development teams and analysts on a scheduled basis..
• Experienced in designing conceptual, logical and physical data models using ERWIN/ER Studio.
• Implemented MDM strategy to maintain consistent, complete, accurate business data for all stakeholders.
• Well versed with different ETL tools including Informatica power center, SSIS, Abnitio.
• Managed full SDLC processes: requirements management, workflow analysis, source data analysis, data mapping, metadata management, data quality, testing strategy and maintenance of the model.
• Involved in creating Enterprise data dictionary and data standards to ensure data quality and consistency.
• Experienced in optimizing performance in relational and dimensional database environments by making proper use of Indices and Partitioning techniques.
• Expert at advance data modeling concepts like Conform Dimensions and facts, Bus Matrix Architecture, family of stars schemas, change data capture, Degenerated dimension, Fact less fact table, Aggregate fact tables, slowly changing dimensions, Snowflake schema to handle complex scenarios in data modeling.
• Having rich knowledge and experience in Oracle PL/SQL, Oracle Application Development Framework (ADF) and Oracle Application Express (APEX)
• Extensive experience in analysis, design, development & maintenance of Oracle 9i/10g/11g database objects, SQL, broad experience in PL/SQL programming, effective use of Oracle packages, stored procedures, database triggers, database cursors, and tools like SQL*Plus, PL/SQL Developer, Toad
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications
• Building data migration/ DDL/ DML scripts to move data between difference environments
• Experience in Error handling and debugging coding issues and troubleshoot production problems
• Excellent team leading experience
• Comprehensive knowledge of performance enhancing tools in Oracle like SQLTrace, Explain Plan, TkProf, different types of optimizer hints, indexes, autonomous transactions and bulk processing
• Experience with file loading using SQL Loader & file manipulation using in - built packages like UTL FILE
• Familiar with the features enchantments in Oracle 12c
• Having experience on writing UNIX shell scripts
• Experience in Performance Tuning & Optimization of SQL statements
• Creating Business Components, Data Controls, Task Flows, Layouts & Rich Faces Components in ADF
• Proficient in development using APEX, creating forms and reports
• In-depth knowledge of Software Development Life Cycle (SDLC) methodology and project life cycle processes like Agile, Waterfall
• Knowledge of working on Windows XP, NT, 2000, 98, UNIX, Linux

TECHNICAL SKILLS:

RDBMS: Oracle 11g, 10g, 9i

Programming Languages: Oracle PL/SQL, SQL, UNIX Shell Scripting, ADF, Application Express

Database tools: SQL*Plus, SQL Developer, TOAD, PL/SQL Developer, SQL Loader

Operating Systems: Windows, UNIX

Domain Knowledge: Finance, Banking, Chemical, Telecom, ERP (Supply Chain module)

Applications: JDeveloper, IFS ERP Application 7.5, Centura

Configuration Management: SVN

Project Management Tools: MS-Office

Project Lifecycles: Software Development Life Cycle (SDLC), Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, DALLAS, TX

Sr. Data Modeler

Responsibilities:

• Coordinated with the Business analyst and DBA for Data Element gathering and creating data model.
• Resolved the revolving issues by conducting and participating in JAD Conducted design discussions and meetings to come out with the appropriate data mart.
• Developed the Star Schema for the proposed warehouse model to meet the requirements.
• Enforced mandatory capture metadata during the logical phase design.
• Identified the objects and relationships between the objects to develop a logical model in ERwin and later translated the model into physical model using Forward Engineering.
• Defined and processed the facts and dimensions.
• Created mapping documents using the Metadata extracted from the Metadata repositories.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Worked with Master Data Management Team to get element / Model level
• Coordinated with other data modelers at offshore location.

Environment: SQL, SQL Server 2000/2005, Oracle 10g, Erwin r7.3, Windows XP, MS Visio

Confidential

Sr. Data Modeler

Responsibilities:

• Studied in-house requirements for the Data warehouse to be developed
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Responsible for Model Reviews at AMFAM Data modelers meetings.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Developed a Conceptual, Logical model using ER Studio based on requirements analysis
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts using ER Studio
• Facilitate creation/migration ofdataobjects (DDL) across Development /QA/Production
• Worked on onshore-offshore model
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Created Billing CSA and Data Mart from scratch
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Responsible for defining the naming standards for data warehouse
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 database systems
• Exhaustively collected business and technical metadata and maintained naming standards
• Used ER studio for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges
• Responsible for Modifying/Upgrading Dynamic Data Mode provided by Guidewireas per Amfam Standards
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation
• Created OLAP data cubes, to show dimensions and reporting formats that would be identical to the applications client would be using
• Responsible for updating Enterprise data dictionary provided by guidewire

Environment: ER Studio 8.1,WinSQL Informatica 7.1.3, Windows XP/NT/2000, Oracle11g,DB2, MS Excel, Agile. Guidewire

Confidential, Eagan, MN

Senior Data Modeler

Responsibilities:

• Gathered complete business and technical requirements byorganizing and managing meetings with Business Analysts (BA’s), Technical Assistants (TA’s), Data Stewards, and Subject Matter Experts (SME’s)on a regular basis.
• Designed and Implemented CMR layer i.e. Operational Data Store in third normal form in Teradata for both Claims and Utilization management.
• Conducted design review meetings with business and SME have to verify the conceptual models.
• Designed and maintained theLogical /Physical Dimensional Data modelsfollowed by generating the DDL statements and physically running them in both test and dev environments for physical creation of tables in Teradata using Erwin 8.2.
• Collected statistics on Non unique indexes and Non Index join columns to get better costs and better plans.
• Worked with ID leads to define and build business facing semantic layers and views.
• Maintained metadata and models for custom data structures current within the metadata repository.
• Performed intensive data profiling and reverse engineered various already existing databases in order to discern the necessary data relationships underlying general and specific information needs and insured that resulting data deliverables support information delivery objectives.
• Developed Source to Target mappings for ETL support.

Environment: Teradata, Erwin 8.2, Power Designer, Oracle 10g, DB2, WinSql, IBM Lotus Notes, Informatica, Windows XP

Confidential, Oakland, California

Data Modeler

Responsibilities:

• Involved in facilitating work sessions and gathering requirements from business users..
• Analyzed different disparate Sources like Reflex, PeopleSoft, SQL Server, Oracle and Flat files from which member, policy, claim, header, claim, premium, deductible, recovery and understand the relationships.
• Performed Extensive data profiling that need to be brought into ODS from their claims processing system called Case Management System.
• Created process documents, reporting specs, design specs and slideshow presentations for the application development teams and managements.
• Created Kaiser Enterprise Wide Data Dictionary by interviewing Subject matter experts, Business Analysts, Data steward in order to come up with standards that can be used consistently over enterprise.
• Created High Level design of all the business processes that helped technical team in understanding.
• Extensively used extensively PL/SQL and T- SQL for analysis of data coming from disparate source systems.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in Multidimensional model.
• Worked on specifications given by Data governance team and Data quality team that required managing the master data from all the business units as well as from IT and ensuring data quality across the enterprise.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Applied concepts of Degenerated dimension, sub-dimension, Fact less fact table, Aggregate fact tables in Multidimensional model, rapidly changing dimensions, Snowflake schema.
• Resolved Multi valued dimensions by placing a bridge or associative entity between dimensions

Environment: ER Studio 6.0, Oracle 8i, SQL Server 2000, PL/SQL, PeopleSoft V8, Toad, Informatica Power Centre 6.0, Case Management System, Business Objects

Confidential, Dover, NH

Data Modeler

Responsibilities:

• Analyze the OLTP Source Systemsand Operational Data Store and research the tables/entities required for the project. Designing the measures, dimensions and facts matrix document for the ease while designing.
• Designed and maintained theLogical /Physical Dimensional Data modelsand generating the DDL statements and working with the Database team in creating the tables, views, keys in the database.
• Used SSIS as an ETL tool and SSRS for generating reports.
• Tuning theSQL and Transact SQLqueries, as required and created the PL/SQL Stored procedures, Indexes, Views.
• AppliedMaster data managementtools for managing the non transactional data entities of the organization to ensure data consistency and for controlling the ongoing maintenance and the application use of the information.
• Validate the models with the production data and developed theSTT (Source to Target) mapping matrix, an expert solutions to design and develop the mappings for the loading of data, to the ETL developers

Environment: Erwin r7.1, Informatica 7.1.3, Windows XP/NT/2000, SSRS, SQL Server 2000/2005, Teradata, Oracle10g,DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro

Confidential

Analyst

Responsibilities:

• Understanding business requirements & developing solutions for the same using oracle PL/SQL and SQL
• Preparing complex queries to meet various publication criteria
• Creating DDL/DML scripts
• Tuning SQL queries to improve the performance
• Generating publication data and export it
• Proven abilities in spearheading in standardization & automation of processes
• Identifying process improvements and provide automation for the same
• Interacting with the client team located in US to get the project requirements, clarifying doubts and developing efficient solutions
• Highly involved in imparting across the department
• Prepare the publication report and get it reviewed by onshore team in US
• Provide continuous support to onsite team
• Participating in team building activities

Environment: Oracle11g, SQL*Plus, TOAD

Confidential

Software Executive

Responsibilities:

• Getting the requirements from the clients and preparing the requirement documentation
• Implementing the solution using oracle PL/SQL as per the requirements
• Exporting/ importing data
• Creating tablespace, importing the data and validating the schema objects
• Single point of contact for communicating business requirements and enhancements from client to development team
• Deploy changes to UAT/production environments
• Visit client location for support
• Provide on call support after office hours
• Provide various reports during the year end period

Environment: Oracle9i/10g, SQL*Plus, SQL Developer, TOAD, UNIX