SUMMARY

• Six years of professional experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Implementation and Support of various Business Intelligence (BI) applications / OLTP, Data Warehousing (OLAP) applications.
• Experienced in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using various data modeling tools like ERWIN, Embarcadero ER Studio
• Data Modeler with strong Conceptual and Logical Data Modeling skills has involved in JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications and queries
• Well versed in Normalization and De normalization techniques for optimum performance in relational and dimensional database environments
• Strong experience in Logical/Physical, Relational and Multi - dimensional modeling, Data analysis for Decision Support Systems (DSS), Online transactional processing (OLTP) and Data warehouse/Business Intelligence (BI) applications, Data Transformation (ETL) and Reporting
• Strong Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing
• Strong working experience in Extract/Transform/Load (ETL) design and implementation using Informatica
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling
• Good working knowledge of building Reports using standard industry Reporting tools such as Cognos, Crystal Reports and Business Objects
• Experience documenting business cases and managed report development from design to release.
• Excellent experience with writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests
• Strong Database experience using Oracle 10g/9i/8i, DB2, Sybase, Teradata, PL/SQL, Stored Procedures, triggers and cursors
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using MS-Visio.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow
• Self-starter, Multi Tasking, Attention to detail, ability to work with minimal supervision and manage time and task efficiently.
• Effective team worker and can carry out individual tasks to meet the deadlines effectively.

TECHNICAL SKILLS

Operating Systems: Unix Aix/ Solaris 7/8/9, RH Linux 7.1/8/AS 3.0,Windows 7/Vista/2003 / XP / 2000 / NT 4.0

RDBMS: Oracle 10g / 9i / 8i, SQL Server 2005/2000/7, DB2, Teradata, Sybase ASE 12.0/12.5, MySQL 4.x/5.x, MS-Access 2000/7/10

Business Tools: Rational Suite, MS Visio, Crystal Report, MS Project

Languages: C, C++, Java, J2EE, Java Script, HTML, XML, SQL, PL/SQL, T-SQL

Tools: Oracle Designer 2000, Embarcardero ER Studio 6.6,9, ERWin4-7s, Informatica 6.x/7.x, SSIS, SSRS, Power Designer 15.0, Cognos 8, Crystal Reports, Business Objects

Others: MSOffice 2007 (Word, Excel, PowerPoint, Access), MS Project, Rational Rose, UML

PROFESSIONAL EXPERIENCE

Confidential, Portland, Oregon

Data Modeler/Data Analyst

Responsibilities:

• Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks.
• Responsible for data mapping, metadata maintenance and enhancing existing Conceptual and Physical data models.
• Conducted sessions with architects, business and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests.
• Maintained and updated Metadata repository based on the change requests
• Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
• Conducted walkthroughs with the DBA to convey the changes made to the data models.
• Utilized Rational Clear Quest to track change requests throughout the process.
• Implemented SQL Scripts to modify the data to resolve assigned defects.
• Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.
• Analyzed and synthesized the requirements gathered from multiple sources and documented the business process flow for the system.
• Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations. Involved in the entire System study, AnalysisandDesign.
• CreatedEntity relationships diagrams, data flowdiagrams and enforced allreferential integrity constraints using Oracle Designer.
• Developed the data warehouse model (star schema) for the proposed central model. Also worked on normalizing star-schema to snow flake schema to fulfill requirement.
• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Developed source to target mapping documents to support ETL design.
• Created tables, views, sequences, indexes, triggers, table spaces, constraints and generated sql scripts for physical implementation.
• Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
• Designed Informatica mappings, enabling the extract, transform and loading of the data into target tables.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

Environment: Erwin 7.2, DB2, Teradata, Informatica8.1, Power Designer, Clear Quest, Cognos, Crystal reports, TOAD, PL/SQL, ER Studio, Lotus Notes Windows 2003, MS Excel, Word and Access

Confidential, Longisland,NY

