| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate Candidate's Name
Street Address E Temple Drive Aurora, Colorado Street Address
PHONE NUMBER AVAILABLE/ EMAIL AVAILABLESUMMARY . Electa is an established Business Program Manager/Product Owner/Project Manager/Business/Systems Analyst Lead/ with a wide range of experience in Product Development in Distributed Server Technologies, Marketing, E-commerce, WebLogic, WebSphere, E-business, B2B. C2C, B2C, CRM, Data Warehouse/Business Intelligence, PeopleSoft HCM/HRIS/HRMS, Workday HRC/HCM, and SharePoint tools, etc. She has extensive experience in IT with Big 5 consulting engagements and Fortune 500 to over 1000 companies. . Provided SDLC guidance to track progress on large project teams in developing a process-driven organization, with business and functional requirements, process flows, and data mappings, developing test plans, and test cases, defining and documenting procedures and workflows, performing testing, creating user documentation and user training manuals, and post-implementation support and lessons learned documentation on any projects. . Consultative B2B experience in implementing Cloud producer and customer solutions. . Artifacts of the system development life cycles (SDLC), involve business requirements gathering, analysis, solution design, testing, training, and support of business information systems deployed throughout cross-functional teams in the 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 . Spent 2 years with Deloitte, IBM, EDS, and NTT DATA on distributed middleware implementations, 5 years with creating other middleware distributed banking applications on Bank of America and FirstBank, spent additional 2 years with universities distributed middleware implementations on various dimensions as on compliance and data management, process management, reporting on various tools, use of various middleware tools like Apache Tomcat, WebLogic, WebSphere, SharePoint, etc. . Lead and implemented SharePoint tool in phases of planning, requirements gathering, and documentation. Data identification and classification, prototype, development, demo, data migration, and final testing and training of IT users. . Customer-focused centric, with strong people skills in partnering abilities, demonstrated with Big 5 consulting engagements and fortune 500 companies in Telecommunication, Software's/Hardware's, Insurance, Health, Human Resources, finance, Banking, etc. . Lead and Implemented PeopleSoft HRIT/HRMS, Oracle e-Business Suite Financials or Procurement and Payroll. applications for several consulting engagements with IBM, Deloitte Consulting and Comcast Corporation, 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, SOAP/Web Services, 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, MDM, Data Governance, Security, Technical Marketing, Software Accounting and Financials, Banking, Web Services in all system development areas. . Expertise and passion in Data Modeling, Data Warehouse on Inmon and Kimball principles, Enterprise Architecting and designing flows, and use cases, with the 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, identifying stale data, 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 to establish a successful IT system,TECHNICAL SKILLSSoftware Tools: Erwin 7r, TOAD, Oracle 9i, 8i, MS / Project, Microsoft suites, RUP, UML, XML, Case Complete, ETL Informatica, MicroStrategy, Ab-initio, Erwin, Brio, WebLogic, SharePoint, OneDrive, Web Methods, WebSphere, Apache Tomcat, Epiphany, Seibel, Java, C/C++ SQL, CAD (Computer Aided Designer), Oracle Designer 2000, PeopleSoft, HCM/HRIS/HRMS, Azure Cloud, AWS Cloud, GCP, Oracle Cloud HCM, HR, Base Benefits, Benefits Administration, ESS, MSS, e-Performance, etc., PeopleSoft, PowerPoint, Visio, Excel, SAS, Sales Logix, Digex, Bizbots, Javelin, Rosenbluth, JDBC, Unix Scripting Shell, SOAP, BEA, CGI, Net Apps, 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, UX Design, SEI (CMM), DB2, Virtualization, AIX, storage, etc.Applications: Middleware Distributed Servers, Compliance, Data Management, E-commerce, E-business, Hosting Architecture, Redundancy, High Availability, Clustering, Failover, Robustness, and Load balancing environments and software tools involved: Oracle 8i, 9i, 11i, Data Marts, Metadata, Oracle, Teradata, Storage Management and Database Security, Supply Chain, Procurement, ERP, SAP, Web Services, Siebel CRM OnDemand & CRM Professional Edition, Processes with RUP, UML design and workflows, Machine learning.Hardware: IBM Mainframe, Sun Microsystems, Dell, Sony, HP,Windows/NTMethodologies: ISO 9000, Agile, lean sigma, CMMI, and waterfallEDUCATION & PROFESSIONAL DEVELOPMENT . M.S. Computer Information Systems, Southern New Hampshire University, Manchester, NH, 1992 (Graduated) . M.B.A Financial and Marketing Systems, Southern New Hampshire University, Manchester, NH, 1992 (Graduated) . B.S. Computer Science Management - Franklin University, Columbus, Ohio/1986 . B.A. Public Administration/Personnel and Labor Relations - Franklin University, Columbus, Ohio/1979CERTIFICATIONS . PMI - Certification (Expired) . SCRUM Master Certification . Focus Project Management/Software Development - Boston University, MA (Active) . ORACLE Database Overall Fundamentals (Active) . ORACLE Database Administration (Active) . Lotus Note (Active) . Oracle Discoverer End User and Administration (Active) . DB2 Version 4.2(Active) . ORACLE DBA for the Advanced Professional (Active)Training . E-business Certification - Deloitte Consulting . UNIX, C/C ++, JAD . Unix Korn Shell programming . Fundamentals of Software Testing . Communications Billing Services Overview . File-Aid for DB2 and File-Aid/RDX Related Data Expert . Project Management Simulation . Information Map-Mapping Operating Procedures . Windows/NT Architecture . Client Server Based Architecture . Web Browser, Internet, HTMLPROFESSIONAL EXPERIENCEThe Judge Group 06/2022 - 09/2022Project Architect . Modernizing formal enterprise CRM, SCM system architecture to current Cloud system architecture. . Represent the teams in meetings on all project architecting. . Putting in place best business practices and creating business documentation and architectural flow diagrams and documents to reflect the new cloud architecture. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, track progress, coordinate project execution, manage risk, manage communication cross-functionally, and coordinate large complex projects in Web Services across departments. . All projects with the use of Jira, Confluence, all cloud platforms as needed, etc.AT&T Corporation/Contractor 03/2021 - 09/2021Product Manager/Solutions Architect . Understanding of the different file processing functionalities such as streaming, batch, real-time, and near-real-time, for Azure, AWS, and GCP cloud transformations and migrations from on-premises to cloud. . Define tools capabilities and tools use cases for the client's event bus and service bus. . Architect the Integration and Non-Integration Layer Use Cases from the producer client hosting tier to the consumer client hosting tier. . Architect the integration and non-integration IEBUS and ISBUS use cases. . Create the use case decision tree flow. . Create the Tool selection sub-decision tree flow. . Orchestrate the decision metrics for file transfer tools. . Consultative B2B experience in implementing Cloud producer and customer solutions. . Set up and develop the proof-of-concept development environment to test clients' tools that does the migration from on-premises to cloud platforms. . All projects are managed by JIRA.Comcast (through WIPRO), Philadelphia PA, and Denver, CO 04/2019 - 01/2020Data Governance Product Owner/Project Manager/Business Analyst . Integrating and analyzing systems, Security Privacy projects with users, data owners, architects to scan and onboard and integrate security systems and privacy on MYCP, CPP and DX, BigID. . Understanding of different data sources and structures for onboarding. . Use of Manta to integrate with Collibra's Data Governance Center to parse all the code of the connected databases and shows all the specified actual data lineage. . Use of Excel spreadsheets to demonstrate system data structures, data elements for analysis, and decision-making on various cloud elements and systems like, Data Lake S3, NDW, MELD, and EMM. . Be able to manage and architect various onboarding BigID security privacy projects. . Data Lake, Azure, S3 on Cloud wrapped around with Scala on API, Python, Hadoop, AWS, and Spark with SQL, Teradata, MongoDB Oracle, Data Warehouse, UX Design, ETL process, Architect design principles. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, and coordinate project execution, manage risk, manage communication cross-functionally, track progress, and coordinate large complex projects in Web Services across departments. . All projects are managed with JIRA, with files kept in SharePoint and OneDrive.EPAM Systems, Eagan MN 10/2017- 12/2018Data Solutions Product Owner/Senior Business Analyst . Work with the customer on clarifying and documenting requirements. . Put requirements as user stories into Jira or TFS. . Collaborate with the offshore team, which will be in St. Petersburg, Russia. . Assist in the Scrum process facilitations! . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead and coordinate project execution, manage risk, manage communication cross-functionally, track progress, and coordinate large complex projects in Web Services across departments. . Use of Financial Services domain, Workday HR/SCM, Risk Management experience. . Used Workday HR/HCM not just to manage and track the workforce, but to also have a full understanding of the workforce HR/HCM data to understand the workforce, skills, capabilities on providing insights the organization can use to make changes, decisions on personal experiences and to nurture organizational growth of employees. . The workday enterprise management cloud I was involved with included solutions for finance, HR, planning and spend management. . After identifying the stale data, the data environment is cleansed and streamlined to suit current data business data needs and business domains and groups. . Ensure collaborative aspects of the SharePoint Platform by offering training to users, and listening to feedback and concerns after deployment for data visualization, UX Design, data governance, data sourcing for enrichment, big data, and streaming data. . Work independently onsite. . Working with Scrum teams. . Tools: TFS, Microsoft Word, Visio, Excel, SharePoint.TEKsystems, Englewood CO05/2016 - 12/2016Lead Product/Program Manager Analyze and integrate data extraction through the entire project life cycle. . Work closely with stakeholders to define project parameters to translate needs into formal requirements with the use of industry delivery methodologies. . Develop detailed project schedule, resource plan, project scope, and status reports. . Apprise the stakeholders and VP of risks, issues, and recommended mitigations. . Create a historical employee data warehouse for easy access. . After identifying the stale data, the data environment is cleansed and streamlined to suit current data business data needs and business domains and groups. . Ensure satisfactory control of deliverables, project documentation, and security standards of archived records.Blue Shield of California, SFO, CASept 2015 - Dec 2015Sr Product/Program Manager on Data Governance/Business Analyst . Creating enterprise data governance operational model. . Determine roles, responsibilities, skills and qualifications, activities/functions on. . Data Owners, Data Stewards, SMEs, Data Custodians, . Identify data governance capabilities and tailor them to the applicable governance team roles. . Specify the key data governance key characteristics, accountabilities, and responsibilities on Facets and QNXT data. . Creating and documenting all the above documents for presentation and best practices to the organization. . Used Composite Information Server query engine to create composite views for query optimization, for data caching, data access, data publishing, data quality, data access security, MDM, data governance, and metadata repository. All the above uses the composite Data Virtualization platform that includes the above-mentioned integrated development environment of desperate source stale data systems to do relationship data discovery, data modeling, view and data service development, and revision control on the entire CIS Platform as a great data integration environment. . After identifying the stale data, the data environment is cleansed and streamlined to suit current business data needs, domains, and groups. . Collaborate in developing and presenting standards and procedures for implementing enterprise logical data models in the CIS Data Virtualization environment. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, and coordinate project execution, manage risk, manage communication cross-functionally, track progress, and coordinate large complex projects in Web Services across departments.Amadeus Consulting/First Bank Denver, CO02/2014 - 05/2015Sr Product Manager/Business Data Architect . Meeting with users to identify data architecting needs. . Modifying existing architecting environments and structures . Creating roadmaps for a new Data warehouse, Business Intelligence, Analytics, MDM, and Data Governance environment. . Modifying the existing data models with the use of Toad, Power Designer, and SQL on Oracle. . Understanding. current needs and the database landscape for future best practices and standards . Use of Scrum Agile on Projects with posted artifacts using JIRA/JIRA . Talking to several users on various applications, to gather . Requirements to be used for the process design with Visio. . After identifying the stale data, the data environment is cleansed and streamlined to suit current business data needs, domains, and groups. . Hyperlinking the SharePoint design process flow models applications in the Visio diagrams. . So, the orderly posting of documents to their SharePoint site. . Document and post the requirements to the SharePoint site as well. . Creating project schedules and work breakdown structures for the group. . Use of Scrum Agile on Projects with posted artifacts using SharePoint.Wipro Technologies (FTE), Torrance, CA,12/12 - 05/2013Senior Product Manager/Lead Data Architect, . Architect, design, and model Honda manufacturing telematics, mobile and financial data in the Honda front-end mobile telecommunications mobile device. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, track progress, coordinate project execution, manage risk, manage communication cross-functionally, and coordinate large complex projects in Web Services across departments. . . Act as the Liaison between the business and technology team working to facilitate detailed communications between project user groups. . Identify and document requirements via data flow modeling, data and object modeling, workflow analysis, functional decomposition analysis, or other standard industry analysis techniques. . After identifying the stale data, the data environment is cleansed and streamlined to suit current business data needs, domains, and groups. . 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 the 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 documentation, best business processes, etc. . Use of VOIP to coordinate project teams across the world.Environment - DB2, SQL Server, Oracle, data modeling, data warehouseNTT DATA, Boston, MA(12/2011 to 3/2012) (Lay Off)Project/Product Delivery Manager . Healthcare Enterprise Data warehouse/Business Intelligence redesign project from existing Oracle enterprise data warehouse to SQL server environment. . Act as the Liaison between the business and technology team working to facilitate detailed communications between project user groups. . Identify and document requirements via data flow modeling, data and object modeling, workflow analysis, functional decomposition analysis, or other standard industry analysis techniques. . After identifying the stale data, the data environment is cleansed and streamlined to suit current business data needs, domains, and groups. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, and coordinate project execution, manage risk, manage communication cross-functionally, track progress, and coordinate large complex projects in Web Services across departments. . Use of all healthcare subject areas in payer, payor, PCP, providers, claims, sponsors, member enrollments, etc. . Co-ordinate in the process of requirements in profiling, conversion, data cleansing, 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 conversion, data federation, data integration, data mart design, metadata creation, processes, and best practices. . Use of VOIP to coordinate project teams globally.Environment: - Enterprise Data Warehouse, change management, change datacapture, master data management (MDM),Dish Network, Englewood CO 11//2011 - 11/2011(Contract Completed)Senior Data Architect, . Act as the Liaison between the business and technology team working to facilitate detailed communications between project user groups. . Identify and document requirements via data flow modeling, data and object modeling, workflow analysis, functional decomposition analysis, or other standard industry analysis techniques. . Data modeling (logical, physical, and conceptual), . Requirement's definition, . Using Teradata and Netezza . Working with Preferred Embarcadero . Maintaining a data dictionary repository . Performing data profiling and working within the data quality program. . After identifying the stale data, the data environment is cleansed and streamlined to suit current business data needs, domains, and groups. . Assisting with Metadata tools, development, and integration . Handling the full lifecycle of data mining and support (staging, base, aggregates, data-marts for BI repository, data mining, etc.
Environment: - Teradata and Netezza, Metadata tools, development andintegration, data mining, data marts for BIDepartment of Revenue, Lakewood, CO 06/2011 - 10/2011(Contract Completed)Business Analyst/Program Manager. . Act as 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. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead and coordinate project execution, manage risk, manage communication cross-functionally, track progress, and coordinate large complex projects in Web Services across departments. . Facilitate detailed communication between project group users, super- users, etc. . Creating test plans and test cases to support data migration and application enhancements to test against data migration for users and super users. Provide process and system diagrams. . Create test plans, and test cases, to prepare for UAT testing, while coordinating all Super Users and their systems environment to do UAT testing Involving in doing pre-UAT testing before the super users to make sure all data migrated and integrated properly, and systems are in sync for super users to begin their UAT testing. . 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, . After identifying the stale data, the data environment is cleansed and streamlined to suit current business data needs, domains, and groups. . Manage requirement scope, traceability for testing, functional, and non-functional requirements. . Submit weekly status reports.Environment: - UAT testing, weekly status reports, business communicationplansBREAK: December 2009 - June 2011. Took time off due to personal reasons.Healthgrades.com, Lakewood, CO 02/2009 - 05/2009(Contract Completed)Business Intelligence Manager/Senior Business Analyst,) . 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 Hospital 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 Data warehouse schema architecting with the use of c . Use of all healthcare subject areas in payer, payor, PCP, providers, claims, sponsors, member enrollments, etc . Use of Excel spreadsheets to create trend analysis on Ad-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. . Implementation of end-to-end SharePoint by exposing to the executives, the SharePoint goals, getting together a skilled team, setting training sessions, defining the service operations, defining the information architecture, planning the SharePoint governance policies, following the implementation best practices, ensuring the SharePoint adoption is well received, and keep it simple through its various web- based collaborative platform integrations. . Use of VISIO and SharePoint for creating and managing processes on web trend initiatives. . Use of Microsoft SSRS, SSIS, SQL Server management, and 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. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead and coordinate project execution, manage risk, manage communication cross-functionally, track progress, and coordinate large complex projects in Web Services across departments.Environment: - Microsoft SSRS, SSIS, SQL Server management, visual studio(TFS), Agile development, Agile development, SharePoint implementation.The Boulder County, Treasurer's Office Boulder, CO 03/2008 - 05/2008Senior Business Analyst, . Collaborated with tax requirements for tax notices. . Use of VISIO for creating data flows and managing processes on tax initiatives for data architecting. . Work with users, vendors, and external clients to coordinate activities and project manage various projects with the MS Project tool. . Projects including encrypting and decrypting mass payment records from financial institutions like JPMorgan Chase, etc., for security purposes. . Use of TOAD, Erwin 7r, on Oracle 9 to develop SQL queries for reports and models for tax notices. . Use of TIMS tax system for tax transactions. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, track progress, and coordinate project execution, manage risk, manage communication cross-functionally, and coordinate large complex projects in Web Services across departments. .Environment: - TOAD, Erwin 7r, on Oracle 9, SQL queries, MS Project tool,VISIOComcast Corporation, Englewood, Colorado06/2006 - 01/2008Senior Data Architect . Front-end point of contact on end-to-end modeling design of billing, Provisioning, reporting, and related systems . Customer-centric user interfaces to include data analysis, requirements gathering, data flow processes, data storage design, data dictionary creation and maintenance, and other activities associated with specific database/directory design and implementation. . VoIP implementation to customers who basically decided to save money because running calls over the Internet would be cheaper than using the PSTN or public switched telephone network. . Provisioning, implemented with no call breakages needed by this service provider for provisioning the end user. Attributes used, such as the user's first name, last name, and email address, are packaged in a security token such as a Security Assertion Markup Language (SAML) assertion. The identity provider sends this SAML assertion to the service provider when the end user accesses the service provider as part of a single sign-on. If no match exists for the presented username, the service provider creates a new account with the end user attributes contained in the SAML assertion. The service provider also immediately grants access to the requested services to the end user. . Work with business and technology owners to understand and document their requirements, design data stores to meet these business needs, and then communicate these designs and requirements to development teams for implementation all with a strong knowledge of cable industry systems including billing systems, provisioning systems, data warehouses, and ETL methodologies. . Experienced in identifying, analyzing, and translating business requirements into conceptual, logical, and physical data models in complex, multi-application environments. . After identifying the stale data, the data environment is cleansed and streamlined to suit current business data needs, domains, and groups. . Hands-on Dimensional modeling and ER data modeling experience - with years of dimensional modeling experience. . Coordinating with application integration architecture with package (SOA), interface development and web front-end . Modeled and managed HRIT/HRMS data models for the Comcast Corporation HR Entities . Demonstrating data analysis skills using SQL, TOAD, and Erwin, for Data Modeling . Strong experienced in using data modeling tools such as Erwin, ER Studio, or Power Designer. . Knowledgeable in OLAP, BI, and Data Mining . Project Manager, Responsible for Project scheduling and planning of various database schemas and models. . Interacting with users, planning, and managing the project deliverables with project managersEnvironment: - Erwin, ER Studio or Power Designer, integration architecturewith package (SOA), ETL methodologies, PeopleSoft HCM/HRIS/HRMSUniversity Management Systems, Boulder, CO 02/06 - 05/06Senior Program Director/Senior Business Analyst . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, track progress, and coordinate project execution, manage risk, manage communication cross-functionally, and coordinate large complex projects in Web Services across departments. . Coordinating the transition and development of all legacy projects into this Web Services environment . Lead and manage the development of this new Web Services environment with the use of Visual Basic, C++, VBScript, ASP, Java, vb.NET, Load Runner, SQL 2000, and Oracle. . Assessing technical, and business trade-offs plus validating, and evaluating all various complex internet projects for gap analysis, matrix scorecards looking at resources, allocated budget, timeframes for project completion, security issues, architectural issues, etc. . After identifying the stale data, the data environment is cleansed and streamlined to suit current business data needs, domains, and groups.Environment: - Visual Basic, C++, VBScript, ASP, Java, and vb.NET, LoadRunner, SQL 200 and Oracle, SQL, TOAD, Erwin, for Data Modeling, ER datamodeling, ETL methodologies, PeopleSoft HCM/HRIS/HRMSB & E Enterprises Boulder, CO 04/01 -01/06Great West Life Insurance, Level3 Communications, Nolan ComputersGreat West Life Insurance - BI/Data Warehouse/Business Analytics DataAnalyst /Architect - HIPPA, Oracle, SQL . Performed daily loads using the Oracle Load utility and used of ETL processes. . Designed and created new client-integrated tables/views for HIPPA security compliance into the schema. . Plan, create and execute test cases while communicating with appropriate project teams to eliminate software bugs. . Scheduled and coordinated all data analyst projects with the use of MS/Project to the appropriate individuals.Level3 Communications -Product Manager - Teradata, UML, CRM, .NET . Managed and participated in several strategic business units to develop switched data dial services within the Soft Switch Business Unit. . Prepared business cases by gaining an understanding of new features, incorporating objectives and forecasts from the Product Managers, and translating these business objectives into detailed business requirements. . Used requirements modeling and process tools and techniques including UML. . Contributed to the product business cases by adding development costs, including Opex, Netex, and Capex . Architected solutions overview web front-end, middle-tier applications, database, and the back-end ASP infrastructure for a client. . Used .NET, Dreamweaver, and a variety of web-centric tools and applications. . Provided supporting documentation on Best Practices for the website implementations. . Managed and participated in email-based marketing, campaign management, and web-based marketing initiatives. . Created detailed project requirements gathering, modeling, detailed analysis, specification, project milestones, and required project tasks. . Defined project scope, schedule, and cost parameters on development projects for CRM end-to-end tasks.Nolan Computers -Great Plains, Siebel CRM on Demand . Created test plans and test cases based on software requirement specifications to meet quality assurance standards. . Conduct UAT and report findings on the QA process and results. . Review, propose, and implement improvements to QA Process . Integrated product with MS Great Plains with the use of .NET and Siebel & SOX (Sarbanes-Oxley)Environment: - .NET, Siebel & SOX (Sarbanes-Oxley), .NET, DreamWeaver,Teradata, UML, CRM, .NETEmployer: Deloitte Consulting - San Francisco, Technical Project Manager(FTE), CA 06/00 - 04/01Clients: - Retail grocery chain, New Commodities LaunchCRM Data Warehouse Architecting for a retail grocery chain - . Architecting technical blueprints for huge complex and risk-binding situations for well-understood e-business solutions using Visio, and UML, the project incorporated Siebel and Epiphany. . Negotiating with clients on the tools for clarity and Solutions presentations to the clients . Provided project plans, schedules, monthly and weekly status reports, and estimated the time, Scope, and Cost Management for a specific product entity in development. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, track progress, coordinate project execution, manage risk, manage communication cross-functionally, and coordinate large complex projects in Web Services across departments. . The customer data warehouse product environment was created to store sales data and information based on store location, promotions, campaign management, sales counts, and geography. This data was used for decision-making by managers, regarding product selection, inventory level, future promotions, and seasonal information.CRM/e-business Commodities trading for a New Commodities Launch . Managing and coordinating all providers and suppliers, partners, and consulting members to put together a high-level Project plan and enterprise solution to kick off these commodities launch with the use of MS/Project and PowerPoint. Put together a communications plan and requirements templates for business and technical specifications. . Architecting end-to-end CRM/e-Business commodities trading site with the use of Visio and PowerPoint presentations for approval . Use of Web Methods, WebLogic, and Siebel to create. . Data portals for future promotions and customer relationships online . Engaged in the building of several Java scripts and website developments. . Involved with Sales on invoicing applications online. . Instituted functional area processes and Procedures for a new website. . Instituted a Change Management process. . Created, reviewed, and analyzed the contract Management, Statement of Work, and Request for Proposals. Architecting the system environment & Design Modeling of the interfacesCRM/e-Business HealthCare Exchange project for Health Care Partners - . Performed the Integration of EDI Suppliers, Providers, and Customers' data relationships online. . Defining, analyzing, Architecting, Integrating, and cataloging health- related data with the use of EDI tool and XML tool for converting data for specific web site portals, Determine ways to integrate EDI- requested data into business health applications Web site Portals that were developed with Web methods and WebLogic; for it to improve online data quality, shorten lead times, reduce cost, be able to measure order response time, inventory, or cash flow and maximum security for its data to satisfy suppliers, users as well as vendors for EDI data integration to flow over the internet, so suppliers or users can choose the transmission mechanism that best meets their business requirements. . Used Siebel 7 for call centers, CRM OnDemand, for business requirements engagements online, and for health care exchanges.Environment: - WebLogic, EDI data integration, XML tool, Design Modeling,WebMethods, WebLogic and Siebel, Change Management process, MS/Project,Visio and PowerPoint, UML, PeopleSoft HCM/HRIS/HRMS.Employer: Professional Services,(01/00 - 6/00)Director, Professional Services (FTE), VenComm.Net - Denver, CO . Engage in managing all projects and developing Client Management strategy between Clients and Engineering for ASP Technical Solutions and high- level requirements and technical architecting the web data. . Assist Marketing/Sales on Client acquisition and contract negotiations. . Provide technical leadership on all client engagements from initial client business needs, transitioning through implementation, Create and develop strategic business processes for proposals, business plans, Statement of Work, Scope requirements, project management, Marketing/Sales client involvement templates, financial and pricing infrastructure, hardware and software infrastructure, hosting infrastructure, e-business requirements for databases, data warehouse, hosting, implementation and services, Assisted the VP of Operations in operational maintenance and hosting issues, Set infrastructure with groups on e-commerce, e-business acquisitions, Oversee, manage, staff, provide and bridge the gap between clients and engineering projects for successful implementation, client satisfaction, acquiring sign-offs on client deals with strong leadership on all client services and engagements, Create business requirements and proposal documents to initiate a contract, Exercise SDLC methodologies for business & e- business processes. . Manage, project planning, project scope, project objective, project schedules, project deliverables, vendor management, budget oversight, lead, track progress, and coordinate project execution, manage risk, manage communication cross-functionally, and coordinate large complex projects in Web Services across departments. . Manage and strategize business visions and plans for e-projects on the websites, Direct and implement web data best practices for the database group.Environment: - SDLC methodologies, Marketing/Sales client involvementtemplates, financial and pricing infrastructure, hardware and softwareinfrastructure, hosting infrastructure, e-business requirementsEmployer: Message Media - Boulder, (01/99 - 12/99)Client: Message Media (FTE), Boulder, CO, Marketing Database Manager forData Warehouse/Data Marts/Senior Business Analyst,Manage Data Marts/Data Warehouse Architect projects with Star Schema DesignPrinciples for numerous clients on the web Set up the infrastructure ofemail, e-customer, and e-business marketing Metadata/Data Marts/DataWarehouse for clients on the web Met with several evaluate datarequirements and tools for Metadata/Data Marts/Data Mining/Data Warehouseand Business Intelligence support Create business requirements and proposaldocuments to initiate a contract Evaluate SOW, vendor SLAs, ServiceRequest, Change Management, Production Support, Project Reviews, ClientVendor Relationships, Hardware/Software standards Serve as a single pointof contact for both external/internal clients Exercise and define pricingon project requirements, Enforced use of 'c for business processes . Operate effectively at senior management and executive levels, technical breadth in the database, security, capacity planning, web applications deployments, and support on distributed mission-critical technology environments. . Confidently and consistently leads a focused organization that achieves goals that improve the company's profitability, increase revenue, retain old customers, encourage new customers, and provide employee growth. . Negotiate and analyze projects to meet strong budget/financial controls.Environment: - SOW, vendor SLAs, Service Request, Change Management,Production Support, Project Reviews, SOW, vendor SLAs, Service Request,Change Management, Production Support, Project Reviews, Star Schema DesignPrinciplesEmployer: EDS (12/97 - 1/99)Client: EDS - Louisville, KY (FTE), Database Data Warehouse/ LeadArchitect/Senior Business Analyst, . Lead and Design Metadata/Data Warehouse projects with Star Schema Design Principles for numerous clients . Administer Clients' Front-End Oracle Discoverer Tool, manage weekly Clients Database loads, Present Design phase Star Schema principles to clients, Work with Account Managers, Account Directors, Business Managers, Business Analysis, Production/ Development DBAs, Unix group, Network group, to resolve customer questions and problem escalation. . Document Standards and procedures e.g. (Sows, ISO 9000, Service Requests, Change Management, Production Support, Project Reviews, Client Vendor Relationships, and Hardware/Software standards, in an enterprise delivery service business . Provide daily technical support, proven leadership and team building skills, project/program management ability with superior written and verbal communication and Negotiate and analyze projects to meet strong budget/financial controls. . Design and develop Business Intelligence solutions using MSBI tools (SSIS, SSRS, and SSAS).Environment: - Design Metadata/Data Warehouse, BI, SSRS, Oracle DiscovererTool, budget/financial controls, PeopleSoft HCM/HRIS/HRMSLead / Systems Integrator / ORACLE Databases, IBM/Global Services -Boulder, CO (FTE) (10/96 - 11/97) . Lead, and transitioned projects to clients' satisfaction in a production Database Administration group from requirements to deployment for continuous maintenance and customer loyalty, Demonstrate leadership roles in presentations, team interaction, strong customer communication, problem solving, strong budget control/analysis, Software/System Integration product installations, and timely customer deliverables, Created a plan to design, develop, and implement a new legal GUI Customer View System for DB2 to Oracle to import to a UNIX platform, Lead and Implemented PeopleSoft HRIT/HRMS applications for several consulting engagementsEnvironment: - PeopleSoft HCM/HRIS/HRMS applications, UNIX platform, DB2 toOracle toEmployer: US West Communication, (9/94 - 08/96)Client: US West Communications (FTE), Denver, CO (FTE), Manager-ProductionDevelopment / BillingIndustry: AT&T, MCI, SPRINT, Cellular/Wireless, Cable. &Applications T l communications . Demonstrated relational product concepts to customers and performed product installations. . VoIP implementation to customers who basically decided to save money because running calls over the Internet would be cheaper than using the PSTN or public switched telephone network. . OSS/BSS, implemented with no call breakages needed by this service provider for provisioning the end user. Attributes used such as the user's first name, last name, and email address, are packaged in a security token such as a Security Assertion Markup Language (SAML) assertion. The identity provider sends this SAML assertion to the service provider when the end user accesses the service provider as part of a single sign-on. If no match exists for the presented username, the service provider creates a new account with the end user attributes contained in the SAML assertion. The service provider also immediately grants access to the requested services to the end user. . Lead technical implementations, enhancements, installations, customer problem solving, and timely customer software tools involving DB2, COBOL, Oracle, UNIX, etc.Environment: - DB2, COBOL, Oracle, UNIX, etc.Employer: State of New Hampshire - Child Support Services, (11/93 - 08/94)Client: State of New Hampshire - Child Support Services, Concord, NH,Systems Analyst (FTE) . Lead team development strategy to timely implement the child support system, Project management/planning. . Held meetings for requirements, benchmarks, and deliverables, Resources, and budget analysis. . Conduct meetings and JAD Sessions with business users and other stakeholders.Environment: - Project management/planning, JAD SessionsEmployer: State of MassachusettsClient: Department of Revenue - State of Massachusetts, Boston, MA (FTE)AFDC Programmer. (10/92 - 10/93) . Lead team development strategy to timely implement the child support system on AFDC, creating a statewide system that will report and document all dead-beat-dads across the nation, Updating the system with constant modifications and analysis, Conducting meetings and JAD Sessions with business users and other stakeholders.Environment: - child support system on AFDC, JAD SessionsEmployer: Nashua Memorial Hospital, (10/86 - 08/92)Client: Nashua Memorial Hospital - Nashua, NH (FTE), Information SystemsSupervisor . Lead the development of all emergency medical records and admissions records, Coordinating invoices for payments and data processing for the whole hospital, Assuring effective integration of hospital computing resources and long-range planning of network requirements, Conducting meetings and JAD Sessions with business users and other stakeholders, Planning the installation of new hardware and software; ensuring application and data security; providing training and assisting hospital staff and administrators in the use of software and applicationsEnvironment: - JAD SessionsEmployer: Blue Cross/Blue Shield, (08/84 - 08/86) Client: Blue Cross/BlueShield - Columbus, Ohio (FTE), Health Claims Programmer/Business Analyst, . Responsible for programming health claims records like ICD9 codes, etc., received on company employees. . Conduct meetings and JAD Sessions with business users and other stakeholders.Environment: - ICD9 codes, JAD Sessions |