SUMMARY

• Provide SDLC guidance to large project teams in developing a process driven organization.
• Assisting the business functional teams in performing requirements analysis, gap analysis, deployment of the application systems and coming up with appropriate workarounds for the identified gaps.
• Architecting/data architecting, solutions design of use case business flows, and construction of business intelligence and reporting application solutions.
• Strong business/Software experience in object - oriented analysis and design including SOA.
• Leading end-to-end System and Business Solutions, and Software Architect that integrates and performs requirements gathering, design and implementation for enterprise e-business, CRM, Data Warehouse, Security, Technical Marketing, Software Accounting and Financials, Banking, Web Services in all system development areas.
• Expertise and passion in MDM, Data Governance, Data Modeling, Data Warehouse on Inmon and Kimball principles, Enterprise Architecting and design flows, use cases, with use of Sparx Systems Enterprise Architect, Altova*XML Spy for schema mapping and UML, Erwin, ETL, Reporting, etc.
• Experienced software development project manager with waterfall and agile methodologies, skilled in gathering and documenting requirements, developing project plans, managing and tracking project execution, designing prototypes and assisting with usability testing, developing and executing test scenarios, complying with regulatory requirements, various governance boards, releasing products to production, and maintaining product releases, etc
• Program and Project management vendor selection/initiatives and management, project planning and resource management, collaborate with marketing and sales teams on proposals, interfacing with executives and stakeholders, and the implementation of software and hardware in order to establish a successful IT system.
• Managing user interfaces across several vertical industries/departments for system developments, releases, upgrades, installations, configurations, deployments and maintenances.
• Thorough understanding of matrix organizational concepts such as risk management, change management, and business development, cost benefit analysis, and return on investment as related to enterprise-wide initiatives to ensure timely completion within budget constraints.
• As an IT supervisor in a hospital overseeing emergency room admissions and general outpatient, inpatient admissions and visit, I had the responsibility of collecting and coding the EMR and applicable medical claims records of ICD-9 and ICD-10 codes for billing purposes for the Finance and HIPAA (X12) applications with insurance health claims.

TECHNICAL SKILLS

• Erwin 7r
• TOAD
• Oracle 9i
• 8i
• MS / Project
• Microsoft suites
• RUP
• UML
• XML
• ETL Informatica
• Microstrategy
• Abinitio
• Erwin
• Brio
• Weblogic
• WebMethods
• Websphere
• Ephiphany
• Seibel
• Java
• C/C++ SQL
• Oracle Designer 2000
• PowerPoint Visio
• Excel
• SAS
• Sales Logix
• Digex
• Bizbots
• Javelin
• Rosenbluth
• JDBC
• Unix Scripting Shell
• BEA
• CGI
• NetApps
• HTML
• .NET
• EMC
• ASP/ISP
• Verisign
• Perl
• PL*SQL
• SQL*Plus
• SQL*Navigator
• Vi
• BI/Business Objects
• Oracle Discoverer
• Oracle Designer
• Oracle Project Accounting
• Java ++
• Visio
• PowerPoint
• Access
• Excel
• Windows/NT
• MS/Suites
• SEI (CMM)
• DB2
• Virtualization
• AIX storage
• IBM Siperian / WCC tools etc.
• Hosting Architecture
• Redundancy
• High Availability
• Clustering
• Failover
• Robustness and Load balancing

PROFESSIONAL EXPERIENCE

Confidential

Lead Business Analyst/Lead Process Designer

Responsibilities:

• Talking to several users on various applications, to gather requirements to be used for the process design with Visio, data distribution using Oracle MDM domains such as customer, supplier, site, account, asset and product.
• Creating project schedules and work-breakdown-structures for the group.
• Use of Microsoft Suites of Products; MS/Word, MS Excel, MS/Project, and Data Profiling of the Meridium system
• Hyper linking the applications to the vision design.
• Proof reading and review it with the Director of the group for approval.
• Orderly posting other documents to their SharePoint site.
• Document and posting the requirements to the SharePoint site as well.
• Creating project schedules and work-breakdown-structures for the group.

Confidential

Senior Lead Data Architect/Data Modeler

Responsibilities:

