Resume_Raj Ganesh Subramanian
- 1. Raj Ganesh Subramanian Cell: (513) 800 - 8116 • rajganesh88@gmail.com SUMMARY:  Around 5 years of experience with a strong background in Data warehousing and Database development involving various roles suchas Development, Maintenance and Production Support involving ETLTools, Oracle, SQL Server and Reporting tools.  Extensive experience with Informatica Power Centre 9.1/8.6/8.1/Client tools - Designer, Repository Manager,Workflow manager, WorkflowMonitor,Pro Active Monitor.  Collaborated with stakeholders from many different business units to understand there business needs and the reporting gaps.  Excellentin optimization of transformations within Informatica to provide higher throughput, dynamic partitioning, parameterizationof static values,etc.  Expertise in ITIL Framework such as IncidentManagement, Problem Management, Change Management.  Excellentin developing Advanced Oracle PL/SQL stored procedures,functions,packages, triggers, cursors,and views.  Expertise in preparing and running Mappings, Sessions/tasks, Workflows,Workletsand Batch processes on Informatica server  Expertise in writing UnixShellScriptingfor concatenation of flat files,basic validations, creationof tag filesfor other interfaces, schedulingInformatica workflows.  A team player with an enthusiastic attitude and excellentcapability of leading and guiding offshore teams providing technicalexpertise.  Stress tolerance and efficient in resolving critical issues on time via systematic approach. Provided tier 1 support to Global Business Users  An effective communicator with analytical, relationship managementand business development skills.  Good knowledge in Dimensionalmodeling for creating logical and physical design of database and ER diagrams using data modeling tools like Erwin  Worked extensivelywith complex mappings using differenttransformations like Source Qualifier, Expression, Filter,Joiner,Router,Union, Unconnected/Connected Lookup, Aggregator and Sorter  Expertise in creationof reportsand query tuning for Oracle SQL’s for Reporting tools such as Spotfire,Tableau, and Cognos.  Overview on R Tool, providing g-plot reports to customers with adhoc data extraction from Oracle/SQL Server.  ExcellentCustomer satisfaction with responsible for identifying, analyzing, measuring and managing project risks.  Performed Application upgrades, Performance tuning, ETLtool upgrades, Versionchanges.  Maintaining IT Policies, Procedures,Standards, Guidelines and owner of audit Checklists.
- 2. Education:  Bachelor of Engineering in Computer Science – 2010 Experience:  Technical Lead at IGATE Technologies Inc. since Sep 2010 – Present day Technical Skills: Databases Oracle 12c/11g/10g/9i, SQL Server ETL Informatica 9.5/9.0.1/8.6.1 Oracle SQL*Loader, PL/SQL Developer, Toad Reporting/Analytical Tool Spotfire Languages PLSQL, TSQL,Unix Shell Scripting, DOS/Windows Scripting OS Windows Family, Unix (Sun/HP/IBM/Linux) SchedulingTools Appworx, Unix Script Methodologies Software DevelopmentLife Cycle,Agile methodology, Data warehouse Design (Kimball’s Star & Snowflake Schema) Project Mgt. Tools Incident Management, Change Management, Mentoring Developers, Managing team TicketingTools TSGService Now, ITIL Corporate Service Now Remote Mgt. Tools Remote Desktop Connection,Net meeting Infrastructure Tools Exchange 2k7/2k10,Putty SFTP,VMware Certifications and Awards :  Patni Level 1 Certification in Oracle- SQL or PL/SQL and BI Informatica Technology  Patni Level 2 Certification in BI Informatica Technology.  IBM Certified Cognos 10 BI Author. Fast learner in Cognos.  Six Sigma Green Belt and iEvolve Kaizen Certifications for implementing reusable/innovative ideas.  Pat on the Back Award for outstanding performance in meeting the guidelines for the project SLA and customer requirements within the specified timelines.  Best employer/most popular employer of the Batch during training.  Coursera Certificate (from Stanford University) on Data Mining and Analysis.
- 3. PROFESSIONAL EXPERIENCE Client : GE TRANSPORTATION Sep 2014-Present Location : MELBOURNE,FL Project : UNIFIED TRAIN CONTROL SYSTEM (UTCS) Role : DATA ANALYST Description: UnifiedTrain Control System (UTCS) is a project undertaken for General Electric Transportation, Intelligent Transportation Solutions (GE ITS),USA.UTCS provides a seamless and disaster-hardened transportation managementsystem. It replaces existingequipment with networked, computer-aided dispatching work stations that function with tactical NS information systems. UTCS includes a promising new feature called the movementplanner. Using a virtual model of the NS rail network, the movement planner formulates an optimal, system-focusedtrain management plan with the objective of maximizing on-time performance. Responsibilities:  Document Technical data generated by the UTCS system consistent with engineering policies and procedures  Analyze the data generated from the Norfolk Southern (NS) railroad production system, to extract meaningful information/ reports that can be used to establish performance and quality of the UTCS production system  Participate in technical discussions via meetings involving data architecture, design, development, and troubleshooting of issues or customer raised concerns related to UTCS data  Execute the design, analysis, or evaluation using sound engineering principles and adhering to business standards, practices, procedures, and product / program requirements  Communicate directly with GE Transportation Engineers and NS field support team to provide support for those work products developed  Participate in Agile scrum meetings, sprint planning, and provide constant updates during daily stand up meetings, test case uploading, etc.  Work closely with UTCS cross-functional teams to understand data usage and data analytics requirements  Participate in Customer conference / expectation discussion as indicated / required  Participate in UTCS team status meetings  Participate in weekly schedule status meetings and provide progress percentages  Fix and resolve all issues related to the data quality, data mining, analytics and data reporting Technologies: Tools : Toad, SQL Developer, R Tool, SAS Enterprise Guide, Putty, Spotfire/Tableau, Rally tool (Agile) Languages : Oracle SQL, PL/SQL and UNIX shell scripts Database : Oracle12c/11g, SQL Server
- 4. Client : GE AVIATION Mar 2014-Aug2014 Location : Cincinnati, OH Project : Data Quality Inspector Migration Role : Onsite TeamLead Description: DQI, Data Quality Inspector, a GE framework for the systematic assessment of data to quantify the extentto which it conforms with stated business rules. DQI is a mechanism for producing statistically valid data samples used to facilitate data audits Metadata-driven code generator with integrated cache objects managementand anomaly resolution workflow. The DQI Migration Project specifically concentratesin the removal of dependencyofthe Oracle tool and migration to PLMi (Product Lifecycle Management intelligence),a GE developed custom tool, which provides enhancedsecurity through streamlined JDBCconnections, easier dynamic querybuilding UI, desktop gadgets with one click report generation and much more Responsibilities:  Requirements gathering, documentation of HLD, LLD and sign off from Users.  Define the Project Cost, Timelines involved, technology involved with corresponding resources required from the SoW provided by Customer.  New Architecture design of Application, Interface dependencies, Documentation of technical citation of activities involved.  Managing the team on query developments, fine tuning, performance improvement, etc.  Involved in development of Unix Scripts for Run time Email reports sent to users.  Working with and coordinating with other Interfaces for Data Issues, Functional data flow.  Working with Informatica, DB, Appworx, Unix TSG teams to get the codes migrated and objects validated.  Creation of detailed report definition documents and Mapping design documents.  Creation of Test Cases/Scenariosas per the new design.  Production Cutover Plan with Fail over risks involved, Roll Back plans well documented.  Overall co-ordination of all codes/packages/mappings/modules/chains/Scripts migration to Prod and schedule of the appropriate objects.  Post Production support and validation. Technologies: Tools : Informatica Power Center 9.1, Appworx, Oracle forms, WinSCP, HP Quality Center Languages : Oracle SQL, PL/SQL and UNIX shell scripts Database : Oracle12c/11g
- 5. Client : GE AVIATION Jan 2011-Mar2014 Location : Cincinnati, OH Project : Global Application Maintenance and Support Role : ETL TeamLead/TechnicalOwner Description: Global Application Maintenance and Support (GAMS)project goal is to provide maintenance and support to the Supply Chain Sectionof GE Infrastructure which has numerousapplications within it. Primary objective of this work is to prepare the warehouse to analyze the aircraft engine components that are receivedfrom eachsupplier and to prepare the reports on the parts moving in/out from FTZ (is a zone created by the US government which is outside the US territories but within US Customs territories) which are to be submitted to the US Customs for export/import duties. Responsibilities:  Supporting the application and providing impeccable solutions to make sure the application availability and performance.  Respond to and resolve operational problems 24x7x365support to adhere service level agreements(SLA).  Directinteraction with the clients for understanding the functionality, business logic and requirement.  End to End Activities (testing, deployment, changes) for Informatica Version Upgrade (8.6 to 9.1), Appworx version upgrade and Database Patch updates.  Providing instant solutions for critical business scenarios.  Production job monitoring, Breakfix and permanent fix for redundant issues.  Working with and coordinating the Source Data Team for resolving data issues.  Working with DBAand other TSGteams for Infrastructure upgrades and Outages.  Understanding the functional requirements.  Creation of detailed report definition documents and Mapping design documents.  Developmentof newreport and Informatica Mappings based on functional requirements.  Enhancementin existing reports and Informatica Mappings  Testing the reports and Informatica Jobs.  Producing weekly, monthly and quarterly status reports.  Giving process related training to other team members  Regularly updating senior managers of progress or areas of concern Technologies: Tools : Informatica Power Center 8.6/9.1, Appworx, Cognos, Putty, WinSCP, HP Quality Center Languages : Oracle SQL, PL/SQL and UNIX shell scripts, Mainframe COBOL Files Database : Oracle12c/11g/10g/9i
- 6. Client : IGATE (INTERNAL) Sep 2010-Jan 2011 Location : Mumbai, INDIA Project : iLEARN Role : Oracle and ETLDeveloper/Trainee Description: ILEARN (IGATE Corporate University) is an excellence centeraimedat development of Professional skills through numerous training modules and tests. IGATE has a renowned structure to provide technicalexpertise and all employees undergoa rigorous procedure and hands on for all different tools. Responsibilities:  Responsible for completing in class training for Oracle, ETLtools such as Informatica and Reporting tools such as Cognos, Business Objects.  Responsible to complete the On Class training projects related to ETLand Oracle.  Needto focus on communication skills, professional skills such as Team building, knowledge sharing, etc.  Needto provide consistently higher outputs for real time project assignments.  Responsible to complete Level 1 (L1) certifications for Oracle and Informatica and Level 2 (L2) certification for Advanced Informatica Concepts.  Responsible for on time Timesheetfilling, adhering to work ethics such as Dress code, Policies, Documents,etc. Technologies: Tools : Informatica Power Center 8.6, PL/SQL Developer, Cognos, Business Objects Languages : Oracle SQL, PL/SQL and UNIX shell scripts Database : Oracle10g