SUMMARY

• 6 plus years of experience in the IT industry. His main area of expertise is in Oracle,Informatica power center, Pentaho ETL, Diver, BigQuery, Tableau, Data Warehousing and data visualization.
• Involved in Project planning, Scheduling, System design, Functional specification, Design specification, Coding, Reporting and System testing.
• Extensive Experience in data staging, database design, data warehouse requirement analysis and Implementation.
• Extensively used ETL methodology for supporting data extraction, transformation and loading process, in a corporate - wide-ETL Solution using Informatica,Pentaho ETL, PL/SQL and other ETL Tools.
• Work Experience with reporting and data visualization tools like Diver, Tableau and BI publisher.
• Extensive work experience with UC4, Clarinet scheduler,Airflow to design workflow for job execution and harvest change management system.
• Extensive experience in database design for data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas, 3rd normal form Data models.
• Worked on Waterfall and Agile Methodologies
• Have extensive experience in Onsite / Offshore Client Handling

TECHNICAL SKILLS

LANGUAGES: SQL, PL/SQL, SHELL, Python

DATABASES: Oracle11g, Confidential BIGQUERY, MS SQL Server, Teradata

TOOLS: & UTILITIES: SQL*Plus, TOAD, PL/SQL Developer, SQL Developer, SQL* Loader, Oracle Enterprise Manager, BigQuery, Pentaho, SQL Server, Diver reporting tool, Informatica 9.5, Informatica 9, DAC, UC4 scheduler, PERL,harvest change management system, SVNBI publisher, RallyON, SONAR, Tableau, Apache Airflow, Sumo.

DEVELOPMENT METHODOLOGIES: Test Driven Development, Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Data Analyst/Data Engineer

Responsibilities:

• Working on user trends reporting using user tracking data.
• Creating pipelines to ingest raw user tracking data source from different sources like website, chat, voice chat etc. And transform this data into meaningful information and creating data visualizations in Datastudio and Tableau.
• Involved in detail user data analysis ranging from CTR analysis, A/B Tests, User Organic Behaviour etc.
• Deployed Apache Airflow on Confidential Cloud Platform to be used for Batch scheduling, Job fail alerts, Data monitoring and alert etc.
• Created new Operators and hooks for Apache Airflow to perform different tasks like checking data in tables, check empty files on GCS etc.
• Writing batch sql queries for teradata and Confidential BQ.
• Creating Tableau reports for Analytical purposes.

Confidential, Sunnyvale, CA

Data Analyst/Data Engineer

Responsibilities:

• Created a suite of Cash Analytics Dashboards to provide insight into cash position easily and help answer most frequently asked exposure questions. Worked on End to end process from ETL pipelines to data visualizations.
• Created numerous ETL pipelines and assisting business analysts to create data visualizations.
• Interacted with business users and Business Analysts for Business Requirement discussions.
• Designed and Implemented DW solution using Pantheon ETL(Pentaho Kettle), Confidential Big Query and reporting tools like Tableau and Plx.
• Created reports and visualizations for data analysis using Tableau.

Confidential, Dublin, OH

Data Analyst/Data Engineer

Responsibilities:

• Designed and documented Extract and reporting process according business specific needs.
• Created Views, Stored Procedures and Functions in Oracle package related to each module. Involved in application Design/development, unit testing and deployment
• Resolved defects, communication with QA and UAT team related to defects.
• Developed pl/sql code to summarize source data and apply complex business logic for reporting purposes.
• Developed Unix Shell Scripts to ensure successful execution of the batch processes
• Worked in Agile environment. We have scrum meeting on daily bases
• Interacted with business users for requirements gathering

Confidential, Dallas, TX

Senior pl/sql Developer

Responsibilities:

• As primary resource/owner for Uverse CCPM process, minimise the business from production issues by effectively identifying issue, proposing solution and fixing issues within limited timeframe.
• Designed and documented Low Level Application Designs in easy to understand and detailed form from High Level Designs, so that other developers can use documented design efficiently for code development.
• Developed code in high paced AGILE sprints, from design, development, helping with testing, code review and production deployment.
• Code development included pl/sql, IPC and shell scripting.
• Created and verified Unit test cases during Development and helped system test with designing and reviewing test cases/plans.
• Arranged and drove daily meetings with offshore team to insure timely and successful completion of project.
• Designed high volume Intraday processes for real time processing of data coming through GoldenGate.
• Used SONAR to follow code standards

Confidential, GreenBay, WI

Pl/Sql Developer

Responsibilities:

• Arranged and drive meetings with BI team as well as business partner to gather requirements.
• Designed process to efficiently divide and allocate development process to onsite and offshore team.
• Arranged and drive scrum meetings with offshore team every day to make sure of quality and timely delivery of deliverables.
• Designed and created efficient ETL(pl/sql) processes and data visualization(Diver) for numerous high impact projects.
• Working on Informatica to help build new BAW for reporting purposes. Working on OLAP data to create new multidimensional database for Analytical purposes.
• Worked in UNIX environment to execute sql*plus scripts, building diver models etc. Also, used shell scripting to modify or massage text files.
• Extensively used UC4 scheduling tool and harvest CM tools.