RAJEEV SINGH

Experience

• 

  Wipro Limited

  Jan 2014 - Jun 2016

  Project Engineer

  Worked on series of customer projects for Vantiv and Citibank. Worked on Citibank Genesis program providing solutions to support common pool of contracts, positions, and customer account balances across CITI on an enterprise basis to common data model, including reference data which was based upon Enterprise Data Standards and anchored to financials.Used SQL Developer as to create daily tabular reports using complex queries and PL/SQL which was consumed by higher officials. Enforced Tectia Client as UNIX platform to run production jobs and checked job level info. Performed SQL query performance tuning by implementing window functions and materialized views. Designed and developed SSIS projects for loading data into SQL Server.Provided 24x7 operational support to all production practices on holidays and weekends. Environment: Teradata, SQL Developer, AIX, Tectia, Datastage, TOAD, SQL Server 2012, Tivoli Show less

• 

  University at Albany, SUNY

  Jan 2017 - May 2017

  Graduate Teaching Assistant

  Worked as a Graduate Teaching Assistant under Prof. A. Galo at SUNY Albany to gain sufficient knowledge about all the concepts of Data Structures and Algorithms. Also gained in-depth knowledge of Java and REST application.Obtained materials needed for classes, delivered lectures, met with students during office hours and helped professor to develop course plans and programming assignments.

• 

  NYS Office of Information Technology Services

  Oct 2017 - Aug 2018

  Student Assistant

  Gathered client requirements Developed modules using core java and spring. Maintaining integrity of data through security, documentation, and change management.Create and implement DDL Scripts for primary database Objects such as tables, indexes,views, sequence, synonyms.DDL Scripts for creating and managing database objects in QA, UAT and Production Environment.PL/SQL development, Stored Procedures, Functions and Packages.Experience using PL/SQL records, tables, cursor variables etc. Used various packages as UTL_FILE (to write the file to a specified directory), EXECUTE IMMEDIATE etc.Designing SSIS Packages, and/or enhanced the existing SSIS packages using Fuzzy Lookup, Derived Columns, Conditional Split, Aggregate, Balanced Data Distributer, Script Component, Script Task, etc. to extract data from disparate sources (SQL Server, Excel, Mail Attachments, Service Now Rest API, XML, CSV etc.)Maintaining SharePoint site using JavaScript, HTML5 and CSS3.Developing ER Diagrams and Schemas to help the ETL Process Designing.Utilizing excellent T-SQL development skills to write complex queries. Perform SQL query performance tuning by creating/modifying indexes, changing query structures and using window functions.Environment: MS SQL Server 2014/2016, MS Visual Studio 2013/2017, MS SQL Server Integration/Reporting/Analysis Services (SSIS/SSRS/SSAS), XML, ASP.NET using C#, Java, Agile/SCRUM Methodology. Show less

• 

  SRIVEN SYSTEMS OF TX INC

  Aug 2018 - now

  Web Developer

  Gathered and defined customer requirements to develop clear specifications for creating module structure.Developed modules Restful services using Java.Develop ER Diagrams and Schemas to help the ETL Process Designing.Design SSIS packages to extract, transform and load data into SQL Server from various sources. Document all SSIS projects.Develop windows batch files for automating file transfers between different servers.Environment: MS SQL Server 2012/2014, MS Visual Studio 2015, MS SQL Server Integration/Reporting Services (SSIS/SSRS) XML, C#.NET, Agile/SCRUM Methodology. Show less

• 

  WIPRO LIMITED

  Feb 2019 - now

  Developer L3

  Gathered and defined customer requirements to develop clear specifications for creating module structure.Perform Root cause Analysis.Creating Unix Shell scripts for automation.Designing database schemas and queries to ensure performance.Responsible for developing advance PL/SQL packages, stored procedures, triggers, functions, indexes, and Collections to implement business logic. Generate server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.Responsible for Data Analysis, Data Scrubbing and Data Load using SQL Loader.Responsible for creating and implementing DDL Scripts for primary database Objects such as tables, Partitions, indexes, Views, Materialized Views, sequences, synonyms in Development, QA, UAT and Production Environment.Implemented various functionalities such as Nested queries, inline view, connect by, decode, outer join, varying array, case expression, Refcursor, cursor expressions manipulation, bulk fetch, insert/updates with save exceptions.Responsible for performing unit testing and integrated testing on newly created PL/SQL and Stored program units.Responsible for troubleshooting and Production Support.Responsible for highlighting Issues/Concerns in either team meeting or group communication mail by following up the issues until closure.Responsible for demonstrating the completed functionality to the customer upon completion of every iteration. It makes sure project is delivered with quality and 100% coverage is done with respect to the project changes.Experience using records, tables, cursor variables etc. Used various packages as UTL_FILE, EXECUTE IMMEDIATE etc.Worked of multiple ETL projects using SSIS.Responsible for creating REST and Web application using Java and Oracle.Used GIT tool to keep the source code up to date.Responsible for developing UI using Struts, Spring Boot, AJAX, JSP, Servlets, HTML, CSS, JavaScript, and jQuery. Show less