SUMMARY:

• Over seven years of professional experience in data modeling, designing, and data analysis wif Conceptual, Logical, and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Extensive experience in the Data Warehousing implementations for Retail, Financial, Insurance and Banking Industries
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 7.0/4/0, Power Designer, Embarcadero E - R Studio and Microsoft Visio.
• Experience working on creating models for Teradata master data management.
• Experience in handling business and technical issues & communicating wif both business users and technical users
• Strong understanding of dimensional and relational modeling techniques. well versed in Normalization / De-normalization techniques for optimum performance in relational and dimensional database environments
• Experience wif Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration
• Experience in developing transactional enterprise data models which meet the normalization rules strictly and understanding of enterprise data warehouses by using Ralph Kimball Data warehouse methodologies.
• Involved in implementing the Referential Integrity by using Primary and Foreign key relationships
• Good Knowledge in designing the data marts using Ralph Kimball's and Bill Inmon Dimensional Data Mart Modeling techniques
• Well versed wif the concepts of Forward Engineering and Reverse Engineering for the existing databases for the Conceptual and Logical/Physical models using Erwin tool
• Involved in implementing the Referential Integrity by using Primary and Foreign key relationships
• Good Knowledge in designing the data marts using Ralph Kimball's and Bill Inmon Dimensional Data Mart Modeling techniques.
• Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
• Good Knowledge on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for implementing the business techniques.
• Excellent analytical and communication skills wif clear understanding of business process flow, SDLC life cycle and facilitated JAD/JAR sessions
• Quick learner, self-motivating and enthusiastic to work wif new technologies. Good team player and has strong ability to work under high stress environments.
• Strong communication, organizational and interpersonal competencies along wif detail-oriented and problem solving skills in the technology arena

TECHNICAL SKILLS:

Data Modeling Tools: Erwin Data Modeler, Rational Rose 2000, ER Studio

Reporting Tools: Oracle Reports, Business Objects, Crystal Reports 2008

Databases: Oracle7/8i/9i/10g/11g, MS SQL Server2000/2005, MS Access, Teradata, DB2

Operating Systems: Windows NT, 2000 & XP, Vista, UNIX

Languages: SQL, PL/SQL, T-SQL, HTML, C, XML

Others: MS Office, TOAD, SQL Navigator

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Sr. Data Modeler

Responsibilities:

• Worked wif Business Analysts team in requirements gathering and in preparing functional specifications and translating them to technical specifications.
• Extensively involved in developing logical and physical data models that fit in exactly for the current state and the future state data elements and data flows using Erwin
• Defined the key columns for the Dimension and Fact tables of both the Warehouse and Data Mart
• Interacted wif the End users frequently and transferred the knowledge to them
• Conducted and participated JAD sessions wif the Project managers, Business Analysis Team, Finance and Development teams to gather, analyze and document the Business and reporting requirements.
• Worked wif Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards.
• Conduct Design discussions and meetings to come out wif the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved
• Designed a STAR schema for the detailed data marts and Plan data marts involving shared dimensions (Conformed).
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Conduct Design reviews wif the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Collaborated wif the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating wif various teams to decide on the appropriate action to be taken.
• Explained and guided Front end Developing team on the database architecture and built objects for effectively accessing the database.
• Maintain change log and history tables for each data model and solved the production issues by debugging the code.
• Performed Data Validation and Unit Testing before handing over the data for production and Quality Testing.

Environment: Oracle 10g, PL/SQL, Erwin 7.2, Microsoft Excel, MS Word, Power Point, TOAD for Oracle Version 8.6.0.38, and SQL developer for Oracle

Confidential . Somerset, NJ

Data Analyst

Responsibilities:

• Responsible for project management, logical and physical OLTP database and data warehouse modeling, ETL mappings, data analysis and integration, XML schemas, and functional and technical specifications
• Implemented and maintaining DR strategy for BCP-DRP (Business Continuity Plan - Disaster Recovery Plan)
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy
• Optimized and updated logical and physical data models to support new and existing projects
• Designed XML layouts and data movement strategies in compliant to ACORD standards
• Implemented Referential Integrity using primary key and foreign key relationships
• Maintained conceptual, logical, and physical data models along wif corresponding metadata
• Created Mappings for Type2 and slowly changing dimensions for updating and inserting of records and in turn maintaining history
• Provided the means of system integration by understanding the source and target data and built the data mapping
• Maintained high-level data architecture documentation, which illustrates the source and destination of data to and /or from approved data sources
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models
• Recommended opportunities for reuse of data models in new environments
• Performed reverse engineering of physical data models from databases and SQL scripts
• Evaluated data models and physical databases for variances and discrepancies
• Examined new application design and recommended corrections wherever required
• Involved in logical and physical database designs and data mappings between cross functional application and used SQL queries to filter data.
• Performed Data Analysis for building the reports and building Enterprise Data warehouse(EDW)
• Defined timelines for project delivery and provided the status update to the client team on a regular basis
• Created entity/process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams
• Interacted wif ETL developers for making them understand the movement of required data
• Assisted wif project and problem analysis, effectively communicated wif management and adhered to firms policies and procedures

Environment: Erwin 7.2, SQL Server 2008, DB2, Microsoft Access, SQL Server 2000, MS PowerPoint, MS Access, Lotus Notes, Microsoft Excel

Confidential, New York, NY

Data Modeler

Responsibilities:

• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project
• Coordinated wif DBA on data base build and table normalizations and de-normalizations
• Understanding clients’ information needs, business objectives, and market sectors and implementing appropriate data analysis strategies
• Recognized and extracted critical indicators from large and complex data sets and interpreted and expressed those indicators in the business context
• Designed and maintained processes for measurement, tracking, reporting, and analyzing traffic and user experience
• Maintained the quality of data analysis, researched output and reporting, and ensured that all deliverables met specified requirements
• Communicated directly wif clients to clarify requirements and present research findings and ensured clients received coherent service
• Developed SQL and PL/SQL scripts to perform data cleansing and PL/SQL procedures to populate date and time dimensions
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process
• Created mapping specification spreadsheets to document the transformation logic
• Worked wif Model Manager and multiple data marts, involving multiple subject areas simultaneously, domains and Naming Standards
• Coordinated wif Business Analyst and designed logical and physical data models as per the requirements
• Conducted and participated in JAD sessions wif the project managers, business analysis team, finance and development teams to gather, analyze, and document the business and reporting requirements

Environment: Oracle 9i/10g, MS SQL Server, DB2, Oracle SQL Developer, PL/SQL, Business Objects, Erwin, MS office suite

Confidential, Lakewood, NJ

Data Analyst/Data Modeler

Responsibilities:

• Gatheird and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Developed project plan wif project manager’s assistance for the first two phases of the project.
• Developed system flow and data flow diagrams for the proposed system.
• Designed conceptual and logical data models.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering in Erwin tool.
• Normalized the tables up to 3NF.
• Involved in the critical design review of the finalized database model.
• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Involved in designing and implementing the security for the databases.
• Helped in migration and conversion of data from the Sybase database into Oracle 10g database, preparing mapping documents and developing partial SQL scripts as required.
• Created stored procedures, functions, database triggers and packages as per the business needs for developing adhoc and robust reports. Incorporated Dynamic SQL, for generation of the where clauses dynamically based on the lexical parameters passed.
• Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing PERL shell scripts & SQL*Loader.
• Involved in the daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Environment: Oracle Database 10g, SYBASE, Linux, Windows XP, Erwin, TOAD, SQL*PLUS, SQL*LOADER

Confidential

Data Analyst/Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created a logical design and physical design in ER/STUDIO.
• Maintained security and data integrity of the database
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Participated in Performance Tuning using Explain Plan and Tkprof.
• Extensively used ER/Studio for developing data model using star schema methodologies.
• Created Unix Shell Scripts for automating the execution process.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Designed Logical and Physical models of Relational Database
• Built strong relationships wif key business and technology partners inside and outside the platform and infrastructure team
• Partnered wif finance, MIS teams, and accounting to ensure the consistency and accuracy of data and reporting
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer
• Created SQL tables wif referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL
• Wrote stored procedures and triggers extensively and working very closely wif developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems
• Involved in developing scripts for validating the data and maintenance of security and integrity of database
• Created scheduled batch jobs using PL/SQL for downloading data into temporary tables to generate the data required for some of the reports
• Worked wif the team of business analysts, developers and end users for generating audit reports and troubleshoot the related queries and fix the connectivity issues

Environment: Erwin, SQL Server, Crystal Reports, MS Office, Windows 2003, Oracle 8i, SQL, PL/SQL, ER/STUDIO, SQL*Loader, Perl, TOAD and UNIX.