Data Warehousing Analyst Resume Profile
Los Angeles, CA
S U M M A R Y / O B J E C T I V E
A comprehensive five-dimensional professional: Technically savvy, Managerial expert, Leadership guru, Business acumen and an accomplished and awarded Knowledge Lender Educator/Teacher, Mentor, Coach, Counselor, Organization/Personal Development : Comprehensive Servant Leadership Managerial, Superior Communications, Teamwork-oriented, People Skills, Strong Analytical and Critical Thinking, Out-of-Box Thinking, Decisive, Sense of Urgency, Ethical, Honest, Fair Judgment, Visionary, Entrepreneurial, Multi-cultural, Global View, Hard Worker, Making History, Self-Starter, Enthusiastic, Passionate, Corporate Values, Social Responsibility, Accountability, Business Political Maturity, Customer Voice, Drive for Results, Highly Motivated, High Energy, Continuous Learning, Knowledge Sharing, Organizational Excellence, Creativity, Innovation Improvement Champion, Highest Quality, Trust Loyalty, Span Organizational Boundaries. Details available upon request
P R O F E S S I O N A L A C C O M P L I S H M E N T S / C A R E E R H I S T O R Y
Confidential
DATA WAREHOUSING Analyst
- Managed development, lunch and maintenance of Web sites supporting Forever 21 fashion/retail business for US, Canada, EU/UK, Asia Korea, Japan and China , Mexico and Brazil desktop and mobile versions WebSphere .
- Managed a large, multi-national, global team US, Canada, Europe, Asia, South America, India, and Central America .
- Managed various vendors: IBM, HP, Infosys India and US , Velocity Partners Argentina, Uruguay, and Columbia , GroupBy Canada .
- Scrum Master: Heavy use of the Agile/Scrum methodology and Jira for tickets tracking and resolution, using sprints, daily stand-ups, epics, dashboards .
- Overseen infrastructure teams in IT for performance tuning and improvement, analyzing SEO, and implementation of various vendor products: IBM Extreme Scale, Akamai, Certona, Mercent, Bloomreach, MooveWeb, optimization of data feeds.
- Managed Data Warehousing/BI/Web Analytics projects Catalogs, Inventories, Customer Profiling .
PROJECT, PROGRAM, PMO
- Formed, set-up and developed the Forever 21 E-Commerce PMO. Then managed the PMO for all E-Commerce related projects. Uses MS PM Server and Calrity.
- Developed and strategic planned for large organziation-wide and projects specific proposals, budgets, peformed financial, business, technolocical and schedule feasibility studies, cost-benefit analysis, business processes re-engineering and organizational development.
- Managed numerous simultaneous projects, in various stages of development, of conflicting priority, resources demand, and various business needs/valuation, reaching decisions based on complex negotiations and using PMO processes, tools, and techniques.
- For all projects followed SDLC/waterfall methodology: phases, milestones, formal reviews, deliverables, ran various meetings developed various metrics and dashboards.
Technologies
Agile/Kanban/Scrum/XP waterfall , B2C, B2B, E-Commerce. OSs/App.Dev.: MS Windows 7/Pro, Office 2010/13, IE 11, Visio, Adobe Pro/Lifecyckle, Google Chrome and Apps . Data Warehourse/BI/Analytics: DB2, SOLR, ETL, Data Marts, Cubes, Reporting. Infrastructure: Windows 7 Pro/Enterprise, HP Serves Blade , IBM Servers Flex , Linux/Apache, Sharepoint, WebSphere Server, IBM Extreme Scale, Akamai, DynaTrace, MoovdeWeb, Certona. PM: Jira for Agile , MS Project 2013, CA Clarity. Web 2.0 technologies: Node.JS, DoJo/CMS wireframes , Ajax, n-tier, CSS, JavaScript/jQuery, HTML 5, Mobility.
Confidential
Sr. Program Manager consulting/contract , IT Dept.
PROJECT, PROGRAM, PMO
- Managed Project Owner/Program Manager role the IT side of a very large systems integration of various CRMs belonging to close to 20 companies - part of BWI Bioesense Webster Int'l BWI medical devices division of J J . This was a multi-year, 170 million project meant to replace various proprietory CRM systems, including BWI's FOCuS and CSI see below into what is called Patient First corporate, global system, based on Siebel and Sales Force. Worked closely with Deloitte consultants. That included upgrade to the DMS Document sharing and Managemannt System.
DATA WAREHOUSING, BI, WEB ANALYTICS, ERP/CRM, COMPLIANCE
- Managed PM role IT projects enhancements/production stage supporting the Business/Customer Relationship Management FOCuS based on Oracle's Siebel, Data Warehouse based on Oracle and SQL Server, Business Intelligence OBIEE and Web Analytics based on Informatica, Cognos and Tableau, as driven by the Corporate Business Functions/Groups' needs. Supported dashboard reporting PMO and nCube data analysis.
- Managed FOCuS CRM , OBIEE Orable Business Intelligence and CSI Complaints Management System and integration/interfaces between them and with JD Edwards and corporate SAP. Included Corporate Compliance and Security. Involved in various Report/Analytics generation: Clients, Physicians, Regulatory Agencies, and Complaints trending, Marketing SalesForce . Heavily involved in Corporate PMO, Compliance and Security matters.
Technologies
Agile/Kanban/Scrum/XP waterfall , B2C, B2B, e-Commerce, Data Warehousing/BI/Analytics, Oracle EBS, JD Edwards, Siebel, SAP. OSs/App.Dev.: MS Windows 7, SQL Server 2K/2K8, Office 2010/13, IE 11, Systems Architect/Visio, Adobe Pro/Lifecyckle, Filenet. Google Chrome and Apps . Data Warehourse/BI/Analytics: Informatica, Cognos, Tableau, SmartTouch, iCoach, ETL, SSRS, SSIS, T-SQL, Data Marts, Cubes, Reporting. Infrastructure: Windows 7 Pro/Enterprise, Sharepoint, Kronos. PM: MS Project 2010, CA Clarity. Web 2.0 technologies: n-tier, CMS design wireframes , CSS, JavaScript/jQuery, HTML 5, Mobility.
Confidential
Independent Senior Consultant
Responsibilities: Provided corporate training over 30 workshops to several clients industry, across the US via SimpliLearn Co. - a global training and certification organization, on following topics:
Project Management for PMP Certification, PMBOK methodology, Risk Management ITIL Foundations, Intermediate, Expert , ITSM Six Sigma Black Belt Agile/Scrum Methodology Sales Force, Siebel Cloud Computing, Virtual Storage Technology, and SaaS Infrastructure Technology and Management Architecting and Managing Modern Data Center Operations Data Warehousing and BI Big Data, Data Analytic with Hadoop and MapR Concepts, Tools, and Implementation Audits and Corporate Compliance: SoX, PII, PIA, PCI, Harbour Safe, COBIT, HIPPA QA, V V, and Testing Management for large systems and for E-Commerce Security for the Enterprise: lifecycle, procedures, tools.
Confidential
Sr. Program Manager acting Director consulting/contract , IT Dept.
PROJECT, PROGRAM, PRODUCT MANAGEMENT, PMO, DIRECTING
- Managed the IT-PH Enterprise and Data/Information Architecture, Application Development QA Groups.
- Managed a portfolio EAI of 10-12 major and several minor IT projects and a team of 20 staff members/contractors BAs, architects, software engineers, DBAs, testers/QA, CM . Increased IT efficiency and lowered the organziation cost
- Supported ERP - Oracle eBusiness Suite, Data Warehousing/ETL, BI, CRM MS Dynamics 2010/13, Web Analytics MicroStrategy , QNXT, ECM/CMS Enterprise Content Management applications. Used SAS, SPSS.
- Initiated and managed the QA and Automated Testing environment, planning, methodology functional, regression, and performance testing , planning, analysis nCover , processes, templates, tools HP Center, QTP, LoadRunner , scripting, reporting, and UAT/UX/UI, software factory concept. Implemented Six Sigma techniques CPI with remarkable results
INFRASTRUCTURE, OPERATIONS
- Led key projects in the areas of Utilization Management, Compliance, BI, Business Re-engineering and Infrastructure.
- Managed the Infrastructure Services using ITSM ITIL lifecycle.
- Employed the SaaS model on-demand software . In this business model we used software as a service SaaS concept whereas users were provided access to application software and databases through the Cloud Computing. Our Cloud Providers managed the infrastructure and platforms that ran the applications, priced on a pay-per-use basis and applications on a subscription fee. That included upgrade to the DMS Document sharing and Managemannt System.
- Managed the Infrastructure Services using ITSM lifecycle: infrastructure as a service IaaS , platform as a service PaaS , and software as a service SaaS a.k.a., the application.
COMPLIANCE, SECURITY, QA
- Initiated and ran the SDL Microsoft Security Life-cycle, IS/IT Security process and embedding the Security Analysis tools Static and Dynamic within the SDLC, following Microsoft SDL and OWASP models .
- Worked closely with the PMO PMBOK and Compliance offices HIPAA, HEDIS, COBIT, FISMA, GLBA, PCI in producing status report, prioritization and initiation, employing RAID Risks, Assumptions, Issues, and Decisions .
- Set up the SDLC process based on ITIL Service Management ITSM /Catalog Incident/Problem/Change Control /Release Mngt., Business Analysis IIBA's BABOK, CoBIT-based Governance Framework with documentation templates and Agile/Scrum methodology using JIRA.
Technologies
- Agile/Kanban/Scrum/XP waterfall JIRA, Zachman, TOGAF, RUP/UML, S arp/MVC Architecture, B2C, B2B, e-Commerce, Oracle EBS, MS Dynamics 2010/13. OSs/App.Dev.: MS Windows 200x/7/Exchange, SQLServer 2008/LINQ, Office 2010/13, IE 9, .NET/C , ASP.NET MVC, SVN, TFS, VS2010, Systems Architect, Adobe Lifecycle, Filenet. Infrastructure: WindowsServer 2008, Sharepoint SSIS, SSRS, SSAS , Novell GroupWise, HP's Fortify/Cenzic app. security scanners . PM: MS Project 2010, On-Time. Web 2.0 technologies: n-tier, CMS design wireframes , WCF/WPF, ASP/JSP, AJAX, CSS, JavaScript/jQuery, HTML 5.
Confidential
IT Director
PROJECT, PROGRAM, PRODUCT MANAGEMENT, PMO, DIRECTING
- Provided Systems/Applications/Information/Data Architecture directions and guidelines for Studio Technology, in all aspects, including TOGAF, Zachman, SOA, S arp, SaaS, CAVRE Completeness, Accuracy, Validity, Restricted Access, Error Handling . Worked on the integration of new technologies and improvement of business processes/models. Served as SME subject maatter expert , facilitating Kaizen, Kanban, Agile techniques JIRA . Supported anti-piracy/intelectual property group.
- Functioned as an IT Director with responsibilities in the area of Systems Architecture, EPMO, Applications Portfolio Management EAI over 120 apps , Compliance, Technology/Infrastructure R D, and Training for the Studio IT. Extensive use of MS Project Server and CA Clarity. Supported various products life-cycle.
- Managed the all phases scoping, planning, vendors selection, reporting, implementation, risk management, documentation RFI, RFP, RFQ, SOW, SLA of several Technology Migration Project. Included the management of Microsoft, HP, Xerox and IBM Premier contracts or vendors like Infosys, Cognizant Tata, WiPro, CapGemini and related SLAs outsourcing, off-shoring . Partnered in R D with Gartner, Forrester and other major organizations.
- Led the PMO SRLs, metrics, scorecards, dashboards and Studio Application Portfolio Management effort surveys, data collection, systems architecture, integration, technology research, communication and implementation, risk management, KPI, BRM and its transformation into Technology Portfolio - HP PPMC Project and Portfolio Management Center . Supported the Budgeting 5YP, AOP through Cognos and Technology Landscape related activities. Implemented Six Sigma CPI techniques with remarkable results
- Supported SalesForce apps, Cognos, CA Clarity implementation and ITDM a Global Distribution Management System based on Web 2.0 technologies and social networking integration.
- Considerable involvement in Data/Information Architecture and ECM Enterprise Content Management . Worked closely with Enterprise Data Warehouse/ETL/BI/Data Mining/Data Marts group, SAP BW/BI and SAP implementations FI, CO, MM, PP , SRM, CRM , SCM, HR, BI .
INFRASTRUCTURE, OPERATIONS
- Managed/Evaluated/Recommended the Infrastructure Architecture following ITSM principles: Cloud apps, storage , Virtualization, Dynamic Hosting, Mobile Computing, Security/Privacy, Business Continuity DR , Performance Monitoring HA , Analytics, Capacity Planning. Cloud tools technology EMC, HP, BMC v9, Microsoft, VMware, CA and Service Management tools technology BMC Remedy, HP Service Manager. Championed the 'Best Practices.' Aligned Business and IT needs, goals, visions and costs
- Developed and managed the Cloud Computing, a.k.a. distributed computing environment working with several vendors Microsoft, Salesforce . The Architectural model was developed: Cloud Platform, Cloud Infrastructure, Cloud Storage, and Cloud Services. The systems architecture of the software systems SaaS was involved in the delivery of cloud computing.
- Developed the Cloud Deployment Model: Private/Internal, Public/External, and the Cloud itself through outsourced products and services . Employed the security, safety and privacy measures.
- Developed/Implemented ITIL Service Management Catalog and CoBIT-based IT Governance Framework processes and procedures and adapted them to organization's environment. Developed KPIs for IT Availability/Uptime, Mean Time Between Failure, Mean Time to Repair, Unplanned Availability through CSF Critical Success Factors and Balanced Scorecard following SMART criteria. Organized training for the Studio IT employees on latest technologies.
COMPLIANCE, SECURITY, QA
- Heavy involvement in QA activities and Testing automation.
- Responsible for the entire Disney's Studio IT applications portfolio and infrastructure compliance. SOX 404, CoBIT, COSO, PCI, PII, EU Safe Harbor, COFA .
- Represented Studio IT at corporate quarterly audits and prepared reports to corporate and executive management.
- Also strong proponent for IT Security: MS SDL, code-scanning tools and Certifications/Compliance.
Technologies
- Agile/Kanban/Scrum/XP waterfall , RUP/UML. OSs/App. Dev.: Windows XP/Vista/200x, SQLServer 2005/2008, Oracle, Office 2007/2010, IE 7-9, .NET, SilverLight, TFS, VS2010. Adobe Lifecycle, iOS, Google Chrome and apps , OpenOffice, Apple/Mac various products , Java/J2EE, Linux RedHat, UNIX, SAP, Cognos, HP Center, QTP, LoadRunner. Infrastructure: WindowsServer 2003/8, Sharepoint SSIS,SSRS,SSAS , Filenet, Citrix, RedHat. PM: MS Project, HP PPMC, Planview, CA Clarity/NIKU Workbench. Data Warehousing/BI ETTL-Informatica, EAI/CRM, ERP packages SAP PI/XI/BW, PeopleSoft HRIS, Oracle Financials, SalesForce . Web technologies: n-tier, CMS design wireframes Silverlight, ASP/JSP, PERL, DOM/AJAX, Flash, CSS, Ruby on Rails, JavaScript, D/X HTML, LAMP/WAMP Linux/Windows, Apache, MySQL PHP , Mobile devices.