Project Data
Resume:
Chaitanya Mudunuru
Email: *********@**********.***
OBJECTIVE:
Aspiring to master in Architecture and Development of BI Domain by seeking better career opportunities where I can exhibit my professional and technical skills to the zenith.
PROFESSIONAL SUMMARY:
A Professional with 6 Years 7 Months of Experience in Software Industry.Was working with Cognizant Technology Solutions as a Senior Software Engineer from March 2011 to April 2012.Previously worked for Accenture Services and Mahindra-Satyam as a Senior Software Engineer from Oct 2005-March 2011 - joining as a fresher after completing Engineering graduation.Cognos8 Reporting Development and Framework, ETL Tools like Informatica 8 Working on Oracle and SQL Server 2008 Databases.Working as an Application Maintenance and Support Analyst Domains of Banking, Energy, Power Systems and Health SciencesA Cognos10.1 BI certified author.
PROFESSIONAL EXPERIENCE:
PROJECT #1
Key Bank – Application Maintenance and Support
TIME PERIOD
MARCH-2011 TO MARCH-2012
CLIENT
Key Bank
ROLE
Application Maintenance Analyst cum Application Owner
PROJECT DESCRIPTION
Key Bank is the one of Top most banks under Community Banking in US. It has more than 500 Applications being utilized for its banking and information maintenance activities. CTS is the largest vendor for Key Bank in developing, supporting and maintaining these applications for Key Bank. Key Bank-AVM is the project which is mainly responsible for taking ownership of maintaining already built in applications and adding value to the existing applications.
KEY CONTRIBUTION Handling 6 Applications of Key Bank as an Application Owner and working for Enhancements for current existing applications.
RESPONSIBILITIES
As an Application Maintenance Analyst, was responsible forCreating new Framework Packages/Cubes or Modifying existing Packages/cubes as per the business needs of UsersDeveloping analytic, query, report studio reports, dashboards, and scorecards for Business users.Modifying existing report structures/data as per the business requirements of the users.Scheduling reports for the business users.Providing technical guidance to the business users as how to use the tool and technicalities of the reporting environmentPreparing Technical Documentation on the application environment.Identifying and rectifying data related issues with the cooperation from database teamsObserving and Understanding the existing environment and identifying and implementing the enhancements.
PROJECT #2
Pfizer – Global Concur Expenses System
TIME PERIOD
JUNE 1, 2010 TO MARCH -2011
CLIENT
Pfizer Pharmaceuticals
ROLE
Production support Analyst
PROJECT DESCRIPTION
GCE is the internal tool for Pfizer Employees to record / submit their time and expense information. This Online Transaction Processing System also handles the reporting system to update the business users with required data for their analysis.
KEY CONTRIBUTION Worked as a support Analyst for GCE Reporting module supporting users with required report net analytical data extracts and access requests.
RESPONSIBILITIES
As a Production Support Analyst, was responsible forHandling the Access Manager for Dev/QA/production User access requestsCreating adhoc based Scorecards, Dashboards, Summary Detail reports, queries for the business users.Running Daily jobs for the users to receive the requested scheduled reports.
PROJECT #3
GE Energy Commercial Reporting
TIME PERIOD
JANUARY 1, 2010 TO MAY 27, 2010
CLIENT
GE Energy
ROLE
Developer cum Reporting Module Lead
PROJECT DESCRIPTION
The objective of this project is to redevelop the reports related to GE Energy Orders and Sales Data mart related applications, GE Energy Global Metrics related applications that are currently present in Business Objects 6.5 version to Cognos8 Version to incorporate the best features of data analysis, report bursting, report scheduling, user defined scheduling and adhoc reporting. During this process, there are 60 plus reports to be rebuilt in Cognos8 Environment along with Cube build process.
KEY CONTRIBUTION Successfully delivered 40+ reports to the user as 1st release.
RESPONSIBILITIES
As a Reporting Module Lead, was responsible forParticipating in Business requirement analysis, Gathering Functional SpecificationsPreparing Functional Specification Document, Software Requirement Specifications.Participating in Client meetings for finalizing the FSD and SRS documentation.Preparing the High level Design and Low level Designs for reporting environment and each report to be migrated.Developing the Summary Detail Reports/Scorecards/Dashboards/Query/List Reports for the first phase.Involvement in creating java scripts/html scripts for executing the report functionality requirements.Migrating the Reports from DEV to QVParticipating in QA Testing phase and finalizing the production move.Successfully migrated the first phase reports.
PROJECT #4
Knowledge Management Reporting
TIME PERIOD
NOVEMBER 1, 2009 TO MARCH 1, 2010
CLIENT
GE Energy
ROLE
Developer
PROJECT DESCRIPTION
The objective of this project is to provide visibility into the Knowledge Management culture and related behaviors of the GE Energy teams. Today the metrics information is spread across many systems without a comprehensive view. For, this visibility of generating automated reporting structure will enable the business to better understand where to focus Knowledge Management related improvements in people, processes, and technology, ultimately to maximize leverage of information and improve effectiveness of the teams.
KEY CONTRIBUTION Successfully developed, tested and delivered the Reports to the customer.
RESPONSIBILITIES
As a Developer, was responsible forGathering Business Requirements and preparing functional specifications and software requirement specification DocumentsPreparing HDD and LDD DocumentsPreparing Report prototypes and Samples for user understanding.Analysing the source Data and cooperate with data modellers for finalizing the reporting database structure.Working on the ETL mappings to perform data loads into the Reporting Database environment.Validating the data quality and receiving an approval from the business users for database structure and quality.Creating Graph/Scorecard/Dashboard/List reports for the business users.Migrating the Reports from DEV to QA to Production.Handling post production support to the business users.
PROJECT #5
GE Energy GSDW – DQ Analysis
TIME PERIOD
AUGUST 10, 2009 TO DECEMBER 31, 2009
CLIENT
GE Energy
ROLE
Developer
PROJECT DESCRIPTION
The Consolidated Global Sourcing Data warehouse will cover sourcing and related transactions (requisitions, quotes, RFQs, Purchase Orders, Receipts, Delivery, e-auction purchases, quality, key business data) based on the current systems integrated. In order to maintain the high level of Data Quality and availability required for GSDW, the requirement is to develop and execute Long Term data quality monitoring processes and analyze and revise the GSDW Load processes. In addition, a metrics reporting mechanism needs to developed and deployed to update GSDW Project team and Sourcing Leadership about data quality of GSDW data.
KEY CONTRIBUTION Worked on DQ analysis and Integration of ERP Source Systems as First Release and Developed 9 Dashboard reports for the business analysis.Worked on ETL Tools like Informatica and developed Mappings and sessions for the data flow from each ERP system to the consolidated Data base.
RESPONSIBILITIES
As a Developer, was responsible forAnalysing the ERP Source data related to 25+ ERP SystemsAssisting in creating the ETL Mappings to load the the ERP Systems Data into the new DQ table structures available in existing GSDW database.Validating the Data quality and correctness for various ERP sources and updating the results to the client for further Data Quality analysis.Developed 9 dashboard reports that help the business users in their data analysis.
PROJECT #6
Lean RCA Coach - Cognos Reporting
TIME PERIOD
SEPTEMBER 1, 2008 TO AUGUST 10, 2009
CLIENT
GE Energy
ROLE
Developer
PROJECT DESCRIPTION
Lean RCA Coach System is basically a java application through which GE Managers perform the Root Cause Analysis on the GE Energy issues. Each Root Cause Analysis will have a reference ID generated using which they keep track of number of RCAs generated, currently open, any RCAs crossed deadline etc. GE Energy required integrating the java application with Cognos8 to produce 7 daily usage reports to keep track of the RCAs. The main objective of the project is to create the required reports in Cognos8 that will replace the currently used java reports from the system.
KEY CONTRIBUTION Played a key role in understanding the requirements and successfully delivered the best quality reports to the customer. Also completed the Enhancements and Change Requests for the Same Application successfully.
RESPONSIBILITIES
As a Developer, was responsible for Understanding and Analysing the existing Java report prototypes and gathering the Cognos report requirements from the users.Preparing HDD and LDD documents along with the functional specifications.Preparing a Cognos framework Model and generating 12 Report Studio Reports for the users.Creating stored procedures for a data load into the Database.Replacing java report links with cognos report links in the Java application portal.
PROJECT #7
GE Energy Services – EDW
TIME PERIOD
OCTOBER 17, 2005 TO APRIL 28, 2009
CLIENT
GE Energy
ROLE
Administrator/ Module Lead
PROJECT DESCRIPTION
General Electric Energy Services – Enterprise Data warehouse is one of the largest data warehouse projects in the world presently. The objective of the project is to build an Enterprise wide Data warehouse Solution for GEE, which consists of Design, Development, Coding, Testing, Integration, Deployment and Maintenance of the Enterprise Data Warehouse and also to coordinate their various sources of information for better decision-making. The primary objective includes providing enterprise wide data warehousing solutions for top-level executives and to a large number for operational users.
KEY CONTRIBUTION Worked as an Administrator cum Module Lead for BO 6.5 and Cognos8 reporting Modules handling daily activities of a Production Support Environment.Installed and configured couple of BCA servers on virtual Windows environment.
RESPONSIBILITIES
As a Production Support Analyst cum Module Lead, was responsible forMaintaining the Access Manager Requests in BO and Cognos.Regular maintenance of Reporting servers and servicesHandling daily outage of restarting the reporting services as a part of the production environment maintenance activity.Handling scheduler requests for BO and Cognos ReportsConfiguring new scheduler environments in BO.Participating in migration of Report structures from BO to CognosAttending to all possible user requests/issues.Migrating reports, packages, cubes from QA to Production.
EDUCATIONAL QUALIFICATION:
High School: Qualified with 80% (May 1999)Intermediate: Board of Intermediate Education, Andhra Pradesh, IndiaQualified with 87.2% ( JUN 1999- MAY 2001)B. Tech.:College: Sreenidhi Institute of Science and Technology. University: JNTU.Qualified with 64.9% ( JUL 2001 – MAY 2005)
TECHNICAL SKILLS:
Programming Languages: C, C++, VC++, SQL Plus, JAVAOperating Systems: HP Unix, Windows XP/2000, MS-DOSDatabases: Oracle 9i,10g, 11g, SQL Server 2008 R2, SQL Server 2005ETL Tools: Informatica 8Reporting Tools: BO6.5, BOXIR2, COGNOS 8.1 BI, COGNOS 8.4.1 BI, Cognos Framework Manager, Impromptu, Cognos 10.1GUI s: VBOthers: MS-Office, Java (Adv).Domain Knowledge: Data ware Housing – Business Intelligence, Power Systems, Life Sciences, Community BankingCertifications: Cognos8 BI Author, Cognos 10.1 BI Author
PERSONAL INFORMATION:
Name: CHAITANYA MUDUNURUDate of Birth: 15-07-1984Mobile: +1 647 761 5380Alternate Email: *********@**********.*********** Number : F4622879Visa : Canadian Dependent Visa
Contact this candidate