Management Data

Jamjuru Jagan Mohan Rao

Email id: ********@*****.*** Phone: 630-***-****

PROFESSIONAL SUMMARY:

About 9 years of IT experience in Requirement Analysis, Data Analysis, Application Design, Data Modeling, Application Development, Production Support, Implementations and Testing of Applications in Data Warehouse as different segments of SDLC

OLAP with strong knowledge in different business sectors

Experience in full life cycle project development, including design, coding, testing and implementation and ongoing product support

Developed multiple cubes in very large segments and maintaining all the cubes.

Analysis of specifications provided by various business users

Extensive experience on TM1 reports and portal customization with experience in Cognos FM, Cognos Report Studio, Cognos Query Studio and Cognos Analysis Studio and Cognos Administration

Experience with Cognos 8 BI modeling, Report Studio, Query Studio and Analysis Studio

Maintained outstanding relationship with business analysts and business users to identify information needs and business requirements

Improved performance of SQL and PL/SQL using EXPLAIN PLAN and TKPROF tools

Expert in developing PL/SQL Database Cursors, Triggers, Exceptions, Packages, Stored Procedures and Functions

Expert in RDBMS including Conceptual/logical & physical Database Design and Model using Erwin, Oracle9i/8i, SQL Server, PL/SQL, TSQL

Expertise in writing and debugging Stored Procedures and Triggers

Created complex DTS Packages for Data Migration and Transformation Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0

Experience in MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005

Experience with different kinds of code migrations from various environments like beta, non-prod, QA and Production.

Experience in overall data warehouse, database, ETL and OLAP tuning for better performance

Involved in Unit Testing, Integration testing and GUI testing

Strong perseverance and diligence towards attaining challenging goals and effective time management

Extensive Data modeling (Star schema for data marts) using ERWIN Designer.

Involved in developing E-R diagrams

Expertise in creating mappings, mapplets and reusable transformations using Informatica

Good Admin knowledge in Cognos TM1 and development

Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis

Solid experience in generating various complex reports using Cognos TM1

Self-motivated, excellent team player with proven leadership skills and excellent communication and interpersonal skills

Experienced with providing 24/7 Production Support

Excellent analytical, problem solving skills and a motivated team player with excellent communication and inter-personal skills.

SKILLS:

Data Warehousing

Informatica Power Center 6.2/5.2/1.7, Mapping Designer, Cognos 8, Cognos BI, Cognos TM1 9.0,9.4,9.5.2,10.1 and 10.2 Cognos Insight, Business insight, Operations Console, Performance Modeler.

Business Intelligence

Power Play, Transformer, Hyperion, Business Objects (Designer 5.0, Supervisor, Reporter & WEB),Crystal Reports 6.0/7.0/8.0, SQL Reports

Data Modeling

Star-Schema Modeling, Snowflakes Modeling, FACT & Dimensions, Microsoft Visio 2003, Flat files, Microsoft excel

Databases

Oracle 7.x, 8.x, 9.x, 10.x, MS SQL Server, Teradata, MS Access, Neo, Netezza, Teradata, DB2

Operating Systems

Windows 98/2000/NT, Solaris, HP-UX 10.2, Linux, UNIX, MS-DOS, Windows XP, Red hat, Sun Solaris

Applications

MS Word, MS Excel, MS Outlook, MS FrontPage

Languages:

C, C++, ASP .NET, Java, SQL, PL/SQL, HTML, Transact SQL, Unix Shell Scripting, Visual Basic.

EDUCATIONAL QUALIFICATIONS

Master of Science (MS), University of Bridgeport, Bridgeport, CT, USA

(Graduated in May 2007)

Bachelor of Science (BE), University of Madras, Tamil Nadu, India - 2004

(Graduated in April 2004)

PROFESSIONAL EXPERIENCE:

Cognizant Technology Solutions US Corp Nov’14 to till date

Client: The Nike Company

Cognos TM1 System Administrator

Responsibilities:

Administer and troubleshoot of Cognos TM1 environment

Upgrade /Migration of Cognos TM1 Installations which also includes patch release management

Cognos Roles/User Management, backup and recovery

Security setup and Analysis for performance related issues

Maintain integrity and configures components along with implementing systems enhancements to improve reliability and performance.

Experience with the TM1 10.2.2 environment

Experience with complex multi-server environments

Provide support for implementation, troubleshooting and maintenance of TM1 systems in complex multi-server environments.

Provide support to TM1 systems on Windows 2008 and 2012 platform including day-to-day operations, monitoring and problem resolution for all of the client/server/storage/network devices, etc.

Provides Tier 1 (Help Desk) and Tier 2 (Escalation) problem identification, diagnosis and resolution of problems.

Provides support for the escalation and communication of status to management and internal customers.

Set up and implement security roles and users in coordination with Security administrator.

Monitor systems capacity and consumption and provide input to chargeback model.

Under general direction, devise or modify procedures to solve complex problems considering Cognos administration and/or model and report generation and consumption. Create and maintain installation documentation and architectural diagrams

Migrate developed content from development to QA and prod environments.

