SUMMARY

• Over15yearsof professional IT experience, 7 years inData ModelingforOnline Transactional processing (OLTP)and Online Analytical Processing (OLAP)systems and 3 years as Data Architect
• Experience in understanding the business needsandgathering user requirements by conducting and participating in JAD sessions, interacting with end - users and training them on the applications developed for the organization.
• Expert knowledge inSDLC(Software Development Life Cycle) and was involved in all phases in projects.
• Experience inDesign, Development and implementation of the enterprise-wide architecture for structured and unstructured data providing architecture and consulting services to Business Intelligence initiatives and data driven business applications. Services in overcoming traditional IT show stoppers for managing information on an enterprise level.
• Have experience in Dimensional Modeling using Star and Snowflake schema methodologies of Data Warehouse and Integration projects
• Extensively worked on ERWIN tool with all features like REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.,
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents.
• Experience withBusiness Process Modeling, Process Flow Modeling, Data flow modeling
• Experience in working with creating ETL specification documents, & creating flowcharts, process work flows and data flow diagrams.
• Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data in Oracle and MS-SQL.
• Performed extensive data cleansing, data manipulations and date transforms and data auditing.
• Experience in usingOracle, SQL*PLUS,SQL*Loader,TOAD,Win NT/2003.
• Developed database objects like PL/SQL packages, Oracle tables, stored procedures, triggers that are used for meeting the business objectives.
• Developed Data dictionary and maintained Metadata for each model.
• Used the tools like TKPROF and SQL*Trace to tune the query performance.
• Used various Hints and Database links to write effective programs across various databases.
• Knowledge in using EXPLAIN PLANS for query optimization.
• Coordinated with other developers in tuning long running SQL queries to enhance system performance.
• Involved in debugging and developing exception-handling procedures whenever required
• Extensive knowledge in software testing methodology and developing Test Plans, Test Procedures, Test Case Design and Execution, Modification Requests.
• Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.
• Good documentation skills and was involved in making functional and technical documentation.
• A strong team member with good Communication and Analytical skills.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, Toad, MS-Visio, ER-Studio

Programming Languages: Oracle PL/SQL,MS-SQL,VB 6.0, VB, ASP.NET

Databases: Oracle,SQLServer,MS-SQL,MS-Access,DB2,Netezza, Teradata, MySQL

Network Security Technologies: Ethernet and VLAN - WINS, DHCP, DNS, Firewalls, Active Directory Services, TCP/IP, FTP, Telnet, VPN, TAS

Virtual Environments: Citrix Terminal Server v 3.x and VMware v2.5.2 Deployment

Web technologies: HTML, DHTML, XML

Scripting Languages: VBScript, JavaScript, UNIX Shell Script.

Application Servers: WebSphere 6.0.

Web Servers: IIS 6.0, Apache Tomcat 5.5, Personal Web Server

Framework: DOTNET

Configuration Tools: Visual Source Safe (VSS), Altova Map Force 2015, Mule Soft, XMLSpy 2015, Tortoise Sub Version, GIT

Operating Systems: Windows-95,98,2000/XP/NT/Vista, Advanced-Server 2003, Unix v5.0, Linux-Red Hat v5.0 and VAX/VMS v5.2

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data Architect

Responsibilities:

• Participate in Solutioning and Design sessions
• Participate and organize JAD sessions
• Identify and analyze new requirements, perform data analysis
• Design Logical and Physical Data Models for Canonicals used in Service Applications
• Generate and deploy DDL Scripts in database Analyzing and Profiling data. Work with mapping documents. Work on Stored Procedures Help in Performance Tuning while running complex queries on database
• Coordinate with cross - teams and offshore team for design and deployment requirements
• Help in deployments and manage subversions for production releases.

Confidential, Green Bay, WI

Technical Architect

Responsibilities:

• Participate in Solutioning sessions for building new Enterprise Data Mart
• Participate in SOW framing sessions
• Coordinate in Resource Planning and Allocation Activities
• Lead offshore Development Team
• Conduct Touch Point and Team Status Meetings
• Identify requirements and provide data analysis
• Design Dim and Fact Tables for Customer domain in Phase I
• Participate in sessions for framing Standards for deliverables

Environment: Erwin 7.3, Toad Data Modeler, Oracle, MS-Visio

Confidential, Minneapolis, MN

Data Architect

Responsibilities:

• Identify and analyze requirements, provide gap and impact analysis.
• Designed Dim and Fact tables (Daily, Monthly and Yearly) to enhance current loads to capture history in SCD Type 1 and 2 methods. Designed Data Flow Diagrams, worked on Logical and Physical Data models in Model Mart, Mapping documents, DDL and metadata dictionaries for both Data warehouse and ODS environments.
• Designed ETL Architecture for handling the daily, monthly and yearly loads for Staging, ODS and Data Warehouse environments.

