SUMMARY

• Around 8 years of professional work experience in software development in data modeling for Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Hands - on experience in Erwin 7.2 and strong knowledge in Logical and Physical database modeling concepts and star/snowflake schema implementation.
• Expertise in system analysis, EDW/Dimensional Modeling, Database design and implementation of RDBMS specific features.
• Extensive Experience working with a Data Modeling Case Tools as Erwin, ERStudio and System Designer.
• Created logical data model from the conceptual model and its conversion into the physical model (database) design using Erwin.
• Expert in Normalization (1NF, 2NF, 3NF and BCNF)/ Denormalization techniques for effective and optimum performance in OLTP and OLAP environments
• Expertise in data modeling concepts in Erwin 7.2 such as Forward, Reverse Engineering and Complete Compare.
• Designed the data marts using the Ralph Kimball’s and Inmon dimensional data mart modeling techniques.
• Excellent experience in Extract, Transfer and Load process using ETL tools like Data Stage, Informatica, Data Integrator and Sql Server Integration Services for Data migration and Data Warehousing projects.
• Experience inOracle 10.x/11.xandSQL-Server 2005/2008 database administration.
• Experience in preparing projectcutover plan,test planwithuse casesforunit test, regression testand User Acceptance Testing(UAT)
• Extensive expertise in SQL Server technologies like MS SQL Server 2005/2008 suites of products like SSRS, SSAS and SSIS including development, deployment, testing and support.
• Strong experience in T- SQL development with the usage of database objects such as views, Stored Procedures, Triggers to facilitate efficient data manipulation and data consistency.
• Experience in .NET Technologies such as C#, Win-Forms, ASP.NET, ADO.NET, IIS, Visual Studio, MSMQ, Windows Services and .NET Framework.
• Flexible, enthusiastic, Self-motivated, and project oriented team player.
• Excellent written, verbal communication and interpersonal skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

Programming Languages: C,C#, C++, T-SQL

Distributed Computing: XML Web Services, SOAP,WSDL, WCF

Web Skills: HTML, XML, XSL, JavaScript, VBScript, ASP .NET

Web Servers: IIS 5.1/6.0/7.0

Data Modeling: Erwin 7.x/4.x, MS Visio

Databases Technologies: SSIS, SSRS, SSAS, OLAP, OLTP,DTS

Databases\Data Access: SQL Server 2000/2005/2008 , Oracle 10.x/11.x, Sybase, MS Access, MainFrames

Tools: and Utilities: UML, Dundas charts, Crystal Reports, MS Visio 2003, VSS 6.0, Code Analyzer, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Toad

Operating Systems: Windows 2000/XP/7, Windows 2003/2008, Linux

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. Data Modeler/Architect

Responsibilities:

• Involved in all phases ofSDLCfrom design, development, functional testing, and Quality analysis to production support.
• Worked towards providing Data Warehouse Architecture solutions.
• Supported front end projects throughout the organization by providing design solutions.
• Worked closely with DBA’s in creation of scripts generated in Erwin 7.2 using Complete Compare.
• Coordinated with Data Governance and Information Architecture team.
• Provided Optimization Techniques for all the projects involved in the organization.
• UsedErwinto designLogical/Physical Data Models, Forward and Reverse engineering, publishingdata modelto acrobat files, created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files.
• Developed scripts for the creation of the physical data warehouse database schema(s), data security and protection, managing performance, performing backups/ restores, and archiving data.
• Analyzed and identified areas for improvement in system performance, including optimization and tuning of data loads, extractions and recommended appropriate optimizations to ensure and improve system performance and reliability.
• Documented business definitions on the logical and physical models using Erwin.
• Performed physical database design at the object level, created DDL scripts, DML scripts defined new strategies using Oracle/ SQL databases.

Environment: ERWIN 7.2, VSS 6.0, SQL Server 2005/2008 Oracle 10.x/11.x, Microsoft Office Suites, T- SQL

Confidential, Danbury, CT

Sr. Data Administrator

Responsibilities:

• Supported the Confidential Online front end application (COL) by providing design support in the area of data management.
• Worked closely with Business Analysts and Front End developers to gather the business requirements and also to modify the existing design based on the discussions.
• Involved in all phases ofSDLCfrom design, development, functional testing, and Quality analysis to production support.
• Worked extensively with DBA’s for deployment of the scripts generated in Erwin 7.2 using Forward and Reverse engineering methods.
• Used Complete Compare extensively in Erwin to compare two data models.
• Produced and documented logical and physical database design using Erwin as a data modeling tool, maintained the EDW using Erwin Model Mart software.
• As part of project team, defined tasks and designed system architecture for new implementations and provided project status information to management.
• Performed physical database design at the object level, created DDL scripts, defined database snapshots, table partitions, and backup/recovery strategies for Oracle/ SQL databases.
• Assisted developers with application design and performance tuning.
• Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.
• UsedErwinto designLogical/Physical Data Models,relational database design, Forward and reverse engineering, publishingdata modelto acrobat files, created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBA to apply the data model changes.
• Involved in implementing logical/physical model notations such as IDEF and IE.
• Designed and developedStar Schemaand createdFactandDimension Tablesfor EDW using Erwin.
• Participated in creating the Data Warehouse architecture.
• Performed data mappings from source systems to new target structures on the database platform.
• Developed scripts for the creation of the physical data warehouse database schema(s), data security and protection, managing performance, performing backups/ restores, and archiving data
• Analyzed and identified areas for improvement in system performance, including optimization and tuning of data loads, extractions and recommended appropriate optimizations to ensure and improve system performance and reliability.
• Documented Migration strategies.
• Collaborated with key business users to develop Crystal reports, Cognos, cubes and other budget analysis and review tools.
• Developeddocumentationfor administrators to follow steps to add, modify, delete or change rights for different users of different departments.
• Trained the users about all the functionalities and analysis of the reports for their applications.

Environment: ERWIN 7.2, VSS 6.0, SQL Server 2005/2008 Oracle 10.x/11.x, Microsoft Office Suites, T- SQL

Confidential

Responsibilities:

• Coordinated testing with other development groups and operations. Identified appropriate level of testing and ensure that testing is complete before signing off.
• Worked extensively with DBA’s for deployment of the scripts generated in Erwin 7.2 using Forward and Reverse Engineering, Complete Compare methods.
• Documented data dictionary on the logical and physical models using Erwin, also maintained the EDW using Erwin Model Mart software.
• As part of project team, defined tasks and designed system architecture for new implementations and provided project status information to management.
• Performed physical database design at the object level, created DDL scripts, DML scripts defined new strategies using Oracle/ SQL databases.

Environment: ERWIN 7.2, VSS 6.0, SQL Server 2005/2008 Oracle 10.x/11.x, Microsoft Office Suites, T- SQL.

Confidential, Wilmington, DE

Sr.Data Modeler

Responsibilities:

• Provided architecture and planning recommendations in the areas of data management.
• Involved in working with multiple teams. Involved in all phases ofSDLCfrom requirement, design, development, testing and rollout to the field user and support for production environment.
• Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives. Work with Database Administrators to coordinate logical and physical data design.
• Gathering the new requirementsfrom the users and business analysts.
• UsedErwinto designLogical/Physical Data Models,relational database design, Forward and reverse engineering, publishingdata modelto acrobat files, created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBA to apply the data model changes.
• Involved in implementing logical/physical model notations such as IDEF and IE.
• Designed and developedStar Schemaand createdFactandDimension Tablesfor the Warehouse using Erwin.
• Judiciously applied Inmon and Kimball structured methodologies to solve the business problems.
• Participated in creating the Data Warehouse architecture.
• Performed data mappings from source systems to new target structures on the database platform.
• Designed, developed and maintained Power Center workflow load processes to data warehouse.
• Developed scripts for the creation of the physical data warehouse database schema(s), data security and protection, managing performance, performing backups/ restores, and archiving data
• Performed database backup and restoration on a daily and weekly basis depending on the time frame.
• Analyzed and identified areas for improvement in system performance, including optimization and tuning of data loads, extractions and recommended appropriate optimizations to ensure and improve system performance and reliability.
• Performed regression testing on the upgraded Power Center 7.1.3 to ensure data integrity
• Documented Migration strategies.
• Collaborated with key business users to develop Crystal reports, Cognos, cubes and other budget analysis and review tools.
• Responsible in designing and introducing new (FACT and Dimension Tables) to the existing Model.
• Developeddocumentationfor administrators to follow steps to add, modify, delete or change rights for different users of different departments.
• Trained the users about all the functionalities and analysis of the reports for their applications.

Environment: ERWIN 7.2, Microsoft Visio, Microsoft Project, Microsoft Office Suite, T- SQL, SQLSERVER 2005.

Confidential, Silver Spring, MD

Data Architect/Data Modeler

Responsibilities:

• Involved in analysis of the existing database design to in order the enhance and extend the dataware house.
• Provided architecture and planning recommendations in the areas of data management.
• Worked with application developers and business analysts to identify, design and implement solutions for extraction and integration of data to and from existing databases to the new data mart for the purposes of reporting, decision support and analysis.
• Extensively used ERWIN to design Logical/Physical Data Models,forward/reverse engineering, publishing data model, applying DDLs to database, Data Modeling and restructuring the existing data Model.
• Extensively used the Stored Proceduresas source forBusiness Objectsquerying, analysis and reporting.
• Createdcomplex reportsand published on Web using Web Intelligence.
• Implemented Inmon methodology which provides an integrated, volatile, up-to-the-minute picture of the business.
• Responsible in designing and introducing new (FACT and Dimension Tables) to the existing Model.
• Extensively developed reports based ontime line & geographical data.
• Created and maintained the databases required for development, testing, education and production requirement. Performed the capacity planning required to maintain the databases.
• Worked closely with system administration staff and was involved in tuning of the ongoing database instances.
• Installed new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Planned and implemented backup and recovery of the Oracle database.
• Involved in migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Involved in implementing logical/physical model notations such as IDEF and IE.
• Expert in creating reports likeBusiness Customers reports,Service charge validation Reports,Monthly paper bill Reports,Tax Summery Reports,Affiliated, Non-Affiliated Reports,Status Reports,Daily/Monthly Orders Reports, andCustomers detailed Reports.
• Developed the VBA macro to automate the process of fetching the reports from repository, refreshing it and sending it to the Microsoft outlook through Broadcast Agent.
• Identified areas for improvement in system performance, including optimization and tuning of data loads, extractions and recommended appropriate optimizations to ensure and improve system performance and reliability.
• Troubleshooting and customization of reports after upgrade i.e.support work.
• CreatedETL processesusingInformatica 7.

Environment: ERWIN 7.2, Business Objects 6.5/XIr2, WebI 6.5/XI, Dashboard Manger, Application Foundation, CMC, Desktop Intelligence, T-SQL, Windows 2000.

Confidential, Indianapolis, IN

Data Architect/Data Modeler

Responsibilities:

• Extensively involved in takingbusinessandtechnicalrequirementsand generating reports.
• Involved in working with multiple teams. Involved in all phases ofSDLCfrom requirement, design, development, testing and rollout to the field user and support for production environment.
• Participated inJoint Application Design/Development (JAD)sessions and involved in discussions with clients/users to determine the dimensions, hierarchies and levels, basic measures, derived measures and key metrics for relational / multidimensional data model for the system, understanding reporting requirements, designing star schema data model.
• Made decisions on Inmon and Kimball methodologies.
• Prepared architecture for the DW environmentand developed data modelfor the reporting and analytics solutions.
• Managed Daily Status meeting and Weekly Status Reports of the group and meeting with Manager and Client Executives.
• DefinedData Model Requirements to meet Reporting, Analysis & specific Business Objects needs.
• Created Cognos Power Play models to improve and supplement existing analytical tools and processes.
• Designed theDW architectureandcreated Facts/Dimensions using Erwin.
• Worked with theDBAs& created thedata modelfordata-marts.
• Involved in FullProjectLifeCycle(requirement gathering to implementation phase to closing phase).
• Expert in designingUniversesusing Business Objects Designer -Universe Methodologyinvolving the creation of underlying database structure, resolving the loops, creating classes & objects, conditions & joins and finally testing the integrity of the Universe.
• Performed database re-organisations as required to assist performance and ensure maximum uptime of the database.
• Involved in maintenance of application design and made sure code is produced with proper integrity, security and performance.
• Performed reviews on the design and code frequently to ensure the site standards are being adhered to.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Assisted with impact analysis of any changes made to the database objects.
• Expertise in creatingWeb-Intelligence reportsusingbusiness objects infoview.
• Developed complex reports inWeb-I&Desk-Ienvironment.
• UsedWeb intelligenceto developdrill reportsat territory, region, & district levels.
• UtilizedMOLAPcapability of BO by creatinguniversesout of theflat files.
• Extensively usedAlerts, Filters, expressions, calculations, etcin Reports.
• Developedreportslike:cross tab, drill down, master detail, drill down & parameters etc.

