Sql Server Manager
Resume:
Shashidhar Neela
***************@*****.***
SUMMARY
> 6+ years of development and administration experience in SQL Server
database system in OLTP environment for Accounting, Insurance,
Healthcare and Public Institutions.
> Experience in software Analysis, Design, Development, Testing,
Implementation and production, support of Client/Server and Web based
applications.
> Experience in transforming complex business logic into Database design
using the balanced Normalization in 2nd and 3rd Normal Form for
highest performance and maintaining it by using SQL objects like
Stored Procedures, User Defined Functions, Views, Triggers, TSQL
Scripting, DTS/SSIS and Jobs.
> Experience in implementing table level and index level partitioning
for improving performance and manageability.
> Experience in designing XML documents using DTD, XML Schemas, and XSLT
for its integration in database. Extensive use of XML, XPath Queries.
> Experience in creating Full Text Indexing to enhance the search
capability of a query against unstructured data.
> Experience in Using Sql Profiler, Database Engine tuning Advisor,
Windows performance monitor, Dynamic management views to determine the
causes for performance degradation and maintaining the performance.
> Experience in running Database Consistency checks using DBCC commands.
> Experience in installation, upgrade and configuration of Microsoft SQL
Server and databases.
> Experience in Microsoft SQL Server Database Administration including
planning, implementing, backup, snapshot, and recovery strategies.
> Experience in planning and implementing Microsoft SQL Server Security
and database permissions.
> Experience in implementing and maintaining High availability methods
like Log shipping, Mirroring, Clustering, and Replication.
> Experience in extracting and transforming data using DTS/SSIS
Import/Export Data, Bulk Insert, BCP and DTS/SSIS Packages.
> Experience in Designing ETL DTS Package for integrating data from
heterogeneous sources (Excel, CSV, Oracle, flat file, ODBC,Text Format
Data).
> Experience in developing drill trough and drill down reports using Sql
Server Reporting services.
> Experience in migration of DB2, SQL Server 2000 to SQL Server 2005 and
SQL Server 2005 to 2008 (Side by Side).
> Experience in different team projects with good project implementation
experience, team skills, troubleshooting, presentation abilities and
issue resolution capabilities.
> Excellent communication, analytical and inter personal skills and
ability to learn new concepts.
> Skilled at assessing client needs, working in a group, suggesting
ideas that enhance efficiency and maximize performance, implementing
cutting-edge technology solutions, and training/supporting end users.
> Flexible and versatile to adapt to any new environment and work on any
project.
CERTIFICATION
> 070-431: Implementation and Maintenance with Microsoft Sql Server
2005.
TECHNICAL SKILLS
Operating Systems: Windows 3.x/9x/ME/NT/2000/XP/2008, UNIX,
Solaris.
Databases: MS SQL Server 2008/2005/2000/7.0/6.x., DB2
ETL Tools: DTS (Data transformation services), Integration
Services.
Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer,
DTS
Import/Export,Backup Server, Replication server, OLAP
Services, SQL
Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Client
Configuration utility,
Replication Tools.
Data Modeling: ER-Win v 4.0, Visio 5.0.
Development skills: Transact SQL (T-SQL).
Languages: C, C++, C#, HTML, JAVA Script, ASP.Net, Visual Fox
pro.
Reporting Tools: Sql. Server Reporting services, knowledge of
Crystal reports.
Application Packages: MATLAB 5.3, PSPICE, Microsoft Office Suite, Adobe
Photoshop
PROFFESSIONAL EXPERENCE
Kentucky State Department of Education, Frankfort, KY Jan
2010 to till date
Project: Kentucky Statewide Longitudinal Data System
Sql Server DBA/ ETL Developer
Responsibilities:
> Actively involved gathering functional requirements and business
requirements.
> Responsible to develop, schedule and Monitor ETL jobs using EDM and
Sql Server Integration Services.
> Responsible for Routine Database Administrator activities such as
administer, monitor and tune, backup and restore in clustered
environment.
> Analyzing source system data to determine the appropriateness for
inclusion into the data warehouse.
> Responsible for source to target mapping specification for bringing
new data into the warehouse.
> Developing, testing and deploying the ETL jobs using SSIS.
> Responsible for running batch files to generate Education fact
Reports.
> Responsible to work with Cognos Report development team to create
views and stored procedures to run the reports.
> Responsible for providing production support including troubleshooting
and resolution.
> Responsible for Technical documentation, and end user documents.
Environment: SQL Server 2005, Sql server Reporting services, Cognos, Data
Manager, Windows Server 2003, .Net, ASP.Net,IIS7.0 Excel, Visio, VB
script, MS Access, Microsoft Excel.
Research in Action, Inc, Baton Rouge LA. Jun 2009 to
Dec 2009
Project: Cohort Graduation Rate (Maine State Department of Education)
Sql DBA/ Analyst
Responsibilities:
> Actively involved in the complete software development life cycle for
creating static reports and a graphical user interface for auditing.
> Involved in gathering functional requirements from the client.
> Performed statistical analysis on the data.
> Performed data conversions from excel, access, flat files into a
Normalized database structure.
> Generated database SQL scripts and deployed databases including
installation and configuration.
> Defined Check constraints, Business Rules, Indexes, and Views.
> Written complex sql joins views and stored procedures to develop
Graduation rate report for all the schools in the state of Maine.
> Scheduled jobs in the SQL Server Agent to carry out the database
maintenance activities such as database backups and consistency
checks.
> Responsible for developing processes, automation of maintenance jobs,
tuning SQL Server, locks and indexes configurations, administering SQL
Server security, SQL Server automatic e-mail notification and SQL
Server backup strategy and automation.
> Developed, tested, and deployed Cohort Graduation Rate dynamic web
application to access the reports for the end user using Microsoft
.Net technologies.
> Managed Windows Server logins, folder permissions, and Share
permissions.
Supported front-end development team to resolve SQL related issues in
Active Server Pages dured server migration
> Created Technical documentation, and end user documents.
> Deployed the Applications using IIS server.
> Developed and maintained FTP site designed by Filezilla software.
Environment:
SQL Server 2005, SQL Server Analysis Services, Sql server Reporting
services, Windows Server 2008, .Net, ASP.Net,IIS7.0 Excel, Visio, VB
script, MS Access, Microsoft Excel.
Siemens Healthcare, Malvern, PA Sep08 to jun 2009
Project: Soarian Financials /Soarian Clinicals
Senior SQL Server DBA/ Developer
Soarian is the flagship software of Siemens Medical Solutions. Soarian is
the product for hospital day to day needs. Soarian Financials deals with
the accounting needs of the hospitals. Soarian Clinicals caters to the
needs of the patient infrastructure, reports and other clinical related
information.
Responsibilities:
> Developed, modified, and optimized complex queries to data retrieval
and modification.
> Migration of databases, logins, maintenance plans and DTS jobs from
SQL Server 2000, Sybase to SQL Server 2005 and update documentation on
SQL Server standards and controls according to the SOX.
> Generated database SQL scripts and deployed databases including
installation and configuration in clustered environment.
> Developed and created data dictionary, stored procedures, advanced
queries, triggers, views, indices, and functions for databases.
> Developed scripts to migrate data and the database objects to/from
multiple sources.
> Implemented table level and index level partitioning.
> Implemented reports based on the requirement of business users using
Sql server Reporting services.
> Resolved database capacity issues, and other distributed data issues.
> Performed Replication management and monitoring the database.
> Created DTS and SSIS Packages to reload tables from Excel data files.
> Involved in Optimizing and Tuning of SQL Queries.
> Scheduled nightly jobs in the SQL Server Agent to carry out the
database maintenance activities such as database backups and
consistency checks.
> Performed restoring of databases per the requests from the clients.
> Preparation of rollback scripts for the respective upgrades to
rollback any problems/issues encountered.
> Schema comparison of databases to ensure the efficacy of the rollback
scripts, using tools like SQL delta. The differences between the
databases, if any, are saved as html reports for further analysis.
> Developed stored procedures, advanced queries, trigger, views, and
indexes by using T-SQL.
> Provided feedback, training, and support to the quality assurance,
production database and operations teams.
> Troubleshoot problems in real time with high pressure and ensure
production support 24*7.
Environment:
SQL Server 2005, SQL Server 2000,SQL Server Analysis Services, Sql server
Reporting services, Sybase,Windows Server 2003, .Net, ASP, Excel, Visio,
VB script, MS Access, Microsoft Excel.
Chicago Public Schools, Chicago, IL Jan08 Aug08
SQL Server DBA /SSRS Developer
Located in Chicago, Chicago Public Schools is the premier urban school
district in the country; owns more than 620 schools from pre-school to 12th
grade throughout Chicago and Illinois area. CPS provides all students and
their families with high quality instruction, outstanding academic
programs, conduct online instruction and comprehensive student development
supports.
Responsibilities:
> Responsible for gathering/refining requirements from the customer for
developing reports.
> Created SQL Server Reports using SSRS 2005.
> Identified the Data Source and defining them to build the Data Source
Views.
> Developed Query for generating drill down reports in SSRS 2005.
> Designed and implemented stylish report layouts.
> Generated Reports using Global Variables, Expressions and Functions
for the reports.
> Identified and worked with Parameters for parameterized reports in
SSRS 2005.
> Responsible for scheduling the subscription reports with the
subscription report wizard.
> Deployed the generated reports directly on the client's workstation.
> High Level Design of ETL DTS Package for integrating data from
heterogeneous sources (Excel, CSV, Oracle, flat file, ODBC,Text Format
Data).
> Looked at the reports and fixed bugs in stored procedures.
> Worked as a developer in creating complex Stored Procedures, Triggers,
Functions, Indexes, Tables, Views and other T-SQL code and SQL joins
for applications.
> Implemented different types of constraints on tables.
> Managed index, statistics and optimizing queries by using execution
plan for tuning the database.
> Maintained the physical database by monitoring performance, integrity
and optimize SQL queries for maximum efficiency using SQL Profiler.
> Monitored Scheduled jobs and alerts.
> Performed production SQL release final verification procedure to
production.
> Documented all database changes and follow and enforce change and
release management processes.
> Improved Report Performance and performed unit testing.
> Worked with users in training and support
Environment:
MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services
2005(SSRS), MS SQL Server Integration services(SSIS), SSAS,Windows Server
2003,.Net, ASP, Excel, Visio, VB script, MS Access.
Pacific Life Insurance, Newport Beach, CA Feb07 Dec07
SQL Server Developer
Pacific Life provides life insurance products, annuities, and mutual funds,
and offers a variety of investment products and services to individuals,
businesses, and pension plans. Pacific Life counts more than half of the
100 largest U.S. companies as clients and is a member of the Insurance
Marketplace Standards Association (IMSA), whose membership promotes high
ethical standards for the sale of individual life insurance and annuities.
Responsibilities:
> Involved in gathering the functional requirements from the client.
> Involved in Creating Complex Store Procedure using T-SQL to evaluate
result for the repots to implement using Management studio.
> Developed complex stored procedure using T-SQL to generate Ad hoc
reports using SSRS.
> Developed different Scripts for the Data analysts for Verification of
reports.
> Responsible for deploying reports to Report Manager and
Troubleshooting for any error occurs in execution.
> Performed data conversions from flat files into a normalized database
structure.
> Scheduled the Reports to run on daily and weekly basis in Report
Manager and also email them to director and analysts to review in
Excel Sheet.
> Created Triggers to enforce data and referential integrity.
> Defined Check constraints, Business Rules, Indexes, and Views.
> Performance tuning of SQL queries and stored procedures using SQL
Profiler and Index Tuning Wizard.
> Creation and Maintenance of Indexes for various fast and efficient
reporting processes.
> Perform T-SQL tuning and optimizing queries for Reports that take
longer time in execution SQL Server 2005.
Environment:
Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Windows
XP, MS Excel 2003, VBScripts.
Department Of Health Services, State of California, Richmond CA
Jan06 Jan07
Sql Server DBA/Developer
Project: Screening Information System (SIS) for Genetic Disorder Branch
(GDB)
Screening Information System (SIS) is a new system undertaken by Deloitte
Consulting for the Department of Health Services (DHS) of the State of
California which will replace all existing legacy systems. SIS is a system
which records data collected from screening of pregnant women (during 15-20
weeks of pregnancy) and newborn babies (when they are born) in the State of
California for diagnosis of genetic disorders. This system keeps data
regarding test data of newborns, clients, physicians, equipments,
healthcare providers, contact details etc and also maintain history of
clients, physicians and healthcare providers. SIS is a system with .Net
front-end web application with SQL Server 2000 as the database server.
Responsibilities:
> Gathered functional requirements and Business requirements and written
the technical specifications for building the Global Enterprise Data
warehouse.
> Worked closely with developers, end users in designing and creating
the Global Enterprise Data warehouse.
> Developed a multi-dimensional database (MDDB) and OLAP cube using SQL
Server 2000 that stored and maintained the data.
> Involved in the complete data warehouse development life cycle and
solely responsible for the design, development and maintenance of 8
cubes.
> Designed and maintained a web reporting environment including portal,
dashboards, scorecards and presentations using SQL Server 2000,
Asp.Net and Hyperion Essbase BI tool.
> Implemented transactional replication among different servers
> Implemented member properties, virtual dimension, dimension custom
rollups, write back, action and drill through.
> Implemented MS Analysis Services setup, tuning, cube partitioning,
dimension design including hierarchical and slowly changing dimensions
> High Level Design of ETL DTS Package for integrating data from
heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format
Data)
> Provided technical guidance and support to end-users by developing
documentations required.
> Performed application and database code production pushes, following
production release procedures.
> Performed production SQL release final verification procedure to
production.
> Documented all database changes and follow and enforce change and
release management processes.
> Audited and enforced database security, code and procedural standards.
Environment:
SQL Server 2000 (Query Analyzer, Enterprise Manager,SSAS, DTS Designer, SQL
Profiler, Replication Wizard, Database Maintenance Plan, Index Tuning
Wizard), Windows Advanced Server, MS Excel, MS Access, TextPad text editor,
Visual Source Safe.
Ritz Technologies, Hyderabad, India. Aug
2004 to Dec 2005
Sql Developer
Responsibilities:
> Generated database SQL scripts and deployed databases including
installation and configuration.
> Involved in creating complex stored procedures, triggers, functions,
complex SQL statements, views and indexes in SQL Server database for a
web based environment.
> Created Triggers to enforce data and referential integrity.
> Defined Check constraints, Business Rules, Indexes, and Views.
> Resolved database capacity issues, and other distributed data issues.
> Performed Replication management and monitoring the database.
> Created Database Maintenance Plans for the Performance of SQL Server,
which covers Database Integrity Checks, Update Database Statistics and
Re-indexing.
> Created Users and Roles, and managed security and permission of
database.
Environment:
SQL Server 2000(SQL Server Management Studio, Query Analyzer, SQL Profiler,
Index Tuning Wizard, MSSQL Server2000 Analysis Server, MS-Reporting
Services, XML, ASP.Net, VB Script.
Contact this candidate