SUMMARY

• 15 yrs of experience in the areas of Data Modeling, Business Intelligence, Data Warehousing, OLAP, MDM, Data Integration, Analytical Reporting.
• Insurance Industry & Financial Services experience. Extensive Vendor Relationship Management & Evaluation experience. Spearheaded Salesforce Cloud Computing.
• Expert in Managing conflicts. Managed onshore & offshore teams.
• Defined roles & responsibilities.
• Highly Logical & Analytical.

PROFESSIONAL EXPERIENCE

Confidential, Silver Spring, MD

Enterprise Data Architect

Environment: SSIS 2012, SSRS 2012, Kalido, Salesforce, MSCRM 4.0, Qlikview 9.0, Lawson 9.0, VSS 2005, Erwin 7.0, MS SQL Server 2012, Sharepoint, HP Quality Center 9.0, QTP, PVCS Tracker, Cast Iron 4.0

Responsibilities:

• Business Intelligence initiative - Piloted Qlikview implementation. Provided a single complete view of data to the upper management, sourced from heterogeneous systems of different LOBs using Data Virtualization techniques. Organized Staff training. Real Time On Demand Reporting capability implementation. Management of Dashboards & Scorecards for Performance Measurement. Oversaw Qlikview Lawson Integration.
• Salesforce - Spearheaded Salesforce SAAS Implementation based on Cloud technology. Integration with Apps using Cast Iron. MMD & Larkspur Financial data migration. Devised Data Governance Strategy. Led Salesforce Mobile App initiative for business leaders to access Customer Information on their mobile phones. MSCRM Salesforce Migration
• MDM - Led Kalido MDM implementation effort including creation of CDI & PIM hubs. Kalido DIW 8 staff training and modeling. Created UID for each product & customer & built cross reference to each connected system. Defined Data Governance process and change control. Customer & Product data available via Web Services to fully support SOAs. Maintained consistent data in real time with all suppliers. Standardized, match-merged, de-duplicated, analyzed & cleansed enterprise data to come up with the golden record to provide trusted, shareable version of customer & product master data
• Integration - Supported Lawson ERP backend implementation. ERP Integration with business apps. Legacy GL System Retirement & Migration to new ERP and Data Integration.
• EAI - Led effort to seamlessly integrate several Insurance apps and systems such as SurePower, USAS, ESL Office using Cast Iron as the EAI tool
• Formulated process to deal with post Data Breach. Led effort to extract & prepare data for State Regulators
• Involved in Disaster Recovery strategy planning, impact analysis
• SOX Audit Strategy Implementation. HIPAA compliance.
• Designed and developed audit mechanisms to support point in time reporting for historical query requests.
• Identified Best Practices for Data Modeling & MDM and ensured their implementation
• Leadership
• Managed team, including Report developer, data analyst, ETL expert, SQL Developer, data modeler
• Technical background and broad experience allows for understanding “big picture” business impacts of technology projects: real costs, practical benefits, risks and contingencies.
• Technical leader, implementing enterprise-based projects efficiently by pinpointing key issues and requirements from organizational imperatives.
• Effective in fostering collaboration & consultative relationships with senior management and across traditional boundaries, focusing on inflection points of technology decisions.
• Exceptional cross functional skills with customers, system users, stakeholders & IT groups including LOB Managers, Technical Architects, SOA Architects, Program Managers, TPAs
• Researched, prepared, documented & applied for InformationWeek 500 award, as a result the company was ranked 56th in US. Received special recognition from the CEO for the effort.
• Coordinated with IT Security Team to protect confidentiality and integrity of processed data, provide availability of the system and data, accountability for transactions processed including Authentication & Authorization methods for Ecommerce websites, Enterprise Portal and Mobile accessibility using Web Services
• Rigorous negotiations with multiple Vendors resulting in more licenses & maintenance support and 25% savings on total cost. Total savings over the years due to negotiations amounts to $0.5 million
• Led $1 million, six-month project, and saved $2k in annual IT staff and support expenses. Dropped software license expenses $3k, saved $1.25k+ in maintenance agreements & boosted customer satisfaction 19%.
• Involved in Tool Evaluations - defined Requirements/Criterias, created RFI, attended presentations by vendors, prepared Evaluation Matrix, ROI discussions with Business and deciding on Pilot Project, POC participation, Negotiated SLAs, QOS, Purchase process & planned staff training
• Used AGILE Scrum Methodology. Responsible for supervising and leading numerous projects simultaneously. Accountable for resource allocation and project timelines
• Worked with the user base and business stakeholders to determine present and future needs. Met with senior management regularly to discuss system design and project status
• Oversaw procedures for software releases. Mentored to in-house staff and provided system documentation

Confidential, McLean, VA

Data Architect

Environment- IBM DB2 UDB 8, ERwin 7, ModelMart, Rational Clearcase, Clearquest, Weblogic DOORS 7.1, DART 4.3

Responsibilities:

