PROFESSIONAL SUMMARY:

• Around 9 years’ experience in Information Technology industry and as a Database developer, Data Modeler and Data Analyst, with multiple domains likeCollection Agency, Logistics & Shipping services, Appliances industry Telecom and Software services.
• An excellent facilitator between Business Clients and Information Technology personnel with effective use of industry’s best business practices.
• Expert knowledge and experience of Software Development Life Cycle (SDLC), including different methodologies such as Agile (Scrum) and Waterfall.
• Worked extensively with different versions of SQL server database as SQL developer and SQL server DBA in Versions SQL Server 2008 R2,SQL Server 2005 and SQL server 2000
• Highly experienced in Data Modeling, well versed with Normalization, DE normalization Process, Logical and Physical data modeling Techniques.
• Strong RDBMS concepts and working experience using database Tables, Views, Stored Procedures and Functions
• Strong understanding in all phases of Software Development Life Cycle such as Development, Testing, Migration and Production support.
• Strong Experience in ER & Dimensional Data Modeling to deliver Normalized ER & STAR/SNOWFLAKE schemas using Erwin r7.2, ER Studio 7.1, EA Studio 1.5.1, Sybase power designer 12.1 and Oracle designer.
• Expert in Designing, Developing and generation of complex Adhoc reports using SQL Stored procedures.
• Knowledge indimensional data modeling - Star Schema Modeling, Snow Flake Modeling.
• Efficient team player with excellent communication skills and interaction with users for Business Requirements.
• Proficient in Data Warehousing concepts including Data Mining using Dimension Modeling (Star Schema, Snow-Flake schema Design and Normalized Structures ).
• Translate business needs into technical requirements and solutions, used Xcelsius for interactive dashboard with radio buttons, Sliders and different charts.
• Quick learner, possess excellent analytical and technical skills, and excellent team player.
• Processes leadership qualities to mentor, guide the team and can work under pressure to meet the project deadlines.

TECHNICAL SKILLS:

Databases & OS: Oracle 10g/9i, SQL Server 2005/2000, DB2 UDB 8.0, Teradata V2R6, Sybase, MS

Access, UNIX, Windows XP/NT

Tools: ERWIN 4.0/7.0, ER/STUDIO 7.x, PL/SQL, INFORMATICA Power Center 8.x/7.x, ToadSQL*Loader, MS DTS, T-SQL,SQL*Plus, ER Studio, Oracle Designer, Sharepoint 2003Teradata FastLoad, MultiLoad, Tpump.

Languages: SQL, PL/SQL, C/C++

Operating Systems: Windows 98/ 2000/NT /XP/VISTA

Project Methodologies: Agile (Scrum), Waterfall.

Other Tools & Utilities: MS SQL Server Management Studio Express MS Visio, MS Office, AutoCAD, MS Project, Adobe Photoshop PS, MS FrontPage, VMware WorkStation

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Sr. Data Modeler/Database Consultant

Responsibilities:

• Liaise with both the business units and the technology staff to identify and implement controls designed to mitigate risks and monitor them for continued effectiveness.
• Met with client groups to determine User Requirements and Goals and converting User Requirements into Technical requirements.
• Created and altered SQL statements before sending database change request to DBA team.
• Maintained and documented all create and alter SQL statements for all releases.
• Interacted with the business users to analyze the business process and gathered the requirements, made necessary changes to schema objects to fulfill their reporting and business needs.
• Identify gaps in agile process, defined and worked with teams to implement solutions.
• Worked on Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using tools like ERwin Data Modeler 4.x, ER/Studio 7.x (ER Studio)- Forward/Reverse Engineered Databases
• Implemented Business Rules in the Database using Constraints & Triggers.
• Converted models from CA ERwin to ER/Studio 7.5 (ERStudio); Developed numerous macros.
• Identified the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Involved incapturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Worked on ETL Design & Implementation - Data Extraction, Transformation & Loading (using Oracle Warehousing Builder, SQL & PL/SQL).
• Effectively communicated with off shore and development team in different locations.

Environment: Teradata V2R6, Oracle 11.2.0/10.1.4, SQL, PL/ SQL, SQL Server 2005/ 2000, UNIX, Toad, Ms office, MS Access. ERWIN 7.6, Power Designer 4.5, Agile (SCRUM) Development Process

Confidential, Piscataway, NJ

Data Modeler /Data Analyst

Responsibilities:

• Coordinated with user to gather the new requirements and worked with existing issues and documented the details and validated from End client.
• Compiled and maintained the Enterprise Schema across all applications. Enforced principles of good canonical data design.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Designed Data Flows & System Interfaces - Service Oriented Architecture (SOA) & Web Services.
• Architected Work Flows, Activity Hierarchy & Process Flows; Design EDW / CDW components.
• Created Metadata Repository, Data Dictionary; Documentation using Interface Diagrams, Flow Charts.
• Worked extensively with the Logistics & shipping department with Database updates and construction and reporting in production.
• Developed reports using MS SQL Server as backend as per user requirements and used Crystal Reports to validate the reports.
• Created complex date objects and filter conditions in universe using Date and CASE functions.
• Created views, triggers and stored procedures using MS SQL server.
• Mentored junior resources and Responsible for production Support and provided to the users.
• Optimized query performance in MS SQL Server by suggesting table indexes on tables for key Business Objects in Universe.
• Worked with data compliance teams, Data governance team to maintain the data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Participated in biweekly technical huddle meeting with development and DBA team. Participated in weekly data analyst meeting and submit weekly data governance status.
• Worked on Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Converted models from CA ERwin to ER/Studio 7.5 (ERStudio); developed numerous macros.
• Involved in Metadata & Data Dictionary Management; Data Profiling; Data Mapping.

