I am a motivated and results-focused Data and Software Architect with more than 12 years of success driving complex full life cycle IT projects. Throughout my career, I've gained significant experience in data analysis and software architecture, and real-time application/software product design, development, implementation, and maintenance. I can offer a combination of project management, team leadership, and troubleshooting skills. I've been recognized for my ability to oversee onsite coordination, gathering requirements from clients through excellent interpersonal and communication skills. I also utilize Agile and Waterfall processes to deliver projects on time and within budget.
Some of my technical proficiencies include:
Google BigQuery (Cloud), HP Vertica, Cassandra, Apache Hadoop & Spark, Oracle 6i/ 9i/ 10g/ 11g, Teradata, MS SQL Server, My SQL, Postgres SQL, Sybase, HTML, Java, JavaScript, JSP, Node.js RE, npm, JSON, SQL*Plus, SQL Developer & Data Modeler, Power Designer, Oracle Forms 10g, HPQC, Autosys Job Scheduler and Remedy 7.0, VMware vSphere 5.5, Oracle BI EE 10g/11g (OBIEE) with Weblogic, Oracle BI Publisher, R Analytics, SSIS, SSRS, Pentaho BI & Jaspersoft BI, Tkprof, HP Performance Center, and Apache JMeter 2.13.
Software Engineer @ Architect the solution containing ETL, Business Intelligence platform with Data Warehouse & DataMart for historical analytic reports.
Estimated project, created technical designs, and collaborated with team to create detailed design and development to build the API DW & DM on SQL Server with the transactional system in Oracle.
Developed the SQL, PL/SQL, T-SQL, ETL and Reports using Oracle, SQL Server, SSIS & SSRS. From October 2015 to Present (3 months) Software Engineer @ Collaborate with team to architect a product suite containing Business Intelligence platform and Data Warehouse infrastructure for historical analytic reports.
Key Project:
Avaya Aura Performance Center 7.1, 7.1.1 & NextGen Aura Performance Center
Methods/Tools: Oracle BI Repository & Dashboard 11.1.1.6.12, Tableau, T-SQL, PL/SQL, WLST scripts, J2EE, HTML, JavaScript, R Analytics & Studio, LDAP, SQL Loader & Developer, MS SQL Server, MySQL, UNIX Scripts, BigQuery REST API and Analytics, HP Vertica, Cassandra, Apache Spark & JMeter, Linux, Google Cloud VM & VMWare vSphere
Estimated project, supervised assignments, created technical designs, and collaborated with team to create detailed design and development to productize OBIEE 11.1.1.6.12 install on clustered environment.
Automated the installation process and developed the core services for turnkey system using C++.
Designed Star Schema Data Model for Contact Flow Analytics and Contact Analyzer.
Designed and developed repository for Contact Flow Analytics, Contact Analyzer, and Experience Portal.
Architected dashboards and reports to improve user experience in new release.
Developed JavaScripts to update the web interface through CSS file for AAPC 7.1.
Designed and developed visualization reports and application to run user ad hoc requests on EMC transactional data stored in MS SQL Server and historical with Cassandra.
Designed the de-normalized flat schema ETL for Google Cloud platform and provided performance benchmark by testing solution with Apache JMeter and redesigning the front-end application reports.
Designed the CMS reporting scalable solution using Hadoop with front-end reporting using Tableau. From October 2012 to September 2015 (3 years) Programmer Analyst @ Worked with team to gather requirements, create technical and detail designs, and develop, implement, and support various projects. Wrote scripts to maintain servers and services running for OBI application. Designed and developed BI Repository and Dashboard. Reviewed script design and development and authorized implementation. Designed and developed ETL jobs to migrate production data from Teradata to SQL Server database. Desinged the BigData solution for Merchandise data with Hadoop using MapReduce features.
Key Projects:
Automation Scripts & Usage Tracking
Methods/Tools: UNIX, Perl, SQL
Designed, developed, and implemented automation scripts to monitor Oracle BI services.
Tracked server usage by gathering and storing it in SQL server database.
Designed and developed the BI Usage tracking reports.
Improved performance of jobs and reports by measuring performance through HP Performance Center.
Merchandising Data & Global KPI
Methods/Tools: Teradata, HTML, JavaScript, Java, Hadoop, Hive, Tableau, Datastage 8.1
Transferred sales, inventory, on-hand store stock, inventory in transit, and other information from Teradata to SQL Server database to provide more accurate Buyer and Department Morning Reports.
Estimated, designed and developed BigData solution with Hadoop to store and process the merchandise data, satisfy the ad-hoc requests through MapReduce jobs and also architected the front-end BI solution using Tableau.
Item File Publication Sync Reports
Methods/Tools: OBIEE, Oracle BI Repository & Dashboard
Built analytics for use by internal Walmart and Sams clientele to identify supplier and compare item adoption percentage to Walmart standards to inform decision-making with suppliers and forecast supplies. From May 2011 to October 2012 (1 year 6 months) Analysis Programmer @ Methods/Tools: Oracle, PL/SQL, C, Pro *C, HP-UNIX/Linux, Oracle Forms 10g, OBIEE, MS SQL Server, UNIX Shell Script
Gathered requirements, technical and detail design and streamlined version control system process.
Wrote UNIX scripts to ftp sales and order files from legacy system to JMS and boost oracle jobs to process the sales and purchase orders; troubleshot existing UNIX scripts to reduce failures.
Developed analytic solution to track history and compile metrics like reason for low sales during markdowns.
Developed T-SQL, PL/SQL Triggers, stored procedures, functions, packages, and forms. Created patch process scripts and streamlined SDLC process. From March 2011 to April 2011 (2 months) Columbus, Ohio AreaProgrammer Analyst @ Methods/Tools: C, Pro*C, PL/SQL, JavaScript, JSP, HP-UNIX/Linux, Oracle Forms 6i & 10g, OBIEE 10g, Unix Shell Script
Designed front-end application and reports for sales audits. Collaborated with team to estimate projects and assignments, create technical and detailed designs, and develop and deliver several projects for the Retek base product in replenishment, promotion, and factory details including:
R3Project, a price conflict identifier that identifies conflicts in item prices against promotions.
Country of Origin, which connects a supplier’s factory as part of the item-supp-country relationship and allows users to chose the supplier factory from which they want to purchase their inventory.
Merch Reports, for which OBIEE reports that analyzed sales, inventory, transfers, sales vs. promotion, and purchase order history were developed.
10g Upgrade, developed RMS environment and upgraded RMS 9.0 to the Oracle 10g product suite. From September 2010 to February 2011 (6 months) Charlotte, North Carolina AreaApplication Engineer @ Worked on Retail Product development (ORMS & OReSA) team to maintain system functionality for key retailing functions including item maintenance, purchasing and receiving, inventory management, and pricing and promotion management. Created functionality for retailers to run businesses effectively, efficiently and at higher profits.
Key Projects:
ORMS 12.0 Supervalu | ORMS & OReSA 13.1 | ORMS & OReSA 13.0.2 | ORMS 13.0 | ORMS & OReSA 12.0.5
Methods/Tools: C, Pro*C, PL/SQL, JavaScript, JSP, HP-UNIX/Linux, Oracle Forms 6i & 10g, OBIEE 10g, Unix Shell Script, XML BI Publisher, ODI ELT, TKPROF, SQL Developer
Collaborated on requirement gathering, technical design, detailed design, and development.
Wrote merge statements to carry out all validations to create and approve items.
Improved performance of item creation process using TKPROF to check explain plan and each query cost.
Prepared UNIX scripts to streamline version control; modified transaction maintenance screens.
Developed T-SQL, PL/SQL Triggers, stored procedures, functions, and packages.
Wrote new batch programs using C, Unix Scripts & Pro *C to improve functionality of customer orders and layaway.
Used SQL Developer Data Modeler to prepare project data models
Introduced web portal in POS 13.1 & SIM 13.1 for customer order inventory reservations and introduced new batch programs in Pro*C.
Developed new screens for transaction maintenance and to direct transactions between ORMS, OReSA, and PeopleSoft financials backward and forward.
Wrote scripts, modified financial batch programs, prepared project data model, developed financial reports, and improved performance of ReSA batch process.
Wrote and modified batch programs and forms to improve wholesale and franchise functionality.
Encrypted and decrypted RTLOG and modified ReSA and RMS batch programs to increase functionality. From October 2005 to September 2010 (5 years) Associate Consultant @ Collaborated with team to support Decentralization of Operations and Global Support (DOGS) app for Salomon Smith Barney’s international settlement and clearance system.
Project: Decentralization of Operations and Global Support
Methods/Tools: C, UNIX Shell Scripting, Sun Solaris 5.8, SYBASE, AUTOSYS Job scheduler
Wrote stored procedures, function, and triggers; created jobs to run batch programs.
Fixed bugs, incorporated enhancements, and tested applications; resolved user-identified technical issues. From May 2004 to September 2005 (1 year 5 months) Programmer @ Worked with team to develop an innovative secure payment collection system application.
Developed socket programs with domain INET and used BITWISE operators to send and receive packets in the GPRS network; maintained scheduled enhancements and coordinated new releases.
SmartWin Online Lottery (Best & Co., Chennai, India)
Team Size: 6 | Methods/Tools: C, Pro *C, PL/SQL, Oracle 9i, Linux,
Collaborated on a team to create client-server architecture-based application that was the first to use mobile General Packet Radio Services (GPRS) and worked on scheduled enhancements and new releases.
Utilized Tuxedo 6.5 architecture to ensure proper processing of requests and responses.
Terminal Management System (Best & Co., Chennai, India)
Team Size: 4 | Methods/Tools: QT Designer 3.1, C++, MYSQL, Linux
Developed application and worked on scheduled enhancements and new releases. From December 2002 to May 2004 (1 year 6 months)
M.C.A, Computer Science @ Bharathidasan University From 2000 to 2003 B.Sc, Electronics @ Bharathidasan University From 1997 to 2000 Arunprasad Rengasamy is skilled in: Oracle, PL/SQL, SQL, Requirements Analysis, Unix, SOA, Shell Scripting, Pro*C, Java, Solution Architecture, Software Project Management, Oracle Applications, Agile Methodologies, Unix Shell Scripting, Weblogic