Coordinate with business user teams for identification and resolution of functionality issues

Research/analyze TM1 administrative functions and report generation to maintain and increase system overall performance.

Modify, install, and prepare technical documentation for TM1 applications.

Identify, escalate and document production impact issues for the environment for business notification

Cognizant Technology Solutions US Corp May’12 to Oct’14

Client: The Walt Disney Company

Cognos TM1 Developer/Administrator

Responsibilities:

Provide regular production support for IBM Cognos TM1 applications (9.5.2, 10.1 and 10.2) such as migration requests, cube rebuilds, TM1 Admin related support and analysis and resolution TM1 Specific issues.

LDAP and Cognos BI User Administration and Project Management activities

Proactive environment cleanup and Monitoring on a production model

Coordinate with the business users to gather Requirements and analyze to build a technical and functional design for TM1 cubes and Web based reports

Design and development of the Data Model with VISIO, PowerPoint

Developed some dashboards using Cognos insight, Performance Modeler and Operations Console in TM1.

Hands on experience on Cognos TM1 contributor, TM1 Architect, TM1 perspective

Built some cubes using TM1 for both Financial and Planning Applications.

Strong experience on TM1 related migration activities from different environments

Strong experience on code deployments to both QA and Production from Non Prod environment

Hands on experience on Cognos TM1 security groups and maintained all the security groups in Production environment.

Involved in testing TM1 applications during version upgrades in Beta, Non Prod, QA and Production

Experience in migrating TM1 contributor applications from one environment to other including the security rights associated to the applications.

Metadata model design and development using IBM Cognos Framework Manager

Design and development of TM1 Reports using Cognos 8 and TM1 10.1

Implement Cognos TM1 Upgrade for various version in clients place

Request Management and Incident Management

Experience as a TM1 application Admin for different segments in Walt Disney company

Incident & request specific KPI Monitoring and Reporting on a weekly basis to the management on priority basis.

Type 1, 2 or 3 requests in all technology areas that he is handling

End to end management involving coordination with EIS, Product vendor and/or Segment teams as necessary

Support Cognos BI, Financial Planning, Informatica, TM1 applications on both server, Web as well as Contributor

Regular business hours (Onsite and Offshore respectively) support for severity 3 and 4 incidents and all request types

Provide 24*7 on call Support to resolve severity 1 and 2 incidents.

Environment: Cognos Insight, Business insight, Performance Modeler, Operations Consol, Citrix Xenon app, Cognos TM1 (9.5.2,10.1,10.2), Teradata

Larsen and Toubro InfoTech Ltd Nov’09 to Apr’12

Client: Travelers Insurance

Cognos TM1 Developer

Travelers is a diversified Finance and insurance company offering key policies and services in various fields and offer a wide variety of property casualty insurance products, surety products and risk management services across the globe. Travelers operate its business across the globe through its various business segments.

From core property casualty products such as auto, general liability, umbrella excess liability, property insurance and workers compensation to specialized coverage’s including errors and omissions liability and business interruption. Its breadth and depth of product offerings also enables to service selected international markets in more than 90 countries worldwide.

Responsibilities:

Providing a real-time approach to consolidating, viewing, and editing enormous volumes of multidimensional data.

Involved in gathering Business Intelligence requirements, analyze source systems data.

Planning software that scales to thousands of participants to support top-down and bottom-up budgeting, planning and forecasting.

Involved in documenting all the cubes in planning and re-forecasting season.

Developed multiple cubes for all Financial Reporting, Planning, Management Information and Reforecast modules.

Building and developing a budgeting, forecasting and other Planning systems using the Cognos TM1.

Modeling business and financial reports and input forms using TM1

Implementation of dashboard capabilities to the web sheets

Created multiple input templates for Users to input their numbers to the cubes using excel template linked to TM1.

Creating TM1 forecasting calculations based on clients requirements.

Implementation of Executive Viewer Explorer solutions.

Modeling business and financial reports and input forms using TM1.

Cognos TM1 Data Warehouse development using Turbo Integrator Processes, Rules and report writing using TM1 Perspectives and TM1Web.

Creating TM1 turbo loader process for populating TM1 cubes from various systems.

Worked in upgrading version from 9.0 to 9.4 and 9.4 to 9.5

Developed all types of controls back to the source system by various levels under various segments.

Extensively working on monthly data uploads to all the cubes that I support in the Production environment.

Have a very good knowledge of shared dimensions for MI and Financial cubes.

Scheduling chores to load all the data overnight and automated many TI’s to export out the data and to upload within the cubes.

Worked in all the planning cycles that take place each month for any reinstatement of various business needs when compared to Actuals.

Environment: Cognos TM1 (Applix) 9.0, TM1 9.4, MS-Excel 2003, MS-Excel 2010, Windows XP, Citrix XenApp.

Trinuc, Palatine, IL Mar’09 to Oct’09

Client: XO Communications

Programmer Analyst

