SUMMARY

• A senior IT professional with quantitative background and hands - on work experience in general ledger accounting, financial planning and analysis, budgeting and forecasting, internal and external financial reporting, business analytical tool modeling and financial decision support.
• Strong experience inArchitecture design, Development, Administrationand upgrade of TM 110.2.2/10.1.1/9. X (TM1 Architect, Web, Perspective, CAFÉ, Active Forms, Performance modeler etc.) and Cognos environments 10.2.2/10.2.1/8. x.
• Hands on experience inCognos BI SuitesCognos analytics 11/10.2.2/10.1.1/8. X(Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Business Insight, Cognos mobile),Power play Transformer
• Well versed in Requirements/Change Management, Impact Analysis and Gap Analysis
• Actively participate in the evolution of the TM1 platform: bridge the gap between the business and IT ensuring common understanding of the data, support improvements with a view to increase efficiency and flexibility.
• Experience in integration of Cognos TM1 with Cognos BI.
• Experience in development of TM1 models/applications including data cubes, dimensions, rules, TI processes, and reports.
• Solid Experience in creating Active forms, Slicers, & Snapshots
• Well-versed in developing reporting applications using Cognos 10.x/8.x components like Report Studio, Query Studio, Analysis Studio and Cognos Connection.
• Extensively worked on Transformer models and cubes that were used in Power play analysis.
• Experience with Cognos BI and TM1 security (LDAP, Active Directory, Access manager, object level security, data security).
• Expert in automating deployment process for Cubes,MDL,Report Packages.
• Expert in writing sql queries against Oracle 11g/10g/9i, SQL Server and Teradata, Hadoop.
• Sound knowledge in business process of Healthcare, banking, Sales, Insurance and Manufacturing domains.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess excellent communication and interpersonal skills.

TECHNICAL SKILLS

BI Tools: Cognos TM 1 10.2.2/9.5 ( TM1 Architect, TM1 Perspective,Turbo Integrator,CAFÉ,Tm1 Ops Console), Cognos analytics 11/10.2.2/10.2. x/8.x(Framework Manager, Report Studio, Query Studio, Analysis Studio, Workspace Advanced,Cognos mobile, Insight), LDAP, Access Manager, EnterprisePlanning10.1/8.4, IIS,HTML, JavaScript, Excel VBA,Windows Scripting.

Operating Systems: Windows 2012/2008/Vista/XP/2003,SUSE LINUX, SOLARIS.

Databases: Oracle 11g/10g/9i, SQL Server 2005/2008,MS Access,Teradata.

Other Tools: CognosLife CycleManager,MotioCI,Toad, PLSQL Developer, HP Quality Center, Service Now,Control-M,PVCS,MS Visio.

PROFESSIONAL EXPERIENCE

Sr. TM1 Analyst\Administrator

Confidential, Chicago, IL

Responsibilities:

• Support the financial user community through training, system enhancement, report generation, and timely response to support calls.
• Responding to a change in the client\'s IT direction, promptly prepared for construction of the planning and forecasting tool, developed a global enterprise-wide application using Cognos TM1.
• Generated financial reports from Assets,ISBS,Liquidity,ERP and Client detail cubes.
• Architected an implemented a large-scale TM1 solution for one of the large banks; Architected and designed the TM1 dimensions and cubes; integrated data from various sources into the TM1 model by developing complex Turbo Integrator processes; architected and implemented a powerful calculation engine to facilitate the profitability analysis, by implementing efficient Turbo Integrator processes and Cube Rules
• Performance fine-tuning - Architected and Implemented a multi-threaded solution, by leveraging the Parallel Interaction, to minimize the data-load and data-extract execution time by running multiple processes in the same time ;
• Responsible for overall administration, configuration and security for the Cognos BI and TM1 environments
• Streamlined existing models to increase performance and reduce maintenance by utilizing stargate views, persistent feeders, conditional feeders and concurrent data loading processes.
• Monitor performance and provide tuning recommendations to the TM1 Sever, Tm1 Instance, Operating system and detect other possible bottlenecks.
• Scheduled Control m jobs and Monitored Data Loads on timely manner.Monitored TM1 Operations Console for server health.
• Successfully Installed and configured Cognos BI versions 10.2.1, Enterprise Planning 10.1.1 on multi-server environments.
• Installed and configured CAFÉ and developed reports using tm1 cubes as source.
• Integrated IBM TM1 10.2.2 environment with BI CAM security and established SSO.
• Involved in capacity planning and architecture for maximizing performance and failover strategies.
• Providing access toTM1Users, revoking access fromTM1users and resetting the password using the Turbo integrator process and control objects.
• Performed Quality Assurance testing on software upgrades, scripts and fixes before they were implemented into the production systems.
• Work with IBM on debugging/trouble-shooting incidences and ticket resolution
• Train and support Cognos&TM1 end users on basic functionality, running processes, viewing/updating cubes and dimensions.

