Software Engineer Developer

* * * * *

GOWTHAM RAJ.C.D Ph no: +91-994*******

**, ******* *****, ********** ****, Email: *******.***@*****.*** COIMBATORE – 641029 TAMILNADU INDIA.

SUMMARY OF EXPERIENCE

• 8+ Years of experience in the field of Information Technology as Data warehouse Architect & BI Developer.

• Extensively worked on Oracle PL/SQL coding, Stored Procedures, Functions, Triggers, Packages and Job Scheduling activities, Performance Tuning Techniques.

• Developed and maintained ETL using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server, flat files to the Staging area, EDW and then to the Data Marts.

• Extensively worked on Informatica Designer Components like Source Analyzer, Mapping Designer, and Workflow Manager.

• Hands on experience in working with Reporting tools like IBM Cognos and SAP Business Objects.

• Experience in working with MS-Excel VBA code and using Excel-based VBA to design, analyze, and deploy programs for the Projects

• Experience in monitoring tuning and analyze database performance and allocates resources to achieve optimum database performances.

• Knowledge on Oracle Revenue Management Billing ORMB in healthcare domain.

• Involved in database testing and maintaining the database server.

• Strong experience in client interaction and understanding business application, business data flow and data relations from them.

• Have good communication skills, interpersonal relations, hardworking and result oriented as an individual and in a team.

• Strong initiative, creative and able to learn new technologies and systems. SOFTWARE AND FUNCTIONAL SKILLS

Hardware Basic Computer Hardware and Networking Systems Operating System Microsoft Windows XP, Vista, Windows 7 Programming Languages SQL, PL/SQL, UNIX Shell Scripting Databases & Tools Databases – SQL Server 2005 and 2008, Oracle 9i/10g ETL Tools – Informatica Powercenter

Reporting Tools - Business Objects, IBM COGNOS,

Data Quality Tools – Informatica Data Quality

Test Management Tools –HP ALM/Quality Center

Other Utilities Version Control - Bit Bucket

2 P a g e

EXPERIENCE PROFILE

Senior Software Engineer June 2016 - Present

Cognizant Technology Solutions, Coimbatore

Software Engineer August 2014 - June 2016

Robert BOSCH Engineering & Business Solutions

Software Engineer July 2011 - August 2014

Hexaware Technologies, Chennai

PROJECT DETAILS

Project #1

Title : Revenue Management Billing

Environnement : Oracle 10g, SAP Business Objects

Role : Senior Developer-Lead

Responsibilities include:

• Getting business requirements from Product Owner to understand business needs and after analyzing the requirement discuss possible scenarios and resolving any apparent conflicts. Propose the User Story Point based on the Acceptance Criteria.

• Preparing high level design for Reporting regarding template in case of new report, mapping and process flow.

• End to end report development process design with proper mapping to create classes and objects in the Universe. Create Joins between the classes and check for the Integrity to make sure no Loops are formed. Create derived tables when requires complex calculations and functions in Universe.

• Universe (.UNV)- Business Objects Universe is the semantic layer that resides between an organization’s database and the end user but more importantly, it is a business representation of your data warehouse or transactional database. It allows the user to interact with their data without having to know the complexities of their database or where the data is stored.

• Unit testing of developed report and having it properly documented in UTC (Unit test case) document. Peer code review of developed code and providing code review signoff (Using PLATINUM’s code reviewer).

• Deploying code to Bit bucket and merge code into PROD environment. After migration need to execute PROD validation queries to validate report.

• Preparing CNTRL-M sheet with job execution sequence in PROD and considering proper dependency on Source files and parent job completion. Testing this scheduling in lower environment and after testing implementing it in Production.

3 P a g e

Project #2

Title : ETI Migration

Tool : SQL Server 2012, Oracle 10g

Role : Developer.

Responsibilities include:

• Understanding existing business model and customer requirements.

• Study and analysis of the database provided by the customers and framing the structure of database where the internal data is used as landing zone.

• Creating Schema for the development database by checking the feasibility of the given customer database.

• Oracle PL/SQL code is used to migrate data from the source database.

• Triggers and Audit tables are created in the target database in order to track the changes.

• Oracle functions are used to reduce the line of codes and reusability of some concepts.

• End to end database testing and performance tuning. Project #3

Title : AUSTRALIAN RISK METRICS.

Tools : SQL Server 2012, Informatica & Cognos.

Role : Developer.

Roles and Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.

• Develop the mappings using needed Transformations in Informatica tool according to technical specifications

• Created complex mappings that involved implementation of Business Logic to load data in to staging area.

• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mapping.

• Involved in Oracle XML data extraction using CLOB and BLOB function.

• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

4 P a g e

• Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.

• Created list reports & cross tab reports using cognos 10.1

• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio

EDUCATION / CERTIFICATION

• B.E Electronics and communication engineering, Sri Shakthi Institute of Engineering and Technology, Anna University of Technology, Coimbatore - 8.0 CGPA

Contact this candidate