• Architect, design and model Honda manufacturing telematics, mobile and financial data in the front-end mobile telecommunications mobile device.
• Engage in developing enterprise data warehouse relational conceptual data modeling, enterprise relational logical data modeling, enterprise relational physical data modeling, enterprise relational entity relationship modeling, data dictionary, model standalone schema scripts with use of Erwin r9 forward engineering and Visio presentations with DB2, SQL Server, Oracle, etc.
• Enforce Referential Integrity and Support Business Rules. Synchronize a Data Model and a Database. Resolve Many-To-Many relationship issues. Validate a Data Model, Generate schema DDL through forward-engineering.
• Co-ordinate process of requirements documentations, best business processes, etc. Interfacing, integrating and engaging users and cross-functional teams for decision better and project implementation. Providing project status, project deliverables and timelines. Mapping project resources to requirements to project appropriate labor hours.

Confidential

Service Delivery Manager/ Consultant

Responsibilities:

• Healthcare Enterprise Data warehouse/Business Intelligence redesign project from existing Oracle enterprise data warehouse to SQL server environment.
• Use of all healthcare subjects areas in payer, payor, PCP, providers, claims, sponsors, member enrollments, etc.
• Co-ordinate in the process of requirements in profiling, conversion, data cleansings, data modeling, project schedules with Facets, (QNXT) data, OPTUMINSIGHT data, and existing etc.
• Enterprise Data Warehouse support/design expertise in change management, change data capture, master data management (MDM), data governance, data conversion, data federation, data integration, data mart design, metadata creation, processes and best practices.

Confidential, Englewood, Colorado

Senior Data Architect/Data Modeler

Responsibilities:

• Data modeling (logical, physical, and conceptual),
• Requirements definition,
• Using Teradata and Netezza
• Working with Preferred Embarcadero
• Maintaining a data dictionary repository
• Performing data profiling and working within the data quality program
• Assisting with Metadata tools, development and integration
• Handling the full-life cycle of data mining and support (staging, base, aggregates, data-marts for BI repository, data-mining, etc.).

Confidential

Business Analyst / Program Manager

Responsibilities:

• Act as the Liaison between the business and technology team working with DOR subject matter experts (business and OIT), OIT lead, OIT Development Manager, and other OIT groups (infrastructure, database management, change management, security, etc.)
• Determine scope and provide time estimates for completion of project tasks
• Facilitate sessions with business and OIT members to define and document concise business requirements
• Create business communication plans or conform to existing plans
• Facilitate detailed communications between project group users, super-users, etc.
• Provide process and system diagrams
• Creating test plans to support data migration and application enhancements to test against data migration for users and super users.
• Analyze business and technical problems and provide solutions
• Identify and document requirements via data flow modeling, data and object modeling, workflow analysis, functional decomposition analysis, or other standard industry analysis techniques
• Manage requirement scope, traceability for testing, functional, and non-functional requirements
• Submit weekly status reports

Confidential, Denver, Colorado

Lead E-Business System Consultant/Program Manager

Responsibilities:

• Acts as a liaison between client areas, technical organization, and other affected areas by planning, conducting, and directing the analysis of highly complex business problems through internet/intranet-based solutions. Responsible for producing business requirements.
• Functions as project manager for large and complex projects.
• Development of use cases, activity and sequence diagrams with Sparx Systems Enterprise Architect tool for Solutions Architecting.
• Development of enterprise Schemas with Altova*XML Spy tool.
• Developing of Schema Mapping documents for Data solutions.
• Development of Functional Specification Documents, Business Requirements Documents, Project Documents, all in a distributed development team environment.
• Leading meeting discussions for Development, Testing, Installations, and JAD sessions, Etc.

Confidential

Business Intelligence Data Architect/Data Modeler Manager/Project Manager

Responsibilities:

• Gathering and defining BI requirements for use in querying the database, pulling and posting data off Omniture’s web based tool on user profiling and healthgrade.com sites for Physicians, Nursing Homes and Hospitals ratings projects.. Projects including the Analyzing of web strategies for the enterprise SaaS business unit to online services with a combination of SEO, SEM, consumer e-marketing and other online sites for conversion projects and user activities revenue project tracking.
• Hands on Data warehouse schema architecting with use of Inmon and Kimball principles.
• Use of Excel spreadsheets to create trend analysis on ah-hoc produced reports used for analysis, to produce intranet web manuals with PowerPoint about subscriptions on physician data, nursing home data, hospital data, plus daily watch and analysis on revenue, metrics, ROI and online programs.
• Use of VISIO and SharePoint for creating and managing processes on web trend initiatives.
• Use of Microsoft SSRS, SSIS, SQL Server management, visual studio (TFS) for Agile development as a (SCRUM Master).
• Work with users, vendors and internal clients to coordinate project activities, produce project timelines and status reports and manage various projects as requested.
• Complete understanding and knowledge of RDBMS.