Ranjit Singh Email & Phone Number

Sydney, Australia

In this role, I am responsible for coordinating with client executive teams to gain comprehensive understanding of business requirements and develop pragmatic solutions with corresponding technical specifications, project budgets, and timelines. In doing so, I conduct customer interviews, analyse source systems data, and troubleshoot and resolve problems, as needed.Recent projects include:• iag: Tasked with modifying ETL solution, developing overall design of data integration strategy to troubleshoot issues related to investigation and formalisation of project requirements.o Improved data flow for more than 5K claims whilst correcting financial imbalance of approximately $4M and resolving critical issues related to end-user experience.o Succeeded in integrating financial solutions through database development and business reporting for various projects.• Shell (India): Provided leadership to small team of ETL developers in modification of existing data marts, ensuring consistency across data models in relation to both functional and financial impacts.o Proved highly effective in managing a team of six technical consultants in preparing execution architecture for solution.o Maintained open lines of communication with client and management staff to support timely completion of tasks in accordance with established department objectives

Kolkata Area, India

During this time, I owned responsibility for optimising data resources to improve ability to analyse to boost capacity for sales and promotion of new products. To be successful, I participated in requirement gathering sessions to design, build, and implement mission critical business intelligence solutions. I also oversaw delivery of reports in MS SQL Server.My projects include:• Lakshya (India): Developed logical and physical data models needed to design data access strategies and write SQL code for manipulation of stored data.o Gained significant experience in creating cross-tab, conditional, drill-down through Tableau.o Enabled efficient validation, extraction, transfer, and loading of data to data warehouse through ETL packages created using SSIS.• Logistics (India): Orchestrated integration of services to enable transfer and review of data from Excel, CSV, flat file, Text Format Data, and other heterogeneous sources.o Reduced database complexities for end-users through creation of views and implementation of stored procedure and triggers for automating tasks.o Employed a variety of SSIS tasks to improve quality of data validation checks during staging and whilst loading data into data warehouse.

Kolkata Area, India

Here, I provided comprehensive support to execution of process improvement projects, streamlining existing systems and fulfilment centre functions. At the same time, I created weekly, monthly, quarterly, and annual reports and presented to management teams, ensuring transparent knowledge of latest numbers and trends.Some of my most remarkable achievements include:• Instituted highly engaging and effective, visually impactful dashboards in Tableau, transforming raw data into meaningful, actionable business intelligence.• Identified and eliminated bottlenecks that resulted in 15% increase in revenue over course of two-years.

Kolkata Area, India

In this role, I supported execution of major business initiatives by collecting, cleansing, and providing modelling and analysis of both structured and unstructured data sets. I also played an integral role in assisting project manager in customisation of technical specifications on a per client, per project basis.

LetSe Software & Services Pvt. Ltd. – Hedge Index (Switzerland) Project – Data EngineerCircar Consulting – The BigCom (USA) Project – Software EngineerDiamond Engineering Works – Material Management Project – Software Engineer

Kolkata Area, India

• Used N-tier architecture for presentation layer, the Business and Data Access Layers and werecoded using C#.• Created ASP.NET web forms and Class libraries containing code for business and data access logic using C#.NET.• Used .Net Validation Controls for server side validations and JSP for client side validations.• Extensively used Application and page level tracing feature of .Net to trace and debug the code.• Developed the web pages using ASP.NET, HTML, and CSS for styling the Web pages.• Used AJAX in some webforms.• Involved in Normalization of the database and created queries to interact with the databas• Written stored procedures, triggers using SQL in SQL SERVER• Used HTML, JavaScript and AJAX for developing Controls and web forms • Extensively used GridViews with sorting and paging• Implemented Template Columns for Custom Nested GridViews• Developed User Documents for the users.• Collaborated with client and management to troubleshoot issues and validate programming requirements within their areas of responsibility.