Summary
Overview
Work History
Education
Skills
Personal Information
Personal Qualifications
Disclaimer
Timeline
Generic

Rakes Maharana

SQL Developer
Bhubaneswar

Summary

Highly knowledgeable and experienced SQL Developer with business-savy and driven nature. Have experience on SQL, MSSQL, TSQL, PL/SQL, SSRS, SSIS and ADF. Have experience on JIRA, confluence, Jenkin, Bitbucket, Control-M. Have experience on Financial, Banking and Utilities domain based project. I believe that my technical, functional and communication skills will enable me in facing the challenging career ahead.

Overview

8
8
years of professional experience
3
3
years of post-secondary education

Work History

SQL Developer

TEKSystems
08.2022 - 01.2024
  • Expertise in Control-M Monitoring tool
  • Daily activities with IBM RTC tool
  • Have a best practice of Confluence and documentation
  • Proactively handling the incidents with Rational Team Concert tool with Git
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production
  • Created indexes, Constraints and rules on database objects for optimization
  • Experience in creating and updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance
  • Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database, table and add enough spaces to database
  • Involved in performing database Backup and Recovery
  • Working on different priority ticket and Control-M Jobs request following the SLA defines
  • Analysis of SQL scripts in case of any Control-M job failures
  • Raising change request and carrying out the change for the new development
  • Work within the Change Management and Configuration Management processes Performing problem management for recurring issues and taking to closure
  • Involvement in defining scope for new releases and helping business in solving existing issues
  • Focusing on making the application more stable in terms of ETL process
  • Designing of tables and views structure as per application requirement
  • Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application
  • Fix any issue related to Db performance and provide correct solution for the issue
  • Working on SSIS package and Transfer inbound data from various sources like flat files, MS Access, and Excel into database using SSIS Packages
  • Debugging the SSIS packages to fix the bugs
  • Deploy and schedule SSIS packages using Control M job
  • Was also involved in Designing database and ensuring their stability and performance.

SQL Developer

Wipro Limited
11.2015 - 01.2021
  • Project: Utilities
  • Client: Arizona Public Service Company
  • Duration: Aug 2019 to Jan 2021
  • Technologies: SQL, T-SQL, SSIS, Testing, .Net, Angular, Typescript
  • Description (in brief): This Project is basically a Utilities domain based
  • Developed SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables
  • Worked on various backend Procedures and Functions using SQL
  • Worked on performance tuning
  • Troubleshooted performance issues
  • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
  • Created database objects like tables, views, Sequences, Directories, function, Cursor, Ref Cursor and Triggers
  • Interact with Business Users, Business owners to know their Business requirements in developing and modifying database objects, reports
  • Data analysis, data management and performance tuning
  • Write clear codes and prepare coding documentations
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for data related changes or new requirements
  • Load data from different sources to the application data warehouse using SSIS packages
  • Loading data from different sources to our databases through different SSIS packages in DB
  • Create and Maintain SSIS packages for ETL process
  • Performing transformation on the source data based on the business requirements
  • Worked on various data sources and destinations like flat files and good exposure to Control flow level items, Data Flow Transformations and Deployment on various environments
  • Deploy and schedule SSIS packages using SQL Server Job Agent
  • Participate in KT sessions conducted by customer/ other business teams and provide feedback on requirements Creating and managing DB objects like tables, views, Stored procedures, Indexes, partitions
  • Responsible for writing test scripts and test cases for code deployment and changes, responsible for system testing, UAT and production deployment.

SQL Developer

Cozentus Technology
Bhubaneswar
06.2022 - 08.2022
  • As a SQL developer, I am handling all the database part such as creating objects, tables, writing query etc
  • 6.4 years of working experience Sql Server and SQL procedures, functions, packages, triggers, cursors, view etc
  • Writing complex queries using CTE, joins, temp Table
  • Writing function and store procedure
  • Working on query optimization and performance tuning.

SQL Developer

Stonex Group INC.
04.2022 - 05.2022
  • 7 years of working experience Sql Server, SSIS, SSRS and SQL procedures, functions, packages, triggers, cursors, view etc
  • Writing complex queries using CTE, joins, temp Table
  • Writing function and store procedure
  • Working on query optimization and performance tuning
  • Working on Murex application.

Education

MTech(Integrated) in Information Technology -

VIT University, Vellore
10.2016 - 03.2020

BSc. (Chemistry) - undefined

Utkal University, Bhubaneswar, Odisha

Senior Secondary School (SSC) - undefined

Gopabandhu Science College, Athagarh

Higher Secondary School (HSC) - undefined

Khuntakata High School, Odisha

Skills

SQL

undefined

Personal Information

  • Father's Name: Mr. Jaladhar Maharana
  • Mother's Name: Mrs. Jayanti Maharana
  • Date of Birth: 02/16/95
  • Gender: Male
  • Nationality: Indian
  • Marital Status: Unmarried

Personal Qualifications

  • MTech(Integrated) in Information Technology, 04/2020, VIT University, Vellore, 7.42
  • BSc. (Chemistry), 06/2015, Utkal University, Bhubaneswar, Odisha, 69
  • Senior Secondary School (SSC), 2012, Gopabandhu Science College, Athagarh, 74
  • Higher Secondary School (HSC), 2010, Khuntakata High School, Odisha, 82

Disclaimer

I hereby declare that all the information provided is correct to the best of my knowledge.

Timeline

SQL Developer

TEKSystems
08.2022 - 01.2024

SQL Developer

Cozentus Technology
06.2022 - 08.2022

SQL Developer

Stonex Group INC.
04.2022 - 05.2022

MTech(Integrated) in Information Technology -

VIT University, Vellore
10.2016 - 03.2020

SQL Developer

Wipro Limited
11.2015 - 01.2021

BSc. (Chemistry) - undefined

Utkal University, Bhubaneswar, Odisha

Senior Secondary School (SSC) - undefined

Gopabandhu Science College, Athagarh

Higher Secondary School (HSC) - undefined

Khuntakata High School, Odisha

Similar Profiles

CREATE PROFILE
Rakes MaharanaSQL Developer