Sql Resume.docx

● 1 Years of Experience as SQL Developer. ● Experience in Creating, Maintaining and tuning views, Stored Procedure, user defined Function and system function using SQL Server. ● Good Experience in Creating SQL Server Database Objects like Tables, View, Procedure, Functions and Triggers ● Having good knowledge of creation and scheduling of SQL jobs to run daily. ● Good Analytical and problem solving skills. ● Ability to grasp new skills and concepts quickly and use them in productive manner. ● Ability to work in both a team environment and individual environment. ● An effective communicator with exceptional interpersonal skills which allowed me to interact with client over phone and emails that result in customer relationship management skills. Work Experience SQL Developer Cogniscient Business Solutions Pvt. Ltd - Noida, Uttar Pradesh February 2018 to Present PROJECTS COMPLETED DURING EMPLOYMENT PERIOD Organization Cogniscient Business Solutions Pvt. Ltd Project Name (Client) Cine city photo equipment Pvt Ltd, Sunil Healthcare Limited, TAG MOTOR LIMITED, Dalmia Continental Pvt. Ltd., TRI-STAR PRODUCTS PVT. LTD (VEGA), Fuji Gemco Private Limited, RHITI GROUP, ACTIA INDIA PVT. LTD., STEELBIRD INTERNATIONAL, Simbij Enterprises Pvt. Ltd, Nazeer Foods Pvt. Ltd., Knitpro International Technology & Tools Crystal Report, SAP B1 PLD, SQL SERVER 2008/2012 Designation Technical Consultant Role Report Development, Support and problem solving Responsibilities ➢ Interacting with Onsite people, Taking clarification Regarding Applications. ➢ Involved in writing SQL Queries. ➢ Designed and Implemented Tables, Functions, Stored Procedure and Trigger. ➢ Performance Optimization of processes, Stored Procedures etc. ➢ Providing fix to the issues identified in the testing phase. ➢ Develop reports using SQL according to client requirements. ➢ Preparing Crystal Report. ➢ Work on some basic Accounting related issues. ➢ Creating SQL jobs.

SQL Developer SQL Developer - Dhii Health Tech Pvt. Ltd ● Having Around 1 year of IT experience in database design, development and support. ● Strong background in SQL Concepts and in T-SQL programming. ● Experience in Transact-SQL (DDL, DML, and DCL) and in Design and Normalization of the database tables. ● Experience in joins and set operators. ● Efficiently worked with Stored Procedures, Triggers, Functions, Cursors and Views. ● Creating the tables with respective keys and indexes so as to improve the performance of the query. ● Experience in Dynamic SQL and complex queries. ● Experience using temporary objects like Table Variables, Local/Global Temp Tables and CTE. ● Have experience in taking Database backups and restores. ● Good knowledge in performance tuning of the T-SQL queries. ● Experience in scheduling and configuring maintenance Jobs using SQL Agent, Windows Task Scheduler. ● Quick learner, hardworking, ability to learn new technologies and positive attitude. ● Dedicated team player, a self-motivated individual, and a faster learner with excellent problem solving skills. Work Experience

SQL Developer

Dhii Health Tech Pvt. Ltd - Hyderabad, Telangana

January 2018 to Present

Academic Career ● B.Tech (Bachelor Of Technology) from JNTU Kakinada, in 2016. Technical Skills Operating Systems Windows 2003/2008/2012 Server, XP RDBMS MS SQL server 2008/2012/2014 Programming Languages SQL, T-SQL Database Tools SSMS, SQL Profiler, SSRS Other Tools Tortoise SVN Projects Project #1

Project H.O.P.E (Hospital Optimum Process Engine) Environment JAVA & MS SQL Server Role SQL Server Developer Database MS SQL Server Description: Hope (Hospital Optimum Process Engine) is a company's own product which is useful for Healthcare domain. The product comes with Patient Record Management, Reports Management, Laboratory, Pharmacy and Inventory. The Patient record management comprises of the Inpatients and outpatients. Laboratory is where the tests are conducted and information is stored and will be part of the bills that will be generated for the patients. Pharmacy and Inventory are the modules where there will be constant watch on the stocks, the inflow and outflow of the medicines or the inventory items. All the activity areas administrative, clinical, financial are integrated into a complete hospital information system that help manage the complete health care organization by automating and improving effectiveness of processes. Responsibilities: ● Making required schema changes, writing stored procedures, functions, adding triggers for tracking data changes in the objects and for Objects/Database drop prevention. ● Written complex queries, Stored Procedures, Views on SQL Server 2008/2012. ● Creating Jobs using SQL Agent, Windows Task Scheduler for Database maintenance. ● Providing support for live issues with 24/7 environment. ● Performance tuning for queries, Stored Procedures by analyzing execution plans and using SQL Profiler. Place: Hyderabad (Kumar Divvi) Date:

SQL Developer

Dhii Health Tech Pvt Ltd - Hyderabad, Telangana

January 2018 to Present Education

Btech in ECE

JNTU, kakinada Hyderabad, Telangana

Bachelor's

Skills sql server (1 year), t sql (1 year), Ssrs (Less than 1 year)

SQL Developer Thorough SQL Developer with strong skills in SQL development and an in-depth grasp of SQL analytics, reporting, and business intelligence. Conversant with T-SQL coding and capable of managing all stages of software development. Markapur, Prakasam, IN To seek challenging tasks and responsibilities and bringing them towards success to grow up my career and best contributed for the growth of the company. Work Experience

SQL Developer

Infocrunch Analytics Pvt Ltd

Present

Understanding the customer requirements and functionality of the application. • Creating stored procedures, functions, packages and triggers for implementing required business logic. • Designing constraints & tables. • Writing complex SQL queries using Inline views, correlated subqueries, joins etc. • Worked on performance tuning using explain plan. • Managing database using Functions, Procedures, Cursors, Triggers, Exception.

DataBase Developer

Infocrunch Campaign Pvt Ltd

Understanding the customer requirements and functionality of the application. • Creating stored procedures, functions, packages and triggers for implementing required business logic. • Designing constraints & tables. • Writing complex SQL queries using Inline views, correlated subqueries, joins etc. • Worked on performance tuning using explain plan. • Managing database using Functions, Procedures, Cursors, Triggers, Exception. Education

BTECH

Bapatla Engineering College Bapatla, Andhra Pradesh

Sadhana Junior College

Loyola High School Skills AACE (Less than 1 year), DATABASE (Less than 1 year), EXCEL (Less than 1 year), MONGODB (Less than 1 year), MS SQL SERVER (Less than 1 year), Data extracting (Less than 1 year), T-SQL coding (Less than 1 year), Data backup and retrieval (Less than 1 year), SQL development (Less than 1 year), Policies and procedures (Less than 1 year), Data analysis (Less than 1 year), Bug tracking (Less than 1 year), SQL analytics (Less than 1 year), Database design (Less than 1 year), T-SQL (Less than 1 year), System backups (Less than 1 year), Troubleshooting (Less than 1 year) Additional Information

SKILLS SUMMARY Operating System MS-Windows Language SQL, MySQL, MongoDB RDBMS MS SQL Server using T-SQL Other Tools MS-Office, MS-Excel PROJECT DETAILS

Organization Name: Infocrunch Analytics Pvt Ltd. Project #1 Survey Management Period May 2017 to till Date. Project Description Survey Management is an application which is used for election survey, Surveyor collect's the opinions from the respondents and different reports are generated using this data. It also help's in managing the surveyor's by the GM's. Role SQL Developer Responsibilities • Understanding the customer requirements and functionality of the application. • Creating stored procedures, functions, packages and triggers for implementing required business logic. • Designing constraints & tables. • Writing complex SQL queries using Inline views, correlated subqueries, joins etc. • Worked on performance tuning using explain plan. • Managing database using Functions, Procedures, Cursors, Triggers, Exception. Organization Name: Infocrunch Analytics Pvt Ltd. Project #2 Constituency Summary Period May 2017 to till Date. Project Description Constituency Summary is an application which is used for election survey, Regional Manager collect's the opinions from the ZillaParishad Members and Taluka members from different parties and Analyze the winning chance of the Candidates in Election. Role SQL Developer Responsibilities • Understanding the customer requirements and functionality of the application. • Creating stored procedures, functions, packages and triggers for implementing required business logic. • Designing constraints & tables. • Writing complex SQL queries using Inline views, correlated subqueries, joins etc. • Worked on performance tuning using explain plan. • Managing database using Functions, Procedures, Cursors, Triggers, Exception.

SQL Developer SQL Developer - Macros Bengaluru, Karnataka Work Experience

SQL Developer

Macros - Bengaluru, Karnataka

July 2017 to Present

• Participate actively in requirement gathering with the client. • Review and analyze the requirement and functional spec document. • Develop detailed technical spec which includes Table structures, Design, System Interface and Scripts.

• Create/Modify required database objects (Tables, Views, Procedures) • Develop required SQL scripts from time to time as per the process enhancement. • Manage multiple automated E-Files, the reports that are sent to the investors on monthly and daily basis. • Solving day to day queries that are being faced by the Investor Reporting team. • Providing Ad hoc data request to trust and other business units internally. Project Exposure in Ocwen: 1. Automation of FHLMC Report - Banks Client FHLMC Skills SQL, PL/SQL, VBA Database Oracle Tools Used Toad, Sql Developer, Macros Team Size 5 Duration 10 Months Description: The automated report was designed for changing the current manual reporting scenario from monthly reporting to daily reporting. Now, this will help the analyst to generate the report within seconds as it automates the system that eventually replaces the manual work. Roles and Responsibilities: • Participated in team meetings for updates. • Develop procedure for Payoff reporting. • Preparing Programmer level test cases. • Developed job to run the procedure at EOD (End of the Day) • Created tables, indexes according to the requirement. • Writing complex queries, cursors, Exception Handling etc. • Develop tool using VBA to fetch data from Oracle database, and stores in ready-to-report excel sheet and vice-versa, from excel sheet to Oracle database. • Responsible for Coding, debugging and ensuring timely deliveries of work requests. • Involved in calls with various business unit. 2. Manual Sweep Client Internal- Investor Reporting Skills SQL, PL/SQL, VBA Database Oracle, MS Access Tool Used Toad, SQL Developer Team Size 1 Duration 2 Months

Description: In the existing Sweep tool, the data came from the dynamics database, so if some day the respective database is slow and not working then analyst used to do the sweep process manually, which used to delayed the production. So, the procedure was made that can process the data same as dynamics does. Now, analyst are able to complete it fast and accurately. Roles and Responsibilities: • Setting up meeting and gathered requirement from the business unit. • Built up the technical spec which includes query build up, table structure. • Developed the procedure that will fetch the data from the tables and perform desired calculations to perform the sweep process and used exception handling in the procedure. • Embedded all the functionalities in MS Access for fetching required data from the procedure to excel using Macros. 3. Sweep Template -PHH Mortgage Client PHH Mortgage Skills SQL, PL/SQL, VBA Database Oracle Tool Used Toad, SQL Developer Team Size 1 Duration 4 Months Description: The project itself has a great importance as it is the most critical process. The procedure was developed which will transfer the money coming from the borrower to the PHH Account and then further to the respective trust accounts. Roles and Responsibilities: • Setting up the meeting with PHH for requirement gathering. • Developed procedure to fetch the amounts and calculate accordingly to transfer it to trust. • Built the template which will run the procedure and will fetch the desired output in the required format. • Creating various checks in template for QC purpose. Company Process: • Currently handling two main process of the company i.e. Loss and Sweep (Transferring of amounts from one account to the another) • On daily basis I have to refresh the production tables and dump the data which needs to be

reported to external investors by other business units. • Need to do the analysis on a weekly/ad-hoc basis that the production data and the dollar amounts are getting updated correctly or not. Skills: ✓ Excellent in building SQL, PL/SQL queries, procedures, packages and triggers. ✓ Hard worker and result oriented. ✓ Ability to work under pressurized situations. ✓ Enthusiast to take up new challenges. ✓ Proficient to communicate clearly and effectively. Education

B. E. in CSE

Chitkara University

January 2014 to January 2018

Class XII

Guru Nanak Mission Public School

January 2013 to January 2014

Class X

Guru Nanak Mission Public School

January 2011 to January 2012

University or Board