Environment: Erwin 7.3 and 9.0, Oracle, DB2 and MS-Visio.

Confidential

Data Architect

Responsibilities:

• Worked on designing one-time Conversion and quarterly Incremental loads for updating ICD9 and ICD10 Medical Terminology Codes from a new source to the Data Warehouse
• Worked on designing complete Inbound and Outbound processes for one-time Conversion as well as Incremental daily loads of Agent-Agency Producer (TRUEPRODUCER) data to and from the CALLIDUS System.
• Provide Mappings for Transaction files that are sent to CALLIDUS system for calculating Agent Commissions
• Designed Database and ETL Architecture in Teradata and Informatica environments for the projects

Environment: ERWIN 8.02, Teradata, DB2, MS Visio

Confidential

Sr/Lead Data Architect

Responsibilities:

• Initiate and schedule meetings with SMEs for requirements gathering during Source Analysis
• Analyze Legacy Source Systems and reverse-engineering them to ODS
• Involved in ODS, ADL(Atomic Data Layer) and Data mart design
• Conversion/Data Migration from Legacy Sources to Netezza Platform
• Was a part of the Standards Team in designing naming standards for Subject Areas, and Domains and standard templates for reports and Source to Target Mappings
• Designed Staging, ODS and Data mart layers using SQL Server 2008 platform for COGNOS BI Application for tracking status in Distribution Centers
• Responsible for end-to-end delivery

Environment: ERWIN 7.3, Netezza, MS-SQL Server 2008, DB2, MS Visio, Toad

Confidential

Sr. Data Modeler

Responsibilities:

• Participated/conducted JAD sessions for requirements gathering.
• Worked with the Project Manager and Business Analyst and designed Logical and Physical Data-models as per the requirements
• Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards.
• Designed and developed the Data Mapping documents, DDL Scripts, data dictionary and Meta data of the models and maintained them.
• Performed Data Validation and Unit Testing before handing over the data for production and Quality Testing.
• Performed Data Conversion/Migration from Legacy Applications developed using Access and SAS to SQL Server 2008 platform

Environment: ERWIN 7.2 /7.3, Oracle, MS-Visio, MS-SQL Server 2008, SQL Developer, MS Office

Confidential

Sr. Data Architect

Responsibilities:

• Analyze the Business information requirements and research the OLTP source systems to identify the measures, dimensions and facts required for the reports.
• Workedon data base build and table normalizations and de-normalizations
• Developed triggers, stored procedures, functions and packages using cursors and ref cursor concepts associated with the project using Pl/SQL
• Maintain change log and history tables for each data model and solved the production issues by debugging the code.
• Coordinated with ETL developers in providing data mapping and SQL queries for bulk data load

Environment: ERWIN 7.2 and 7.3, Oracle, Teradata, MS-Visio, SQL Developer, MS Office

Confidential, Herndon, VA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Identified and streamlined complex queries which were causing iterations and effecting database and system performance
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Created Views on tables as per the requirements
• Coordinated in database changes needed for the front end development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Work directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified by customers.
• Maintained change log for each data model and solved the production issues by debugging the code.

Environment: ERWIN, Oracle, MS-SQL Server 2005, MS-Visio, TOAD, Clear Case, MS Office

Confidential, Englewood cliffs, NJ

Sr. Data Modeler/Data Analyst

Responsibilities:

• Worked in-house on analyzing the business and functional requirements documents
• Involved in preparing Business Process diagrams, flowcharts, process/work-flow diagrams, data flow and relationship diagrams using MS-Visio and data-models showing process mappings, screen designs, use case diagrams
• Designed Metadata Repository to storedata definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Worked interactively with Business Analyst in understanding and manipulating changes in business requirements during Change requests
• Coordinated with DBA for implementing business rules, database changes and specifying user-roles for various processes in the project

Environment: Erwin 4.0, Oracle, MS-SQL 2000, MS-Visio, MS-Excel, MS-Access

Confidential

Business Analysis/Data Modeling

Responsibilities:

• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Validated and updated the appropriate Logical Data Models to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated user and technical documentation for processes in all phases of the project
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database models to incorporate design changes
• Involved in data profiling and cleansing to remove redundant data
• Provided input to resolve data limitation/constraints and issues
• Developedstored procedures, triggers, functions and packages in PL/SQL
• Reviewed processes and provided input into project plan
• Extensively used tracing methods to troubleshoot various time consuming queries.
• Helped in data migration from various applications to Oracle and MS-SQL 2000/
• Participated in development, UAT testing and implementation of pilot and real-time for the application development
• Provided other data analysis services, as required

Environment: Erwin 4.0, MS-SQL Server 2000, MS-Excel, Visio, MS-Access, Oracle, SQL, PL/SQL