SUMMARY:

• Eighteen plus years of IT Experience - in Analysis, Design, Architecture, Development, and Managing Software Applications.
• Having worked in Oracle, and Big Data environments.
• Having worked in Healthcare, Retail, Telecom and Media domains.

TECHNICAL SKILLS:

OP System: Linux, Windows, Unix

Technologies: HADOOP, Sqoop, Hive, Spark, Spark Streaming, Flume, Kafka, Hbase, Oozie, SQL

Database: Oracle 11, Cassandra

Languages: Java, Scala, Python, .NET, PL/SQL

Roles: Big data Architect, Technical manager, Tech Lead, Data Modeler, Developer

Companies/Clients: HPE, ESPN, Confidential, Confidential, Confidential, Alemeda Alliance for Health

PROFESSIONAL EXPERIENCE:

Architect & Technical Manager

Confidential

Responsibilities:

• Sqoop was used to move data to and from Oracle to HDFS.Hive was used to Split the data into two companies’ data.
• Incremental Sqoop jobs were created to keep this repository current and hence used as Reporting source.
• Active Archival was the by-product of this design.
• Spark is used to run interactive Analysis.
• Armor is a financial application with warranty estimates but smaller in size.
• Oracle technologies were used to split this data.
• POC for Fraud Detection was developed using Kafka. ii) Data Quality:
• It’s a 22 TB database and millions of records being loaded from 200 plus manufactures. Due to the history of mergers and acquisitions data quality from multiple sources haven’t been up to the quality. Also due to the evolution of business some data structures need to be redefined. Billions of records were redefined and cleaned up without downtime. iii) ETL SSIS conversion:
• The batch process loading data from flat files to the repository was done by Oracle sql loader but is being migrated to Microsoft ETL tool SSIS. It was a team of 10 developers having domain managers in UK and US.

Oracle database architect

Confidential, Oakland, California

Responsibilities:

• SterlingSIA: The company initiated Self Insurance Administration. Medical, Dental and Vision plans will be combined with Stop Loss insurance for the eligible clients. As the clients will range from small to large companies, we needed to develop various flavors of enrollment. Some will be done from their internal applicatios running on APEX, some will be from web clients running on PHP, and some using EDI 834. As the Claims processes were done by TPA
• Capitol, enrollment information will generated in flat files and sent to them.Invoicing: This is the first piece of the financial module. This involves capturing various plans, like HRA,FSA and the pricing of the services, such as Debit card and regular administration charges, and creating invoices for them. The objective and design was to model a typical financial module involving Receivables and Payables.

Environment: Oracle 11g,Pl/sql, PHP

Confidential, Connecticut

Project Lead & Developer

Responsibilities:

• Transmission department revamped its software, developing in-house applications and buying third party applications. The meta data for the media files and the transmission data resided in legacy system. A robust interface using web services is the project is about. There were three teams, each comprising a couple of developers. These teams had heterogeneous technology like Microsoft and Java technologies. I was leading and coordinating this effort to build the web services..

Environment: Oracle 10g, Java J2EE, PL/SQL 2.3, Weblogic.

Project Lead

Confidential, Connecticut

Responsibilities:

• It is a tool that would help Software Configuration Management or anyone who would like to create and move security related data from one environment to another, for example from Test to Production. Using Keystone services, provided by Disney, data will be pulled and pushed from to Keystone databases. The technology used are, .NET, C#, Windows services and Oracle. Applications, Roles, Functional Abilities and attributes will be created to authenticate and authorize application resources, such as the screens, processes, and secure entities like fields or buttons. ii) Phoenix Admin screens:

Application Developer

Confidential, Connecticut

Responsibilities:

• Proposals system is the starting point for ESPN’s advertisement sales. It presents ESPN’s inventory for its networks to the advertiser. Using the information from the Rate card, Nielson Research, and scheduling sub-systems the Proposal system provides the user with Ratings, Impression and Rate information for their programs, eventually ending with creating Orders.
• Proposals have been thus for manually built by planners, picking up episodes based on their judgment, resulting in slowness and inefficient or expensive deals. The objective of this project is to use some advanced algorithms to pick up the best plans possible, from the entire inventory, in a more scientific way, in a very short period of time, thus saving money and improving efficiency. The basic criteria like the networks clients want to have their units on, the dollars they are willing to spend for the expected CPM/impressions, and the flight dates they want to air their commercials are given by the clients. Optimizer will be fed with all inventories that fall into the clients' criteria on the one hand, and would be expected to come up with the best plan that would satisfy the CPM/impressions within the clients' budget
• As the networks and hence the amount of data grew rapidly, the system began to slow down. The slow applications were identified and within them the slow Sqls, slowness causing designs were identified, tuned and the applications were made as good as it used to be.

Environment: Oracle 10g, .NET, C#, PL/SQL 2.3

Oracle Programmer/Analyst

Confidential, Arlington, Virginia

Responsibilities:

• Informatica as ETL and Microstrategy as the reporting tool. Different vendors like Confidential &T, internal users and Government regulatory body are the users. Data is obtained from various sources and systems via COBAL file, flat file and oracle tables and loaded into Transient, Staging tables, Data warehouse and into Data marts. Reports would be generated and accessed via web.

Environment: Oracle 8i, Informatica, Microstrategy 7.0, SQL*LDR, TOAD, Windows NTHP Unix.

Programmer/Analyst

Confidential, Long Island, NY

Responsibilities:

• Oracle database that supports Confidential ’s corporate retail business. It is an Oracle (3 tier) application running on BM AIX servers with Internet Application Server, Oracle9iAS, and interfaces with Confidential ’s UD, USI and System 80 Shipping mainframe systems. It encompasses the following corporate retail functions:
• Contracts and Pricing
• Order Entry
• Returns
• Conversions

Environment: Oracle 8i, Developer 2000 (Forms 6i, Reports 6i), Java, SQL*Plus, PL/SQL 2.3., Designer6i, SQL*Loader, Oracle9iAS, JDBC, Windows NT

Programmer/Analyst

Confidential, San Jose, CA

Responsibilities:

• This company is in the Storage Area Networking (SAN) industry. They sell Fiber channel Switches and need a License Key to get activated after being bought. Getting the switch related information from the customers and creating License key over the web is the crux of the project. The customers enter some identification information about the switch through BROCADE/OEM (IBM, Compaq...) branded websites.

Environment: Oracle 8i, Developer 2000 (Forms 6.0, Reports 6.0), Java, JSP, XML, SQL*Plus, PL/SQL 2.3, Oracle Applications 11.x, Erwin, SQL*Loader, JDBC, Windows NT

Programmer

Confidential, San Leandro, CA

Responsibilities:

• The project is about validating a few years of data (a few millions of records) based on the Department of Health Service (Dhs) Rules. The compliant records should be sent to Dhs for inspection. This process will be used regularly Confidential present and in the future. Also the work will create a kind of Data warehouse of the data with all required information for the company which will be available for various analysis and policy making support system. Various kinds of reports will be developed for the Senior Management and for various other internal, customer reports.

Programmer Analyst

Confidential

Responsibilities:

• The work includes system analysis, design, development and implementation of an integrated environment for running administering reports. Tables are designed to store all the report related details. Forms are designed in Forms 4.5 to run single/multiple reports, to view the reports, to administer the reports, to register for new report requirements and to co-ordinate the report development work. The work also includes setting standards for designing the reports in Reports 2.5 for the report designers.

Environment: Oracle 7.3, Developer 2000 (Forms 4.5, Reports 2.5), SQL *Plus, PL/SQL, Windows 95