.Net Developer Data Warehouse

Rishi Srivastava

704-***-**** **********@*****.***

Technical Lead / Full Stack Senior .Net Developer

Technical Lead with extensive experience managing on and offshore teams in diverse industries including, Manufacturing, Banking, E-commerce, Insurance, and Safety, across all stages of the SDLC. Expertise in full stack development, designing complex applications, Data Warehouse project life cycle, project management, and team leadership. Serves as the bridge between the development and operations teams, automates repeatable tasks, and increases efficiency and reduces manual errors throughout the development lifecycle.

Areas of Expertise

Team Leadership Project Management Full Stack development Microsoft programming Data Warehouse

Service Oriented Architecture (SOA) N-tier Architecture Web applications Windows applications

Performance tuning Testing Code reviews Walkthroughs ETL Azure DevOps CI/CD

Technical Skills

C# VB.NET Visual Basic 6.0 XML C++ Windows Server Windows OS Linux / Ubuntu

Microsoft Visual SourceSafe Team Foundation Server GIT Azure DevOps Visual Studio Crystal Reports

QTP Automation Classic ASP ASP.NET JavaScript CSS JSON XML XSD XSL/XSLT WCF (SOAP/REST) AJAX HTML5 IIS 6.0/7.0/7.5 Web API AngularJS JQuery MS SQL Server MS Access Oracle ADO ADO.NET ENTITY FRAMEWORK LINQ SSIS SSRS MS.NET Framework and Client / Server WCF (SOAP/REST) MVC

