SUMMARY

• Result oriented, self - directed and enthusiastic Software Engineering Professional fascinated to work with extremely large distributed systems & large-scale data processing engine with RDBMS, Big Data & NOSQL technologies and the components of its ecosystem.
• Offering 10 years of Data Driven expertise in diverse domain experience with Technology, Financial, healthcare and defense market leaders Like Confidential, Confidential, Confidential - Confidential, Confidential and their best practices. Worked as an Engineer to reveal predictions, trends and anomalies from Data.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Consultant - Data Engineering

Responsibilities:

• As a member of emerging-tech agile team, our mission is building Fraud Prevention System (FPS) using Artificial Intelligence and predicting mechanisms.
• Decoded and converted hive scripts to migrate entire HDFS system to Snowflake / Databricks (Delta Lake) system in AWS.
• Re-engineered hive and zeppelin workflow into Databricks notebook (PySpark, Python, R, SQL, Scala, AI/ML).
• Converted hive code (data node) into snowflake, and created best practice guideline to data modelers.
• Converted zeppelin workflow (logic node) into Databricks notebook.
• Resolved real time conflicts while converting hive to snowflake (like function anomalies) and zeppelin to Databricks (spark, python and R code conversion challenges).

Technology: Snowflake, Databricks, Python, PySpark, DB2, Hadoop, Hive, R, AWS.

Confidential

Consultant - Software Engineering

Responsibilities:

• Worked as a core engineer and decoded oracle pl/sql engine to migrate entire system to hadoop/hive base system.
• Have to handle rdbms to hive conflicting challenges.
• Resolved Query Level Performance tuning, real-time improvement of a long running module optimization in hive.
• Wrote PySpark code for data pipeline and flow it to dataframe for analytics. Include analyze data and push it through the matrix reporting.
• Thorough, methodical, and creative with extreme attention to detail, passion for making websites and applications accessible to all users, by driving accessibility in web and mobile applications, used W3C Web Content Accessibility Guidelines (WCAG) 2.1 to automate accessibility testing along with unit testing frameworks like testrail.

Technology: PySpark, Oracle Database 12c, Hadoop, Hive, accessibility laws and standards (WCAG 2.1, Section 508, ADA)

Confidential

Sr. Software Engineer

Responsibilities:

• Designed, Developed and Deployed data-mart for the ETL Conversion / Migration as a team lead, from various claim management application like CSP, Facets, Cosmos, Diamond and RX Solution into Integrated Data warehousing systems for National Encounter Management and Information System (NEMIS) for healthcare claim adjudication process (One of the largest claim management systems in USA).
• Used Oracle 12c Exadata, Snowflake, TWS, GIT, VISIO, CA Rally, procedures, triggers, DB links, index, hints, global temporary table, Cursors, Ref-cursors, Table partition with interval partitioning and followed all phases of the SDLC Best Practices and methodologies.
• Active team member of code review, deployment team and design & architecture team.

Technology: Oracle Database 12c, Snowflake, Python, OpenShift 3.6, Tableau, Jenkins, XL deploy, CA Rally, VISIO, GIT, TWS, TOAD, Oracle Linux 6

Confidential, Dallas, TX

Sr. Data Engineer

Responsibilities:

• Designed, Developed and Deployed User Interface based application to calculate Net Present Value (NPV) Engine. Worked as a core development lead and design architect.
• Which is considered one of the core loan modification engines which saves huge in human hours and proudly serving in Confidential in North America. I achieved Above and Beyond for the year 2013 for that application. (Oracle, Java).
• Created, Enhanced and Modified reporting layer for Waterfall report, Advance Forecast report, Pipeline report, Current inventory report to take business decision which is used by very top-level management of Confidential .

Technology: Oracle Database 11g, TABLEAU, HP ALM, SVN, JIRA, VISIO, Control M, TOAD, MS SharePoint, AIX 5.6.

Confidential, San Francisco, CA

Software Engineer

Responsibilities:

• Designed and implemented solution for multi-terabyte operational marketing database integrated client’s data ( Confidential Inc. ) with demographic data for prospect and consumers.
• Successfully designed and implemented data de-dup process for mission critical centralized repository system and added in ESP workflow.

Technology: Oracle Database 10g, Data stage, Visio, TOAD, TWS/ESP Workstation, Trillium.

Confidential, Irving,TX

DW-BI Consultant

Responsibilities:

• Created PL/SQL & SQL scripts for the ETL Converting/Migrating data from Mainframe, DB2, MSSS, Oracle, XML and Flat files into Oracle database tables for Data warehousing and BI purpose.
• Used Sql loader, external tables and SSIS for the purpose of loading flat file and XML data.
• Created/modified logical and physical models using Erwin with normalization of relations.

Technology: Oracle Database 11g, SSIS, MSSS, Power BI, Statistical Analytical Software, VISIO, TOAD, AIX 5.6.