INDRESH PADMONKAR US Citizen

Morrisville, NC – **560 H – 919-***-****, C – 919-***-**** ac2fpn@r.postjobfree.com Experienced in computing applications in diverse industries. Skilled in resolving complex problems, worked effectively with executives, managers, end users, technical and non-technical individuals, anticipating and addressing potential issues and opportunities. I have mastery in multiple technologies/computer languages, with a history of expanding technical skills through education, peer-peer training and experience. Work well, both independently and in a team environment. Core competencies:

Big Data/Hadoop Hive/HBase/Oracle Architect(Data/App)

SQL, Scala, Java, Spark Data Analysis, ETL, BI Team Lead

Sqoop Agile, DevOps Data Governance/Security Professional Experience

TEK Systems, Client - IBM Watson Health Durham, RTP, NC Sodtware Engineer, Big Data platform Oct 2016 – Till date Design and development of healthcare data processing system based in data-lake (bigdata platform). Created hive SQLs, Java and JavaScript programs for data transformation. Did analysis and design of system to handle separate load instances for different customers. Created logical and physical data models. Created ETL flow to transform and move data from raw to custom region of data lake using Pentaho tools. Also, created system with hive queries to handle avro tables with nested arrays to feed to analytics systems, prepared data and written programs to invoke different analytics REST- APIs. Created offboard system to export data from lake to Oracle data mart. Worked with test engineers to create automated system testing. Worked in scrum team, followed SAF -agile process. Tools: Hortonworks Hadoop, Pentaho, hive, hdfs, Sqoop, JavaScript, Hue, Oracle, Java, regular expression, SQL, hiveQL, Git, mercurial, AVRO/csv files, Jenkins

Cisco Systems Inc. Morrisville, RTP, NC

Engineer/Analyst, Big Data platform Jul 2012 - Sep 2016 From last 4+ years worked on big data platform. Completed design and development of systems to inject data from files/ Oracle/MSSQL dbs to Hadoop file system or hive or hbase database. Improved performance and scalability of applications by using MapR Hadoop technology. Also, have done the architecture of data storage in hadoop and data modeling. Involved in analysis and testing activities during upgrades and development. Proof of concept of different tools (flume, Oozie, Spark..) adoption to the company environment. Reduced cost by merging processing and systems. Created few analysis and design documents to add new features to the existing and new products. Automated some existing process. Led a team of onsite and offshore engineers to create a new data movement architecture. Worked as data analyst/scientist for multiple applications. Data enrichment and de-normalization process creation to feed into Analytics tools of different domains. Created the process of data on boarding to Hadoop development. Data security and data governance consideration as per the company needs. Used SQLs extensively for data analysis. Expertize/used Cisco data like service request, contract, install base, network collector and defect. Maintain applications created by different teams using PDI, Spark and Scala. I have basic knowledge of flume, Kafka, OpenStack tools, Oozie, Cisco TES Tools – MapR-Hadoop, hive(server1/2), SQL, HiveQL, Java, sqoop, HBase, MapR Tables, Pentaho tools, Agile Methodology(Rally), MSSQL/Oracle, continuous integration, TOAD, PL/SQL, Maven, JIRA, Rally, VISIO, Rundeck, Hue, Scala, Spark, Eclipse, Json, XML file formats, Impala NTT Data (Keane Inc.) Morrisville, RTP, NC

Consultant, Cisco Systems, Inc. Jul 2006 – Jul 2012 I have successfully completed multiple roles in 10 projects of different size. Each project had multiple groups located across the globe. The cost of projects was between 250k to 2.5 million. I was core member in 3 Projects. Completed many tasks successfully, including interaction with user groups, logical/physical architecture, Project Management, design, development and implementation. I am Involved in making critical decisions and crisis management as needed.

Tools: SQL, TOAD, PL/SQL, Oracle 9i database, forms and reports, Oracle Apps – EBS(contracts, service requests, return materials), Maven, JIRA, Rally, Agile Methodology, Microsoft Project, VISIO, Oracle Designer 9i, Toad Data Modeler, Data Flux, SAS, Denodo, Java, Unix Scripting, Manufacturing Domain INDRESH PADMONKAR Page 2

Global Information Systems Inc. Tallahassee, FL

Department Of Health, State Of Florida, Applications Development Analyst Apr 2006 – Jul 2006 I Worked as Data Architect/Analyst to resolve data integrity issues in data mart and operational databases. It includes working with customers and different IT teams to get data samples and involve in data analyzes. Also created a process for data cleansing and data scrubbing. Create and maintain reports to help data mining. I helped DBA team to configure oracle tools and home grown application.

Tools: SQL, PL/SQL, Oracle Database 10g, Oracle report Writer 9i, Oracle Forms 9i, Oracle App. Server 9i. The Hartford Financial Services Group Hartford, CT Application development Consultant Nov 2003- Mar 2006 Managed with hands on, many projects of different size for underwriting, accounting and invoicing divisions of commercial lines insurance (using Data Warehouse / Read-only databases). Accountabilities include:

High level and low level architecture of the applications. Customer interaction, logical, physical data modeling using Erwin, production support to 1.5 Terabyte database, maintained back end batch jobs, handled change requests, developed programs. Maintained transaction system used to create invoicing.

Done programming for data cleansing and ETL work to different source data, Business Intelligence functions to identify accounts existence and help cross-sell products, created modules and integrated with main application, performed tuning of applications and queries, and did impact Analysis of application tools upgrade Tools: pl/sql, Oracle Database, Reports on Windows, Citrix, SQL Navigator, Erwin, PVCS (for version control), SOX documentation, ITG for documentation.