Easy-Est. is costing and estimating software which is affordable, user-friendly & could estimate & cost any kind of Civil Engineering Structure. It has been developed for the Construction Industry and can be used by Architects, Civil Engineers, Quantity Surveyors, Consultants, Builders, Contractors, Realtors and also Construction Companies. It can estimate & cost any kind of structure as simple as a 'Storm Water Drain' costing in thousands or as complex as a 'National Highway', consisting of hundreds of CD works, Flyovers/Interchanges, Underpasses and Bridges costing thousands of crores. The software can estimate any type and size of structure whether independent and discrete or a group of structures such as a Township, University Campus or an Industrial Complex comprising of many different structures.

Responsibilities:

Gathered the business requirements by interacting with users.

Responsible for making decisions on coding standards and documentation.

Extensively developed PL/SQL packages with procedures, functions.

Developed various test cases including stress tests to test the efficiency and speed of the application.

Developed procedures to run the SQL*LOADER to load data from flat files into the target database tables.

Optimized the performance of the application with the help of Explain Plan for SQL queries.

Wrote SQL, PL/SQL, stored procedures, views and cursors for implementing business rules and data transformations.

Extensively used various data transformation functions of PL/ SQL.

Used Stored Procedures for accessing and retrieving the data from database to Crystal Reports 9

Wrote SQL scripts including SQL LOADER, SQL procedures, packages, functions and cursors for special data loads.

Wrote shell scripts to invoke PL/SQL Scripts.

Creation of users, roles, indexes etc.

Wrote database triggers and created log tables for debugging.

Generation of procedures, which return REF cursors as result sets.

Scheduled the shell scripts in various environments through the crontab.

Performed thorough UNIT and UAT testing with SQL queries to check the correctness of the code and business rules.

Performed Data base Code Optimization using Explain Plans.

Used parameters for filtering data in Crystal Reports 10.

Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD by using Crystal Reports 10

Optimizing, and fine-tuning the Crystal Reports for efficiency.

Participated in the DBA activities like creating users, granting and revoking privileges on database objects and taking backups.

Involved in unit testing & user support.

Involved in integration of the application.

Involved in 24/7 on call production support.

Environment: Oracle 9i, 10g, SQL, PL/SQL, Forms 10g, TOAD, ASP.net, SQL*Loader, UNIX.

Logic Planet Inc, Edison, NJ Oct’07 to Feb’09

Programmer Analyst

The increasing demand for medical transcription and health information processing services in the USA is resulting in a sharp rise in the demand for well-trained and experienced Medical transcriptionists. A corresponding increase in the availability of skilled MTs and QCs (Editors) to handle the increasing workload is a major challenge for the Human Resources department of each Medical Transcription Services Organization (MTSO) company.

Responsibilities:

Design and implementation of software application solutions, ensuring business requirements are met

Involved in documenting business requirements, functional and technical specifications, application blue prints and application support documents.

Involved in preparing project design, coding, testing, scripts using TI, PLSQL,SQL and UNIX scripting

Responsible for performance management of software applications.

Responsible for providing technical user training and support transition/knowledge transfer.

Developed planning submissions using TM1 web, Cognos BI - Business Insight, Cognos Insight and Contributor/ applications web.

Liaison with vendors for any defect corrections, long term strategy and case management.

Work closely with industry experts to understand technical issues and corrective action.

Manage organization hardware infrastructure design and implementation across environments.

Lead resource in automation of application reusable artifacts.

Responsible for performance debugging and optimization to meet business needs.

Collaboration with organizational leads to understand and document pain points for future enhancements.

Mentoring of resources across the company to improve team members knowledge and technical skills

Kicked off meetings with the clients (users) and gathered business requirements.

Assisted in defining and involved in documenting functional specs and helped establishing deliverables.

Analyzed and Mapped conversion data elements from original legacy system to new system database Banner views and fields, and vice versa.

Creating of SQL*Loader control programs and PL/SQL validation procedures to map data from different data sources to the Oracle Server.

Functions and triggers were used at different levels in the all modules to perform various validation operations.

Widely used the parameters facility in UNIX and PL/ SQL to facilitate automation of the processes.

Developed packages, stored procedures, functions for performing various calculations and converting COBOL based program of some of the departments into Oracle-based SQL scripts.

Created shell scripts to transfer data from web FTP server to Oracle directory on UNIX.

Involved walkthrough code for team members and smoothly migrated code to Production environment.

Coordinated with the Testing team members to perform integration testing

Provided SQL tuning, table indexing, data migration, project migration, program debugging.

Developed Unix Shell Scripts to perform extracts and run various PL/SQL procedural jobs.

Developed SQL Loader Control files and loaded bulk physical data from flat files.

Optimized the performance of the SQL queries in procedures with the help of Explain Plan, Indexes and Hints.

Developed custom procedures to extract monthly reports based on sales team requirements.

Provided SQL tuning, table indexing, data migration, project migration, program debugging.

Provide weekly status reports on the applications SLA’s for 24/7 support

Environment: Oracle 9i, 10g, SQL, PL/SQL, Forms 10g, TOAD, ASP.net, SQL*Loader, UNIX, Cognos BI, Applix TM1, XML,MS DOS, HTML.

Contact this candidate