Birendra Negi Email & Phone Number

Noida, Up, In

- Designed and implemented scalable data architecture solutions for enterprise clients, improving data accessibility and analytics capabilities.- Led the migration of on-premises data warehouse to Google Cloud Platform.- Designed Architecture in LookML Data Model and implemented multi-layer security in GCP Looker.- Perform reverse and forward engineering for the legacy RDBMS SQL and procedures.- Developed DBT Model in RDL & RDH with Big Query data warehouse.- Worked with Product owners to get the required, managed end to end project delivery.- Helping to build feature reporting of Non-Financial Risk data in GCP Looker environment.

Gurugram, Haryana, India

- Worked on analysis, design and implementation of projects end to end Analytics data model in SAS and LookML using Oracle and Big Query data warehouse.- Perform reverse and forward engineering for the legacy Oracle and SAS data sets.- Developed Business logics in Python and LookML to migrate legacy SAS codes.- Worked with Stakeholders to get the requirements and finalizing business strategic planning.- Extracted, Exploratory Data Analysis and validated of portfolio data, including new business trends, for use in portfolio analysis.- Handled complex Ad-Hoc requests for the client using Complex SQL and LookML queries.

Noida, Uttar Pradesh, India

- Worked on analysis of PepsiCo ticketing data.- Sensitized HCL team across tracks about SLA performance. - Developed and managed SLA management ticketing tool.- Extracted data from various sources like SQL Server, Oracle, .CSV, Excel and Text file from Client servers and through FTP.- Provided Monthly and Weekly Operation Review Dashboard to PepsiCo & HCL leadership.- Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally. - Involved in writing Stored Procedures and Functions, Cursors to handle database automation task- Assistance to preparation of billing reports by storage and bytes level.

Noida, Uttar Pradesh, India

- Understanding the business and Source System.- Provided technical support in collecting, cleaning, organizing, and managing data.- Helped in creating Analytical data warehouse in SQL Server. - Created and Managed Complete Database Structure using SQL server 2012. - Extensively used SAS procedures like Proc Print, Proc Report and Proc Sql for report generation and Proc Summary, Proc Freq, Proc Means and Proc Gchart for statistical analysis. - Created complete Documentation of a project.

Delhi, India

- Leads Regional MIS and Account team.- Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.- Helped to create Regional MIS data warehouse in SQL Server- Formulating queries (SQL) on information tool to fetch management relevant reports. - Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks and providing technical support. - Coordination and feedback with Head office for new development & requirement. - Provided supervision on various reports/dashboards to the team members.

Noida, Uttar Pradesh, India

Master Of Computer Applications - Mca, Computer Science

Diploma Of Education, Computer And Information Sciences, General

Bachelor Of Commerce - Bcom, Business/Commerce, General