SUMMARY

• Over 15 years of technical expertise in Design, Development, Implementation, Integration and Support of IT solutions, with comprehensive experience in Data Modeling using Data Warehouse Industry Reference Models.
• Extensive experience in industries including Retirement Services, Personal Insurance, Commercial Insurance, Law Enforcement, Wholesale Banking, Retail Industry and Credit card Network.
• Extensive experience in Data Warehouse environment using Teradata V13 and Oracle 11i/Exadata.
• Extensive experience in Data Profiling and Cleansing using Trillium Data Discovery tool.
• Strong knowledge in OLTP/OLAP Systems, Normalized (OLTP), Denormalized (DW and ODS) models and Dimensional Strategies.
• Experience in designing Star schema and Snowflake schema.
• Extensive experience in designing data models using TERADATA FSLDM reference models.
• Extensive experience in designing data models using IIA/IIW reference models.
• Extensive experience in designing data models using ACORD standards.
• Extensive experience in Data Warehouse and Data Mart Design and Data Warehouse Bus Architecture (Kimball).
• Experience in designing Extract, Transform, and Load (ETL) / Data Staging process.
• Experienced in enforcing data integrity using integrity constraints.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Email Notification, Sequencer, Routine activity and Execute Command.
• Excellent knowledge in Extraction, Cleansing and Modification of data from/to various Data Sources, Flat Files from Mainframe System.
• Experience in UNIX Shell Programming for Scheduling, File Manipulation etc.
• Extensive experience in integration of various data sources like Siebel, Oracle, Mainframe Flat files and MS Access into staging area.
• Experience in Evolving Strategies and developing Architecture for building a Data warehouse.
• Recognized by corporates like Confidential Corporation for outstanding achievements.
• Certified Teradata Professional - V2R5
• Extensive experience in working in SEI-CMM Level 5 Company.
• Extensive experience in various development methodologies such as waterfall, Agile etc.
• Extensive experience in working in onsite-offshore model.

TECHNICAL SKILLS

RDBMS: Oracle 11g, Teradata V13, Oracle Exadata, MySQL, DB2, Tandem Non-Stop SQL.

Application Tools: Erwin Data Modeler 7.3.9, Erwin Model Manager, ACORD 1.20, Trillium Discovery Data Profiler 11.5, Informatica Power Center 7.1, Cognos, SQL*Plus, SQL*Loader, PL/SQL Developer, TOAD,SQL Assistant, Teradata Administrator, BTEQ, FastExport, Multiload, FastLoad, SQL Loader, Siebel Tools, IBM Lotus Workplace Web Content manager, Rational RequisitePro, Rational Robot, Visual SourceSafe, MPCT Atlas, TSO, MS Office.

Industry Data Models: ACORD, IIA/IIW, JXDM, FSLDM.

Languages: SQL, PL/SQL, C/C++/Visual C++, TAL, TACL, Java 2.0

Web Technologies: Jdeveloper, Java Servlets, Java Server Pages

Scripting Languages: UNIX Shell scripting, HTML 4.0, DHTML, Java Script, ASP, PHP

Operating Systems: Windows NT/2000/XP, UNIX, Linux, Tandem

PROFESSIONAL EXPERIENCE

Data Architect / Data Modeler

Confidential, Enfield, CT

Environment: Erwin Data Modeler 7.3, Teradata 13, FSLDM.

Responsibilities:

• Perform initial study/analysis on various source systems to Confidential, understand business and system functionality.
• Review record layouts and ensure data dependency across source system capabilities in detail.
• Perform data profiling and review data relationship across source system functionalities in terms of the business requirements.
• Develop Logical Data Model using Teradata FSLDM reference Model in Erwin for various business capabilities.
• Coordinate the Data model versions within the project using Erwin Model Manager.
• Prepare Logical Data Model Mapping documents for various capabilities.
• Work with source system teams to ensure that the data feed provided has accurate structure/content to support the warehouse reporting requirements at high level.
• Plan and conduct LDM reviews with Modeling, Design and Architecture teams.
• Conduct LDM hand-off sessions with Physical modelers and developers.
• Provide additional Data architecture support to Confidential .
• Provide Data Model support to Database view development and QA team.

Data Architect / Data Modeler

Confidential, Hartford, CT

Environment: Erwin Data Modeler 7.3.8, Teradata 13, DB2, Ab Initio, AtenaSuite.

Responsibilities:

