SUMMARY

• 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.

TECHNICAL SKILLS

• 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

Confidential, RTP, NC

Software Engineer, Big Data platform

Responsibilities:

Design and development of healthcare data processing system with in data-lake (big data 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 analytic 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

Confidential, Morrisville, NC

Engineer/Analyst, Big Data platform

Responsibilities:

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

Confidential, Morrisville, NC

Consultant

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

Confidential, Tallahassee, FL

Applications Development Analyst

Responsibilities:

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.

Confidential, Hartford, CT

Application development Consultant

Responsibilities:

• 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.

Confidential, Glastonbury, CT

Architect/Analyst Designer

Responsibilities:

• 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.

Confidential, Hartford, CT

Research Assistant

Responsibilities:

• 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.

Senior Consultant

Confidential, Windsor Locks, CT

Responsibilities:

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. 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 Confidential, was subsequently adapted for use throughout the corporation. 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).