Environment: Erwin, Business Objects XIR2 (Designer, Business Objects, Infoview & Webintelligence), SSRS, IBM DB2, ORACLE 9i/10 g, T-SQL

Confidential

Data Architect/Data Modeler

Responsibilities:

• Involved in all phases ofSDLCfrom requirement, design, development, testing and rollout to the field user and support for production environment.
• Gathering the new requirementsfrom the users and business analysts.
• Consulted with application development business analysts to translate business requirementsinto data design requirements used for driving innovative data designs that meet business objectives. Work with Database Administrators to coordinatelogical and physical data design.
• Involved inFull life cycledesignanddevelopmentofBusiness Objectsreporting Application
• Provided detailed architectures/workflows, leveraging the core implementation and incorporating new and legacy servers to achieve the set goals:
• Increased performance in the near real-time reporting environment
• Increased accessibility through Web Intelligence
• Ability to scale new servers into the cluster with added Load Balancing and Fail over capabilities
• Extensively used ERWIN to design Logical/Physical Data Models,forward/reverse engineering, publishing data model, applying DDLs to database, Data Modeling and restructuring the existing data Model.
• Added and modified Informaticamappings and sessionsto improve performance, accuracy, and maintainability of existing ETL functionality. Recommended additions and modifications where appropriate.
• Worked extensively on Inmon 3NF methodology.
• Involved in implementing logical/physical model notations such as IDEF and IE.
• Heavily used theUniverses&Stored Proceduresas source forBusiness Objectsquerying, analysis and reporting.
• Extensively createdcomplex reportsand published on Web using Web Intelligence.
• Responsible in designing and introducing new (FACT and Dimension Tables) to the existing Model.
• Extensively developed Revenue reports based ontime line & geographical data.
• Expert in creating reports likeResidential and Business Customers reports,Service charge validation Reports,Monthly paper bill Reports,Tax Summery Reports,Affiliated, Non-Affiliated Reports,Status Reports,Daily/Monthly Orders Reports, andCustomers detailed Reports.
• Developed the VBA macro to automate the process of fetching the reports from repository, refreshing it and sending it to the Microsoft outlook through Broadcast Agent.
• CreatedCrystal Reportswith extensive use ofgraphs, charts,metric fields.
• Created Cognos Power Play models to improve and supplement existing analytical tools and processes.
• Developed complexcrystal reportswith multiple sub reports on it.
• Scheduling full client reports and WEBI reports Using BCA server.
• Developing the Unix shell scripts in order to run the Daily Cycle reports
• Troubleshooting and customization of reports after upgrade i.e.support work.
• CreatedETL processesusingInformatica 7.

Environment: ERWIN, Business Objects 6.1b, Web Intelligence 6.1b (Reporter, Explorer, InfoView), Broadcast Agent Publisher, Oracle 9i, VBA, PL/SQL, Shell Scripting, Informatica 7.x.

Confidential

Data Modeler

Responsibilities:

• Extensively involved in takingbusinessandtechnicalrequirementsand generating reports.
• Participated inJoint Application Design/Development (JAD)sessions and involved in discussions with clients/users to determine the dimensions, hierarchies and levels, basic measures, derived measures and key metrics for relational / multidimensional data model for the system, understanding reporting requirements, designing star schema data model.
• Prepared architecture for the DW environmentand developed data modelfor the reporting and analytics solutions.
• Managed Daily Status meeting and Weekly Status Reports of the group and meeting with Manager and Client Executives.
• DefinedData Model Requirements to meet Reporting, Analysis & specific Business Objects needs.
• Designed theDW architectureandcreated Facts/Dimensions using Erwin.
• Worked with theDBAs& created thedata modelfordata-marts.
• Heavily usedPL/SQLfor the application likeClarity& createdstored procedures/functionsinORACLE.
• Involved in FullProjectLifeCycle(requirement gathering to implementation phase to closing phase).
• Expert in designingUniversesusing Business Objects Designer -Universe Methodologyinvolving the creation of underlying database structure, resolving the loops, creating classes & objects, conditions & joins and finally testing the integrity of the Universe.
• Created universes & views over the applications likeTrade Stone,Clarity&BMC Incident Management Software’s (Remedy).
• Expertise in creatingWeb-Intelligence reportsusingbusiness objects infoview.
• Developed complex reports inWeb-I&Desk-Ienvironment.
• UsedWeb intelligenceto developdrill reportsat territory, region, & district levels.
• UtilizedMOLAPcapability of BO by creatinguniversesout of theflat files.
• Extensively usedAlerters, Filters, conditions, calculations, etcin Reports.
• Developedcrystal reportslike:cross tab, drill down, summary, topn, drill down & parameters etc.
• CreatedBusiness ViewsusingBusiness View ManagerforCrystal Reporting.
• DevelopedCrystal Reports, amended flexibilities & functionalities by addingFormula&Parameters fieldsinto the report.
• Developed complexCrystalReportsusingsub-reportsfor drill down capabilities.
• Created highly graphicalcrystal reportsforRemedyforservice management.

Environment: Erwin, Business Objects XIR2 (Designer, Business Objects, Infoview Webintelligence), Crystal Reports 11, IBM DB2, ORACLE 9i/10 g, PL/SQL

Confidential

Data Modeler

Responsibilities:

• Discussions with the users to capture the requirement.
• Designed logical model after identifying entities and attributes with appropriate relationship in logical model
• Arranged for review meeting to review the Logical Model with SME's and developers
• Created physicalmodel and database scripts to create database objects
• Maintained Oracle database by creating and maintaining user, grants, database objects
• Wrote complex SQL and Oracle Stored procedure and triggers
• Involved in SQL performance optimization of stored procedures
• Created test plan with test cases for various modules.
• Supported the application during warranty period.

Environment: Erwin 4.0, Visio, Toad, Oracle 7.0, Windows NT, Windows 95

Confidential

Oracle Developer

Responsibilities:

• Used various levels oftriggers and proceduresto validate the data at each level.
• Extensively involved in writingPL/SQL stored procedures, functions and packages.
• Createddatabase tableswithcomplex constraintsapplicable to the business rules.
• Created a user-friendly GUI interface, with extensive use of features of Oracle Forms 4.5.
• In order to keep all the activities of the company under control, various reports like field clinic report, enroll report, voucher payments report and analysis reports were generated.
• Managed Daily Status meeting and Weekly Status Reports of the group and meeting with Manager and Client Executives.
• Involved in all phases ofSDLCfrom requirement, design, development, testing and rollout to the field user and support for production environment.
• Gathering the new requirementsfrom the users and business analysts.
• Responsible in designing and introducing new (FACT and Dimension Tables) to the existing Model.
• The design document was finalized through conduct of design walkthroughs, and independent review by the user.
• Analyzed the source data from ORACLE.Designed and developedStar Schemaand createdFactandDimension Tablesfor the Warehouse.
• Involved in writing, testing, and implementation of thestored procedures,functions at Database level and form level using PL/SQL.
• Extensively usedStored Proceduresfor Pre Session and Post Session Data Loading
• Prepared architecture for the DW environment anddeveloped data modelfor the reporting and analytics solutions.
• DesignedETL specificationdocuments to load the data in target using various transformations according to the business requirements.
• Interacted withBusiness UsersandBusiness Analyststo understand and document the requirements and builtUniversesfor end user reports generation usingBusiness Object 6.5/XI designer.
• Worked withETLdeveloper & helped them in creatingwork flows.
• Developeddocumentationfor administrators to follow steps to add, modify, delete or change rights for different users of different departments.
• Involved in re-designing or customizing theexisting Viewsto suit the reporting needs.
• CreatedCrystal reportswith multiplesub-reports.
• Developedviewsover the databases using ODBC connection drivers to supportcrystal reports.
• Trained the users about all the functionalities and analysis of the reports for their applications.

Environment: Business Objects 6.5/XIr2, WebI 6.5/XI, Dashboard Manger, Application Foundation, CMC, Desktop Intelligence, Oracle 8i, SQL, PL/SQL, Windows 2000, Crystal 9, Informatica 7.x.