Sr. Cognos TM1 Administrator

Confidential, Raritan,NJ

Responsibilities:

• Work closely with business stakeholders to understand business requirements
• Responding to a change in the client\'s IT direction, promptly prepared for construction of the planning and forecasting tool, developed a global enterprise-wide application using Cognos TM1.
• Design, build and populate TM1 Cubes with latest forecast data from Data Repository and build dimensions and various types of Cubes in TM1
• Key contact for facilitating quarterly forecast, assist internal and external auditors with interim and year-end field work. Assist in the monthly consolidation and provide monthly standardized reporting
• Administer the Cognos TM1 development, quality assurance, production environments, including managing Cognos TM1 security using Active Directory, and migration of objects from development to production
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actual
• Installed and configuredTM1 10.2 and created multiple instances (Dev, QA and Prod) in the server.
• Worked with Tm1 integration between Cognos Business Intelligence components.
• Review financial statements and analyze sales revenue and expenses. Participate in the monthly financial close and reporting process Forecast revenue, expenses and sales volume for quarter business review, annual operating plan, and long range plan.
• Installed and configured CAFÉ and developed reports using tm1 cubes as source.
• Streamlined existing models to increase performance and reduce maintenance by utilizing stargate views, persistent feeders, conditional feeders and concurrent data loading processes.
• Resolving any production issues and working with IBM vendor if there are any tool relating issues.
• Provided training on system functionality and business models to the FP&A and accounting departments.

Sr. Cognos & TM1 Developer

Confidential, Thousand Oaks, CA

Responsibilities:

• Collaborate with business users and members of the BI team, including business analysts, database administrators, and managers, to design and develop Cognos TM1 solutions.
• TM1 Architecture and Installation, Monitor Server Performance, Implement TM1 Security, etc., Maintain Applications, Customize Business Rules.
• Maintain and enhance current Actual\Planning\Forecast financial TM1 models.
• Contribute to the development, maintenance and delivery of end-user training. Prepare and review technical documentation specific to the various TM1 Applications being built;
• Support the TM1 User Community when required by working on assigned support tickets and end user Inquiries Installed and configured Cognos BI versions 10.2/10.1/8. x, Enterprise Planning 8.4,10.1.1 on multi-server environments. upgraded TM1 application from 9.5 to 10.1 version
• Security set-up for TM1 applications using Cognos Access Manager (CAM).
• Responsible for the ongoing operational stability of the environment ensuring objects are properly monitored and audited to provide data integrity, accuracy and timeliness of delivery
• Scheduled jobs by using control-m and Monitored Data Loads on timely manner
• Applied patches and hot fixes to TM1 and EP Systems
• Created detailed documentation for Cognos and TM1 system including data-flow diagrams and maintenance procedures.
• Supported Production Environment 24/7 for Cognos, IBM TM1, IBM Enterprise Planning systems

Cognos TM1 Developer\Administrator

Confidential, MI

Responsibilities:

• Performed Business requirement analysis, Functional requirement analysis to the client.
• Designing, building, testing, and improving Cognos TM1 cubes and dimensions
• Developing and optimizing TM1 rules and processes for data transformation
• Responsible for overall administration, configuration, security, and maintenance for the Cognos environment.
• Analyzing the Cube Dimensionality for ease of the process towards the various segments of the business model
• Involved in the Migration of entire project from CognosReport net to Cognos 8.2/8.4.
• Managed standardized Excel spreadsheets that leveraged complex TM1 API calls and VBA coding to dynamically generate reports and extract data from TM1

Sr.Cognos Developer/ Administrator

Confidential, San Francisco, CA

Responsibilities:

• Install, Configure and Setup of Cognos8.4 environments on a multi-server environment
• Managed a development team that develops and maintains SQL databases; Cognos Framework Manager; Powerplay cubes and reports.
• Created and maintained Cognos based reports through Report Studio.
• Developed Business Intelligence solutions that are used by various levels of management.
• Involved in the performance tuning of theCognosinfrastructure including the software configurations and the interaction, effective utilization of the hardware platform including memory, and CPU resources.
• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, Executive Dashboards using Report Studio.
• Designed the Dashboard Templates and Created Various Dashboard reports for the Business Users.

Cognos Consultant/Administrator

Confidential, Warren, NJ

Responsibilities:

• Interacted with users to transform the business specification into technical requirements.
• Installed, Configured and Maintained different versions of Cognos 8 across multiple environments
• Upgraded Cognos environments from CognosReport net 1.1 to Cognos 8.2, Cognos 8.2 to Cognos 8.3,
• Used Framework Manager to build models, packages and publish packages
• Creation of Complex Multi-Object Report Studio Reports using Lists, Crosstabs, charts, Images and HTML applications using Report Studio.and ad-hoc reports using Query Studio.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Trained End Users to use and build the Ad-hoc and analytical reports using Query Studio, Analysis Studio.