• Work closely with analytical and reporting teams to understand data requirements and provide data solutions accordingly.
• Coordinate periodic data warehouse model changes within different project teams in Personal Lines Data Warehouse project.
• Review business data requirements and translate them into logical and physical database models using ERWIN.
• Provide guidance for users and business owners, who seek data, across the organization.
• Provide data expertise to other data application teams.
• Assist users with data quality issues - and track issues thru resolution.
• Participate in database platform migrations and provide support in data model compatibility issues (DB2, Teradata).
• Work with data strategy team to define corporate metadata definitions for all Enterprise Data supported databases.
• Provide input to data modeling and physical database development standards with the Data Modeling Team.
• Work as an onsite-offshore coordinator to ensure that Database Admin support is available to the project 24x7.

Data Architect / Data Modeler

Confidential, Hartford, CT

Environment: Erwin Data Modeler 7.3.8, ACORD 1.21.0, Oracle 11g, Ab Initio, XML, Stylus Studio.

Responsibilities:

• Worked with Lead Information Architect and SMEs to identify the high level Business requirements for the proposed system.
• Worked with SMEs to build high level Business Model.
• Performed a detailed analysis on the existing applications Atlas CDE and Policy Writer to identify reusable database components.
• Prepared Logical and Physical relational data model based on the initial Business Requirements.
• Worked with POC team to evaluate the feasibility of having an Oracle XML based database.
• Worked with Data team to understand and analyze the detailed data requirements and defined TravAcord Data Elements for the project Data Dictionary.
• Worked with the Lead Information Architect to design and build Hybrid (Relational + XML) data model and XML/XSD for multiple projects across various Lines of Business.
• Worked very closely with development teams to fulfill their data requirements on time.
• Worked with other teams supporting interfaces to the Platform project (Gateway, External Services etc.) to ensure data architecture standards are followed across the projects.
• Worked with the IA team to prepare Data Mapping Document for the Integration Architecture (IA), which acts as an interface between the new Platform application and existing Policy Admin system (CARS).
• Worked with project teams to ensure that all aspects of projects data requirements are fulfilled and conform to the enterprise architecture standards. Assisted in continuous improvement efforts to enhance User Experience and provide increased functionality.

Data Modeler / Data Analyst

Confidential, Hartford, CT

Environment: Oracle 9i/Exadata, Teradata V2R6, Teradata Tools, UNIX, Erwin 4.0, Trillium Discovery, Siebel Analytical Tools, Business Objects, Informatica Power Center 7.1, Business Objects, MS Visio, Rational RequsitePro.

Responsibilities:

• Worked with business users and business analysts to understand the data requirements and help them to unify/standardize the current disparate business rules.
• Identified and Analyzed Source systems and data.
• Provided assistance to business users to finalize the authoritative systems and data requirements.
• Performed data profiling analysis and Data Cleansing for various business application sources using Trillium Data Discovery tool.
• Worked with Business users to address and resolve a major set of data inconsistencies across the business applications.
• Worked with Software evaluation team to evaluate three databases for the project.
• Prepared Unix Shell scripts for acquiring data for database performance testing.
• Developed Conceptual, Logical and Physical data models for Staging and Atomic layers for the project.
• IBM Insurance Information Warehouse (IIW) model was used as reference model.
• Developed Logical and Physical data models (dimensional) for Data Mart layer.
• Bus Architecture approach was used to design the Enterprise Data Warehouse. .
• Prepared Data Design documents.
• Prepared Data Mapping Documents for various source systems to Atomic/Data Mart layers.
• Participated in the delivery of functional specifications as it relates to the data needs of the business.
• Worked with enterprise Architects to define Architecture and Approach to the Project.
• Provided Data Modeling expertise to the technical and business teams.

Technical Lead/Data Analyst

Confidential, Hartford, CT

Environment: Teradata V2R6, UNIX, Mainframe, TSO, SQL Assistant, Teradata Administrator, BTEQ, FastExport, Multiload, FastLoad, ERwin Data Modeler 4.x, Trillium Discovery Data Profiler.

Responsibilities:

• Provided technical assistance to development team on major enhancements to BKF Extract, Transformation and Loading processes that bring data from Oracle, Mainframe systems.
• Facilitated customer review meetings to understand client's business process and review the performance and accuracy of the data loads.
• Generated HLD, LLD, Source to Confidential mapping, test cases and miscellaneous documents.
• Developed custom ETL packages using Teradata utilities BTEQ, FastExport, Multiload, FastLoad.
• Worked with enterprise Architects to define Architecture and Approach.
• Defined standards and guidelines for design and development.
• Managed technical issue and provide resolution.
• Conducted technical reviews for design and code.
• Involved in approving code that has completed unit testing.
• Recommended best architecture alternatives for project and estimate technical work packages.

Data Modeler / Data Analyst

Confidential, City of New York

