| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCAREER OBJECTIVEAccomplished IT Consultant with a Doctorate in Physics and over 30 years ofexperience in Information Technology seeking a challenging careeropportunity where expertise in a wide variety of computer applications,mathematical and analytical skills, technical consulting, data integration,systems design, and ERP's such as PeopleSoft , Oracle Financials, DataWarehousing, Business Intelligence and Oracle Hyperion can be effectivelyapplied to completing projects, full life cycle development, and achievingcompany objectives. Have also worked as a Scrum Master.PROFILE . Over 30 years of IT experience. . 18 years of experience in SQL and PL/SQL Programming and optimizing/fine tuning them. . 14 years of experience in Oracle database tools like SQL loader, import, export, and other database utilities. . 10 years of Dimensional and Relational data modeling experience. . 10 years of Oracle Developer Forms, Reports and Discoverer experience. . 10 years of Oracle Application Server experience. . 2 years of experience in Oracle Data Integrator (ODI), Hyperion Financial Management (HFM), Planning, Essbase, Hyperion Financial Reports, Maxl, Calc scripts and Smartview. . 2 years of experience in PeopleSoft HRMS, People Code, App Designer and SQR reports. . 3 years of experience as Scrum MasterCAREER BACKGROUNDGeneral Motors, Austin, TX May 2014 - Feb 2023Java, Database developer and Scrum Master . Worked in Shadow IT group on GPIM (Global Products Information Method) application. This is utilized to develop standardized work instructions to document vehicle assembly instructions for automobile assembly. The resulting deliverable provides an illustration of the assembly along with the engineered intent usage, assembly work elements and part description. . Worked in CCA group on Mercia Links. This is a cots product that shows current usage of parts and their forecasting. . Worked in GCCX (Global Connected Customer Experience) on CIG (Common Integration Gateway) application. CIG is an integration gateway that exposes web services to different applications. One of the main functions is to manage the mobile devices and their numbers. . Worked in the OnStar group as Java Developer to develop microservices. This was to modernize legacy apps. . Also involved in extracting data from Legacy DB using DataStage. . Worked as a Scrum Master.University of Houston Clearlake; Houston, TXMarch 2014 - May 2014ConsultantData warehousing and building a datamart in a SQL server environment.Creating new reports and modifying existing reports using SQL ServerReporting Services (SSRS).ETCC; Richardson, TXNovember 2013 - January 2014Consultant . Worked on the PANY project to build interfaces for processing transaction data using pl/sql. One of the modules was for maintaining patron account information and the other was for processing violations.Perficient, Inc; Houston, TXAugust 2011 - July 2013Technical Consultant . Worked/built interfaces to load and extract metadata and data using ODI, Oracle SQL and PL/SQL. . Worked on different projects for various clients using Essbase, Planning, and Hyperion Financial Management. . Designed and developed reports using Hyperion FR and SmartView.Key Project Achievements . University of Houston Developed an ASO Essbase application, rules files to build dimensions and attribute dimensions. Used oracle sql and pl/sql to populate the intermediate tables in the data warehouse. Created reports in FR and Smartview. Involved in system integration testing, user acceptance testing, user training sessions and migration of code from development to test instance. . Kinder Morgan Used sql and pl/sql to pull data out of the source system into a temporary staging area. Built interfaces using ODI to load data and metadata to Hyperion Planning and Essbase. Automated the load process and migrated the applications and ODI objects to the test environment. . Fidelity National Finance Built a Hyperion Financial Management application for their statutory reporting. Used sql and pl/sql to pull data from oracle apps to populate temporary tables. Built interfaces in ODI to load and extract data and metadata. Designed and developed reports using FR. Worked with client to perform integration testing and user acceptance testing (UAT). Implemented security and user provisioning. . Internal Project. To demonstrate OFA to customers, installed and configured OFA and OBIEE to set up dashboard for Oracle Financial Analytics. . Christus Health. Supported and maintained Hyperion Financial Management (Ver 11.1.2.1) and other applications used in the monthly closing process. Worked on rules files to import metadata and data. . Riceland. Upgraded Essbase and Planning from version 11.1.1.3 to 11.1.2.1 and Financial Reporting from 9.3.3.to 11.1.2.1 . National Oilwell Varco Developed a C# application for data extraction and load from Hyperion Financial Management to Hyperion Planning and vice versa based upon user provided specifications.CGI; Houston, TX January 2003- August 2011Senior Consultant . Design and extracted data from Apps 11i for building OLAP cubes for detailed trending analysis, data mining and budgeting of sales and cost data using Hyperion Essbase and reporting tools. . In the role of an architect have done, data modeling, designing and implementation of Fabnet portal based on Oracle Application Server 10g. . Performed analysis, design, architecture, data modeling, writing technical & functional specifications, test cases and testing in Data Warehousing and Business Intelligence. . As a part of the data warehouse/datamart data load (ETL) have written complex Oracle PL/SQL procedures, functions, and database triggers to load data from Oracle Apps. Optimizing sql, pl/sql and other applications. . Have done a lot of optimizations of SQL, PL/SQL, and other applications. . Usage of Oracle backend tools like SQL loader, import, export, and other database utilities. . Worked on PeopleSoft (Payroll, Human Resources, and Benefits) in a techno/functional role. Experience includes responsibility for analysis, detail design, coding, developing application test plans, user acceptance testing and system functions from technical and functional perspectives. Specialties also include customizations to PeopleSoft products that fit enterprise requirements while maintaining the integrity of the delivered functionality of PeopleSoft. Support and maintenance of PeopleSoft. Maintained/Built reports using SQR. . Created new reports/interfaces as per specifications. Implemented changes to existing customizations, reports and adding in new customizations. Involved in the implementation of security and applying Tax Updates/Bundles. . Worked on various PeopleSoft projects like Code of Conduct, Pension Path, Etime and Applicant Tracking System. As a member of the PeopleSoft upgrade team from 8.9 to 9.1, involved in analyzing customizations and applying changes to the customizations and implementation of security. Customized MSS (over 800) as per user requirements.Air Liquide; Houston, TXOctober 2001 - January 2003Senior Data Warehouse/DSS Analyst . Performed detail analysis, designing, architecture, technical and functional specifications, test cases, and unit testing for Business Intelligence and Oracle Portals. . Designed and migrated the sales portal to 9IAS as well as building data marts for varying business units. . Performed analysis, design, architecture, data modeling, writing technical & functional specifications, test cases and testing in Data Warehousing and Business Intelligence. . Written complex PL/SQL procedures, functions, and database triggers to load data into datamarts. . Have done lot of fine tuning of SQL and PL/SQL and also the usage of Oracle backend tools.Rapidigm; Houston, TXNovember 2000 - October 2001Consultant for Air Liquide . Web portal development and maintenance, using Oracle Webdb and Oracle 9IAS. Design, development and support of the Data Warehouse and data marts. Development and support of Oracle Reports, Forms, and discoverer. . Have written complex pl/sql packages as a part of the portal development.Admiral Computing; Victoria, AustraliaJuly 2000 - November 2000Programmer/Analyst . Designed and developed an in-house web-based application using Java and HTML. . Maintained and developed reports using Oracle reports designer for a client. . Wrote stored procedures, functions and packages in the Oracle database. . Maintained Oracle development and test instances for an ongoing project.Praxa; Victoria, Australia September 1997 - June 2000Programmer/Analyst . Analyzed project/client functionality, data modeling, project standards, and liaison with the client on project requirements, writing test specifications and unit testing. . Delivered highly complex forms as per specifications using Designer and Developer 2000. Was a technical mentor for team members. . Enhanced and developed Oracle Packages, procedures, and functions for data extraction from Oracle databases, writing test specifications and testing unit modules. . Developed modules using Visual Basic and created stored procedures, functions, and packages on a SQL Server database. . Maintained the admissions application software built by Praxa. . Developed and tested a backup strategy for Oracle Databases. . In house Projects - Installing Oracle Databases, Developer Server, Application Server, and Oracle WebDB on NT Servers and fine-tuning oracle databases. Created test Intranet web site using Oracle WebDB.Infomatics; Bombay, India June 1996 -June 1997Programmer . Worked on a project for the Indian Army (Army Group Insurance), which involved creating Oracle forms, reports and writing test specifications.SKILLS/TECHNICAL SPECIALIZATION . SQL, PL/SQL, SQL Loader, Import, Export and other Oracle database utilities. . Oracle Developer Forms Reports and Designer. . Oracle databases 11g/10g/9i/8i/7 . Optimizing and fine tuning of sql, pl/sql and other Oracle applications. . Oracle Application Server. . PeopleSoft HRMS, People Code and Tools, App Designer and SQR . Hyperion Financial Management, Planning, Essbase, Calc Scripts, Hyperion Financial Reports and Smartview. . Oracle Data Integrator (ODI) . IBM DataStage . Oracle Financial Analytics (OFA) . Oracle Business Intelligence Enterprise Edition (OBIEE) and Crystal Reports. . SQL Server and Visual basic. . Java and Spring boot. . SSRS (SQL Server Reporting Services) . HTML, JavaScript, Java, C++, Remedy, PVCS, Kintana and PrimaveraEDUCATION . PhD, Physics (Magnetic Resonance); Indian Institute of Technology, Bombay, India . Master of Science, Physics (Electronics); Indian Institute of Science, Bombay, India . Bachelor of Science, Physics (Physics and Math); CHM College, Bombay, India |