SharePoint (SSOM, CSOM, Web Parts, Apps, IFRAME, Hadoop HDFS Hbase Sqoop Hive Map Reduce PIG Flume SSRS / SSIS Power BI

Employment Summary

Allegheny Technologies, Monroe, NC - 07/2017 - present

FCS / TEK System, Charlotte, NC - 03/2006 - 05/2016

DAMCO Solutions, India - 12/2000 - 02/2006

Professional Experience

Allegheny Technologies, Monroe, NC 07/2017 - present

Technical Lead / Senior Application Developer

Gather business requirements and drive sprint planning, design, review, development, testing, and deployment processes. Oversee onsite/offshore consulting resources, from third party vendors.

Successfully implemented and delivered Metal Piece transaction solution, for all ATI plants.

Designed and developed Service Request System for all users.

Designed and developed Safety Audit Checks applications, for electronic entries, for all ATI equipment.

Designed and developed single signoff API consumed by all ATI custom applications.

Captured data from various PLC devices (Allen Bradley, Siemens, Yokogawa, Adam) and incorporated them into metal melting process solution.

Designed and developed a solution to capture operator’s hours and process payroll.

Designed and developed a solution to capture data from Thermal Heat Camera, based on ROI pointers, and the integration with various other customer applications.

Supported enhancement of existing code bases. Managed various legacy applications and provided support.

Bank of America, Charlotte, NC 06/2016 - 06/2017

Senior Application Developer (VI)

Enhanced existing code bases using, VS 2015, TFS 2015, Notepad++, SQL, JSON, AJAX, Font Awesome, CSS, Java Script, Angular JS, WCF, MVC, C#.

Implemented WCF service to upload weekly/on demand ADS data into FSB Data Warehouse. Implemented file processing window application for pull data from ADS systems. Involved in sprint planning, design, review, development, testing and deployments processes.

Activision Publishing, Inc. Los Angeles, CA 05/2015 - 06/2016

Team Lead / Application System Engineer

Led midsize development teams onsite and offshore.

Automated process to download sales from different vendors (Sony, Microsoft xBox, Play Station), to internal data warehouse.

Optimized "eTera" application used to move weekly data to data warehouse. Worked on SharePoint integration to load games’ manual documents to SP 2013 custom list, using SharePoint Server Object Model in C#.

AAA Carolinas Charlotte, NC 03/2012 - 04/2015

Application Developer Lead / Senior Consultant

Involved in entire SDLC of portal development and all phases of implementation including, requirement gathering, design architecture /framework, technical design, development, testing, training, and support. Designed project plan and team allocation processes.

Developed Rating Engine module using C# and SQL. Designed and developed Underwriter Module screens using ASP.NET, C#, SQL, AJAX, JavaScript / JQuery, AngularJS and CSS.

Developed SSO component using MVC framework. Developed Choice Point Order MVR and Clue Reports Web Service to interact with Lexis Nexis reporting services. Developed backend C# program to move documents (xls, pdf, doc, txt, img etc) from RMA Claim system to SharePoint list / libraries using SharePoint Server Object DLL's.

Assisted migration team with roadmap for Universal to AAA data migration (Policy, Claims, History, Activities, Order MVR/CHR reports etc). Collaborated with business users to understand and capture business process requirements and transform them into technical requirements.

Additional Professional Experience

Disney Domestic Safety Scorecard, Orlando, FL

Application Developer Lead / Senior Consultant

Design and Developed Safety Dashboard screens using ASP.NET, C#, AJAX, Oracle, XML. Involved in designing the Data Definition for data warehouse to kept data in multi dimensions form (Cube - Dimension/Facts). Developed new ETL Jobs using SSIS packages to pull data from other Division of Disney Parks, Stores, Offices. Enforce the coding standards to increase the quality of the applications. Propose technical solutions to enhance the application speed and performance.

Disney Domestic Labor Reporting, Orlando, FL

Application Development Lead / Senior Consultant

Design Architecture / Framework of the entire application. Design and Developed Labor Dashboard using ASP.NET, C#, AJAX, Oracle, XML. Worked on ETL (SSIS) to store the labor hours data in data warehouse in form of cubes by organization hierarchy, location, year, and physical week. Involve in project management, requirement process, design Technical and System Solution Definition Document.

Disney Cruise Line, Orlando, FL

Senior Software Engineer / Team Lead

Involve in design and developed WCF web service for Kiosk device to consume it for reservation module. Worked on Dining reservation module using VB.NET, C#, and Oracle/SQL. Involved in ETL interfaces required to transfer data between server and Cruise DB's.

Analect LLC Charlotte, NC

Senior Software Engineer / Team Lead

Interacting with the third-party software vendors to get knowledge of the XML receiving and sending application. Developed 5 different interfaces ActiveX exe to receive/send the data to the third-party software using https-post method in form of XML using VB.NET and SQL. Worked on the various Web Screens: Index Maintenance, Implicit Cash, Calculate Proxy Offerings Prices, using Classic ASP and SQL. Worked on the following reports using Crystal Report: Deferred Compensation Plan Details, Deferred Compensation Plan Summary, Termination Event Details, Tax Report

Funder America Charlotte, NC

Project Lead / Senior Software Engineer

Worked on Inventory Module, Warehouse Module Account Receivables/Payables Module –GUI/COM Component using VB and SQL. Developed Various ActiveX exe Interfaces for exporting the data to MAS Accounting Application. Developed Various DTS programs to perform various scheduled operations. Developed Shipping LABEL Generation program for RF handlers in C++. Worked on Place order ecommerce module where authorized vendors can login over the internet and add items in shopping cart and place the order, designed and developed the entire module.

Seibels Bruce, Inc / Universal Insurance, Inc., Charlotte/Winston Salem, NC

Software Developer

Built a Web Application in Classic ASP/SQL for Commercial Automobile to quote and bind policies for SC, NC, and GA state agents. It involve complete module of Commercial Auto, Property, General Liability insurance business.

Developed a web-based in Classic ASP/SQL application which provides a comprehensive solution for Universal Agency/Agent users where they can quote and bind policies for NC State for the Automobile, Motorcycle and non-owner vehicles.

Worked on Choice Point Order MVR and Clue Reports web Service using Lexis Nexis services and Rating Engine Component using VB/SQL.

Meesiba Airlines Charlotte, NC/ India

Developer

Involved in a web-based application in Classic ASP/SQL that provides a comprehensive solution to communicate information between the maintenance planning team and the airline mechanics about required maintenance necessary for the its air planes. Project was divided into three main modules: JC Web (Presentation Layer), JC Business Engine (Application Layer), JC Service Engine (Background Services).

Education and Professional Development

Masters in Economics

Shobhit University, India

Bachelors / Diploma in Computer Application

National Institute of Professional Studies, India

Training/Certifications

Diploma in Unix, ‘C’ and Oracle

Certification in Hadoop Programming

Brain Bench Certified ASP Programmer

Certification in Project Leadership

Contact this candidate