Environment: Oracle 9i, ERwin Data Modeler 4.x, Trillium Discovery Data Profiler, Informatica Power Center 7.1., DB2, Rational RequisitePro.

Responsibilities:

• Interacted with Business users to understand the functionality of present case management system for both Adult and Juvenile systems.
• Performed Data Analysis for existing DOP Juvenile and Adult Case Management Systems.
• Performed Data Profiling using Trillium Discovery Data Profiler.
• Evaluated the feasibility of designing data models using Global Justice XML Data Model.
• Developed Logical and Physical data model for Staging and Atomic model using Erwin.
• Designed and implemented data validation procedures.
• Prepared Data Mapping Documents for Source systems to Atomic/Data Mart layers.
• Prepared test environment and loaded test data from DB2 tables using Informatica Power Center 7.1.
• Developed System Test Plan and Test Cases.
• Gathered requirements for Management Reporting required within and outside the agency.
• Developed Dimensional models using ERwin.
• Prepared Data Design documents.

Senior ETL Developer

Confidential, Phoenix, AZ

Environment: Informatica PowerCenter 5.x/6.1, Erwin 3.5.2, XML, MS Access, SQL Navigator, Oracle 8i, Windows NT 4.0 and Solaris.

Responsibilities:

• As a Senior Developer assisted the team in understanding the Customer requirements and meeting the clients on daily basis and accommodating their needs on the application.
• Involved in Designing the Database and online application along with the technical architects.
• On Oracle database created the tables and worked on writing the stored procedures and calling this procedures in the informatica mappings.
• Worked on creating complex online reports for Billing, Accounts etc using the crystal reports tool.
• Involved in end user training and implementing this package in various environments like Windows NT, Windows 2000 and supporting this application 24*7 on client basis.
• Created complex mappings to extract data from multiple sources and load them into staging level tables.
• Developed Informatica mappings to load monthly data such as members credit and debit transactions.
• Scheduled Informatica sessions on server manager.
• Monitoring daily job load and troubleshooting failure jobs.
• Integrated member transaction details by extracting data from different modules of the enterprise.

ETL Developer / Data Modeler

Confidential, MN

Environment: NonStop SQL, ERwin 3.4, TACL, UNIX Shell Scripts, C++, Windows NT 4.0.

Responsibilities:

• Performed detailed analysis on existing Purchase centric data/model.
• Wrote shell scripts to Extract purchase data from DB2 tables.
• Involved in developing Conceptual, Logical and Physical data model to implement three layers of Guest centric Data models using ERwin.
• Generated HLD, LLD, Source to Confidential mapping documents.
• Designed and developed C++ programs embedded with SQL to Extract/Transform/Load data to data mart level of Guest data model from DB2 database and flat files.
• Generated test environment and production environment migration documents.
• Involved in writing assembly test cases and preparing Test data document to aid testing team.
• Prepared Unit test cases and System test cases and recorded the results accordingly.
• Generated UAT test cases and coordinated the review of the same by Business Analysts.

Database Developer

Confidential, CA

Environment: NonStop SQL, TAL, TACL, C, GenWeb

Responsibilities:

• Interacted with clients to gather business user requirements.
• Evaluated the feasibility study on new product features and enhancements.
• Prepared estimation document to estimate the effort, duration and resource requirement during each enhancements to the project.
• Generated HLD, LLD, Test cases and miscellaneous documents.
• Designed and developed major product enhancements using C and TAL.
• Generated test environment and production environment migration documents.
• Wrote TACL scripts to simulate the test environment.
• Prepared Unit test cases and System test cases and recorded the results accordingly.
• Coordinated maintenance and enhancements of DSM/SCM with other Tandem products.
• Coordinate Major Product release processes.

Database Developer

Confidential

Environment: MPCT ATLAS, NonStop SQL, TAL, TACL, UNIX Shell scripts.

Responsibilities:

• Interacted with users to understand the problems reported on Atlas package globally.
• Prepared high-level estimation on effort, duration and resource requirement to resolve reported issues.
• Prepared high level design documents, low level design documents and Test plans.
• Configured test system environment to simulate the issues reported.
• Developed sub packages using TAL and C.
• Performed major enhancements for Core System Module servers of Atlas package.
• Provided functional and technical support to Atlas Banking production systems of branches in Europe, Middle East and Africa.
• Resolved issues ranging from business to technical levels and was successful in foreseeing problems and provide ways of improving the systems.
• Worked with sub projects that managed End of Day processing, Yearly Data Purges and End of Month support.
• Participated in Planning and implementation tasks for Atlas Package upgrades/implementation.
• Coordinated production release process.