• Worked with Data Integration Architect and Process Analysts to obtain and document data flow diagrams (DFD) and formulate the data architectural in alignment with the vision
• Collaborated with database administrators, information architects, business analysts, business engineers, application architects, storage engineers, testers and data modelers
• Attended BRS Walkthroughs, Peek & Peer Reviews. Minivision docs. Provided plan and specification for QA step
• Built an MS framework for capturing, sharing, distributing, securing, and leveraging Client’s data resources.
• Worked with the BI Governance team to implement end-to-end BI methodology and data standards through development lifecycle and implementation of BI projects.
• Assisted in migration planning to move existing applications or systems to new data sources or data stores.
• Created Migration Documentation and Process Flow for mappings and sessions
• Updated Subject Area Life Cycles and defined entity state transitions
• Created process and data interaction CRUD matrix
• Maintained and configured source code using Rational Clearcase as a version control system
• Oversaw ETL development of the financial mortgage data warehouse supporting the Loan, Investor and Property subject areas. OLTP & OLAP design. Dimensional Modeling using Kimball methodology
• Maintained data integrity in the warehouse by performing data analysis and data quality processes (use of PL/SQL to analyze data and perform data extracts). Created & deployed DDLs & DMLs.
• Proposed and implemented Data Security Standards including privacy, classification, PGP encryption
• Published standards and procedures for data analysis and design activities. Followed MISMO standards
• Defined data domains. Published data dictionary to facilitate communication about all corporate business models
• Interfaced with customers and data analysts to understand and refined data requirements using DOORS
• Mapped data requirement to the Operational Data Store (ODS) and the Enterprise Data Warehouse (EDW)
• Designed TDS data models and corresponding ODS & CDW models. Reverse Engg, physical & logical data modeling. Data movement between Schemas.
• Created data structure diagrams for source fields and any previously performed rationalization. Developed data quality control processes to verify integrity of ODS data relative to the source HR system
• Created function & process decomposition diagrams and narrative deliverables for functional requirements

Confidential, Pasadena, CA

Project Manager

Environment- MS SQL Server2000, Test Director, ERwin 4.1, MS Analysis Services 2000

Responsibilities:

• Ranked 9th among the top mortgage banks in USA
• RUP & UML Methodology. SDLC methodologies. Scorecarding, Performance Measurement & Dashboarding
• Provided specification support to Report development
• Ensured data standards compliance at a project level - oversaw project implementation of data models (logical/physical). Represented the enterprise perspective in data design discussions. Contributed methodology knowledge to the project planning process. Used CASE tools
• Participated in Business Intelligence Steering Committee
• Assisted with performance evaluation of alternatives and assessment of risks and costs.
• Created project plans using MS Project.
• Synchronized 4 different databases including SQL server, Siebel & Peoplesoft. Maintained Data Repository
• Wrote SQL queries to optimize databases. Managed team of 8 including 5 offshore developers. Maintained ODS. Responsible for Data Cleansing, Aggregation & Transformations
• Studied Mortgage Banking business requirements, prepared database design docs & functional specs. Developed the Loan Contact Management System across 3 different platforms
• Created Logical & Physical Data Models for each Loan Processing task. Developed Archiving strategies. Populated and maintained technical metadata repositories. Created Audit & Snapshot tables
• Developed data marts (star schema), cubes, OLAP design, MDX. Used Kimball Methodology.
• Provided docs for Data Mapping & Data Sourcing. Coordinated & instructed DBAs, Application Developers, Business Analysts, Rules & Profiles team, BRAIN calculation logic team

Confidential, Orlando, FL

Sr Data Modeler

Responsibilities:

• Data Modeling (Oracle 8i, ER Studio, SAPHIR, SAP-FrontEnd, Informatica PowerCenter 6)
• Created Enterprise Data Dictionary (EDD) for 12 depts, used by Business analysts, Data Architects, DBA & Developers. Directly linked the EDD to Business Object Types (BOT)
• Reverse Engineered & removed 600 duplicate domains in the gFACTS logical model, categorized into 11 unique fields for consistency, published submodels to promote integration of disjointed databases. Used horizontal & vertical splitting for optimization & denormalization for efficiency
• 30% reduction in data redundancy, accessibility increased two folds resulting in efficient bandwidth utilization
• Designed & improved Knowledge Perspective DB for performance by optimizing entity relationships in the model
• Performed ETL on 5 different instances of SAP R/3 functionality for DataWarehousing, Metadata definition extraction using Stored Procedures. Merging of gFACTS & CSTS Data. Data Mining pattern recognition
• Misc (JMeter, ChPt Report Designer, Caliber RM, MS SharePoint, OPNET ITGuru, ITSentinel, ARIS-SOX Mgr)
• Performance & Stress Testing on KP search engine for 2000 user & 500 concurrent users
• Training in OPNET tools, Modeled Confidential LAN & WAN by importing traffic data, installed capture agents in app servers like Domino server, WebSphere to study traffic
• Created 16 reports in ChangePoint. Organized training for key Managers of 9 depts in preparation for Sarbanes Oxley (SOX) Act audits
• Involved in Req Mgmt & creating Functional Specs for the project, improved SDLC
• Created Feasibility Study for Preference Mgmt project to save user settings ranging over 28 different apps. Involved in Risk Assessment, improving the efficiency by properly integrating roles & entitlement
• Worked on integration of MS SharePoint into Enterprise Portal
• Created design docs for the Enterprise Portal Framework for easy compatibility of Web Services & SSO