Candidates About

 

      Sreenivasa Reddy                       

Mr. Sreenivasa Reddy has more than 11 years of broad-based IT experience. His capabilities include project management, software application development in data warehouse projects using business intelligence tools like Informatica, GreenPlum, PostgreSQL, Cognos, and Tableau. Sreenivasa Reddy has extensive knowledge of large-scale data analysis using numerous databases on multiple platforms. He has been a lead developer, Project Leader and Project Manager on several highly complex projects with short deadlines in Supply Chain, Manufacturing and Insurance domain.

ü  Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.

ü  Strong Data Warehousing ETL experience of using Informatica 7.x/8.x/9.x Power Center Client tools - Mapping Designer, Workflow Manager/Monitor and Repository manager.

ü  Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

ü  Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling

ü  Expertise in working with relational databases such as Oracle 11g/10g, SQL Server and DB2.

ü  Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica ETL tool on Oracle, GreenPlum, DB2, Flat Files and SQL Server Databases.

ü  Extensively worked on PostgreSQL functions Development & Testing on GreenPlum

ü  Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.

ü  Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

ü  Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

ü  Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

ü  Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

ü  Experience in using Automation Scheduling tools like Appworx and Control-M.

ü  Worked extensively with slowly changing dimensions.

ü  Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

ü  Excellent interpersonal and communication skills and experienced in working with Functional people, business people and developers across multiple disciplines.

Project Profile

Project Name	Treasury Data Lake
Client	GE Treasury
Role	Onsite Project Lead
Organization	Tech Mahindra
Duration	Sep-2016 to Till Date
Software’s	Database: GreenPlum, PostgreSQL Tools: Informatica 10.x, UNIX, Appworx, Putty, Denedo, Spotfire, PGAdmin, Aginity, Udeploy, Jenkins & Rally

 

Project Description

            Treasury Data Lake is an EDW build on GreenPlum database with PostgreSQL. It has multiple layers like ingestion layer, integration layer and distribution layer to integrate with multiple source systems like Atom, MDM, Cash, 3PD, Bony Collateral & WSS. This project developed on Agile methodology on Devops model

 

Contribution

As an Onsite Project Lead, was responsible for

ü  Requirement gathering and work with business owner on data dictionary as per the current business requirement

ü  Create source contract view in GreenPlum in Ingestion layer/Mirror Layer

ü  Design the data model for each source system

ü  Prepare the Data Mapping Sheet (DMS) to create PostgreSQL functions

ü  Develop the PostgreSQL and testing

ü  Data Loading from Mirror layer to Integration layer using PostgreSQL functions as per DMS

ü  Create Distribution layer and load the data as per reporting requirement

ü  Creation test case documents

ü  Worked on Unit Testing, Integration Testing and Functional testing.

ü  Promote the code to QA and production using Udeploy

ü  Post production support and monitoring the jobs

 

 

 

 

 

 

Project Name	Treasury EDW
Client	GE Treasury
Role	Onsite Project Lead
Organization	Tech Mahindra
Duration	April-2015 – Sep-2016
Software’s	Database: Oracle 11i Tools: Informatica 9.x/10.x, UNIX, Appworx, Putty, COGNOS & Rally

 

Project Description

The GE Treasury EDW is built with multiple layer like Source, Stage, Integration layer, Enterprise layer and distribution layer. It involved multiple source systems like ATOM, VALUT, TPD, MDM, WSS, BONY, SUMMIT etc. It maintains Financial data like Trades, LE, ME, Counterparties, Instruments, Product, cashflows for long term/short term bonds, Investments, Loans, GL etc to support the daily, weekly, Monthly Quarterly, Yearly reporting needs for top level management analysis to take appropriate decision making. This project will eliminate the manual process of capturing data and high availability of system

Contribution                                                                                                              

As an Onsite Project Lead, was responsible for

         

ü  Developed and execute this project on agile methodology

ü  Understanding business requirement and requirement gathering as per the business need and provide best solution as per dataware house methodology like Top-down approach

ü  Involved in design the data model

ü  Developed High level & low level design documents

ü  Developed complex Informatica mappings to implement the business logic as per HLD’s & LLD’s.

ü  Created Tables, Views, Indexes, and SQL Scripts to load the data into the tables in the Development environment.

ü  Enhancements and maintenance of application

ü  Fixing the Data quality issues

ü  Creating UNIX Shell Scripts

ü  Creating the Appworx jobs and maintenance

ü  Involved in Integration testing & UAT.

ü  Project monitoring & interaction with client and users.

ü  Creating Worklets & workflows

ü  Involved in Performance Tuning

ü  Production Support & bug Fixings

ü  Involved in Efforts estimation & defense proposal for RFP’s

Project Name	Supplier Collaboration Portal
Client	GE Transportation
Role	Onsite Project Lead
Organization	Tech Mahindra
Duration	June-2013 – March 2015
Software’s	Database: Oracle 11i, Tools: Informatica 9.x, UNIX, Appworx & Putty

Project Description

GE Transportation is a global technology leader and supplier to the railroad, mining, marine, stationary power, drilling and energy storage industries. At GE Transportation, connectivity is the cornerstone of our innovative technology that helps our customers solves their toughest challenges. GE Transportation deliver breakthrough efficiencies through our brilliant, connected machines; use advanced manufacturing techniques that bring our innovative concepts to life more efficiently and cost-effectively, and deliver on our promise of speed to move them faster to market.

  This project is built to integrate multiple sources like ORACLE, CAS & JDE and build centralized Data ware house to support supplier demand, Purchase Orders, Shipments and builds scorecard.

