SUMMARY

• Over ten years of professional experience in Data Modeling, Business Data Analysis and design of OLTP and OLAP systems.
• Extensive experience analyzing and documenting business requirements and system functional specifications including use cases
• Strong Knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema and ODS architecture for modeling a Data Warehouse by using tools like Erwin, Power Designer, E - R Studio, AbInitio, Designer 2000 and Microsoft Visio.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments
• Experience working with Agile data modeling methodologies
• Experience working with conceptual, logical and physical data modeling considering meta data standards
• Building reports using SQL SERVER Reporting Services (SSRS), Crystal Reports, Micro strategy, Business Objects and Cognos.
• 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 Rational Rose and MS-Visio.
• Facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
• Worked with various RDBMS like Oracle 11g, SQL 2008,DB2
• Extensive experience in development of T-SQL, Oracle PL/SQL, DTS, OLAP, Stored Procedures and Triggers for business logic implementation.
• Experienced in Data loading using PL\SQL Scripts, performance tuning, creating new database, indexes, creating and modifying table space, optimization and Data Modeling.
• Very Good exposure to ETL tools like Informatica, Micro Strategy and IBM Data Stage andSSIS2008/ 2005
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata
• Excellent communication skills, self starter with ability to work with minimal guidance.

TECHNICAL SKILLS

Data Modeling Tools: Erwin 4/5/6/7,System Architect 11.3, Rational Rose 2000, MS Visio 2000/2007/2010 , E/R Studio

Databases & Database Tools: MS & SQL servers 2000/2005/2008 , Oracle 9g/10g/11g, MS Access 2003/2007/2010 , Teradata, DB2,TOAD 9, Data Stage XE 390, Kalido 7, Queryman 5/6, Informatica 8

Reporting Tools: Cognos 8, Business Objects XI, Crystal Reports 2008, Actuate Reports 10

Programming Languages: UML, XML,XSLT, HTML, JavaScript, .NET 2.0/3.0/4.0 based C# and VB, ASP .NET, C,C++, MATLAB,XSLT, XML,HTML

Environment: and Utilities: HP-UX 11.11, Sun Solaris 7/8/9, Red Hat Linux 7.1/8/AS 3.0, Linux flavors Fedora and Ubuntu, IBM-AIX, 5.6/5.7,Windows Server 2003 / XP / 2000 / NT 4.0/7/Vista, MS Office and Macro programming using VBA

PROFESSIONAL EXPERIENCE

Confidential, Nutley, NJ

Enterprise Data Architect/Sr. Data Modeler

Responsibilities:

• Gather the various reporting requirement from the business analysts.
• Gather all the Sales analysis report prototypes from the business analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Reverse Engineering the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR schemas for the detailed data marts and Plan data marts involving shared dimensions (Conformed) ;
• Conduct Design reviews with 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 with the Reporting Team to design Monthly Summary Level Cubes to support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
• Worked Closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic
• Create ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server usingSSIS,
• Create and load Staging and Dimensional databases usingSSIS,
• Create and deploy UDM Cubes for Sales Analysis using SQL Server Analysis Services.
• Create and deploy reports using SSRS.

Environment: SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Crystal Reports7.5/8.0, Windows 2000, Crystal Enterprise8.0, Erwin 7.0, Oracle10g, Teradata

Confidential, Phoenix, AZ

Data Architect/Sr. Data Modeler

Responsibilities:

• Working with the Business Analyst and DBA, conducting team meetings and JAD sessions for technical requirements gathering, business analysis, testing and project coordination
• Analyze and evaluate existing system for assessing how it supported functions from the Use Case diagrams and UML diagrams
• Developed Logical data model using Erwin 7.2 and created physical data models using forward engineering
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create graphical representation (E-R diagram) using Erwin7.2
• Used BTEQ for SQL queries, and TPump for loading data from source into teradata tables
• Used teradata utilities such as Fast Export, MLOAD for handling various tasks
• Participate in updating the dimensional model, and identify the Facts and Dimensions
• Employed process and data analysis to model a Customer Information Business System.
• Produced functional decomposition diagrams and defined logical data model.
• Coordinated with ETL team for analysis and reporting needs.
• Developed data migration strategies and impact analysis for database
• Design, plan and program data conversion procedures from old to new databases
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality
• Model a database to store customer demographic and other data.
• Work with Business analyst to design weekly reports using a combination of Cognos Impromptu and Power play multidimensional, to deliver reports to CEL and Marketing groups.
• Design complex reports like aging analysis, invoices generation, profit/loss, balance sheet etc.
• Involved in design and development of standard and ad-hoc reporting using SQL
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to in corporate the new calculations.
• Involved in overall data mart testing and different team review meetings.

Environment: Teradata V2R5, Oracle 10g, SQL Server, Teradata, DB2 SQL, Unix, Cognos Impromptu 7.2, Cognos PowerPlay 7.2, Erwin 7.2, XML, Microsoft Access, Microsoft Excel

Confidential, Hartford, CT

Data Modeler

Responsibilities:

• Communicated with users and business analysts to gather requirements.
• Involved in business process modeling using UML through Rational Rose.
• Involved in preparing Logical Data Models/Physical Data Models.
• Defined the calculations based on the reporting needs and the source data available
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin tool.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Developed data mapping documents between Legacy and User Interface Systems.
• Wrote PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Developed 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.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Rational RequisitePro, ERWin, DataStage, DB2 UDB, SQL Server, Sybase, Windows NT, Linux, Sun Solaris, T-SQL.

Confidential, Dallas, TX

Responsibilities:

• Designed the data marts project using the dimensional data modeling.
• Object Modeling in UML using Rational Rose.
• Gathered all the sales analysis report prototypes from the business analysts belonging to different Business units.
• Gathered the various requirement matrices from the business analysts.
• Participated in JAD sessions.
• Conducted design discussions and meetings to come out with the appropriate data mart.
• Designs for the various reporting requirements.
• Conducted Design reviews with the business analysts, content developers and DBA’s.
• To ensure the feasibility of the designs.
• Monthly summary data marts, inventory data marts using Erwin.
• Worked with the implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Sybase, Windows NT, Sybase Power Designer, SQL Loader, Rational Rose, Crystal reports

Confidential

DBA/Developer

Responsibilities:

• Installed and configured SQL Server.
• Designed and developed the databases
• Created a logical design of the central relational database using Erwin2.5.
• Involved in the forward engineering of the logical models to generate the physical tables using Erwin2.5.
• 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.
• Involved in writing web forms in ASP.NET using C#.NET
• Worked extensively with the datagrid and repeater controls of ASP.NET
• ADO.NET objects such as sqlconnection, sqldataadapter, sqldatareader are used to retrieve the result sets from the SQL server.

Environment: SQL server 7.0, Erwin 2.5, Windows NT, Crystal Reports, Visual Studio.NET, C#.NET.

Confidential

Oracle Developer

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Involved in the analysis of how the purchase order process was organized.
• Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL.
• Involved in writing Triggers which internally called procedures and functions.
• Involved in testing the database for queries that were generated and handled the performance issues effectively.
• Involved in documenting the entire technical process.
• Supported technical teams involved with ORACLE issues and operations.
• Involved in the maintenance of the database.

Environment: Oracle 8.0, Oracle Designer, UNIX