Employment History:

Confidential

Data Modeler

Responsibilities:

• Performed data analysis, metadata mapping documents, data flow diagrams and design conceptual, logical and physical data models for the International Sales, Marketing and Commissions subject areas of the Enterprise Data Warehouse using the Erwin data modeling tool.
• Analyzed needs and requirements of existing and proposed IT systems to support data related requirements.
• Supported existing database standards and naming conventions to enhance corporate data dictionaries.
• Strong understanding of Data Modeling in data warehouse environment such as schema.
• Lead project planning, design, implementing the Data Architecture goals of a project.
• Assigned to Enterprise Database and Warehouse Projects responsible for data research/Analysis/metadata definition/Data Mapping and logical and physical
• Data Modeling for EDGE Enterprise Data Gathering Engine EDW.
• Created source to target mapping STTM document and worked on ETL mapping, session and workflow coding, ETL architecture, and provided data quality analysis to determine cleansing requirements.
• Responsibilities included migration and integration strategies for corporate production databases i.e., migration/integration of data from recently merged corporate acquisitions logical and physical design for both Operational Data store ODS and Dimensional/Hierarchical Data Warehouse data structures.
• Generated data source to target mapping STTM documents and data model change control processes.
• Additional responsibilities included developing Business Processes for change control and configuration management of the Enterprise Data Warehouse.
• Involved in logical database design Erwin and physical implementation.
• Well versed in Normalization and De-normalization data warehouse techniques for optimum performance in relational to multi-dimensional database environments.
• Provided assistance in logical and physical database architecture using Erwin and ER Studio.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools.
• Translate data models into normalized relational database designs.
• Worked extensively on forward and reverse engineering processes
• Experience building reports using Crystal Reports, Business Objects, Cognos, and MicroStrategy.
• Worked with DBA to create the physical model and tables. Scheduled multiple brains storming sessions with DBAs and production support and development environment for the team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
• Created DDL scripts for implementing Data Modeling changes. Created Erwin reports depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with physical DBAs to apply the data model changes
• created/maintained/modified data base design document with detailed description of logical entities and physical tables
• Created many kinds of reports, such as Dashboard Report, Linked Report, Drilldown report, Parameterized Report, Sub Report or Row Level Security Report, by using Table Report, Matrix Report and Chart Report in SQL Server Reporting Services SSRS .
• Had experience with data acquisitions, data availability, data backup archiving and recovery.
• Develop backup archiving and recovery strategies, implementation of backup procedures and recovery of database.
• Used report level variables, group level variables, expressions, grouping skills, parameters, cascading parameters and indicators to handle and format reports' important features, such as visibilities, page breaks, dynamic columns or dynamic matrix reports.
• Created ETL packages using PL/SQL, SQL Server SSIS Designer to extracted data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SQL Server Business Intelligence Development Studio BIDS .

Confidential

Data Modeler

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as implementing the Data Architecture goals of a project.
• Created and reviewed the conceptual model for the EDW Enterprise Data Warehouse with business users.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Strong understanding of Data Modeling in data warehouse environment such as schema.
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.
• Implemented the Slowly changing dimension scheme Type II for most of the dimensions.
• Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
• Well versed in Normalization and De-normalization data warehouse techniques for optimum performance in relational to multi-dimensional database environments.
• Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about the data model and business requirements.
• Translate data models into normalized relational database designs.
• Provided assistance in logical and physical database architecture using Erwin and ER Studio.
• Created the DDL scripts using ER Studio and source to target mappings STTM S2T- for ETL to bring the data from JDE to the warehouse.
• Worked with DBA to create the physical model and tables. Scheduled multiple brains storming sessions with DBAs and production support and development environment for the team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
• Worked on the model based volumetric data analysis and data based volumetric analysis to provide accurate space requirements to the production support team.
• Had experience with data acquisitions, data availability, data backup archiving and recovery.
• Develop backup archiving and recovery strategies, implementation of backup procedures and recovery of database.
• Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
• Developed and implemented SQL, PL/SQL functions, procedures and packages
• Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
• Worked with client and off shore team to make sure that the reports and dashboards are delivered on time.
• Experience building reports using Crystal Reports, Business Objects, Cognos, and MicroStrategy.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System. Worked with the test team to provide insights into the data scenarios and test cases.

Confidential

Data Modeler

Responsibilities:

• Installing, configuring and upgrading Oracle database on UNIX environments
• Develop UNIX shell scripts, Data Analysis, SQL Scripts and PL/SQL code to develop various database monitoring and cleaning tools.
• Strong understanding of Data Modeling in data warehouse environment such as schema.
• Worked closely with business analyst to identify users and gather requirements and planning and implementing the Data Architecture to determine the goals of a project and finalize scope.
• Controlling and Maintaining System Security through Profiles, Roles, Privileges and Auditing. Ensuring database security and integrity with auditing features
• Translate data models into normalized relational database designs.
• Well versed in Normalization and De-normalization data warehouse techniques for optimum performance in relational to multi-dimensional database environments.
• Provided assistance in logical and physical database architecture using Erwin and ER Studio.
• Working with Management to estimate Server capacity and storage requirement for Databases
• Experience in developing shell scripts to monitor database logs, trace files, user activity, long running jobs, database backups, server resource utilization.
• Had experience with data acquisitions, data availability, data backup archiving and recovery.
• Develop backup archiving and recovery strategies, implementation of backup procedures and recovery of database.
• Experience building reports using Crystal Reports, Business Objects, Cognos, and MicroStrategy.
• Installation and implementation of RMAN database backups.
• Developed and implemented PL/SQL functions, procedures and packages

Confidential

Software Analyst

Responsibilities:

• Participated in designing the Market Set which is the e-procurement suite as part of ERP product from Commerce One SAP
• Ensured the quality of ERP architecture through validation of the technical architecture design and the completeness of documentation for the architecture, design of ERP infrastructure and projects
• Worked on an e-commerce web application development using MVC Model View Controller framework with J2EE, XML technology.
• Developed a reusable Java framework that enabled rapid development of dynamic user interface for Java applications, which provided a layer of abstraction for gathering data and passing it to the back-end systems.