SUMMARY:

• More than 9 + years of experience in Information Technology on ORACLE and Data modeling for OLTP / OLAP systems.
• I was involved in preparation of Test plan, Preparation of Test cases, Functional testing System Testing, Black box testing, White box testing, Integration Testing, Production testing.
• 5+ years of experience in Data modeling (relational, dimensional and hierarchical).
• 2 + years of experience in providing production support.
• 2+ years of experience of teaching Data ware house concept in University of Michigan.
• 2+ years of experience of generation of ER Models with ER Studio.
• 2+ years of experience of generation of UML diagram.
• 2 + years of experience of object oriented programming using C++.
• Team Management, review on the work done by team members and guidance to achieve optimum standard.
• Participated in Business Requirement Analysis, extracting High level Test scenarios.
• Involved in Test Estimation, Test planning, Test strategizing and Test approach phases.
• Good understanding of Software testing life cycle (STLC).
• Expertise in creating relational database development, for creating complex database queries, writing Constraints, Indexes, Views, Packages, Stored Procedures, Cursors and Functions using PL/SQL in Oracle databases (8i, 9i, 10g, and 11g).
• Implemented PL/SQL advanced topics like Bulk Collects, Bulk Inserts Ref Cursors, Collections, Dynamic SQL, Autonomous transactions, Table Partitioning and External tables.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Skillful in working with the tools like SQL * PLUS,TOAD
• Good experience in data modeling using Erwin Data Modeler: Creating entities, relationships, sub - types, schemas and ERD to database schemas.
• Good experience in Software Engineering Processes (Agile and Waterfall Methodologies). Development of software project based on users’ requirements and meeting deadlines to satisfy users' needs.
• Hands on experience in project management tools like VSS, ASANA, Microsoft project
• Strong Technical & Analytical Skills, willing to share, investigate, learn, work hard, and thinks from a user perspective and to work in cutting edge technology with strong relationships with colleagues, clients and vendors in functional and technical areas, proactive and open-minded.
• Managerial Activities: Project planning and scheduling, Project Management and Task Allocation to Team, Project team meeting & Performance reviews, Effort Estimation, Performing & establishing Quality Management process for Project, Client coordination for the project including status meeting, Manage Knowledge Transfer Process and induction plans, Knowledge Management and best practices, Reviewing deliverables for ensuring quality and trace ability, Team Building
• QA Activities: Preparation of Test plan, Preparation of Test cases, Functional testing, System Testing, Black box testing, White box testing, Integration Testing, Production testing.

TECHNICAL KNOWLEDGE:

Technical: Oracle 12c/11g/10g/9i/8i, Oracle Form Builder 10g

TOTAL WORK EXPERIENCE:

Confidential, Dallas, TX

Data Modeler + PL/SQL Developer

Responsibilities:

• Interacted with the business users on regular basis to consolidate and analyze the requirements.
• Identified, formulated and documented detailed business rules and use cases based on requirements analysis, Involved in multiple projects with different business units. .
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.
• Creation of Conceptual, Logical and Physical data models for OLTP and OLAP systems
• Data Mart design using dimensional data modelling techniques
• Analysis of database requirements with the project stakeholders
• Design and build of ETL processes
• Capacity planning for database servers
• Design lots of Use cases for Enterprise Applications.
• Design UML for Enterprise Application using Zachman framework.
• Created lots of procedure, package, and functions.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Created the index for increasing the performance of data conversion process
• Performed Unit Testing, Integration Testing and Performance Testing.
• Load the data from Excel file to oracle database.
• Done Configuration Management using VSS and GIT.
• Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
• Prepared and updated design specifications.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
• Created lots of SQL script for ETL Process.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Created Oracle Materialized Views.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Generation of ER Models with ER Studio
• Created lots of UNIX shell script to automate the process.
• Experience in writing shell scripting for various ETL needs
• Design and development of UNIX Shell Scripts to handle pre and post session processes.

Environment : Erwin 9.6, Oracle 12c/11g, MS Access 2003, MS Excel, TOAD, Microsoft Office,tableau, Business Object, qlikview, Advanced JavaScript

Confidential

Data Modeler + PL/SQL Developer

Responsibilities:

• Responsible for re-designing the existing Confidential Database to in corporate product enhancements
• Establish Data Modeling standards and best practices.
• Design lots of Use cases for Enterprise Applications.
• Design UML for Confidential .
• Involved in designing OLAP data models extensively used slowly changing dimensions (SCD).
• Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
• Experience in BRD development and technical document writing
• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
• Normalized the data up to 3rd Normal form.
• Defined processes for Product DB installation, Product DB Version upgrades and Product DB enhancement rollout
• Conducted Data Architecture (DA) Audit for Confidential Product Database and identified critical database issues that affected the performance, integrity and scalability of the application
• Created data dictionary and the logical data model for the Confidential database
• Helped the Product engineering Team in prioritizing the application enhancements necessitated based on the finding from DA audit
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic.
• Developed mappings, sessions and batches for relational & flat file sources and targets. Loaded data into target database from sources using Workflow Manager.
• Created detailed data specifications document which is a source for ETL team.
• Supported ETL team in understanding rules for loading data into data mart.
• Designed Data migration process using ETVL (Extract, Transform, Validate and Load)
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
• Used Analytic functions, Decode, case statement while writing complex SQL queries.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
• Exported the database and imported the same into development and test environment whenever required.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Data modeling (relational, dimensional and hierarchical).