Contribution                                                                                                              

As an Onsite Project Lead, was responsible for

ü  Extensively played an active role in business and functionality of the system, understanding source systems and requirement analysis and provide the solution to the business users as per the requirement.

ü  Developed complex Informatica mappings to implement the business logic.

ü  Created Tables, Views, Indexes, and SQL Scripts to load the data into the tables in the Development environment.

ü  Enhancements and maintenance of application

ü  Creating UNIX Shell Scripts

ü  Creating the Appworx jobs

ü  Involved in Integration testing & UAT.

ü  Project monitoring & interaction with client and users.

ü  Creating Worklets & workflows

ü  Fixing the Data quality issues

ü  Involved in Performance Tuning

ü  Production Support & bug Fixings

ü  Involved in Efforts estimation & defense proposal for RFP’s

 

Project Name	CIA Reporting
Client	GE Corporate
Role	Onsite Coordinator
Organization	Tech Mahindra
Duration	Apr 2013 – May 2013
Software’s	Database : Oracle 10g Tools : Informatica 9.x ,Putty & UNIX

Project Description

  The GE Corporate implementing a solution to effectively manage the invoicing Information for the long-term future consequently, the new Integration of CIA will receive the invoice information and it will process the as per the applicable business rules and will posted to DXL external system for further process

Contribution

As an Onsite Coordinator, was responsible for

 

ü  Extensively played an active role in business and functionality of the system, understanding source systems and requirement analysis and provide the solution to the business users as per the requirement.

ü  Developed complex Informatica mappings to implement the business logic.

ü  Created Tables, Views, Indexes, and SQL Scripts to load the data into the tables in the Development environment.

ü  Enhancements and maintenance of ODM

ü  Fixing the Data quality issues

ü  Involved in Integration testing & UAT.

ü  Shell Scripts creation in UNIX.

ü  Project monitoring & interaction with client and users.

 

 

Project Name	Commercial Reporting
Client	GE Energy
Role	Project Lead
Organization	Tech Mahindra
Duration	Jan-2012 – Mar-2013
Software’s	Database : Oracle 10g Tools : Informatica 9x, Cognos & UNIX

Project Description

  The GE Energy Business is implementing a Data ware Housing solution to effectively manage the Orders & Sales business Information for the long-term future consequently, the new Integration of ODM Data Warehouse automated the process to load the data in the ODM Data warehouse using informatica and create a report as per the business need using COGNOS

 

 

Contribution

As a project Lead, was responsible for

 

ü  Extensively played an active role in business and functionality of the system, understanding source systems and requirement analysis and provide the solution to the business users.

ü  Developed complex Informatica mappings to implement the business logic.

ü  Created Tables, Views, Indexes, and SQL Scripts to load the data into the tables in the Development environment.

ü  Enhancements and maintenance of ODM

ü  Fixing the Data quality issues

ü  Involved in Integration testing & UAT.

ü  Shell Scripts creation in UNIX.

ü  Project monitoring & interaction with client and users.

 

 

Project Name	PGS Finance Needs(EMIS)
Client	GE Energy
Role	Team Lead
Organization	Tech Mahindra
Duration	Aug-2011 – May 2012
Software’s	Database : Oracle 10g Tools : Informatica 9x, UNIX, Putty & Cognos

Project Description

  The GE Energy Business is implementing a Data ware Housing solution to effectively manage the Power Generation Services Business for the long-term future.  Today PGS Business operates in 50 locations across 5 countries.

  Consequently, the new EMISDWH Data Warehouse must be prepared to accommodate and manage the new SAP source data where required for Reporting. EMISDWH data warehouse use multiple Source systems, such as EMIS & CIP. More than 150+ Informatica mappings and 15+ Cognos reports need to be built on EMISDWH, scheduled and emailed to users, whenever required. Additional solution output would also include the ability to export report data into PDF, Excel, and CSV etc.

Contribution

As a Team Lead, was responsible for

 

ü  Extensively played an active role in business and functionality of the system, understanding source systems and requirement analysis.

ü  Designing and making changes to the Data model of EMIS DWH.

ü  Developed complex Informatica mappings to implement the business logic.

ü  Created Tables, Views, Indexes, and SQL Scripts to load the data into the tables in the Development environment.

ü  Performance Tuning of queries with thorough analysis of DB.

ü  Involved in the Estimation & Costing.

ü  Involved in creation of Technical & Functional Design documents.

ü  Involved in Integration testing & UAT.

ü  Shell Scripts creation in UNIX

ü  Project monitoring & interaction with client and users.

 

Project Name	ES Marvel
Client	GE Energy
Role	Team Lead
Organization	Tech Mahindra
Duration	Mar-2011 – Jul-2011
Software’s	Database : Oracle 10g Tools : Informatica 8x, Cognos, Business Objects, Putty & UNIX

 

Project Description

  The GE Energy Business is implementing a Data ware Housing solution to effectively manage the Orders & Sales business Information for the long-term future Consequently, the new Integration of ODM Data Warehouse automated the process the distribute the files across multiple systems to transferring the files from ODM to multiple location using SFTP .

Contribution

As a Team Lead, was responsible for

 

ü  Extensively played an active role in business and functionality of the system, understanding source systems and requirement analysis.

ü  Developed complex Informatica mappings to implement the business logic.

ü  Created Tables, Views, Indexes, and SQL Scripts to load the data into the tables in the Development environment.

ü  Involved in Integration testing & UAT.

ü  Shell Scripts creation in UNIX.

ü  Project monitoring & interaction with client and users.