LANGUAGES/SOFTWARE:

• MicroStrategy 8, 9
• Oracle 8, 9, 10
• DB2 UDB
• MS SQL 7, 2K, 05
• SQL 92 DML, DDL
• Visual Basic
• C#
• Java
• C/C++
• COBOL
• HTML
• JavaScript
• VB Script
• .Net
• VBA
• MS Windows
• Linux/Unix
• AS/400
• OS/MVS/JCL
• Cognos
• Informatica
• Great Plains
• Platinum
• Infinium
• PeopleSoft

EXPERIENCE:

SENIOR SOLUTIONS ARCHITECT

Confidential, Phoenix, Arizona

Responsibilities:

• Establish architectural standards and best practices for enterprise business intelligence tools and solutions.
• Design, develop and deliver reporting applications of varying levels of complexity on time and on budget.
• Work directly with business partner, end - to-end, development, and quality teams throughout the entire SDLC to create requirements, architecture, design, test strategy, and implementation documents.
• Accurately estimate the size and cost of projects.
• Guide multiple simultaneous projects from both a technical and project management perspective.
• Ensure projects adhere to schedule, budget, established architectural guidelines and BIDW best practices.
• Manage and delegate duties to teams of BI architects and developers of owned projects.
• Provide guidance for projects ranging in size from $150k to $2m+.
• Work with Database Architects to ensure data models support the needs of the application.
• Design efficient ETL strategies for near real-time loads with an appropriate level of aggregation in order to support near instantaneous response times.
• Skilled in multiple releases of the best-in-class BIDW platform tool-sets.
• Work with directors, business leaders and all aspects of information technology (IT) to ensure there is a business intelligence strategy and road map to accomplish the goals of the business.
• Provide expert leadership experience for the finance, banking, credit, healthcare, pharmacy and retail industries.
• Demonstrated proven experience with business intelligence architecture and data modeling for large complex multinational companies.
• Excellent communication and interpersonal skills, and the ability to interact and collaborate with IT teams including application development, testing, operations, security, compliance, project management, analytic teams and external vendors (both onshore and offshore).
• Source, evaluate, interview, recommend and on-board new staff.
• Effectively develop and deliver demonstrations and presentations to all levels of audiences up to and including top senior management (Vice Presidents and Senior Vice Presidents).
• Superior expert level guidance and vision for Enterprise Information Management principles (data lineage and governance).

MICROSTRATEGY TEAM LEADER

Confidential, Baltimore, Maryland

Responsibilities:

• Design, implement, manage, and maintain multi-tier Business Intelligence reporting and analysis systems in a mixed operating environment based on user reporting requirements.
• Provide ongoing project management for the MicroStrategy environment.
• Coordinate with project team members and vendor to ensure timely, accurate, and complete delivery of committed tasks.
• Promote and ensure appropriate use of the MicroStrategy.
• Develop and deliver MicroStrategy presentations and trainings.
• MicroStrategy Administration including installation and configuration; LDAP and AD security configuration, and performance management.
• Develop MicroStrategy cubes, dashboards and reports.
• Responsible for providing recommendations for improving and adheres to applicable CMMI standard processes and procedures for area of responsibility.
• Construct data decomposition diagrams, provide data flow diagrams and document the ETL process.
• Identify and document data quality issues and data patterns.
• Write SQL DDL and DML code for database access, modification and construction including triggers, constraints and stored procedures.
• Familiarity with a variety of the field concepts, practices and procedures. Ability to rely on instruction and established guidelines to perform function of the job.
• Familiarity with other Business Intelligence Reporting/Querying tools as well various ETL Tools (I.e. Informatica, Cognos, Business Objects).
• Experience working with multiple database platforms (Oracle, DB2 UDB, SQL Server, Teradata) and operating systems (AS/400, Linux, MVS/JCL, Windows).
• Contribute to and/or create and deliver presentations to project teams
• Expert level understanding of database architecture, theories, principles, and practices as they relate to OLTP, OLAP, and Big Data.
• Perform a variety of tasks with a great deal of creativity and latitude.

BUSINESS INTELLIGENCE ANALYST

Confidential, Phoenix, Arizona

Responsibilities:

• Developed custom .NET web service components in C# to cleanse name, address, email and phone from web traffic data .
• Created SSIS packages that used custom web service components that processed 100k+ web traffic records per minute.
• Used T-SQL extensively for ad-hoc query requests.
• Maintained schema for MicroStrategy applications and SSAS projects.
• Developed reports using SSRS.
• Presented technical details of project proposals to all levels of customers.
• Acted as a liaison between IT and other departments (sales, finance, upper management, etc.)

DATA WAREHOUSE ARCHITECT / ADMINISTRATOR

Confidential, Phoenix, Arizona

Responsibilities:

• Designed, implemented, managed, and maintained multi-tier Business Intelligence reporting and analysis system in a mixed operating environment based on user reporting requirements.
• Employed MicroStrategy 7.1 - 9.0 (including Architect, Narrowcaster and SDK), WIN2K, MS SQL Server 2000/2005, IIS, and AS/400 DB2 UDB.
• Trained, mentored and supported IT and corporate users. As necessary, created data-marts, dashboards, grid and document type reports, supporting metrics and attributes to support unique reporting environments.
• Enabled efficient use of the MicroStrategy tool-set for data analysis and mining.
• Designed hybrid star/snowflake logical schema and physical data models using Kimball modeling techniques.
• Thoroughly analyzed business requirements such as breadth of data to capture, end-user data analysis needs, expected query response times.
• Reported on any deficiencies by employing gap analysis techniques.
• Developed highly optimized indexing strategies, etc.
• Created ETL specifications for the transformation of existing production system operational data stores.
• Achieved initial goal of creating a vendor scorecard that made it possible for direct vendor B2B participation ultimately resulting in improved shipping and receiving operations, vendor relations, and most importantly, higher gross margin and return on investment.

SENIOR APPLICATION DEVELOPER

Confidential, Tempe, Arizona

Responsibilities:

• Generated $4000 in revenue weekly by billing out, on average, 32 hours to client projects.
• Developed computerized solutions to their business problems.
• Actively participated in the design, implementation, test, and support phases of the systems development life cycle for the firm's clients.
• Communicated client needs and expectations in the form of written documentation including Vision Scope Documents, Business Requirements Documents, Data Flow Diagrams, Process Flowcharts, Project Timelines including Critical Paths, Status Reports and End User Training Manuals and Online Help Files.
• Implemented solutions using rapid application development tools such as Microsoft Visual Basic for use in multi-tier, multi-server environments.
• Employed object-oriented and distributed component object modeling techniques.
• Provided technical support for the sales effort.

STAFF CONSULTANT

Confidential, Phoenix, Arizona

Responsibilities:

• Generated $4000 in revenue weekly by billing out, on average, 32 hours to client projects.
• Provided technical consulting to Infinium clients. Customized NT Financial Management software product for specific customer needs.
• Created a flexible check-writing tool, which the software product lacked, for inclusion in subsequent product updates.