Experience

• 

  Tata communications transformation services (tcts)

  Jan 2012 - Dec 2013

  Graduate engineering trainee

  Client : Cable and WirelessRoles and Responsibilities:• Strong analytical and problem-solving skills with ability to clearly articulate solution alternatives.• Create reports and write small programs to test and analyze the database.• Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.• Create, manage, analyze the data in a regular basis • Monitored database system details within the database, including stored procedures and execution time.• Created the backup and restore strategy for production, development and test environments.• Manage data from the beginning to the end on a project basis• Responsible for all the data inside the database, taking frequent backup of the database, to make sure that data is not lost and keep records of the archives.• Identify performance problems and modify databases to improve performance.• Assist developers with all the database activities.• Preparing specification documents for the users. Show less

• 

  Actalent

  Jan 2014 - Aug 2014

  Sql developer

  Title : TelecomOrganization: EASi EngineeringClient : Atlantic Engineering Group (Google)Duration: Jan 2014 to Sep 2014Environment: Database-Microsoft SQL Server 2008/2012, SQL Server Reporting Services (SSRS) /, SQL Server Integration Services (SSIS).Description GIS application is developed for Atlantic Engineering Group, which is one of the telecom service provider leaders globally. It provides various types of services in the United Kingdom.Roles and Responsibilities:• To document the business process by identifying the requirements.• Created numerous ordinary to complex queries involving multi-table, Unions corelated sub- queries, CTE’s and views for diverse business requirements.• Development of Stored Procedures, Functions, Triggers, Views.• Involved in all phases of the project (Documentation, Designing, Unit Testing and Defect fixing).• Providing permanent fix on recurring issues.• Created various reports like parameterized, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS).• Loaded the data using the SQL Loader, Imports & UTL Files based on file formats. Show less

• 

  Tata consultancy services

  Sept 2014 - Jun 2022

  Client :Digital RealtyRoles and Responsibilities:• Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports and Dashboard reports using SSRS.• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks• Performed Optimization and Performance Tuning SQL Scripts to make reports run smoothly and efficiently.• Scheduling reports using reporting services to Email with an attachment in the desired format of the report to the top management.• Involved in all phases of the project (Documentation, Designing, Unit testing, and Defect fixing)• Created and monitored the job process for daily, weekly and monthly based on the business requirements.• Involved in job scheduling and alerts.• Imported data from different source using SSIS package.• Acting as Team Lead managing a small team of developers with requirements gathering, technical guidance and mentoring/coaching them.• Involved in gathering business requirements from the clients and translating it to the technical requirement for the team.• Excellent communication skills and stakeholder management. Good team player. Show less Client: WellsFargoRoles and Responsibilities:• Worked with Business Analysts to understand the requirements• Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT and Production Move)• Perform ETL processes using SSIS tool for SQL Server• Design/Develop complex queries efficiently as per the given business requirements• Created database fact/dimension tables, views, stored procedures, functions and triggers are required.• Identify columns for Primary Keys in all the tables at the design time and create them.• Worked with Business users to understand the Business Logics as per the need.• Develop views, sub-queries and joins for complex queries involving multiple tables. Created joins and sub-queries for complex queries involving multiple tables.• Loaded flat files (4GB) data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.• Generated reports using SQL server reporting services (SSRS).• Design/Develop Test Plans, Test Cases and documentation of various processes involved.• Generated various reports like parameterized, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS) for various projects.• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.• Documentation of all the processes involved in maintaining the database for future reference.• Communicate effectively and clearly, in writing and verbally, in one-on -one and group presentation situations.• Strong ability to effectively lead a team. Show less

  • Senior ETL Developer

    Apr 2017 - Jun 2022

  • Data Analyst

    Sept 2014 - Apr 2017
• 

  Ernst & young global consulting services

  Jul 2022 - now

  Lead financial analyst

  Team : Supply Chain Services- Travel Meetings & Events• Developed Stored Procedures to generate various Dashboards for TM &E Team using PowerBI.• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks• Performed Optimization and Performance Tuning SQL Scripts to make reports run smoothly and efficiently.• Involved in all phases of the project (Documentation, Designing, Unit testing, and Defect fixing)• Created and monitored the job process for daily, weekly, monthly based on the business requirements.• Imported data from different source using SSIS package.• Involved in gathering business requirements from the clients and translating it to the technical requirement for the team.• Excellent communication skills and stakeholder management. Good team player. Show less