Confidential

Data Modeler +PL/SQL Developer

Software: Oracle 12c/10g/9i, SQL and PL/SQL, Proc *C, UNIX, PERL, Toad,Oracle forms, Sql Developer, MS SQL 2005/2008, MS Excel, MS Word, IIS 8.5, Visual Studio 2015, .NET C#, WCF, WPF, WF, MS SQL 2012, MS-Office, Razor framework, ASP.Net MVC 3.5, Windows Services, UCMA 4.0, Lync Server SDK, Advanced JavaScript, MMC basics and Power shell, SQL Stored Procedure, tableau, Business Object, qlikview

Hardware *: WINDOWS98/NT/2000/XP, Solaris 5.8, UNIX, and Linux, WINDOWS 2012 Server

Job Responsibilities:

• Discuss with Business stakeholder, Provider Contract negotiating Team and Confidential Architect Team to understand the functional and non-functional business requirements
• Understand the data requirement for Confidential provider of the e-visit claim.
• Design datamart for modeler application to generate reports based on the e-visit using dimensional data modeling.
• Create conceptual, logical and physical data models for the Modeler datamart
• Design ETL process architecture, to get historical claims from the data warehouse and load in the modeler datamart.
• Create Data dictionary for the Data Model
• Perform capacity planning and handover the Physical Data Model to the Confidential DBA Team to create the Physical Database
• Review the Data Model with Confidential Data Architect Team and obtain Data Model signoff
• Conduct knowledge sharing session with the Development Team
• Participated in creating the logical model of an online processing system for a large claim system using Erwin9.6.
• Worked with DBAs to generate physical model.

Confidential

Data Modeler + PL/SQL Developer

Software: Oracle 12c/10g/9i, SQL and PL/SQL, Proc *C, UNIX, PERL, Toad, Oracle forms, Sql Developer, Informatica 9.6.1, Advanced JavaScript

Responsibilities:

• Team lead - Allocated tasks, Performed System integration testing, generated Daily Status Report, Monthly status report and Test summary report.
• Involved in ETL Process Validation for data completeness, data correctness and data transformations according to the requirements.
• Worked with Sr. Architects/Lead Developers to set up the design of all ETL mapping to load it to EDW as target systems.
• Responsible for setting up ETL functions in PL/SQL using stored procedures, packages for aggregation and summations.
• Performed Positive and Negative Testing Manually.
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.
• Had a strong working experience in Extract/Transform/Load (ETL) design and implementation in areas

Confidential

Data Modeler + PL/SQL Developer

Responsibilities:

• Team lead - Allocated tasks, Performed System integration testing, generated Daily Status Report, Monthly status report and Test summary report.
• Unit testing the developed code and providing support during integration testing
• User Acceptance testing support
• Design use cases for Specialty Sales Tax system.
• Design UML for calculation of Sales Tax for Sales Tax system.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models
• Compare data with original source documents and validate Data accuracy.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Worked on ER STUDIO to create data models.
• Working with business user and sorting out their issues faced in the application, monitoring the interface jobs, working on bug fixes in the business layer and the database layer, resolving claims and provider issues.
• Business Rules and Correspondence support.
• Working with Business to find the difficulties faced in the application and strategizing solutions for the same.
• Creating Oracle tables, views, packages & procedures.
• Developing new forms and new reports using Oracle forms and Reports.
• Customizing and optimizing existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Writing the database triggers and using Dynamic SQL in oracle Forms and Oracle Reports.

Confidential

Data Modeler +PL/SQL Developer

Software *: Oracle 11g, Clear case, Clear quest, Toad 9.5, PLSQL Developer 7, Java, HTML Oracle forms, Sql Developer, MS SQL 2005/2008, MS Excel, MS Word

Hardware *: WINDOWS98/NT/2000/XP, Solaris 5.8, UNIX, and Linux

Responsibilities:

• Involved in creation of Low Level Design including sequence diagrams and class diagrams to understand the existing architecture.
• Understanding of the Functional specifications, based on that prepared design documents.
• Extensive analysis to find the issues present in the existing financial planning sources. Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community
• Analyzed on what enhancements needed on the source systems.
• Experience in BRD development and technical document writing
• Designed new financial planning data mart to make the data available in the required format.
• Had working sessions with finance users to understand the grain for each subject area.
• Worked with business users to validate the reference data.
• Created detailed data specifications document which is a source for ETL team.
• Supported ETL team in understanding rules for loading data into data mart.
• Developing highly complex applications using Oracle 10g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL
• Using concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables
• Analyzing business requirements, preparation of source-target mapping documents, conduct unit testing and code walkthroughs to ensure there are no missing elements, and perform integration testing
• Handling code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest
• Using existing processes and procedures for application deployment and provided 24x7 production support as Primary
• Tuning of Queries, Packages using Oracle utilities Explain Plan, DBMS Prof.
• Developing procedures using native dynamic SQL ( Confidential ), dynamic SQL, Ref cursors.
• Developed the different components of application such as JSPs, Servlets and used VSS and GIT for version control.