Badges
Certifications
Work Experience
BUSINESS INTELLIGENCE DEVELOPER -INTEN
Rosendin Electric• May 2019 - August 2019
Tools and languages Used: SQL, ETL-Oracle Data Integrator(ODI), Informatica, Oracle Analytics Cloud, Google BigQuery, Python- pandas, Numpy, Jupyter Notebook, Oracle E-Business Suite • Performed data preprocessing by profiling large sets of unstructured data from different sources using SQL merged it and extracted usably Information using advanced data mining techniques • Developed interactive KPI dashboards and reports that aided marketing and allied teams by providing high-value information to respond to trends and make data-driven decisions
DATA WAREHOUSE -ETL DEVELOPER
FORSYS INC• April 2017 - July 2018
Tools and languages Used: Oracle Data Integrator(ODI), Informatica, Operational Data Store (ODS), Oracle E-Business Suite, MS-SQL Server, PL/SQL, Data Mart, SQL Developer • The project involves ETL part where the Extraction is done from oracle EBS source tables, Transformed and Loaded into Staging Oracle database • Involved in enhancement, maintenance and Support of ETL jobs, routines, UNIX scripts and writing PL/SQL procedures and in calling them through ODI jobs. • Designed and implemented data warehouse and data marts using Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema
Big Data
Gitam University• September 2017 - April 2018
• Loaded the data from different sources like Oracle Database and Microsoft SQL Server into HDFS using Sqoop and loaded into Hive tables • Developed pig scripts to transform the data into a structured format and Hive queries for Analysis across different banners • Developed Map Reduce programs for applying Business rules on the data and executed hive queries for Denormalizing the data
Research Assistant
Gandhi Institute of Technology and Management GITAM School of Technology• June 2016 - January 2017
• Paper published in International Journal of Science Technology & Engineering, (IJSTE) • “Survey on Big Data Analytics and Hadoop Tools”, Volume 3 | Issue 07 ISSN: 2349-784X, page: 186 - 191. (January 2017)
Education
Chicago State University
Computer Science, MS• August 2018 - May 2020
Gandhi Institute of Technology and Management
Computer Science & Engineering, BS• June 2014 - March 2018