Sainath Kumar Pattipati

IT Applications Manager

acrika@r.postjobfree.com

646-***-****

SUMMARY

Highly accomplished professional with a distinguished 10-year career leading the design and implementation of advanced data capture, integration, analysis, and reporting solutions to enhance decision-making.

Worked in various roles as Project Manager, Project lead, Team member, Onsite- offshore co-coordinator and in Pre-sales. Good experience in Project Management, Functional Requirement analysis, Solution Design, Gap Analysis, UAT, Configuring Applications, Data Analysis, Conversion Strategy, Data Migration, Production Support, Training Business Users (Class room sessions and development of training material), Testing, Documentation.

Recruiting, mentoring and managing global matrixed IT teams that enable superior service delivery, rapid business enablement and benefit realization through large project implementations.

Organized and goal-oriented, with more than seven years' experience in project management and a strong customer focus.

Analytical problem-solver, able to anticipate issues and create new systems that streamline operations, resolve concerns and improve efficiency.

Skilled in building excellent rapport with clients and team members. Able to see the big picture, delegate effectively and motivate team members to achieve on-time project completion. Proven ability to quickly grasp and apply new technologies and best practices.

CORE COMPETENCIES

Enterprise Project Management.

Software Development Management.

Enterprise Architecture.

Systems Development Life Cycle Management

Project Design, Execution & Management.

Change and Release management.

Business Process Analysis & Automation.

Business Intelligence & Data warehousing.

Data Modeling & Predictive Analytics

OLAP & OLTP Database Management

ETL, Dashboard & Reporting Frameworks

Team Development, Training & Leadership

TECHNICAL SKILLS

Reporting Tools OBIEE, Tableau, Cognos 10 – Active reports, Business Insight Advanced, Report Studio, Adaptive Analytics, Analysis Studio, Metric Studio, Event Studio, and Query Studio, Cognos Impromptu, Cognos Series 7, SQL Server Reporting Services, Crystal Reports, SSRS Reports. Project Management

Tools

MS Project, MS Power Point Presentations.

Modeling Tools Cognos Framework Manager, Adaptive Warehouse, Cognos Transformer, Cognos Metric Designer, ERWIN, Access Manager, Microsoft Visio, Rational Rose, Erwin.

Markup Languages XML, HTML.

Programming

Languages

PL/SQL, T-SQL, Java, C#, ADO.Net, ASP.Net, JavaScript. Operating Systems Windows 98, NT, 2000, XP, 2003 Server, Knowledge of UNIX Basic commands.

Databases Microsoft SQL Server, Oracle EBS, IBM DB2, MS Access, MS Excel.

ETL Tools Microsoft SSIS. BIDS, Data Manager, Informatica. Version Control PVCS, Visual Source Safe.

EDUCATION

CLASS BOARD PERCENTAGE

B.Tech (E.C.E) J.N.T.University Hyderabad,

A.P (2001-2005)

72.06

XII Board Of Intermediate

Education

A.P.

88

X School Of Secondary

Education

A.P.

80

CERTIFICATIONS

Certification

Code

Certification Name and Logo

Skill soft Project Management Professional Training & Certification EX0-101 ITIL Foundation v.3 Certification.

AINS21 AINS 21 Property and Liability Insurance Principles COG-180

COG-180: IBM Cognos 8 BI Professional

70-528 Microsoft Certified Technology Specialist on .net Framework 2.0 Web Applications.

70-448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

PROFESSIONAL EXPERIENCE

Company/Client: Niagara Bottling LLC, Ontario, CA, USA January 2013 – Present

Position IT Applications Manager

Project Business Intelligence & Data warehousing (Sales, Finance, Supply Chain, Customer Service, Manufacturing).

Description Senior Level IT leadership role charged with architecture, design and development of enterprise BI solutions. Oversees strategic project initiatives, proof of concepts and development/maintenance of enterprise architectural artifacts.

Responsibilities Established the vision for and led the design and development of the dimensional data warehouse and

business intelligence system, pioneered the use of Metadata repositories to uncover patterns of system utilization allowing for the identification of opportunities for system improvements and the ability to mitigate system issues leading to over 30% reduction in costly customer service calls.

Led user requirement sessions, participated in vendor selection, designed hardware architecture to resolve disaster recovery, business continuity, and availability requirements.

Launched document & knowledge management practice to streamline team collaboration and SOX auditing processes.

Improved team work and collaboration by providing mentorship, coaching and facilitating team building activities for development, QA, production support and technical services team.

Hands on supervisor of IBM BI Suite of applications, and Oracle EBS.

Worked closely with IT systems director to implement and rollout BI solution.

Environment Microsoft Project, OBIEE, Tableau, Cognos 10.2 Suite (Cognos Connection, Framework Manager, Report Studio), Adaptive Warehouse, Adaptive Analytics, Cognos SDK, Oracle EBS, SQL server 2005, Windows XP, IIS, Microsoft Visio, Eclipse, Apache, VSS 6.0, Visual Studio .Net 2005, Rational Rose, MS-Office, SharePoint, C#, Core Java, Visual Basic, VBScript and Java Script, Sybase. Company/Client: Mphasis/AIG, AMERICAN

