SUMMARY:

• Cognos TM1 developer with over 13 years of business performance management, systems implementation, data rationalization, and project delivery experience.
• Expertise in development and implementation of forecasting and analytical tools using Turbo Integrator processes, rules and complex active forms.
• Define, interpret and integrate complex business requirements and implement reliable and efficient planning solutions.
• Optimize and redesign existing solutions while ensuring software runs, efficiently and support up to 1K end - users.

TECHNICAL SKILLS:

Database and Application Development: IBM Cognos TM1, Microsoft Access and Excel, Oracle, MS SQL

Programming: QlikView, Qlik Sense, IBM Cognos TM1 Rules and Turbo Integrator, Cognos Disclosure Management (CDM), SQL, Oracle PL/SQL, Visual Basic, Visual Basic for Applications, Java, JavaScript, .NET, HTML, XML, JSON, RESTful API

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Senior Principal Software Developer

Responsibilities:

• Collaborated with multiple departments, including Quality Control (QC), Engineering, and Marketing to meet or exceed requirements, design, quality, timeline, and budget expectations.
• Developed enterprise planning platform “ Confidential Costpoint Enterprise Insights” using IBM Cognos TM1. Enabled an accurate forecast of labor hours and direct and indirect cost, revenue, and profitably to all levels of the projects.
• Modified budgeting and forecasting application to be database-agnostic; simplified the model and reduced number of maintained processes by 15%.
• Optimized existing solution, which decreased resource consumption by 85% and data load times by 95%.

Confidential, Raleigh, NC

Principal Consultant

Responsibilities:

• Established client relationship and collaborated with 20+ member project team represented by FP&A, Sales, HR and IT departments; gathered, interpreted, and documented business requirements; translated into complex financial planning models, using IBM Cognos TM1.
• Developed capital expenditures forecasting application, which eliminated the need to maintain multiple off-line data sources across multiple departments and reduced forecasting time by 50%.
• Redesigned “personnel planning model” that reduced manual data entry and allowed for easier and faster forecasting cycle.

Confidential, Yardley, PA

Senior Solutions Architect

Responsibilities:

• Led code reviews and training and training of new developers.
• Developed Best Practices for development, architecture, design, code construction and testing.
• Served as development lead for “Presto” budgeting and forecasting solution. Designed and developed code that automatically generated TM1 objects, processes and rules for large-scale application. Developed SQL queries and Turbo Integrator code, which ensured data validation and speedy load processes.
• Developed BI reports that combined data from multiple SQL Server, Oracle and TM1 data sources.
• Optimized burdening methodology and business calculations which made model scalable and repeatable as a market solution.
• Designed support for business process improvement through application deployment for multi-phase release. Created structured code to interface with data warehouse and designed end-user input templates and reports.
• Designed and developed multi-currency model, which scaled across multiple ERP instances.
• Reviewed, analyzed, and optimized production TM1 instance, which led to dramatic performance increase without impacting end-user interface and kept within critical forecast timelines.
• Created and implemented a plan, which modified dimensions and rules, reduced 5,500 lines of code to less than 1,000; decreased data load times from 1.5 days to a few hours; allowed users quicker data access.
• Designed and developed a user-friendly access to consolidated financial and statistical data at the level of resolution available in the Oracle general ledger systems.

Solutions Architect

Confidential

Responsibilities:

• Architected a model, which consolidated multiple data sources into master chart of accounts; provided planning and forecasting capability at the general ledger account level of detail; designed automatic data tie out process for actuals and forecasts.
• Designed data archival process to preserve historical data. Created an alternate method for data entry and reporting. Assisted gathering data and reporting requirements for Global Commercial Operations.
• Designed SOX-compliant TM1 and security models based on current business processes for Corporate Pricing department using .Net.
• Developed complex SQL loads and TM1 rules that enabled top-down forecasting for a multi-company organization.
• Performed as a primary design architect for a multi-company implementation across three primary end-user groups.
• Developed complex ETL processes, which supported historical extraction and accounted for disparate ERP staging practices, which generated global forecast by consolidated and individual company views.
• Delivered TM1 web-based performance testing in conjunction with client performance testing team.
• Defined new TM1 and security models, reviewed business logic, and assessed impact on current cube design.
• Developed dimensions, cubes and automated data loads using Turbo Integrator for Salary Planning application. Developed and optimized rules for automatic benefits calculations.
• Performed server upgrades and validated operation of TM1 model and templates.
• Installed, configured and administered Virtual Machines, Windows servers, Cognos TM1 Servers, Cognos Disclosure Management and Cognos BI servers.
• Setup SSL certificates and configured load balancing.