SUMMARY

• Around 6 years of experience in the field of Database Administration, Design, Development and Implementation of business applications such as OLTP, OLAP, Data warehouse with Proficiency in Oracle 8i/9i/10g/11g, SQL, PL/SQL.
• Good knowledge and experience in Software Development Life Cycle (SDLC), involving Requirements Analysis, Design, Development, Implementation, Deployment, Maintenance and Testing.
• Experience in developing advanced PL/SQL code using packages, stored procedures, functions, collections, cursors, triggers, and materialized views.
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in writing DDL, DML commands.
• Created ad hoc reports to users in Tableau, a data mining tool which is used for data visualization by connecting various data sources.
• Mining various data sources and providing visualization and analysis of complex data structures.
• Experience in using Visual Studio for GUI applications and Windows Forms applications.
• Extensive experience in BI process using tools like Cognos, and Crystal Reports
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Experienced in conducting JAD Sessions and giving Presentations about the project progress.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team and self-motivated.

TECHNICAL SKILLS

Databases: Microsoft SQL server 2005/2008, Oracle 8i/10g/ 11g, DB2

Data modeling tools: Erwin, Sybase Power designer and Oracle Designer

Oracle Tools: TOAD, SQL Developer

ETL Tools: SQL*Loader, Informatica, Data Stage

Reporting: Cognos 8, Crystal Reports

Languages: SQL, PL/SQL, JAVA, HTML, XML

Other Tools & Packages: VMware, Rational Rose UML, MS Office suite

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Dover, NH

Data Modeler/ Data Analyst

Environment: Oracle 11g, SQL, PL/SQL, Linux, SQL Developer, Sybase Power designer, SQL* loader, ERWin

Responsibilities:

• Involved in the entire life cycle of the project starting from requirements gathering to end of system integration.
• Interacted with the client for business requirements gathering. Worked with MS Access.
• Identified the Entities, attributes and designed a relational database system (RDBMS).
• Worked with DBAs to create a best fit Physical Data Model from the Logical Data Model using ERWin.
• Performed Reverse Engineering of the legacy application using DDL scripts in ERwin, and developed Logical and Physical data models for Central Model consolidation.
• Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Used reverse engineering for a wide variety of RDBMS, including MS Access, Oracle and Teradata to connect to existing database and create graphical representation using Erwin.
• Used Sybase Power Designer in designing the data models.
• Developed PL/SQL Procedures, Functions, Cursors, Packages, Views and Materialized Views
• Used SQL Loader, external tables and import/export toolbar to load data into Oracle
• Unit testing the PL/SQL code. Made necessary database structure changes for OLTP as per business requirements
• Used indexes and hints to improve performance of SQL queries.
• Used data Normalization techniques
• Investigate and resolve code and data issues related to ETL processes. Resolved priority production support issues and defect fixes in PL/SQL.
• Designed mappings using Informatica coming from different sources like databases, flat files into oracle staging area.
• Developed the Data warehouse model (star schema) for the proposed central model for the Project.
• Monitoring and optimizing the performance of the database
• Involved in development and maintenance of copy program that merges data from source database to operational database.

Confidential, York, PA

Data Modeler

Environment: Erwin, Datastage, DB2, UML, SQL server 2005, Sybase power designer, Linux, T-SQL

Responsibilities:

• Engaged in business process modeling using UML through Rational Rose. Produced Logical Data Models/Physical Data Models.
• Created the calculations based on the reporting needs and the source data available
• Recognized source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Involved with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using ERwin tool.
• Created Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Formed data mapping documents between Legacy and User Interface Systems.
• Worked closely with Tableau reporting users to provide/design the ad hoc reports.
• Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports
• Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Formed mappings in Informatica to load the data from various sources includes SQL server, DB2, Oracle, Flat files into the Data Warehouse, using different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.
• Used SQL Server Reporting Services (SSRS) for database reporting in Microsoft SQL server 2005.
• Performed User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Produced the documentation of Data Acquisition and Interface System Design.

Confidential

SQL developer/ Data Modeler

Environment: Oracle 8i/10g, Oracle Designer, PL/SQL, SQL* Loader, UNIX, Crystal Reports, SQL server.

Responsibilities:

• Installed and configured SQL Server.
• Designed and developed the databases.
• Created a logical design and physical design of the central relational database.
• Produced Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Developed and modified PL/SQL code to make new enhancements, resolve issues as per the requirements
• Provided production support and maintained data.
• Maintenance of production database and development database which includes table space management, user creation, privileges, roles etc.
• Developed PL/SQL functions, stored procedures, cursors, triggers, packages
• Created PL/SQL procedures using REF Cursors, used in developing reports.
• Used SQL* Loader and PL/SQL stored procedures for data conversion processes.
• Created Tables, views, triggers, and indexes.
• Maintained security and data integrity of the database.
• Developed several forms & reports using Crystal Reports.
• Designed database structures for effective data extraction, validation and error logging
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes.