Santosh Kumar Email & Phone Number

Hyderabad, Telangana, India

Drafts and executes quality SQL data scripts and queries for production data updates and reporting.• Manages data change request aspects of the endpoint eDRS system.• Reviews change requests for clarity, completeness, and impact.• Collaborates with Client Services and customers as needed to ensure database updates are made in the spirit of the original request.• Manages and continuously updates Data Management best practices.• Reviews Data Management Plan Specification for quality, consistency and feasibility.• Verifies database lock, project archives and the client-related documents.• Collaborates with IT and implementation team to address Clinical application requests and/or changes to Clinical database systems

Hyderabad, Telangana, India

• Day to day management and direction of studio operations.• Ensuring the studio remains clean, orderly, and efficient.• Coordinating the flow of product and virtual assets through all stages of the studio workflow.• Implementing studio-wide safety programs.• Works with Producers on scheduling and weekly workflow for product photographers.• Production support on both large and small budget studio shoots for photography and product videos.• Schedule repairs of camera and lighting equipment.• Oversee check-in and check-out of video and photo equipment via Cheq room. Prep equipment for location shoots.• General utility – Maintenance/Cleaning of camera and lighting equipment after a location shoot.• Install, operate, maintain or troubleshoot technical equipment.• Using systems/data to track and plan for volume and flow of product that requires imaging.• Collecting and analyzing data and testing solutions for process improvements and new initiatives- Verification of billable requests are quoted/PO’ed and billed.- Stage Billing- Facilitate billing for power usage, stage manager OT,engineering (billable hours or power hookups), security and other billableproduction services.**Preparation of Wrap Reports using Power BI Dax functions.• Creation of Databases, Tables for production data (Monthly),Stock Inventory, Servicing Equipment's List by using SQL SERVER.•Entering Production Data, Stock Inventory Data, Servicing Equipment's List into those tables on daily basis• Modifying Existing tables and Improves performance of MS-SQL stored procedures.• Performed several transformations and data cleansing on data including various transformations.• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Ability to write complex SQL queries.• Knowledge in performance tuning, Query optimization, Database creation, maintenance, monitoring, Import/Export wizard, backups and recoveries.

Hyderabad, Telangana, India

Working with GAMMA, COMPANIES HOUSE, HOOVERS tools and doing 3 checks for sales data.1. searching given company from given list using company’s house (data base for companies) if it is active company type..2 searching company .in gamma (it is internal tool having data of sales persons and assigned companies).if Company is assigned to any sales person3. Searching given company subsidiaries in HOOVERS website and researching subsidiaries in gamma• Sales persons Accounts addition in gamma.• Preparation of daily reports using VLOOKUP &PIVOTTABLES.• Responding to queries raised by SALES TEAM• Preparation of charts using excel.Working with conditional formatting and date and time functions in excel.

Hyderabad Area, India

• Assigning jobs & creation of jobs to recruiters by JOBDIVA TOOL• Posting of new jobs using FILED GLASS• Interacting with relevant managers regarding approval of job.• Rejecting profiles in duplicate scenarios• Preparation of daily reports using excel formulas VLOOKUP, SUMIF, COUNTIF.• Resolving recruiter queries by outlook and assigning jobs in case of emergency• Preparation of monthly reports using pivot tables.• Preparation and joining tables using joining conditions in SQL.• Preparation of weekly presentations using POWERPOINT.• Working with MAILMERGE in word for preparation of letters.

Hyderabad, Telangana, India

PROJECT: ISSUE RACKER(Windows Project)**Creating tables for customers data as per client requirement using SQL SERVER 2008. Performing data cleaning in Excel operations like concatenate, text to columns, Left, Mid, Rightfunctions, VLOOKUP function in multiple work sheets, data validation, data consolidation.• Managing large datasets with functions: IF condition, sum if, countif, INDEX, MATCH, VLOOKUP• Manipulating DATE, TIME, TEXT functions• Task automation using MACROs• Preparation of daily reports using VLOOKUP & SUMIF & COUNTIF & PIVOT Table• i have knowledge on the latest EXCEL 365 functions like CONCAT function, TEXTJOIN function,MAXIFS function, MINIFS function, IFS function, XLOOKUP function, FILTER function• New chart types like MAP chart, WATERFALL chart, FUNNEL chart, HISTOGRAM chart• smart data types: STOCKS, GEOGRAPHY• Improves performance of MS-SQL stored procedures.• Performed several transformations and data cleansing on data including various transformations.• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Ability to write complex SQL queries.• Knowledge in performance tuning, Query optimization, Database creation, maintenance, monitoring, Import/Export wizard, backups and recoveries.*working with Joining conditions and creation of triggers.Preparation of forms using C# Grid View.

• Creation of tables using SQLSERVER • Worked with JOINS,VIEWS,STORED PROCEDURES,INDEXES in SQL• Using ADO linking Microsoft Access with database servers using SQLSERVER • Modifying macros based on the suggestions by the client optionally• Ability to solve complex problems, strong analytical skills and the ability to trace issues to the root source.• Improves performance of MS-SQL stored procedures.• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Ability to write complex SQL queries.• Knowledge in performance tuning, Query optimization, Database creation, maintenance, monitoring, Import/Export wizard, backups and recoveries.• Very good at writing unit test cases and rendering unit test results.• Good knowledge on writing Sub queries, Joins, Set operations and stored procedures.• Work with QA team on fixing data quality or process bugs.• Met with clients to determine and articulate project scope and expectations.• Designed and implemented stored procedures views and other application database code objects.• Performed quality testing and assurance for SQLSERVER.• Responsible to support issues in application on the enterprise environments (Development, UAT, Testing and Production).• Having client interactions on daily to resolve the production breakages.* Providing Technical Training to Teams

**Interacting with Clients and providing Electronic Data Capture Machines in rental basis.**Collecting Proper Documents from customers.**Preparation of Reports for Sales data .**Interacting with service team in case of Client Issues.

Hyderabad Area, India

**Verification of equipment's after pasting asset ids to it.**Preparation of various documents which includes Technical documentation &Preparation of reports using Excel sheets.**Preparation of variuos electronic circuits.***Trouble shooting of equipment's**Preparation of S.O.P for equipment's**Supporting for administrative tasks**Procurement, Office Inventory**Technical training

Hyderabad, Telangana, India

 Verification of equipment's after pasting asset ids to it. Preparation of various documents which includes technical documentation &Preparation of reports using Excel sheets. Preparation of variuos electronic circuits Trouble shooting of equipment's Preparation of S.O.P for equipment's Supporting for administrative tasks Procurement, Office Inventory Technical training Interacting with service vendors in case of any issues

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering

Intermediate, Mpc

S.S.C, Ssc