Environment: SQL Server 2008/ 2005, Sybase data server 12.5, UNIX, Toad, Embarcadero ER/Studio 7.5 (ER Studio), XML, XSD, AIX

Confidential . Benton Harbor, MI

Data Modeler

Responsibilities:

• Directly interacted with client to gather business requirements and translated them into functional/technical documentation.
• Worked extensively on Design & Implementation of Data Extraction, Transformation & Loading (using SQL*Loader, Informatica& other ETL tools); Analyze Oracle & SQL Server Data & Migration of the same.
• Worked on Reporting (MS Analysis Services / Reporting Services) - Design & implement Analysis adhoc reports & scheduled reports - for ad hoc & canned requirements
• Involved in building Database from the scratch for Financial Billing system and Order processing using analytical data models as source.
• Used MS SQL Server as backend for report generation as per user requirements. Created environment for ad-hoc and Financial/HR canned Reports for treasury management.
• Created complex date objects using date functions on universe to be used on the reports to fulfill client’s Business needs.
• Performed unit testing, system testing and assisted in user acceptances test (UAT) for universe and reports.
• Involved in Metadata & Data Dictionary Management; Data Profiling; Data Mapping; Applied SOA (Service Oriented Architecture) to share master data; Use of CASE tools; Data Analyst/Analysis duties.
• Performed Data analysis - Delivered Normalized, De-Normalized & Dimensional schemas

Environment: SQL Server 2000/ 2005, Sybase data server 12.5, ERstudio 7.6,SSIS, SSRS, SSIS, BIDS, SharePoint 2003, Crystal Reports, Windows XP/ 2000.

Confidential, NYC, NY

Business Objects Consultant

Responsibilities:

• Documented Business/Technical Requirements and Design Templates as per end user requirement.
• Worked with DBA to create table, add columns by providing them SQL scripts.
• Developed detailed reports for the Sales and Marketing department to analyze sales and enable Marketing Team to make informed Decisions.
• Implemented DDL in oracle database.
• Worked with development team to get change request and implement in data model and then database.
• Performed Normalization, Indexes Tuned and Optimized the existing database design.
• Maintained data mapping information and documented properly.
• Performed various tasks that included data massaging, data extraction from flat files, data transformations into various file formats, validations, loading data and checking for any data integrity errors.
• Successfully designed Aggregation tables in the dimensional model data warehouse that were used for running of special Marketing campaigns.
• Defined aggregate SQL functions on measures to improve performance.
• Identified database issues i.e. Chasm Trap and Fan Trap using Multi-Parse SQL.
• Gathered functional requirements and design technical specifications for the Enterprise reporting.
• Imported data from Excel to compare Actual Vs Budget in order to validate the reports generated.
• Documented data dictionary for all version of data models.
• Verified business definitions for table and column and maintained standard physical naming with primary qualifier and class words.
• Worked very closely with end user to implement their needs in data model design.
• Created Conceptual, logical and physical data models which are designed with maintaining data governance and naming standards

Environment: Erwin, Embarcadero ER/Studio 7.5, Micro Strategy, Java / J2EE, SSRS, SQL Server 2000/ 2005, Sybase data server 12.5, UNIX, Toad, Ms office.

Confidential, Fairfield, CT

Database Developer/Analyst

Responsibilities:

• Defined Entities and their attributes with their name and definitions.
• Designed logical data model and populated with all entity and their relationships.
• Worked with developers to transfer logical data model into physical data model.
• Generated DDL from physical data model which was used to create tables in database.
• Used SQL against the database to check data retrieved. Created the joins strategies while designing the universes.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers.
• Interacted with the various users for reporting requirements and provided end user support and problem resolution for various issues related to Database
• Created and modified the existing Stored Procedures.

Environment: Oracle 8i/ 9i, SQL Server 2000, ERwin, UNIX, Windows NT, Crystal Reports, Toad, SQL*Plus, XML, Visio.

Confidential

Oracle Developer/Consultant

Responsibilities:

• Involved in implementation of the complete test cycle for sales order processing system.
• Requirements Analysis and Gathering
• Extensively used Oracle Loader and PL/SQL for ETL.
• Migrated large volumes of ETL data from legacy systems to Oracle database.
• Extensively designed Data mapping and filtering.
• Enhancements and Functional Specifications.
• Consolidation, Cleansing, Integration, ETL, and customization of data.
• Installation and configuration of Oracle Databases and Unix O/S
• Coding using Developer 2000 (Oracle Forms and Reports) as part of the enhancements
• Implementation and Maintenance of client applications
• Unix System Administration
• On-call and Helpdesk support
• Backup and recovery of the databases
• Writing several utilities using PL/SQL, Pro*C, SQL Plus and Shell scripting
• Customizing several MIS reports according to the client’s requirements
• End user

Environment: ETL, Oracle 8.0.5/7.3.4, PL/SQL, Pro*C, Developer 2000 (Forms 4.5 and Reports 2.5), Sun O/S 5.6, TCP/IP, SCO UNIX 5.05, SQL*Loader, SQL*Forms 3.0,Windows NT/98