SUMMARY:

Highly accomplished data management executive with experience leading teams to analyze business processes, gather system requirements, design solutions, and deliver accurate applications. Expert in various systems and technologies related to Insurance Systems, Banking Systems, Loan Registration Systems, Reinsurance, Trading Systems, Data Warehousing, Electronic Data Interchange (EDI), and Database Administration (DBA). Known for excellent communication skills, executive influence and developing programs aligned to a company’s needs.

CORE COMPETENCIES:

• Policy Development
• Requirement Identification
• Team Leadership
• BI/Information Management
• IT Strategy
• Cost/Benefit Analysis
• Digital Transformation
• Big Data/Cloud
• Data Architecture
• Data Warehousing
• Project Management
• Change Management

TECHNICAL PROFICIENCIES:

Operating Systems: Windows, UNIX

Languages: PL/SQL, T - SQL, Visual Basic 5.0, JavaScript, PowerBuilder 4/7/8

RDBMS: Oracle 7.3 and 9i, Sybase 11.2, Sybase SQL Server, DB2, DB2 Control Center, MS SQL Server, Teradata

Software Tools: Informatica, TOAD 7.6 and 8.6, Erwin, MS Visio, MS Project, DB Artisan, PowerDesigner 12.5, Infosphere Data Architect, Rochade Metadata Repository, XML Spy, Cognos 8.4, TROUX Architect 9.0, Tableau, Qlik, Guidewire

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, IL

Experienced Manager

Responsibilities:

• Managing engagements, engagements economics, leading teams and managing client expectations to help our clients in their key business/digital transformation projects.
• Extensive experience with Confidential Suite with a focus on the Data Management Solution.
• Build key relationships with clients, identifying opportunities for business development and at the same time being a trusted advisor for our clients.
• Implemented data warehousing/data-mart solutions, performed data analysis and data mapping, developed standards and processes from a data management perspective
• Mentored and guided junior team members to establish Data Architecture, Data Modeling, Data Governance and Metadata Management disciplines
• Composed enterprise data strategies translating to execution, crafted roadmaps to achieve the future state vision

Confidential, Chicago, IL

Experienced Manager

Responsibilities:

• Led and managed the Data transformation work-streams within multi-million dollar transformation projects .
• Participated in various pre-sales/sales pursuits acting as SME in the Data Management domain garnering additional work in excess.
• Build key relationships with client stakeholders, managed client expectations and managed vendor relationships.

Confidential, Chicago, Illinois

Experienced Manager

Responsibilities:

• Provided management & advisory consulting services to Confidential 100 clients in the Enterprise Intelligence practice covering such disciplines like Business Intelligence, Data Warehousing, Data Architecture, Metadata ManagementData Governance etc.
• Leading engagements, managing engagement economics, ensuring delivery of quality services at clients.
• Performing current state assessments, composing strategies to establish the future state from a Data Management perspective.
• Interfacing with client executives to understand key issues faced and helping them build effective solutions to mitigate risks. Instrumental in providing thought leadership and industry best practices at various client engagements.
• Fostering business development activities at strategic clients and building client relationships.
• Drove numerous pre-sales pursuits in the Insurance vertical from a Data Management/BI perspective
• Provided Subject Matter Expertise (SME) at various clients with a focus on Guidewire Claim Center, DataHub and InfoCenter products
• Domain expertise in P & C Insurance vertical, part of the complete sales life-cycle including pre-sales presentations, client relationship management, strategic opportunity management & other activities
• Crafted and composed numerous proposals (RFP) for various clients in the finance and insurance verticals

Confidential, Milwaukee, Wisconsin

Enterprise Information Architect / Principal Consultant

Responsibilities:

• Provide data architecture, business intelligence, and management consulting to support of various projects; design and implement standard operating procedures and proven application development strategies.
• Examine business functions and suggest strategies for technology development that streamline operations while reducing IT expenses.
• Interfaced with client executives to examine business strategy for BI reporting.
• Structured detailed project plan with infrastructure requirements that integrated with other project initiatives.
• Facilitated development of rigorous executive reporting dashboards. Mentored & guided team members in data modeling practices for Master Data Management initiative
• Mentored team members in IBM’s 9 data concepts for banking & dimensional modeling concepts
• Supported technical requirements by providing data architecture services for Global Access Control (GAC) project, including ensuring standards and best practices were adhered to by various
• Recommended the clients use a free add-on tool to view data models and to save time and money for the enterprise and data architecture team.
• Fabricated solution to access data required by project that lead to $500K savings in development costs.
• Built Enterprise Data Architecture Group within the organization to include process development and implementation with 6-person team of third-party contractors. Introduced and established solid Data Modeling discipline to utilize key strategies that lead to efficient architecture design and delivery; enforced standards and best practices to improve results. Coordinated $200K project budget.
• Initiated use of DB2 connect interface to access mainframe data easily and quickly; designed and implemented a Metadata Repository solution with superb time/cost savings, and improved productivity.
• Conducted reviews and inspections of project-related artifacts; provided recommendations to enhance database performance.

Confidential

Senior Data Architect/Project Lead/Senior Application Developer/Consultant

Responsibilities:

• Directed team of 5, including offshore resources, in development of innovative simplification strategy for Enterprise Data Warehouse storing credit card transactions.
• Coordinated systems vendor team members throughout strategy design and deployment.
• Oversaw inspection and review of project artifacts, resolved technical issues, and presented status reports to key Target stakeholders.
• Served as Project Manager and provided technical leadership for various global business intelligence products, to include NOZOMI project to report service-related metrics for the diagnostic imaging business.
• Utilized offshore/onshore development model and led team of up to 30 Developers and Analysts. Mentored team members and inspected all project-related documents for accuracy; negotiated project scope and formulated work breakdown structures and task estimation.
• Championed technical development and project leadership for large enterprise applications within Allstate Insurance Company; estimated tasks, created Work Breakdown Structure (WBS), and communicated status updates with team members and supervisory staff. Converted data from various reinsurance legacy and client/server systems, including AON and AMRE, into the data-warehouse.
• Pioneered data acquisition strategies, implemented databases, and oversaw problem resolution.
• Led logical and physical design for the staging area and programmed applications in complex PL/SQL to fetch, standardize, transform, and cleanse the data.
• Developed PL/SQL procedures and prepared database requirements and design specifications for the data-warehouse; conducted database administration (DBA) tasks to support development areas.
• Interfaced between business users and technology team members at Confidential ; estimated required tasks according to comprehensive requirements gathering effort and drove all processes to completion based on solution recommendations.
• Created complex queries and reports, and loaded data using SQL Loader.
• Performed modeling tasks such as logical data modeling and entity-relationship modeling.
• Maintained and supported insurance policy management system called Confidential using SQL Windows 1.5 and Oracle 9i backend.
• Served as Senior Application Developer to mentor other team members on project scope, timeline, and deliverables; steered solution development and supported SIMS application for television and entertainment industry.
• Interfaced effectively between external clients and client liaisons to describe new system initiatives and define project requirements.
• Fixed bugs in software, designed enhancements and maintained solution as needed for maximum productivity.
• Researched technology best practices and made recommendations to management with regards to implementation of internationalization and Unicode support for the SIMS product.