INTERNATIONAL GROUP, INC, NJ, USA January 2011 – Dec 2012 Position IT Project Manager

Project Foreign General Client Server Applications Project Description Foreign client server applications are group of around 20 small applications which provides different reports for making intelligent insurance decisions based on data available from various branches/field offices. Data from ODS was Extracted, Transformed and Loaded into Data Warehouse. Cognos was used as OLAP and for generating dynamic reports to analyze the current business trends and actuarial & underwriting teams to analyze data and make predictions about the future business trends/planning. Mainly these applications are used for FP & A reporting purpose and to make the adjustments to the data reported by field offices and in preparing financial statements for yellow books.

Responsibilities Managed staff of 7 internal employees and consultants to architect, design and develop enterprise solutions.

Primary liaison between development team, QA and other organizational units to ensure accurate information to and from development team.

Managed cost budget to allocate overall cost estimate to individual tasks.

Produced project status reports, managed the team and resolved day-to-day production issues with emphasis on SDLC.

Consolidated nearly 600 Access reports and managed migrating them into Cognos reports to improve organizational effectiveness by redeveloping many tactical reports shared across different business units.

Environment Microsoft Project, OBIEE, Tableau, Cognos 10.2 Suite (Cognos Connection, Framework Manager, Report Studio), Adaptive Warehouse, Adaptive Analytics, Cognos SDK, Oracle EBS, SQL server 2005, Windows XP, IIS, Microsoft Visio, Eclipse, Apache, VSS 6.0, Visual Studio .Net 2005, Rational Rose, MS-Office, SharePoint, C#, Core Java, Visual Basic, VBScript and Java Script, Sybase. Company/Client: Mphasis/AIG, AMERICAN

INTERNATIONAL GROUP, INC, NJ, USA Feb 2010 – Dec 2010 Position IT Development Manager

Project CMR System

Project Description CMR FX Calculation is the Project for FX Rate Calculation Update revises the foreign exchange rate calculation in FGEN, which flows to downstream systems and other reporting mechanisms. This change is intended to improve reconciliation processes and comply with FASB financial reporting standards in AIG. This Project has two phases Phase 1 introduces average rates into the foreign exchange calculation and management reporting, Phase 2 addresses foreign currency re-measurement and translation and UEPR calculations in FGEN, EUI and downstream systems.

Responsibilities Managed both onsite and offshore teams to design, development of CMR system.

Resource planning and staffing for both teams.

Responsible for defining the overall project plan and executing it.

Ensuring the documentation to follow AIM Methodology.

Customer interaction and requirement analysis.

Coordination with cross track teams to ensure on-time delivery.

Environment Cognos 8.4 Suite (Cognos Connection, Framework Manager, Report Studio), Cognos SDK, SQL server 2005, Windows XP, IIS, Microsoft Visio, Eclipse, Apache, VSS 6.0.

Company/Client: Mphasis/AIG, AMERICAN

INTERNATIONAL GROUP, INC, NJ, USA Dec 2008 – Jan 2010 Position Project Lead, Onsite Coordinator

Project Global Accounts

Project Description This project is to create necessary reports for GL posting. Responsibilities Managed both onsite and offshore teams to design, development of CMR system.

Gathered the Business Requirements from the end Users.

Acted as liaison between offshore team and business stake holders.

Used Framework Manager to build metadata model,

which could be used by Report Developers in the group.

Modified, Created, published, and modified several packages in Framework manager according to the

business needs.

Developed Standard Templates, which laid a foundation for all reporting needs.

Developed Dashboard Reports, Standard Reports,

Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 8.4.

Creating Query Prompts, calculations, Conditions & Filters for the users.

Scheduling and Distributing Reports through Schedule Management in Cognos Connection

Creating user groups in Cognos Connection from Active Directory groups.

Involved in Documentation for User training.

Worked on Cognos Servers issues

Supported the Cognos Development and Production

environment

Environment Cognos 8.4 Suite (Cognos Connection, Framework Manager, Report Studio), Cognos SDK, SQL server 2005, Windows XP, IIS, Microsoft Visio, Eclipse, Apache, VSS 6.0.

Company/Client: Mphasis/AIG, AMERICAN

INTERNATIONAL GROUP, INC, NJ, USA April 2007 – November 2008

Position Senior Software Engineer, Onsite Coordinator Project Reinsurance Project

Project Description This project is to provide necessary reports for reinsurance depart for their reconciliation and preparing financial statements. Responsibilities Involved in gathering Business Requirements from Business Analysts and Users.

Interacting with Development and Management Teams, providing Technical Assistance to Developers.

Used Framework Manager to build metadata model, which could be used by Report Developers in the group.

Created, published, and modified several packages in Framework manager according to the business needs.

Developed Standard Templates, which laid a foundation for all reporting needs.