CONNECTICUT MEDICAL INSURANCE COMPANY Glastonbury, CT Architect/Analyst Designer Jul 2002– Oct 2003

Key member of IT team that handled many projects for Underwriting, Claims and Billing divisions:

Done physical and logical architecture of insurance applications, physical data modeling, as per customer requirement designed programs for data cleansing and data scrubbing in Data Warehouse/Transactional data bases, played a key role in upgrades of application tools and database, developed new modules using forms/reports/pl/sql stored procedures, and conducted performance tuning of application and queries. Tools: Visio, Erwin, sql loader, pl/sql, Oracle Database, Oracle Developer, Forms, Reports on Unix (Sun Solaris), Toad, Crystal reports, ASP, Enterprise Manager, Informatica, Java script, Java, Servlet/JSP. RENSSELEAR AT HARTFORD (RPI) Hartford, CT

Research Assistant Jan 02 – Jul 02

As Project/Team Leader, designed and developed an application that served a user interface to a legacy application using FORTRAN, C and UNIX scripts. Responsibilities included requirements gathering, use cases design, high-level application design, class design, and screen design.

Developed application using JAVA, servlets, JSP, JavaBeans, html, Unix shell script.

Designed test cases and implemented the application. Tools: Jdk1.3, Java Swing, Oracle Database, UNIX, Tomcat, Java servlet, JSP, JDBC. United Technologies Corporation, Senior Consultant, CT

(consulting company - DHARMA SYSTEMS) 1997 – 2001

Hamilton Sundstrand (A Division of UTC) Windsor Locks, CT Project: Bill of Materials System Jun 01 – Dec 01, Sep 99 – Apr 00 Served as Architect/ Design Analyst, designing applications with in the frame work of the corporation, production support to Engineering application that maintained data related to company’s products and drawings. The very large database has Read-only/Transactional schemas. Front end was a combination of Java forms and Oracle forms, reports.

Project: HR–Training Data Management (Internet Application) May 00 – May 01 As Analyst/Developer/Tester on team, automated process for on-line training registration, approval, and communication. Created database of courses taken/completed by employees. System, originally developed for Hamilton Sundstrand, was subsequently adapted for use throughout the corporation. INDRESH PADMONKAR Page 3

Project: Environmental Hazard Reporting System Jan 99 – Aug 99 Data modeling for the application (logical and physical). Application development and deployed both as client- server and multi-tier version. Worked on all phases of the software life cycle Tools: Oracle (v8i and V7.3) on AIX UNIX, Pl/sql 8.0, 2.3, Developer /2000 on Windows NT (V2.1, Forms 5.0 and Reports 3.0), Oracle Application Server 4.0 (On windows NT4.0 service pack 4.0). Project: HR Reporting System Jul 98 - Dec 98

Client interaction and preparation of software requirement specification. Extensive development using mod_pl/sql(htp, htf packages), sql, html, JavaScript. Implemented database changes (tables, synonyms, schema, roles, privileges, etc). Created packages, stored procedures and functions. Data loading from legacy systems

(ETL operation).

IFC-ONSI (A Division of United Technologies Corporation) South Windsor, CT Project: Data Warehouse Application (DWH) Feb 98 – Jul 98 Served as a Team Leader. Involved in Data modeling (star structure). ETL work to get data from different legacy system (files, dbase, Oracle) to DWH. Meta data changes and data validation. Created Visual Basic forms for user data loading interaction. Created Crystal Reports (Dictionaries also used) for On-line analysis DBA operations (worked with tablespace, roles, users, etc). Created process to automate data loading. Hamilton Sundstrand Windsor Locks, CT

Project: Aircraft Parts Maintenance System Nov 97 – Feb 98 Team Leader Involved in all project phases: Client interaction, requirements gathering, Data Modeling Data entry forms, reports design and development. Implemented as client-server application

.

Language/Tools: Oracle 8i, Oracle Application Server 4.0.X, Developer V.6i/6/1.3, Oracle Forms 4.5 and Report Writer 2.5 on Windows NT, TOAD, PL/SQL, HTML, Informatica, JavaScript, JDBC Thin Driver for Oracle 8.x, Java Applet, and JavaBeans using IDE Jdeveloper/Tomcat, Erwin

SOUTH STAR DATA CONSULTANTS Pvt. Ltd. Bangalore, India 1996 - 1997 IT Consulting Company focused on Database Systems

Senior Software Engineer/Business Analyst

Client: IBM Thailand, Bangkok, Thailand

Project: Tax Computerization Dec 96 – Apr 97

Design Analyst/Developer/DBA for a large Distributed database application Tools: Oracle 7.2 on OS/2 Warp 3.0, Forms 4.5 / Reports 2.5 on win-os2, Pro*C on AIX 3.0, Discoverer/2000, Designer/2000, Oracle Financials

Client: PSI Data Systems Bangalore, India

Project: Bank Automation Jan 95 – Dec 95

Team Leader/Developer/Tester to implement a banking application. Tools: Oracle V 7.X, Informix, Oracle forms /reports, Pro*C, pl/sql, sql. Professional Training and Education

Pentaho Tools RTP, NC (Certified PDI ETL Developer) Data and Application Security - Cisco White Belt Training and Certification, RTP, NC Advanced Java 8, Maven, Introduction to Docker, Hadoop Development Fundamentals, PMP Boot camp, Improve Effective Presentation, Virtual Meetings, Machine Learning, Kafka SAS Programming SAS institute, Cary, NC

MS, Computer Science Rensselaer Polytechnic Institute, Hartford, CT, USA BS, Electronics and Communications Mysore University, HASSAN, INDIA Diploma, Aeronautical Engineering Air Force Technology College, BANGALORE, INDIA

Contact this candidate