SUMMARY

• Overall 10 years of experience in IT industry as a Software Engineer. Out of Ten years, 7 years of experience as a System Analyst and Developer in Business Intelligent platform using IBM Cognos TM1 and 3+ years of experience as software developer in Microsoft Technologies.
• Strong development skills using IBM Cognos TM1 9.x and 10.x
• IBM certified TM1 Developer and Analyst
• Strong work experience in all TM1 components (Architect, Perspectives, TM1 Web, Contributor and Performance Modeler)
• Hands on experience in writing rules and feeders.
• Expertise in Building Cube, Dimensions using TM1 Turbo Integrator processes.
• Excellent knowledge in Data Integration with different data sources
• Excellent knowledge in Reporting and Template design
• Excellent knowledge in Cognos BI & TM1 integration and Security setup
• Experience in Installation & configuration of TM1 servers and clients
• Excellent knowledge in Migration & LDAP Configuration
• Experience in TM1 Administration and Security setup
• Hands on experience in TM1 troubleshooting (Rules/Feeders/ TI scripts)
• Thoroughly documented the steps, provided production support and provided knowledge transfer to end - users for Cognos TM1
• Expert in Budgeting and Forecasting, Profit and Loss, Balance Sheet, Head Count and Cash Flow by using Cognos TM1 Architect, Perspectives, Performance modeler & Contributor.
• Experience in project management activities like RFP, Requirement Gathering, Requirement Analysis, Estimations, Planning and Post Production Support.
• Ability to design develops, upgrade, troubleshoot and maintain complex operational and financial systems.
• Experience in Development and Production Support Environments.
• Extensively used SQL Server 2008/2005/2000 for Writing Stored Procedures and Database Management.
• Experience in Onsite/Offshore model
• Self-Motivated, hard working and goal-oriented with a high degree of flexibility, resourcefulness and commitment.

TECHNICAL SKILLS

BI Technologies: Cognos TM1 10.x/9.x (TM1 Architect, Perspective Excel, Performance Modeler, Contributor), Cognos 10.2 BI Suite, (Framework Manager, Report Studio, Cognos Connection, Cognos Administration, Transformer), Excel VBA, Windows Scripting. Brio Intelligence

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

Operating Systems: Windows 7, XP, 2008, 2003.

Languages: C, C#, VB.Net, Core Java.

Microsoft Technologies: Visual Basic 6.0, C#, ASP.Net, ADO.Net, Microsoft .NET, Framework 1.1/2.0/3.5

Web Technologies: HTML, XML, ASP, Java Script.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Architect/Developer

Responsibilities:

• Understanding the requirements and based upon it designing the application
• Provided Production Support for Applications and Models in Production.
• Troubleshooting TM1 related issues and supporting end user’s performance issues.
• Proficient in writing rules, appropriate feeders and fine tune feeders for better performance.
• Performed Troubleshooting by diagnosing errors based on error logs.
• Scheduled Chores and Monitored Data Loads on timely manner.
• Created monitor process for entire application
• Involved in creating reports and active forms
• Different environment setup for every release testing and UAT
• Automating server environment refresh

Environment: IBM Cognos TM1 10.1, SQL Server 2008

Confidential, NA

Tech. team lead - admin

Responsibilities:

• Interacting with the onsite coordinator and understanding the requirements and based upon it designing the application
• Creating manual dimension using XDI spreadsheet and version controlling
• Creating TI process for dimension update
• Involved in creating cube and dimension
• Involved in creating TI process for data load from data source
• Created control TI process for application
• Created monitor process for entire application
• Design and developed reports and active forms
• Security setup and automation

Environment: IBM Cognos TM1 9.5.2, SQL Server 2005

Confidential

Onsite Lead, Implementation and support

Responsibilities:

• Interacted with Functional / Business users for requirement gathering and clarification
• Maintaining project tracker and on time delivery
• Application onsite coordinator
• Implemented security features
• User training and UAT support
• Bug fixing on time during UAT and track maintaining
• Application deployment and support

Environment: IBM Cognos TM1 9.5.2, SQL Server 2005