Developed Standard Reports, Dashboard Reports, Charts, Drill through Reports, Master Detail Reports, Bursting Reports using Report Studio and Query Studio.

Creating Query Prompts, calculations, Conditions & Filters.

Scheduling and Distributing Reports through Schedule Management in Cognos Connection

Query Optimization, Performance Tuning of reports and model.

Creating user classes and profiles in Cognos Connection.

Testing and improving Report Performance.

Training Users on Query Studio for Ad-Hoc Reporting.

Involved in Documentation for User training.

Maintained the cubes on the series 7 environment

Deployed Cubes and Reports on PowerPlay Enterprise Server and also Published to Upfront.

Implemented security and granted privileges according to user classes using Access Manager (Used LDAP Directory Server).

Environment Cognos ReportNet 1.1, Powerplay Transformer 7.3, Cognos PowerPlay, Access Manager, SQL, PL/SQL, Oracle 9i, SQL Server, Windows 2000, Windows 2003 Server.

Company/Client: Mphasis/AIU, AMERICAN

INTERNATIONAL GROUP, INC, NJ, USA Nov 2006 – Mar 2007 Position Software Engineer

Project Name ScheduleF

Project Description This Schedule F process involves the processing of ceded and assumed reinsurance business data received from the Mainframe - Schedule F system as a continuation. It accumulates data based on Business Functions, allocates financial amounts and prepares a final reporting product for sending it to the DBG Corporate – Schedule F system for further processing and producing the Annual Statement

(Yellow Book) for Statutory Reporting.

Responsibilities Designed, Developed and Implemented an Enterprise Wide Reporting system using Cognos ReportNet.

Installed and configured various components, such as the Framework Manager and Content Manager (Database).

Maintained projects using VSS as the version control mechanism

Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into the Framework Manager

Used Framework Manager to build models, packages and publish packages to the ReportNet Server.

Built models containing query subjects, query items, and namespaces from scratch as well as from imported

metadata.

Created Filters, Calculations, Conditions, Graphs, and Prompts.

Created several List, Crosstab, Chart, Repeater reports using Report Studio.

Developed Prompt Pages and used Conditional Formatting.

Created adhoc reports using Query Studio.

Developed Multidimensional Models in PowerPlay

Transformer and generated Power Cubes for OLAP

comprising of dimensions, hierarchies, levels, categories, and measures.

Created Alternate Drill-Down Path, Special Categories & Currency Conversion set up to better suit different user groups.

Published reports and cubes to Upfront using PowerPlay Enterprise Server (PPES) and Impromptu Web Reports

(IWR).

Implemented security by creating Namespaces and User Classes using Access Manager.

Performed proof-of-concept projects in ReportNet

(Framework Manager, Report Studio, Query Studio, and Cognos Connection).

Tested all the reports with Generated SQL and Manual SQL data.

creating reports based on the developed catalogs. Environment Cognos ReportNet 1.1, Powerplay Transformer 7.3, Cognos PowerPlay, Access Manager, SQL, PL/SQL, Oracle 9i, SQL Server, Windows 2000, Windows 2003 Server.

Company/Client: Mphasis/AIU, AMERICAN

INTERNATIONAL GROUP, INC, NJ, USA May 2006 – Oct 2006 Position Software Engineer

Project VB6.0 to .Net Migration project

Responsibilities Analyzing and developing specification documents for VB6 to

.Net Migration project.

Used Microsoft assessment tool to analyze the effort estimates for this project.

Migrated to required code into .Net 1.1 framework successfully.

Unit tested the applications and documented the results based on the designs.

Co-ordinated with other team members and consolidated the deliverables and created the final build.

Resolved issues resulting from User Acceptance Testing. Environment .NET Framework 2.0, ADO.Net, C#.Net, ASP.Net, IIS, Microsoft Visio, Windows 2003 Server, VSS 6.0, Microsoft Visual Basic 6.0. Company/Client: Mphasis/AIG, AMERICAN

INTERNATIONAL GROUP, INC, NJ, USA June 2005 - Apr 2006 Position .Net Developer

Project IAD – Audit Response Tracking System (IAD – ARTS) Project Description This system helps to track the audit details. The application allows adding and deleting the audit details of different offices at different places. It sends the emails (10 days prior to the last date) to the persons to be informed regarding the audit last date. The audit details can be extracted to the excel sheet. Responsibilities Analyzing and developing specification documents for ScheduleF system as per the requirements.

Developed web pages in ASP.NET and coded the application logic in C# as code behind.

Worked with ADO.NET data objects like Data Set, Data Reader and Data Adapter for retrieval and updating data to SQL Server 2008.

JavaScript for complex validation, navigation,

communication and format customization.

Manage and support internal web development using HTML, CSS and Java scripts.

Co-ordinated with other team members and consolidated the deliverables and created the final build.

Resolved issues resulting from User Acceptance Testing. Environment .NET Framework 2.0, ADO.Net, C#.Net, Microsoft Visio, VSS 6.0.

Contact this candidate