Resume
Sr Solutions Architect Ft Worth, TX
SUMMARY:
I would like to have a Senior Confidential position in the Dallas, Texas area where I can use my Confidential Development/Administration/Mentoring skills and extensive Business knowledge to support the end - user community
EXPERIENCE:
Confidential, Ft Worth, TX
Sr. Solutions Architect
Responsibilities:
- Designed, Developed, and Implemented Confidential Reports for multiple Business Units; incorporating data from Oracle, SQL Server, Teradata, Informix, Sybase, and DB2
- Designed, Developed, and Implemented Confidential Framework Manager Models (thru v11.0.12)
- Designed, Developed, and Implemented Confidential Multi-Dimensional PowerCubes using Transformer (thru v11.0.12), and PowerPlay (thru v11)
- Designed and Implemented Skybot Scheduler processes
- Designed, Developed, and Implemented Confidential Real-Time Monitoring solutions (thru v10.2.2)
- Designed, Developed, and Implemented Confidential TM1 Cubes (thru v10.2.2)
- Administered Confidential multi-server environment with 30,000 + active users
- Administered JIRA Issue Tracking tool for Enterprise Data Department (2,000+ users)
- Mentored Confidential Administrative Development Team, as well as Confidential developers for 50+ departments
- Handled Production support issues
- Performed several multi-server installs of through v11 in a Windows environment
- Involved in Hardware Refresh for Confidential environment
- Involved in migration strategy from Confidential ReportNet/Series 7 to Confidential 8, Confidential 8 to Confidential 10, and Confidential 10 to Confidential 11
- Trained end-users on Framework Manager, Report Studio, Transformer, Confidential Workspace Advanced, and Confidential 11 Reporting tool
- Designed simple Dashboards using Tableau
- Led Windows Operating System upgrade
- Led Confidential Beta Testing Team
- Designed, Developed, and Implemented MS SQL Server DTS packages to execute UNIX processes
Confidential, Frisco, TX
Sr. Consultant
Responsibilities:
- Designed, Developed, and Implemented Executive Dashboards using Confidential Visualizer 7.3
- Designed, Developed, and Implemented Confidential Multi-Dimensional PowerCubes using Transformer, PowerPlay, and Impromptu (v7.3); incorporating data from Oracle, SQL Server 2000, Teradata, Informix, Sybase, and DB2
- Designed, Developed, and Implemented Confidential ReportNet Reports
- Designed, Developed, and Implemented Confidential Framework Manager Models
- Designed, Developed, and Implemented Confidential Impromptu Web Reports
- Designed, Developed, and Implemented MS SQL Server DTS packages to execute UNIX processes
- Administered Confidential multi-server environment with 6,000+ users
- Administered JIRA Issue Tracking tool for Confidential Enterprise Reporting Team
Confidential, Houston, TX
Sr. Consultant
Responsibilities:
- Designed, Developed, and Implemented Confidential Catalogs and Impromptu Web Reports on Oracle platform to support Asset Management Business
Confidential, Glen Allen, VA
Sr. Systems Architect
Responsibilities:
- Designed and Developed Executive Dashboards using Confidential Visualizer 7.1
- Designed and Developed Confidential Multi-Dimensional PowerCubes using Transformer, PowerPlay, and Impromptu (v7.1); incorporating data from Oracle, SQL Server 2000, and MS Access
- Designed and Developed Ad-Hoc reports using Confidential Architect and Confidential Query
- Designed and Developed Confidential Impromptu Web Reports
- Designed and Developed macros and batch files to automate building of Confidential Multi-Dimensional PowerCubes
- Wrote DTS routines to extract and manipulate MS Access data in SQL Server 2000
Confidential, Holland, MI
Sr. Consultant
Responsibilities:
- Incorporated Confidential Visualizer Dashboards into Epicentric Web Portal
- Designed and Developed Executive Dashboards using Confidential Visualizer 7.0 using Confidential and Essbase Multi-Dimensional Cubes
- Designed and Developed Confidential Multi-Dimensional PowerCubes using Transformer, PowerPlay, and Impromptu
- Configured Confidential Visualizer and Confidential NoticeCast to run on server with other Confidential products
Confidential, Cleveland, OH
Sr. Consultant
Responsibilities:
- Designed and Developed Confidential Multi-Dimensional PowerCubes using Oracle Stored Procedures, Impromptu, Transformer, and PowerPlay
- Created and Updated Oracle tables using Oracle Stored Procedures, SQL Scripts, and Batch Scripts
- Updated Confidential Catalog Tables, Joins, and Folders based on new Oracle Instance and new tables
Confidential, Houston, TX
Principal Consultant
Responsibilities:
- Specialized in designing Executive Dashboards using Visualizer
- Worked at customer sites installing Confidential products and training
- Involved in understanding Clients business rules and deliver analytical solutions
- Provided technical direction to the application teams in Installation, Configuration, Development and Administration of Confidential Enterprise Suite products such as: PowerPlay Enterprise Server, Impromptu Web Reports and ETL tool like Decision Stream
- Worked with the Data warehouse DBA and ETL Team to define the ETL / Data Mapping rules and plan the ETL process from the source system
- Built secure Confidential Multi-Dimensional PowerCubes with security and deployed the cubes over the web
- Wrote macros to accommodate issues around building and deploying Confidential Multi-Dimensional PowerCubes
- Published Impromptu Web Reports using Power Prompts
- Planned and set up Application/Database level security using LDAP technology and Access Manager
- Designed Data warehouse/Data Mart Logical and Physical Models using Star and Snowflake Schema methodology
Confidential, Minneapolis, MN
Operations Analyst
Responsibilities:
- Designed and Implemented Confidential Catalogs, Multi-Dimensional PowerCubes, and Management Reporting on Oracle and SQL Server platforms to support both Product Business and Service Business
- Designed and Implemented SQL Server Data Warehouse (including daily update routines from SAP extracts) to support the following Business Units: Operations, Sales, Marketing, Order Management, National Accounts Services, Inventory Management, Sales & Operations Planning, Purchasing, Finance, and Executive Management
- Designed and Implemented Business Objects back end and front end (including universe design, security, and complex reporting) on above SQL Server Data Warehouse to support the above Business Units
- Designed and implemented forecasting program
- Produced daily analysis and in-depth business metrics for executives
Confidential, Dallas, TX
Operations Manager
Responsibilities:
- Responsible for identifying system problems and needs in Product Management Departments and teaming with Information Services and other departments to devise and implement solutions to increase profitability and efficiency
- Managed team responsible for hardware/software support of 250 employee department.
- Responsible for my department’s hiring, training, and reviewing
- Managed prioritization of Information Services resources for Product Management
- Designed and implemented Business Objects back end and front end (including universe design, security, and complex reporting) on Oracle platform to support entire company 's reporting needs
- Remapped existing reporting environment from XBase to Oracle Data Warehouse
- Designed and implemented forecasting program which increased turns from 7 to 20 in one year
Confidential, Dallas, TX
Programmer/Analyst
Responsibilities:
- Developed and completed migration of monthly paper-based Vendor sales reporting to automated system
- Wrote, automated, and supported batch processes, programs, and download routines to update off-line databases and distribute analysis across the nation
- Provided support for Product Management departments as liaison between Information Services and Product Management departments
- Provided analysis to entire company using, but not limited to, the following software: FoxPro/DBase, Clipper, R&R Report Writer, Q&A, MS Access, MS Excel, MS PowerPoint
