Preview

Vacation

Good Essays
Open Document
Open Document
1958 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Vacation
[pic]

MANI CHOWDARY Email: ramravi207@gmail.com Phone: 216-264-6066

PROFESSIONAL SUMMARY: • Over 7 years of Experience in Designing, Developing, Maintaining Client/Server and Business Intelligence (BI) database applications using SQL Server 2008R2/2008/2005/2000/Integration Services (SSIS)/Analysis Services (SSAS) /Reporting Services (SSRS). • Expertise in creating complex T-SQL Stored Procedures, (DML/DDL) Triggers, User Defined Functions, Cursors, Views and indexes (Clustered, Non Clustered, Unique) maintaining ACID rules and database normalization. • Extensive knowledge of Relational Database Management Systems (RDBMS). • Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures, triggers, views, functions and cursors using SSMS & SQLCMD. • Extract, Transform and Load (ETL) data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS & SSIS packages. • Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues. • Extensively worked in migrating (ETL) data from Excel, Oracle, CSV file sources to Oracle, DB2, Sybase and MS Access, MS SQL Server and vice versa by using Data Transformation Services (DTS), Import/export data, Bulk Copying Program (BCP) and SSIS utility. • Expert in creating jobs using SQL Server Agent to schedule, configure and deploy SSIS Packages daily/weekly basis which generate Alerts, Mail (SQL Mail Agent) when having errors. • Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan,

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Trained 5 database managers in the proper procedures for managing the functions, to understand ambiguity resolution and the uncertainty issues.…

    • 478 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below:…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    CMGT 400 Week 1 DQs

    • 676 Words
    • 3 Pages

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    cis3730_Exam1_Studyguide

    • 512 Words
    • 2 Pages

    You will be asked to write SQL scripts to display required information, like we did in the homework.…

    • 512 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Cis 515week 3

    • 1024 Words
    • 4 Pages

    Having data to base decision on is an important step in improving the business model and utilizing business intelligence to improve functions and services is critical to that end. In this case, the university can utilize business intelligence reports to forecast enrollment increases and decreased based on historical data. In many cases, “BI tool helped to use data and trend analysis to…

    • 1024 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Given a set of guidelines and tools, explore how project work and development can be enhanced and improved with proper structure and formality.…

    • 1818 Words
    • 8 Pages
    Better Essays
  • Good Essays

    Cis 111

    • 790 Words
    • 4 Pages

    (2012). Database systems: Design, implementation, and management. (10 ed.). United States of America: Joe Sabatino.…

    • 790 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    DBM 380 Syllabus

    • 623 Words
    • 4 Pages

    This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration.…

    • 623 Words
    • 4 Pages
    Satisfactory Essays
  • Better Essays

    In this paper the writer will seek to respond to the questions designated for both scenarios. This paper will list typical fields for each type of data. Provide an example of two relationships that you need to track. This paper will also answer the questions of: Do you need a database system? If not, can Excel® handle the data and the output? What are the advantages and disadvantages? Would you use a personal database or an enterprise database? Explain your answer. Would a decision support system (DSS) be helpful? Explain your answer.…

    • 1392 Words
    • 6 Pages
    Better Essays
  • Powerful Essays

    IT Solutions

    • 2079 Words
    • 12 Pages

    Identify suitable business data, data elements, data types, and resources, based on the following interview between a database analyst and a lecturer from Sutherland University:…

    • 2079 Words
    • 12 Pages
    Powerful Essays
  • Satisfactory Essays

    research paper

    • 329 Words
    • 2 Pages

    Zemke, F. (2012, MARCH). What 's new in SQL:2011. Retrieved September 2012, from www.sigmod.org: http://www.sigmod.org/publications/sigmod-record/1203/pdfs/10.industry.zemke.pdf…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    nothing

    • 277 Words
    • 2 Pages

    Currently a junior majoring in Information Systems at TSU, I have demonstrated strong academic performance in all Information Systems courses, maintaining a 3.3 GPA in my major. The courses I have completed have given me a solid foundation in the tools, processes and methodologies involved in Database Administration. I have a proven ability to learn challenging concepts quickly and have developed competencies in diverse areas, including:…

    • 277 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Career Research Paper

    • 1003 Words
    • 5 Pages

    Career Research Development Devry University. Example paper of job research techniques utilizing hidden research on internet.…

    • 1003 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    It is also essential to import data from excel to SQL directly to avoid time wastage. The following report shall detail the creation of SQL database, tables and insertion of data in SQL tables.…

    • 480 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    C.) Information Systems Analyst V: Key member of the system landscape team. Responsibilities include: Works with team to identify the future systems landscape for IS&T. Performs detailed analysis to identify opportunities to streamline existing landscape and develop future landscape model. Key contributor to development of new data warehouses for the region and determination of how they fit in overall landscape. Excellent communication and business analysis skills are required. The following skills are desirable: Knowledge of Unix/Oracle, Data warehousing, SAP, Project Management, technical/database background. Normally require BSCS or Information Management plus 8 yrs related exp, or MBA plus 6 yrs experience. Strong analytical, management, technical and interpersonal skills.…

    • 297 Words
    • 2 Pages
    Satisfactory Essays

Related Topics