Nitesh Bharadwaj Velamuri

• Lead the team of 7 people across Price tracker, L4TF and Gold Retail projects
• Developed Looker dashboards using the data from Big query
• Enhanced the existing looker dashboards as per client requirements
• Followed CI/CD process and maintained version control of the codes
• Monitored the existing GCP workflows and explored GCP Cloud Build product
• Resolved the issues in Power BI dashboard within SLA’s
• Enhanced the existing Power BI dashboards as per client requirement
• Followed all the SDLC steps

(Commonwealth Care Alliance) - Actuarial Dashboards

• Migrated Existing SSRS reports to GCP-Looker Dashboards
• Converted existing stored procedures and SQL queries in MSSQL server to GCP-Bigquery standards
• All the data necessary for Looker dashboard development in created in Bigquery and tables/views in Bigquery are connected to Looker environment for dashboard development process
• Working along with business to publish the white papers on various health care challenges
• Generating adhoc reports in SAS, Excel, and Power BI as per business requirements
• We have used to “dbt” to migrate the code from development environment to Production environment
• We have followed CI/CD process to deploy the code
• We check-in /checkout the code the in Git using Google cloud shell

(Capital Blue Cross)-Early Warning System

• Developed Centralized data repository by performing ETL operations with python
• Performed ETL activities on Netezza DB by establishing connection between DB and Python environment
• Performed all ETL activities with the help of SQL in python environment
• Created business specific tables, which in turn acts as source to Power BI environment
• Established connection between Netezza DB & Power BI environment
• Presented different visualizations like Heat map, Bar graphs, Tabular charts, Donut charts, pie graphs in depicting various information related to claims, members, and groups across different LOB’s
• Involved in development, unit testing of functionalities provided by client and BA

(Pfizer) - Programmed Content Creation

• Developed Error Handling macros for the existing content.
• Generated RTF Narratives using proc ODS.
• Improved Readability of existing content by converting text output data to tabular form.
• Used various procedures like proc report, proc format etc.
• Involved in development, unit testing of functionalities provided by client and BA.

(CITI Bank) - Common Data Area

• Understanding the Functionality
• Development of test plan, test scripts, reusable actions, and Generic Functions
• Setting up data required for script execution
• Interacted with Developers and QA team members, TL in different defect raising situations
• Designed and developed Test Metrics, Reports, and schedules as necessary and participated in walkthroughs and meetings.

(CITI Bank) - Rapid Response Team

• Creating test SAS data sets by extracting the data from data Sources using Base SAS
• Coding basic SAS program to validate the Requirement.
• Summarizing the data by using proc summary and generate the reports by using proc report.
• Performed Source to Target validation using proc print and proc freq.
• Scheduling and monitoring the jobs in Autosys.
• Email Review and Reporting to Manager.