PROFESSIONAL SUMMARY

• Over 8 years of experience in Enterprise Database and Java Application Design, Development, Testing, Production deployment and maintenance of complex systems.
• Expert in Data Architecture, Data Modeling Data Analysis with high proficiency in requirement Gathering and Data modeling including design and support of various applications in OLTP, OLAP Environment
• Experienced in identifying entities, attributes, metrics, and relationships also assigning keys and optimizing the model.
• Proficient in identifying facts dimensions, star snowflake schemes
• Expert in developing complex transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses utilizing Star Schema and Snowflake models adhering to Kimball and Inmon Data Warehouse methodologies.
• Extensive experience in using ER modeling tools such as ERwin and ER Studio.
• Extensive experience with Normalization 1NF, 2NF and 3NF and De-normalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Involved in the maintenance of the repositories for the metadata
• Experienced in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Proficient in Data Cleansing and Data Profiling based on standards.
• Excellent in SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL.
• Involved in Performance tuning and query optimization techniques in transactional and data warehouse environments.
• Involved in the preparation of Detailed Design Documentation.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC and facilitated JAD sessions.
• Good interpersonal and human relation skills to interact with clients and co-workers

TECHNICAL SKILLS

PROJECTS SUMMARY

Confidential

Sr. Data Modeler/Analyst

The System for Award Management SAM is a Federal Government owned and Operation free web site that consolidates the capabilities in CCR/FedReg, ORCA, and EPLS. SAM is streamlining processes, eliminating the need to enter the same data multiple times, and consolidating hosting to make the process of doing business with the government more efficient.

Roles Responsibilities:

• Involved from initial project initiation phases to identify the scope and releases along with the Project Managers, SMEs and Functional Managers while requirement gatherings
• Analyzed existing systems which are consolidated like CCR, FedReg, ORCA and EPLS
• Performed analysis, reconciliation and integration of all the project data models for different Subject Areas in order to produce conceptual data model
• Analyzed and designed Data Models ,Technical Database design Documents, Interface specifications
• Worked on Normal Forms and Relational data model techniques to create the project Logical and Physical Data Models
• Worked with Functional managers to validate the data models and to get the signoffs
• Developed and implemented strategies and methodologies in support of Master Data Management initiatives.
• Responsible to conduct meetings with customers and coordinating the teams to integrate the different modules of Migration to meet the timelines
• Gathered and maintained accurate metadata in ERwin models and project related documents in centralized shared folders.
• Participated with key management resources in the strategic analysis and planning requirements for Data Warehouse/Data Mart reporting
• Preparing the Modeling standards for Logical and Physical data Modeling Class words, Audit and Business Effective columns
• Involved and attending the meetings with customers to identify and finalize the new release activities
• Providing the solutions for issues happened during project execution
• Developed Data dictionary and maintained Metadata for each model.

Technologies: ERwin 9.x, Clover ETL, Oracle 11G, Microsoft Excel, Sql Developer.

Confidential

Sr. Data Modeler

This project is to keep track of the outages occurred in a network. Outages in a network are identified using the alarms generated by Nodes in the network. In addition, some component correlation tables are used for calculating the Network Outage.

Roles Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution
• Gathered and translated business requirements into detailed, production-level technical specifications, added new features and enhancements to existing technical business functionality
• Involved in gathering user requirements along with Business Analyst
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Extracted data from the databases Oracle and SQL Server using Informatica to load it into a single data warehouse repository
• Created data mapping documents from source to target systems
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part of Data Analysis responsibilities
• Identified and processed the facts and dimension tables
• Worked with report developers for building Data Marts for ad hoc reporting
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation phase
• Assisted end users, operations and testing teams by providing them with the necessary documents

Technologies: ERwin r7.1, Informatica 8.x, Windows, Linux, SQL Server 2000/2005, SQL, Oracle 10g, MS Excel, MS Visio.

Confidential

Sr. Data Modeler

A Trouble Ticket is defined as the official method used by the Customer to advise Company of a perceived Network Outage. This project is used to track the detection, reporting and resolution of the problem in the network.

Roles Responsibilities:

• Analyzed business process and gathered core business requirements
• Created the data model structure and Star Schema modeling with all related entities and relationship with each entities based on the rules provided by the business manager using Erwin.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures and report requirements that are consistent across all application and systems.
• Extensively worked with ETL Development team to load data from multiple sources to Staging area Oracle 11g using Informatica Power Center.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Involved in identifying the bottlenecks and tuning to improve the Performance.
• Postproduction support and ensure documentation delivery to Function and Technical teams.

Technologies: Erwin, SQL-Server, Oracle, Informatica Power Center, Linux

Confidential

Java Developer/Analyst

HAPS is an application to migrate an existing application in mainframe to Java. The loader module of this application loads the transactional data into a summary table in Oracle from which the Aggregator module performs all the required arithmetic logic and populates the Daily Flash DB2 tables. The UI then draws the data from these tables to display on the corporate statistics web pages.

Roles Responsibilities:

• Provided technical guidance to business analysts, gathered the requirements and converted them into technical specifications/artifacts.
• Developed Stored procedures, Triggers and Functions to process the trades using PL/SQL and mapped it to Hibernate Configuration File and also established data integrity among all tables sitting on Oracle Database.
• Designed and developed Customer registration and login screens using JSP, HTML/DHTML and JavaScript.
• Developed web pages to display the account transactions and details pertaining to that account using JSP, DHTML, AJAX and CSS.
• Wrote application front end with HTML, JSP, Ajax, custom JSP tags for role-based sorting and filtering and used JavaScript validations to validate the fields of the user registration screen and login screen.
• Servlets are used to service requests from UI to manipulate Business Objects and invoke respective Action Classes for making database updates.
• Followed Agile Methodology TDD, SCRUM to satisfy the customers and wrote JUnit test cases for unit testing the integration layer.
• Involved in implementing Branching Methodology Plan and performed Check-in/Checkout in Subversion.
• Developed various activities like transaction history, search products that enable users to understand the system efficiently.
• Involved in unit testing and system testing and also responsible for preparing test scripts for the system testing.

Technologies: J2EE, J2SE, Core Java, JSP, Servlets, JDBC, JavaScript, Tomcat, Oracle.

Confidential

Java Developer

Teller application will be a desktop application and will be used by Bank Employee. This application will perform all core banking related functions and also interact with other services either using Web services or certificate exchange.

Roles Responsibilities:

• Gathered requirements for this project.
• Involved in Analysis of the requirements.
• Involved in developing the UI using Java Swing.
• Development of Prototype Plugins in ECLIPSE RCP.
• Used JDBC and developed DAO classes to connect to the Database.

Technologies: Java, JDBC, Oracle, Eclipse RCP