Free Essay

Resume

In:

Submitted By manasavuyyuru93
Words 1001
Pages 5
Professional Summary: * Extensive Experience in MS SQL Server 2005/2008 and 2000 Database Administration and PL/SQL developer in Business Analyst including Planning, Deployment / Implementation and configuration. * Extensive experience in writing Complex Stored procedures as well analyzing and debugging existing complex stored procedures. * Successfully led, executed and maintained projects with multiple databases. * Implementing all kinds of SQL Server Constraints (Primary, Foreign, Unique, Check etc). * Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries * Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs) * Proficient in creating T-SQL (DML, DDL, DCL and TCL), Indexes, Views, Temporally Tables, Table Variables, Complex Stored Procedures, System and User Defined Functions . * Strong experience in creating complex Replication, Index, Functions, DTS packages, triggers, cursors, tables, views and other SQL joins and statements. * Expertise in Client-Server Application Development using Oracle […] PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. * Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem * Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations. * Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Trouble shooting, and Database Objects authorization. * Strong problem solving skills, good communication, interpersonal skills and a good team player. * Have the motivation to take independent responsibility as well as ability to contribute and be a productive team member. * Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.

TECHNICAL SKILLS: * Operating Systems | Windows7,Windoes8,Windows2003 Enterprise, XP Professional and Windows 2000, UNIX | Languages | Java, C, C++, SQL, HTML,XML | Databases: | Oracle PL/SQL, SQL developer, MS SQL SERVER 2008/2005 | Database Tools | SQL Coding, SQL Query, SQL Enterprise Manger, SQL Server Management Studio, SQL Mail, SQL Client Utility, TOAD | ETL Tools | Microsoft Integration Services (SSIS), SQL Server Analysis Services(SSAS) |

Project Summary Inovalon, Melford, MD SQL Server Developer Feb’15 – Till Date Description: Inovalon is a cloud-based analytics and technology to help clients achieve insights that improve clinical and quality outcomes, utilization, and financial performance in the field of healthcare. The purpose of project was to develop the gap identification and resolution solution for Medicare Advantage, managed Medicaid, commercial and dual eligible health plans and it improves care and insight that drives greater risk score accuracy, utilization efficiency, membership satisfaction and quality.
Roles and Responsibilities: * Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database. * Optimized the performance of queries with modification in index system for online system. * Wrote triggers (After and Instead Of) and stored procedures to capture updated and deleted data from OLTP systems. * Created and modified Reports using Crystal, Business Objects and Discoverer as per the business requirements * Defined relationships using primary keys and foreign keys for the entities and normalized the entities * Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic. * Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS). * Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS. * Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS. * Responsible for ongoing maintenance and change management to existing reports and optimize * report performance in SSRS-2008. * Used Reporting objects like Tabular, Matrix, Sub Reports, Parameterized reports using SSRS 2008. * Designed and developed monthly, Bi- Weekly, Tax Reports for our Clients * Participated in Databases Architecture and data modeling design. * Interacted with the Business Admin and gather the requirements and analyzed them. * Performance tuned of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard. * Tracked all enhancement requests and reported performance problems via electronic ticketing system (Remedy). * Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player

Environment: MS SQL Server 2008 R2, SQL Server Integration Services, SQL Server Reporting Services, SQL Query Analyzer, T SQL, PL/SQL, SQL Server Index Tuning Wizard, Visual Studio 2005, Windows 2008, MS Office 2007.

HDFC, India June’13 – July’14
Jr. PL/SQL Developer
Description:
HDFC Bank provides different financial services. The scope of the project that I worked on was to facilitate in the maintenance and development of the application, which supported personal banking on wealth management, asset management dealing with different types of accounts and services.
Responsibilities:
* Developed various Oracle PLSQL packages, functions, procedures for process design and extensions. * Created Daily, Weekly, Monthly, Quarterly, Yearly Reports and Several Complex Reports for Group Finance and Payables using PLSQL Procedures. * Used SQL Developer to Load / Extract data into and from Excel files. * Extensively used Dynamic SQL for DDL and DML commands in PL/SQL. The procedures are built to generate reports with dynamically varying conditions based on the input parameters passed. * Used SQL Analyzer and Profiler analyzing the SQL statements and procedures. * Created Schema Objects such as tables, views, maintained referential integrity and granted roles to the Users. * Developed internal reports using SSRS. * Created different Data sources and Datasets for the reports. * Extensively involved in various phases of testing the products before migrating Production, from Unit testing through regression, UAT and performance testing. * Expertise in Loading in multiple tables data and able to use merge statement of conditional. * Created ETL mechanism to transform the data from OLTP source to the newly created OLAP model. * Loaded flat file using as SQL *LOADER into database. * Used TOAD & SQL Developer for debugging application. * Trained a team of junior developers. * Created detailed technical documentation.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, SQL Server 2008, SQL *Loader, SSMS, SQL Query Analyzer, UNIX, UNIX Shell Script.

Similar Documents

Premium Essay

Resume

...Do you know how huge of a role a resume has in an individual’s life? Resumes play imperative roles and they are the best recommendation. Having a resume during interview times are very crucial and being sure that it includes the main parts an employer seeks is just as important. The benefits of having a resume can be tremendous and also hugely impact the future of an interviewee. Having a clear understanding of what to include in a resume is the first step in preparing a resume. A resume is a document that summarizes your education, skills, talents, employment history, and experiences in a clear and concise format for potential employers. Being sure to meet an employer’s expectations by incorporating the main parts of a resume is an advantage over those who do not. When preparing a resume be sure to include your contact information, objective or goal, work experience, and education. There are many different formats for preparing a resume, but most employers prefer the Reverse Chorological resume format. The contact information is the first part of a resume a potential employer sees. Including your contact information would definitely be one of the most important parts of a resume. If you don’t include your contact information, then how can the employer contact you to set up for an interview? So, be sure that your current information is available for the employer. This section of a resume is often located at the top of your document. Contact information should include your full...

Words: 440 - Pages: 2

Free Essay

Resume Instruction

...capacity and experience/ interest in my particular industry What traits do I looking for in successful employees? The obvious things: Critical reasoning, team player, organization, multitasking… BUT, also Understanding your place Doing what they are told with very little oversight Finding he little ways to add value Key point: In order to gain my tryst in solving the big problem, one must be able to execute the small things well Brass Tacks Understanding the process “Weeding out” process: Step 1: 100-90 Missing or inconsistent information Step 2: 30 seconds scan of resume- who can I throw out 90-25 Typos-Yikes! No fit/ no skills Poor organization Key insight: I will have spent very little time evaluating many candidates before I weed them out Saying the wrong things Ex: B.A. Economic[s] Key insight: The cover letter and resume must be perfect. Typos and grammatical mistakes will not be tolerated. Period....

Words: 908 - Pages: 4

Premium Essay

Technical Resume

...When an employer looks at your resume, you've got about 6-10 seconds to make a good impression. To capture the reader's attention, you need to be clear and to-the-point. Be Organized and Logical In addition to reviewing your experience, employers also use the resume to sense whether you are organized, logical, and concise. Make sure your resume is balanced, neat, visually appealing, and flows consistently. Clearly separate sections and emphasize section titles. Keep a Positive Tone Your resume should present you in the best possible light. If you don't possess every skill an employer is seeking, do not emphasize your shortcomings. Focus on what you can offer. Combine Sections When Possible Try to combine any short sections together to make your resume more compact. For example, if you only have one entry under training, consider placing it under your education instead and change the section title to "Education and Training." Use Common Section Headings Use common section headings. Examples: Objective, Experience, Employment, Work History, Skills, Summary, Summary of Qualifications, Accomplishments, Achievements, Capabilities, Education, Professional Affiliations, Publications, Licenses and Certifications, and Honors. Be Concise and Omit Irrelevant Information Employers don't want to read a long, drawn-out version of your life's accomplishments. They have stacks of resumes to read, and want to know quickly whether or not you would be a good fit for their company. So, be clear and...

Words: 1126 - Pages: 5

Free Essay

International Resumes

...Mexico: http://www.learn4good.com/jobs/customer_service/e/192731/search/guadalajara/ Israel: http://www.learn4good.com/jobs/customer_service/e/181381/search/tel-aviv/ UAE: http://www.learn4good.com/jobs/customer_service/e/157668/search/ras-al-khaimah/ Differences in resume, cover letter and email formalities internationally: For starters the term resume can also be referred to as a “CV” or curriculum vitae, which is typically the same thing as a resume except CV’s are normally two pages long and with multiple attachments. Cover letters as referred to in the U.S have multiple names internationally like letters of interest and motivation letters. Regardless of the name the process is still the same however typically self-photos of the applying individual are attached to a cover letter, resume or both whereas in the U.S, photos are not appropriate attachments when looking for employment. It is also important to remember that paper sizes differ in other countries so altering your document size will be necessary if you want all your information to come through, otherwise your resume, fax, email etc. may have some missing information when viewed or printed out. It is ideal to send both a resume in English and the language of the country in which you are applying to. You may even need to prepare yourself to be interviewed in both languages (Thompson,...

Words: 1402 - Pages: 6

Free Essay

Try English Resumé

...fr/langues/anglais/cv/cv/CV.htm Specific features of Anglo-Saxon CVs compared to French CVs There isn’t 1 type of CV in English but many types: things vary from country to country 2 distinct trends: UK & USA => Adjust according to your objective + be as consistent as possible If you want your CV to catch a recruiter’s attention, it must be clear & easy to read (type size: 10-12) CV = showcase => show you’re rigorous, concise, that you master word-processing tools, that you can use the spell-checker Aspects common to all Anglo-Saxon CVs ( CVs are word-processed (never handwritten - it’s the same for letters) ( Their length varies: UK not limited to 1 page (but be as concise as possible because concision = valuable skill) / USA resume = 1 page but CV = as many pages as necessary ( Write your first name first, your family name second (e.g. Jean-Luc LEBRETON) ( Add +33 before your phone number  ( There’s no photo (unless specifically required) ( Some CVs have a SKILLS section at the top http://www.quintcareers.com/transferable_skills.html Use action verbs rather than noun ( The EXPERIENCE / EMPLOYMENT part must be detailed French people value academic achievements whereas English-speaking people favour effective skills. Have your placements / internships + student jobs in this part This part often comes before the EDUCATION part ( Use verbs of action achieved, arranged, assisted, co-ordinated, completed, dealt with, developed, established, expanded, handled...

Words: 641 - Pages: 3

Premium Essay

How to Write a Resume

...! ! Andrea Sanchez Professor Peter Wegner English 301 12 August 2013 ! ! ! ! ! “How to Write A Resume”! Do you want a job but not sure where to start ? You will need to know how to write a resume that is effective and will give the results you want. Let’s start off with determining what the purpose of a resume is. The purpose is to obtain a interview and ultimately get a job or internship. It is very important to be selective in the information you place in your resume and include details that are only relevant to the employer and the position. Avoid using pronouns and articles (a, an, the) whenever possible. ! The formatting of a resume is important and provides the information needed in a logical, easy to read sequence. When using underlines, italics, bold, and all caps it helps guide the employer through the resume with ease. A key word is consistency which makes the information on the resume simple for the employers to read. Including personal information is a highlight in your resume. The employer wants to know your name, address, phone number, and email address on the top of the first page of your resume. Personal information such as religion,age, political affiliation,and martial status are not included on a resume. There are considered illegal questions for the employers to ask. ! An objective also needs to be a part of your resume which can immediately help identify the position to which you are applying. You can also include a summary of qualifications...

Words: 1187 - Pages: 5

Premium Essay

Vault Guide Resumes, Cover Letters & Interviews 2003

...Library Journal “The granddaddy of worker sites.” – US News and World Report “A killer app.” – New York Times One of Forbes' 33 “Favorite Sites” – Forbes “To get the unvarnished scoop, check out Vault.” – Smart Money Magazine “Vault has a wealth of information about major employers and jobsearching strategies as well as comments from workers about their experiences at specific companies.” – The Washington Post “A key reference for those who want to know what it takes to get hired by a law firm and what to expect once they get there.” – New York Law Journal “Vault [provides] the skinny on working conditions at all kinds of companies from current and former employees.” – USA Today VAULT GUIDE TO RESUMES, COVER LETTERS & INTERVIEWS © 2003 Vault Inc. VAULT GUIDE TO RESUMES, COVER LETTERS & INTERVIEWS HOWARD LEIFMAN, PhD, MARCY LERNER AND THE STAFF OF VAULT © 2003 Vault Inc. Copyright © 2003 by Vault Inc. All rights reserved. All information in this book is subject to change without notice. Vault makes no claims as to the accuracy and reliability of the information contained within and disclaims all warranties. No part of this book may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Vault Inc. Vault.com, and the Vault logo are trademarks of Vault Inc. For information about permission to reproduce selections from this book, contact Vault Inc.150...

Words: 46382 - Pages: 186

Premium Essay

Human Behavior

...Goodbye Miss Gloria Tadino was mildly surprised whe she found 50 resumes on top of her desk. The resumes attachments to applications for a single job opening that was advertised in a newspaper a few days ago. The position vacant is for an encoder. Gloria, still single, was hired by the company and is currently the recruitment supervisor in the human resources department. The resumes of applicants on her desk indicate her most recent assignment. She was ordered to analyze them and prepare a shortlist of ten names who will be interviewed by the committee headed by the manager of the human resources department. Gloria took a good look at the requirements for the vacant position which consist of the following: 21-26 years old, graduate of B.S. in Computer Science, and a resident of Manila. Gloria found out that thirty of the applicants did not meet the requirements, so their applications were set aside. Still, Gloria needs to eliminate ten more. She was in a quandary and she could not make up her mind on who would be eliminated. As Gloria was shuffling the resumes, she noticed one with a name similar to her ex-boyfriend’s. She said to herself “I don’t want to work with someone who has this name,” and she took out the resume and set it aside. She has nine more names to go. Next, she noticed that five applicants graduated from the university where his boyfriend is an alumnus. She set aside the five resumes. With the last four, she agonized in trying to find a reason for weeding...

Words: 336 - Pages: 2

Premium Essay

Khaarus

...for Organization Name to view more information about the employer. If Submit Resume is available above, click it to submit your resume directly to this employer. If it is not, please read the Application Instructions below for details on how to send your resume to the employer. No of Openings: 1 Wage/​Salary: $10.00-$13.00 Per Hour Job Description: Busy ENT office seeking Medical receptionist with a minimum of 1 year experience. Candidate must have knowledge and experience using EMR or other electronic medical record software. Job duties include, but not limited to: *Patient registration *Appointment scheduling *Answering telephone calls as well insurance verification. Qualifications: Qualified candidates must possess excellent interpersonal communication skills, customer service skills, and telephone etiquette. High school diploma Must be able to perform in a high-pressure environment and have the ability to organize multiple tasks and prioritize responsibilities. How to Apply: Candidate must be highly motivated, flexible, detail-oriented, a multi-tasker and have a great personality and communication skills. In order to be considered for this position, candidates must provide a cover letter with hourly rate requirements, resume and references. Inquiries without direct medical experience or the required documentation need not apply. Resumes may be emailed to jpage@rontalclinic.com or faxed to 248-737-0636, Attn: Office...

Words: 279 - Pages: 2

Free Essay

Life Sucks

...How to Write the Perfect Resume By Vivian Giang and Melissa Stanger | Business Insider – Fri, Nov 30, 2012 10:30 AM EST * Email0 * * * Share27 * * Print It takes recruiters an average of "six seconds before they make the initial 'fit or no fit' decision" on candidates based on resumes, according to research conducted by TheLadders. With this kind of competition, you need to have a flawless resume to get through the screening process. We write a lot about resumes — what to do, what not to do — so now we're introducing a guide to crafting a curriculum vitae that will get you into the interview room. However, these rules are general advice we compiled from career experts. Everyone should tailor their own resume depending on the industry they're in and the position they're applying for. Tailor your resume to the specific position you're applying for. elizabethdaniellephotos / statigr.amYou're basically selling yourself on that piece of paper, so mold the information to reflect what your potential employer is looking for in an ideal job candidate. This is different depending on your industry. Miriam Salpeter advises in U.S.News & World Report that candidates should study the company's web site and "look for repeated words and phrases, taglines, and hints about their philosophical approaches." Then, "mirror some of their language and values in your resume." Put your name and contact info at the top. Business InsiderThis sounds simple...

Words: 916 - Pages: 4

Free Essay

Afgh Ghga

...Letters While your resume is a summary of your credentials, your cover letter should essentially be a sales pitch. Your aim is to demonstrate why your skills and your background make a perfect match for the position you're applying for. The cover letter is not the place to summarize your background--you have already done this in your resume. Remember, employers typically receive hundreds of resumes for each job opening. You must stand out from other job seekers in a positive way. The best way to distinguish yourself is to highlight one or two of your accomplishments or abilities that show you are an above-average candidate for this position. Stressing only one or two unique attributes will increase your chances of being remembered by the recruiter and getting to the interview stage, where you can elaborate on the rest of your accomplishments. You can also gain an extra edge by showing that you have some specific knowledge about the company and industry. This shows that your are genuinely interested in the job you are applying for--and that you are not blindly sending out hundreds of resumes. More importantly, the employer will view your interest as an indication that you are likely to stay with the company for a substantial period of time if you are hired. 10 Key Details to Remember When to send a cover letter: always mail a cover letter with your resume. Even if you are following up an advertisement that reads simply "send resume," be sure to include a...

Words: 1976 - Pages: 8

Free Essay

Sergtsey

...December 14, 2011 St. Michael’s Hospital – Report St. Michael’s hospital has one of the largest patient amount in Toronto. They have also received many awards, such as the 3M Health Care Quality Team Award, which shows that this hospital cares for all patients and treats everyone with the utmost respect. This hospital is also affiliated with the University of Toronto, which allows most of their graduates to begin working or enhance their working experience inside St. Michael’s hospital. Most of their recruitment happens internally, meaning they have job postings inside their facility and keep it there for a minimum of one week. This gives opportunity for everyone to join and enough time to send in resumes and cover letters, making it a great hospital to apply to. When reviewing resumes, the first item that Human Resources looks for is the individual’s qualifications (schooling, certain degrees). This is the minimum they look for, and if they do not meet these qualifications, they will be rejected. When looking for outstanding employees, they look for the individuals missions and values, which are in par with what the hospital looks for in their current employees. Work experience, as well as being a good team worker will also increase your chances of being hired in St. Michael’s hospital. The HR representatives of the hospital also do a technique...

Words: 1185 - Pages: 5

Premium Essay

Globalization

...রাত ১২ টা ২২ মিনিটে মনে হল Job Interview নিয়ে কিছু কথা বলি । আমি একজন International MBA Student. আমি আমার কিছু Experience বাংলাদেশের বন্ধু, শুভাকাঙ্ক্ষী তথা সবার সাথে Share করতে চাই যারা পড়াশুনা শেষ করে চাকরীর সন্ধানে বের হবেন । যার জন্য Post টি বাংলায় লেখা । এই Post-টি তাদের জন্য উৎসাহ যোগাতে পারে নিজে কিছু করার, যারা মনে করেন শুধু মামা-চাচা-খালুরাই পারে Job দিতে । Post-টি ৩-টি পর্বে ভাগ করে প্রকাশ করা হবে । পর্ব-০১ ১। আগে নিজে মনে মনে চিন্তা করুন আপনি কোন Sector এর জন্য উপজুক্ত, সেই অনুযায়ী চাকরী খোঁজার চেষ্টা করুন । ২। চাকরী খোঁজার আগে আপনার CV/Resume টি খুব Unique ভাবে তৈরি করুন । এজন্য Google / youtube অথবা আপনার পরিচিত কোনো ওয়েবসাইট ব্যাবহার করতে পারেন। এই কথাটি বলার কারন হচ্ছে, CV/Resume format প্রতিনিয়ত change হতে থাকে । HR officer রা সবসময় Updated থাকেন এসব ব্যপারে । সুতরাং তাদেরকে বোকা বানানোর কোনো অবকাশ নেই । ৩। যেকোনো Companyতে CV ছাড়ার সময় অবশ্যই Cover Letter সংযুক্ত করতে ভুলবেন না । ৪। একটি Formal mail id ব্যাবহার করুন। mylollypop@gmail.com / hotchick69@msn.com এ জাতীয় মেইল আইডি ব্যাবহার না করাই ভালো । ৫। Job agencyর সাথে নিজেকে সম্পৃক্ত রাখুন । Company website গুলতে প্রতিদিন চোখ রাখুন, বিশেষ করে তাদের Career Section । http://www.prothom-alojobs.com/ এক্ষেত্রে আপনাকে সাহায্য করতে পারে । ৬। উন্নত বিশ্বে Job খোঁজার অন্যতম একটি কৌশল Door to door knock । তার মানে হচ্ছে আপনি রাস্তা দিয়ে চলার পথে কোনো Company দেখলে ভয় এবং লাজ-শরমের মাথা খেয়ে ভেতরে প্রবেশ করবেন । ২-১ পেইজের CV টি কোনো Officer / Receptionist / Manager এর হাতে দিবেন এবং তাকে অনুরোধ করবেন আগামিতে...

Words: 314 - Pages: 2

Premium Essay

Case Study

...Samuel Smoot 02/16/2016 HR Case Study #1 Overview The three most appropriate selection methods in the hiring process I think would be best would be the Resume/ Curriculum vitae review, Application form and formal interview. Since I have been in the working field, these three methods have been used each and every time for my hiring process. I believe that these three methods are more so traditional used and very effective in selecting the right candidate for a company. I will give an overview on each selection method I have listed and how it would be effective in the hiring process. Resume/ Curriculum Vitae Review The Resume or Curriculum vitae review (as known as the CV) is a summary of a potential candidate’s work experience, education, skills and references. There are different kinds of CV’s that can be used, A Chronological CV, A functional CV and a combined CV. A Chronological CV focusses on presenting the candidate’s experience on an employer by employer basis, with the posts being listed in reverse chronological order. It also contains detail of education and qualifications, together with hobbies. Some chronological CVs also contain a brief personal statement at the front which sets out the key skills and strengths of the candidate. This is the most common type of CV. (Adenle, 2016). A functional CV highlights and shows off a candidate’s skills and abilities rather than work history. It more so used when a candidate doesn’t...

Words: 804 - Pages: 4

Free Essay

Business

...Dear Mr. Samuel I am writing to apply for the manager position advertised in the Jobsearch.com. As requested, I am enclosing a completed job application, my resume and references. The opportunity presented in this listing is very interesting, and I believe that my strong experience and education will make me a very competitive candidate for this position. The key strengths that I possess for success in this position include: ● With a bachelor degree in Finance BBA (Bachelor Business Administration) at Azerbaijan University, I have a full understanding of the human development project. I also have experience in learning and excelling at new business techniques as needed. ● I have experience building large, sustainable, customer-based collaboration with famous companies. I understand the social value of the non-profit sector and hope that my business experience will be an asset to your organization. I am confident that my skills and past experience could make great contributions to your organization. Therefore I would appreciate the opportunity to discuss my qualifications for this position in greater detail with you in person at your earliest convenience. At last I am honored to working under you and join to your team. Please see my resume for additional information on my experience. I can be reached anytime via email at orxanss@yahoo.com or my cell phone, (+99450) 7245456 Thank you for your time and consideration. I look forward to speaking with you about...

Words: 321 - Pages: 2