SUMMARY

• 10 +years of experience in building Forecasting/Budgeting applications and Business Intelligence on multiple domains.
• Experience in installation of Planning Analytics 2.0.9 local server BigFix 9.5.13, ILMT 9.2.19. and PAW administration.
• Experience in migration of applications from TM1 to PA.
• Trained end users on PAX, created support documents.
• Experience in building Forecast and Budget - FTE, Non-FTE, Capital, Income Statement, Balance Sheet and Reporting planning tools.
• Experience is building applications in TM1 web, PAW and Perspectives (TM1 combined with VBA).
• Created worked books using advanced virtual dimension concepts in PAX.
• Expertise in creating Dimensions, Cubes, TI processes and business rules in PA.
• Created regularly scheduled automated jobs to load TM1 data structures and managed TM1 data through Excel and Spreadsheets
• Experience with Cognos Tools such as Cognos BI 10.1/8.4 Suite, Cognos TM 1 9.5/10.1/10.2 and Analysis Tools such as Cognos Transformer & Power Play.
• Experience on Installation & Configuring the Cognos 10.1 BI Environment. Worked on Migrating reports from Cognos 8.4.1 to Cognos 10.1 series
• Hands on Experience with Framework Manager Modelling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Expertise in developing Database Schemas such as Star Schema and Snowflake Schema, which are used in relational, dimensional and multidimensional modelling.
• Experience in maintaining Cognos enterprise planning (EP) environment for Forecasting and Budgeting life cycles.
• Worked on creating packages in MSSQL Server Business Intelligence Studio 2008.
• Experience in various industry sectors such as Taxation, Pharma, Manufacturing and Retailers.
• Involved in Performance Tuning, Developed Stored Procedures, Functions and Packages.
• Worked on Cognos 10 TM1 Insight and Performance Modeler for building Applications, Cubes, Dimensions, Replications, Processes and Models.
• Knowledge on Power BI (Design and Development).
• Strong problem-solving skills, ability to develop strategies for clients, and provide detailed documents to clients.
• Extensive experience in Multiple Relational Databases including SQL SERVER, ORACLE, TERADATA.
• Deploying Models and reports from Staging to Production and administering users/groups/roles.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.
• Excellent Team coordinating Skills with the Development Team and Deliverable dates.
• Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem-solving skills.
• Day to day oversight and prioritization of the work of L1/2 Production Support teams
• Coordination of activities with Infrastructure teams for applications owned by Enterprise Analytics
• Assist the Enterprise Analytics Support Manager to establish and maintain all corporate policies and programs to assure a safe working environment
• Assist in the onboarding of new Analytics applications (development/testing of application security, setting up of support structures)
• Participate in DR (Disaster Recovery) tests and maintain DR documentation for Analytics applications
• Responsible for analysis of current system including performance, diagnosis and troubleshooting of problem programs and designing solutions to problematic programming.
• Extensive knowledge of Data Warehousing, BI and OLAP concepts.
• Acting as a liaison between Business Groups, Architect and Design teams and the Development/Support team.

TECHNICAL SKILLS

DWH/BI Tools: PA 2.0.9, PAW 2.0.49, TM 1 9.5/10.1/10.2 (Performance Modeler, TurboIntegrator, Architect, Perspectives), Cognos EP 8.4(Analyst & CAC),Cognos 8.4/10.1/10.2 Suite (Reports Studio, Analysis Studio, Workspace Insight, Workspace Insight Advanced, Framework Manager, Transformer),SQL Server Business Intelligence studio, Agile, GIT, Fusion

Databases: SQL Server 2000/2005/2008 , Oracle 9i/10g/11g, Teradata, IBM DB2, SAP, SOX.

Operating System: Windows 2008 R2/2003/98/95 and MS DOS

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Developer / Support Lead

Responsibilities:

• Worked with end users to gather requirements, analyze, and provided estimations.
• One point of contact for all TM1 work: Design, Development, Support and Administration.
• Installed PA and PAW local on windows 2008 R2 and Hyper V servers. Migrated application from TM1 to PA.
• Developed Balance Sheet, Income Statement, Reporting, Backlog and Bookings TM1 applications.
• Created processes to extract hierarchies to Reporting dataset for downstream applications.
• Created process to load data from different sources, archive versioning, open and close forecast cycles.
• Worked on creating process to identify missing master data in reject tables and send email notification to users.
• Worked on applying business rules for TM1 cubes, and to transfer data between different cubes to Reporting cube.
• Acting as a liaison between Business Groups, Architect and Design teams and the Development/Support team.
• Act as Operational Lead of L3 Production Support team for Enterprise Analytics (managing work assignments and priorities for on- and offshore team members)
• Day to day oversight and prioritization of the work of L1/2 Production Support teams
• Coordination of activities with Infrastructure teams for applications owned by Enterprise Analytics
• Assist the Enterprise Analytics Support Manager to establish and maintain all corporate policies and programs to assure a safe working environment
• Worked closely with clients on daily basis in Requirements gathering, Design Reviews, peer reviews, Defect calls, FRD calls and effort Estimation
• Provided knowledge sharing sessions within project team and across the organization.
• Involved in Staffing of Cognos resources to various Projects.
• Creating TS & FS design documents for model and reports based on the functional documents
• Coordinate the review, presentation and release of design layouts, drawings, analysis and other documentation
• Working with large sets of data, multi-dimensional data sets

Confidential

Computer Programmer/Analyst

Responsibilities:

• Develop BI and reporting solutions that includes Analyze, design, coordinate and supervise the development of software systems based on business requirement.
• Giving user support, maintaining reports, models and structure.
• Responsible for analysis of current system including performance, diagnosis and troubleshooting of problem programs and designing solutions to problematic programming.
• Maintain positive client interactions
• Automate excel, foxfro reports in report studio and in Cube.
• Utilizing the report studio to develop analysis types of reports such as list reports, cross tab reports, chart reports, and master detailed reports.
• Manage operations of the engagement.
• TM1 Administration - security, clients’ installation, configuration, migration, modification
• Partner with other team members in the technical design of various TM1 applications.
• Developed Reports of list, chart, crosstab, cascading, burst, Master - Detail, Drill Through in Report Studio
• Doing data visualization in Active Report and in Workspace-Advance.

Technical Environment: TM1 (9.5, 10.2) Architect, Café, Cognos BI 10.2.1.1, Framework Manager, Report Studio, Query Studio, Oracle, Tableau 10

Confidential

Assist Manger/Team Lead

Responsibilities:

• Developed TM1 Rules, Turbo Integrator process, Dimension, Hierarchy and Dimension subset
• Implementing TM1 Security, User Access on cube, users rights, Cube View, Core, Metadata
• Integrated TM1 to cognos software
• IBM Cognos TM1 10.2 Developer certified.
• Creating Cubes in TM1
• Understand and work with Turbo Integrator to load and retrieve data.
• Experience in TM1 rules editor to create/update various calculations
• Working with large sets of data, multi-dimensional data sets
• Developing TM1 applications / cubes in support of business needs and develop TM1 processes and TM1 rules.
• Responsible for implementation and development of IBM Cognos TM1 - planning, budgeting and forecasting solutions, as well as analytically and reporting applications
• Acting as a liaison between Business Groups, Architect and Design teams and the Development/Support team.
• Understanding the business requirements and translate that to technical processes.
• Manage operations of the engagement.
• TM1 Administration - security, clients installation, configuration, migration, modification
• Partner with other team members in the technical design of various TM1 applications.
• Developed Reports of list, chart, crosstab, cascading, burst, Master - Detail, Drill Through in Report Studio
• Doing data visualization in Active Report and in Workspace-Advance.
• Assign user security, user roles and responsibilities
• Set up new database and audit database in Cognos configuration
• Developed Dashboards in Cognos Workspace and Report Studio
• Have Built Reports with various Conditional Styles and Render Variables.
• Assisted Business users to create reports in Cognos Workspace Advanced
• Working in Cognos Administration and Production support
• Working knowledge of Cognos SDK
• IBM Cognos BI solution design, administration, installation, server configuration, and technical support
• Built Active Reports in Cognos 10.2 for Business Offline Reporting and Executive Demo presentations
• Implemented complex data, object and package security filters within the IBM Cognos BI suite of tools
• Creating dynamic cubes in cognos10.2
• Built Complex Reports having child reports, HTML items in Report Studio
• Assisted Users in Creating Custom Definition Groups for better presentation of Reports
• Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio
• Experience in creating Ad-hoc reports using Cognos Query Studio
• Efficient in writing SQL Queries in SQL Server
• Fine-tuned the reports, underlying queries and tables using indexes.
• Worked on Production Support and fixing report/package/data issues.
• Worked on Data Analysis, Validate reports and find data quality issues
• Production Support which involves solving user problems and Provided End User Training and Support
• Prepared User documentation to train users and functionality of each report

Technical Environment: Cognos BI 10.2.1.1, Framework Manager, Report Studio, Query Studio, Windows 7, Teradata, Access Database