Confidential, Maimi

Tech. team lead - admin/ developer

Responsibilities:

• Involved in Installation and configuration of TM1 servers
• Environment setup with LDAP Configuration & Security mapping
• Environment Migration from Development, UAT to Production
• Interacting with the client and understanding the requirements and based upon it designing the reports
• Involved in creating cube, dimension, TI Process for data Import
• Designed security mapping through Excel based
• Created control TI process and monitor process for entire application
• Involved in creating reports and active forms

Environment: IBM Cognos TM1 9.5.1, SQL Server 2005

Confidential

Application development Support & Maintenance

Responsibilities:

• Monitoring the daily data load status
• Resolve/ response to the end user quires and issues
• Creation/Modification/Insertion of elements in dimensionsthrough Turbo Integrator Processes.
• Creating TI processes to load the data/delete the data/save the data in the cube.
• Writing Scripts to load custom data into the cube and from one version to another version.
• Used Skip Check and Feeders for optimization of Rules.
• Writing Scripts using Turbo Integrator Processes to create subsets for a dimension.
• Building/Scheduling/Monitoring the TM1 Chores and its processes.
• Worked with control cubes, lookup cubes in the process of Currency Conversion.

Environment: IBM Cognos TM1, SQL Server 2000

Confidential

Tech. team lead / developer

Responsibilities:

• Gathering the requirements and analysis of the specifications provided by the clients during weekly meetings.
• Interact with the Clients on a regular basis for resolving issues pertaining to the data delivered and special client requests.
• Responsible for creation of new models and enhancements to the existing models to accommodate dynamic reporting requirements.
• Development of TM1 Input Sheets/ Reports in TM1 Perspectives / Cubes.
• Perform peer reviews of code and test plans.
• Providing access to TM1 users, revoking access from TM1 users and resetting the password for TM1 users.
• Responsible for best practices like naming conventions, error handling, and document reviews.
• Analyze, write specifications and write test plan.
• Updating both the exchange rates - Forecast & Budget in the Admin Cash Flow Cube.
• Supporting to ad-hoc queries/issues raised by Customers.
• Archiving the cubes for historical periods by unloading from memory.

Environment: IBM Cognos TM1, Sql Server 2005.

Confidential

Developer

Responsibilities:

• Developing TM1 Cubes, Dimensions, Business Rules
• Writing rules and TI process without wizard method
• Creating Multiple TM1 Instances for development, Testing etc
• Enhancing the performance of TM1 cubes using feeders and skipchecks
• Created process for handling the security
• Created security design templates for assigning the security access
• Loading Data into Cubes using Turbo Integrator

Environment: Cognos TM1, Oracle.

Confidential

Developer

Responsibilities:

• Understanding of business, functional and technical knowledge for planning, budgeting and forecasting models
• Installation and configuration of Cognos TM1
• Database, data model and application architecture
• Developed TM1 model cubes and TM1 views
• Created TM1 dimensions and subsets with attributes
• Created TI process to load the data into cube
• Add security at client, cube, and element level.
• Source file and mappings
• Complex rules calculations

Environment: Cognos TM1, SQL Server 2005.

Confidential

Developer

Responsibilities:

• Direct and manage project development from beginning to end
• Creating high level architecture, modeling data, designing dimensions, hierarchies, attributes and cubes,
• Creating Turbo Integrator (TI) programs to process data
• Creating system documentation and user training manuals
• Involved in the trouble shooting in the Production.
• Data validation and source mapping

Environment: Applix TM1, SQL Server 2005.

Confidential

Application development Support, Maintenance & Report Generation

Responsibilities:

• Interacting with users to conduct requirement analysis and develop the technical specifications based on their projected business needs
• Involved in coding to develop web page
• Involved in creating a table and write a store procedure
• Involved in creating dimension, cube and views
• Involved in creating dimension, cube and views
• Performing business & risk analysis to identify and design robust, scalable reports that contribute to the organization’s productivity and profitability

Environment: Applix TM1, Brio, Asp.Net, SQL Server 2000 & Java script.