Sql Server Data

Sindhu Shivapuja

Email: ******.**********@*****.***

Contact no: +1-256-***-****

PROFESSIONAL SUMMARY:

5+ years of progressive experience working with large databases in Oracle and SQL Server platforms

Experienced ETL Data Analyst with expertise in Data Validation, Data Conversion, Oracle PL/SQL Development and Direct Integration processes

Database Administrator with extensive experience designing, coding, testing and supporting next-generation database solutions in Oracle Database and MS SQL Server environments

Adept analytical skills to triage and troubleshoot defects and formulate solutions to address software or process issues

Data Conversion (ETL) Analyst 2012 -2015

Duquesne Light Company, Pittsburgh, PA

Developed PL/SQL queries, Procedures, Scripts for Data ETL (Extract, Transform, and Load) or Data Conversion processes

Developed ETL processes that involve in designing and preparing the codes that meet the program specifications as well as the client requirements

Automated Synchronization process of converted data across Oracle's CC&B (Customer Care & Billing) and MDM (Meter Data Management) Applications

Identified Audit Points and Audit objects for the Data Conversion Internal Audit process and perform quality audits for completeness and accuracy

Imported data into Oracle and MS SQL Server databases from multiple source types

Executed Batch processes in CC&B and MDM Applications for Direct Integration

Loaded CSV files into Oracle Database using SQL Loader process

Designed and Developed Reports and deliver the data validation results for Management review

Extensively used SharePoint platform for data access and storage

Certified Oracle DBA 2010 -2011

SQL Star International Ltd

Trained as a System and Database Administrator (SDBA) equipped to Install, Administer, and Manage Oracle 10g database on Linux, Perform database backup and recovery, Perform automatic memory tuning

Oracle PL/SQL Programming experience on Oracle 11g database

Microsoft SQL Server DBA 2007 - 2009

Wipro InfoTech Ltd (Client: HDFC Bank)

Installation, Configuration and Migration of Microsoft SQL servers 2000/2005/2008

Troubleshooting, Monitoring, Space management, Optimization and Performance tuning of SQL server environments across entire system

Design database and perform file management tasks such as creating databases, creating file groups and schemas, set database options and perform capacity planning

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS package designer

Develop SQL queries for testing and troubleshooting against Data Warehouse

Perform SQL server security management tasks such as creating users, logins and granting user permissions

Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing updates

Create and manage database maintenance plans and design and implement Backup and Disaster Recovery plans

Prepare current database structure and configuration for high-performance through analysis and optimization

Applying Service packs & Critical patches and Bug fixes

Knowledge of Database Snapshots, Mirroring and Replication on SQL server 2005

SOFTWARE PROFICIENCY:

Programming Languages: PL/SQL, SQL, R, Unix/Linux Shell scripting, Perl Script

Databases/Tools: MS SQL Developer, ODI, MS SQL server 2005, Oracle 10g/11g, SQL Query Analyzer, SSIS, SSRS, Control-M, Microsoft Excel, Microsoft Project

Operating Systems: Windows 2000 Server/XP/Vista, Red Hat Linux 5

EDUCATION and CERTIFICATIONS:

Bachelor of Engineering in Computer Science, VTU (2003-2007)

Red Hat Enterprise Linux System Administration (RHEL5u4)

Microsoft Certified IT Professional MCITP Database Administrator (070-444)

Microsoft Certified Professional MCP (070-228)

Oracle Certified Professional OCP (1Z0-043)

Oracle Certified SQL Expert (1Z0-047)

15.071x The Analytics Edge (from MIT) –Data Analytics and Statistics(2015)

Contact this candidate