Data Modeler

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Involved in business process modeling in UML using Rational Rose.
• Transformed project data requirements into project data models using Erwin.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Coded stored procedures, triggers, functions, indexes, views and packages.
• Utilized Erwin’s reverse engineering process.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed procedures for extracting the data from different data sources to the central data warehouse.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages
• Designed data flows that extract, transform, and load data by optimizing SSIS performance
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Designed and developed the cubes through Microsoft Analysis services.
• Created DTS packages to loading data from various flat files and OLTP databases.
• Used DTS to load the data into the warehouse, process the cubes and coded scripts involving the transformation services.
• Involved in scheduling backups of databases and logs and restoring them when necessary.
• Performance tuning of the database and SQL queries.
• Provisions were made for ad hoc querying and reporting using Crystal Reports.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin 7.2, MS SQL Server 2008 R2, SSIS / SSRS, Oracle 10g, Informatica Power designer, DTS, MS Analysis Services, Rational Rose, Win NT/2000, Crystal Reports

Confidential, San Diego, CA

Data Modeler/Data Analyst

Responsibilities:

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Developed logical and physical data models for central model consolidation.
• Worked with DBAs to create a physical data model from the logical data model.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed process methodology for the reverse engineering phase of the project.
• Developed project plan with project manager’s assistance for the first two phases of the project.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Used graphical Entity-Relationship diagramming to create new database design via easy to use, graphical interface.
• Involved in logical and physical designs and transforms logical models into physical implementations
• Utilized Erwin’s reverse engineering and target database schema conversion process.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
• Involved in different team review meetings.
• Involved in the creation and maintenance of repositories containing metadata.
• Did unit testing and tuned for better performance.
• Involved in the critical design review of the finalized database model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Windows NT servers, Oracle databases, SQL Server, DB2, Microsoft Transaction Server, Erwin, Crystal Reports, Informatica, MS-SQL server analysis manager.

Confidential, Detroit, MI

Data Modeler/Data Analyst

Responsibilities:

• Involved in all phases of SDLC including analysis, designing, developing, testing and maintenance.
• Performed in-depth analysis on the business objectives.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Used class diagrams (UML) to model the logical data models and then to physical data model.
• Extensively used Normalization techniques (up to 3NF).
• Mapped the data between Source and Targets.
• Experience in Data Extraction and Conversion and in preparing the Gap Analysis.
• Used ER/Studio to generate SQL code for creating database.
• Maintained Design document and performed testing.
• Gathered user specifications and system requirements for development process.
• Converted Data stored in flat files into Oracle tables.
• Used MS Visio for Creating Process flow diagrams.
• Worked with the implementation team from the design to the implementation phase.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts to Teradata data warehouse.
• Good experience in data analysis querying and writing in SQL and TOAD.

Environment: Oracle Database 10g, UNIX, Windows XP, Teradata, ER Studio, MS Visio, TOAD.

Confidential

Oracle Developer

Responsibilities:

• The Data Mart (BMDM) system stores marketing data in an Oracle relational database and is interrogated using the Power play\ Impromptu end-user reporting tools.
• Responsible for data modeling and building a star schema model in Erwin.
• Identified the fact tables, dimensions and the key measures.
• Used star schema methodology for the modeling of the data.
• In creation of the data mart new functionality had to be added like Trend data Inclusion, Product Profitability Calculation \ Reporting, Concept Reporting, Size Of Line Reporting, Global Brand Grouping \ Reporting etc.
• Assisted data warehouse project team in extracting business rules.
• Created an enterprise data dictionary and maintained standards documentation.
• Analysis of data requirements and translation of these into dimensional data models.
• Interacted with the end users and found out the performance of the database and also involved in developing test cases.

Environment: Oracle 7.x, PL/SQL, SQL Navigator, Sun Solaris2.x, Windows NT, Erwin, Cognos.

Confidential

SQL Developer

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Designed and developed the database.
• Initiated use case analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships.
• Created a logical design and physical design of the central relational database.
• Used Erwin Case tool for relational database design.
• Configured the DTS packages to run in periodic intervals.
• Extensively worked with DTS to load the data from source systems.
• Writing stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Created tables, views, triggers, stored procedures and indexes.
• Created integrity rules and defaults.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Developed several forms & reports using Crystal Reports.

Environment: SQL server 7.0, Erwin, Windows NT, Rational Rose, Crystal Reports.