SUMMARY:

• Experienced over 14 years working in Financial Performance Management system implementation involving Cognos TM1, BI Suite and Data warehouse And Techno - functional Consultant with core experience in core experience in TM1/BI tool, modeling of Financial Planning, budgeting/forecasts/consolidation tm1 applications. Extensively worked with clients throughout the complete lifecycle of the TM1 and BI implementation projects.

TECHNICAL SKILLS:

SKILLS: Business Intelligence/ETL/Financial Planning and Analysis/ Corporate Performance Tools & ERP Cognos 8/9/10: Transformer, PowerPlay, Architect, Visualizer, Metrics, Report Net, Framework Manager, Analysis Studio, Mobile, Security, Contributor/Contributor Administrator, Metric /Report / Query Studio, and TM1/Perspectives/Web/ Executive Viewer/Contributor/ Insight/ Integrator/Web; DataStage 8.5 & 8.7, Analysis Services (SSAS), OLAP Cubes, Reporting Services (SSRS); SAS (Data Integration, Enterprise Miner/Guide, Dashboard, OLAP Cube Studio, Information Map Studio, and Web Report), Orion ERP, Google Analytics, Databases Oracle, SQL Server, Enterprise Edition, DB2, Netezz

PROFESSIONAL EXPERIENCE:

Lead Developer /Architect

Confidential -Ohio

Responsibilities:

• Analyzes business and functional requirements and Produce design artefacts and technical specifications.
• Partner with Functional team to define solutions based on requirements and assist in estimating testing/Impl work.
• Lead resolution of production issues and maintaining appropriate service level agreements.
• Partner with Application Functional Leads in optimizing solution performance in line with operational requirements.
• Provide task level work structure breakdown with accurate turnaround and effort estimations for Tm1 projects.
• Collaborates effectively with BA, LOB, Development, Support and offshore development teams.
• Accountable for all phases of development process: analysis, design, construction, testing and implementation; provides user and operational support on applications to business users.
• Hands on experience with Tm1 development assignment, good on TM1 turbo integrator processes, business rules.
• Designs and configures objects such as cubes, dimensions, elements and chores, Implements custom security rules.
• Proficient with TM1 Architect, Perspectives, Excel plug-in, Experience with ORA DB and SQL Server.

IT environment: Cognos Tm1 10.2 ve, DB2, Cognos Data Stage

BI/DW Lead and Onsite Co-ordinator

Confidential

Responsibilities:

• Understand and analyze the impact of ERP upgrade on the ETL process for Data Warehousing.
• Design, Plan and Develop programs to optimally extract, transform, and load data from sources to target systems.
• Regular interact with the clients/users and ERP upgrade team to clarify open queries relating to the project during all project phases - co-ordinate with the offshore team on the day to day task status and to clarify open queries.
• Write/Modify Database DDL scripts to create/alter tables, indices, synonyms.
• Develop/Modify Informatica ETL mappings, sessions and workflows to retrofit the changes due to source upgrade.
• Sync the sustaining development into r12 environments as in when code is deployed to production.
• Migrated the code between various environments using with DBA team help.
• Work on the sustaining development/enhancements alongside the r12 upgrade project.
• Create test cases and unit test the ETLs and Diagnose and resolve performance issues and Document the changes.
• Guide the reporting team to retrofit the reports due to changes and enhancements in source table structures.

Project Lead Developer

Confidential

Responsibilities:

• Cognos Tm1 10.2.2 development/support experience -Design and develop corporate performance management systems for Confidential Corporate for planning and budgeting/forecast model, worked as tm1 developer/Analyst, with implementation team-using cognos tm1 tool 10.2.2 version.
• Extensively worked requirement gathering from finance team, model enhancement, change request, and solutions in developing new TI process/Rules. Testing and UAT and production deployment.
• Worked on TM1 cube builds, dimension, TI processes and chores, rules and general troubleshooting issues.
• Responsible for creating and maintaining the planning and execution of Cognos TM1 upgrades.
• Cognos tm1 server maintenance of all environments. UAT and Development team and coordinate with Windows team for Tm1 upgrade activities
• Responsible for planning, support, administration, maintenance, monitoring, troubleshooting and performance of IBM Cognos TM1 environments.
• Perform analysis of server logs error, tm1 process failure, Tm1 server and instances management experience.
• Perform analysis & provide operational recommendations to ensure TM1 environment CPU, memory & disk utilization by establishing acceptable thresholds and associated alerts.
• Documented all systems development to ensure continuity and transfer of knowledge for effective post implementation support- Prepared users & Documentation.
• Handled all user issues relating data, access and configuration and Supported the TM1 User Community.
• Extensive work experience data validation of functional testing and technical testing during upgrade to 10.2
• Involved in writing TI process for loading data from the source systems, flat files, and cube-cube load.
• Familiar with IBM Cognos 10 BI platforms, BI integration and cognos life cycle manager tool.
• Familiar with DW project implementations and fair SQL knowledge.
• Managed and lead development team’s onsite - offshore delivery models for ETL, DW, and Qlikview and Cognos BI/TM1 projects.

IT environment: Informatica 9.1, Oracle, Netezza, Control-M, Cognos BI, Qlikview. Microsoft SQL Server 2008.

Senor Business Analyst

Confidential

Responsibilities:

• Mind-Tree assignment was a CPM consultant -my work includes-Designing and building planning, budgeting and forecasting solutions for a range of up-coming clients and preparing POC’s for the various proposals for new customer using the Enterprise Planning (CP) and Cognos TM1/BI tools.
• Setting up sessions within the CPM Practice-Provided on Cognos Planning and TM1 tools for new joiners. Focusing on the design and developing of planning, budgeting models of for Finance user's requirements using Corporate Performance tools viz, Cognos Enterprise Planning TM1. Worked on the TM1 project-design and implementation of financial planning and consolidation with TM1 cubes tools including CognosTM1 Web and Turbo-Integrator and Deploying and Configuring TM1 in standalone environment for budgeting and consolidation.

BI/CPM Project lead

Confidential

Responsibilities:

• Worked for Hindustan Confidential Ltd project. As a Cognos Consultant-supporting the Cognos Finance and Cognos Planning applications for the HUL business for China and Honk Kong regions- work involves - Development and Support of Cognos CF & EP applications and Supporting management accounting reporting models and Experienced in trouble shooting various kinds of issues faced by end-users on EP applications and Cognos TM1.
• Supporting and resolving the technical/functional issues on Cognos Planning all Confidential modules and helping the allocation module- data load, roll-ups, reporting, and Analysis, responsible for client interfacing, requirements definition, planning and coordination of work, knowledge transfer and resolving technical issues.

Senior Financial Analyst

Confidential

Responsibilities:

• Analysis on Cognos Finance reporting, analyzing entra company eliminations, allocation of costs, preparing sales scorecard and task like changing the memory configuration for modules, setting - up file location and connecting and editing to database directories for Cognos consolidation and helping the onsite user on setting-up Cognos consolidation session so that it meets user day to day reporting needs.
• Helping the team to solve user issues in Cognos reporting, and Analysis of GE Industrial Sales volume data from data warehouse and analysis of performance of Cost Centre for various GE locations/Plant- and performing Account reconciliation for revenue accounts and analyze the variances and identifying route cause for variances.
• Identifying all reconciling items by category (and individually), making corrections and implementing a Control Plan to keep the Digital Cockpit and GL, and GL to Cognos Consolidation, GL to Global Sales Universe in sync.
• Allocation of revenue’s to proper Business Units and accounting and reporting. And assisting / Coordinate the implementation of these processes in the field. For Oracle GL team and Cognos, and Digital Cockpit and Global Universe team.
• Working for Finance Function for GE Aircraft Engines - Cincinnati (USA) and Transitioned high end billing and AR reconciliation process. Analyzing the EFH - T &M reports for GE End Customers(Airline Operators) Analyzing sales by product line and shop visit (units) and identify the key drivers based on Price, Volumes, by product lines/customer etc and report out to HQ on the final comments.
• Setting up Assets in compliance with US - GAAP and Federal Tax regulations in order to establish and maintain detailed fixed asset records for GE Motors business
• Analyzing the customer determination of expenditure capitalized and ensure that proper capitalization has been followed. Account reconciliation of Capital Work-In Progress, Depreciation and Fixed Assets accounts. And identifying and analyzing the system errors and correcting them during closing of ORA