Sql Server Microsoft Office

I am certified as MCTS-SQL Server **** R* database professional, Oracle 9i and 10g OCP/DBA, MCP, MCTS –Windows 7, MCTS- Windows Server 2008, and ITIL V3.

EDUCATION

Master’s in Computer Science (Information Systems Management) May-2015, Marist College, Poughkeepsie, NY

MCA (Online) Oct-2013, I.C.F.A.I, India

BCA Apr-2010, G.G.D.S.D College, India

EXPERIENCE:

Coborn’s Inc. May 2017 till Present

Data Architect

Work with the management and business team to improve database design.

Work with the management team on the implementation of data warehouse design and data integration.

Provide 24* 7 support for the administration and maintenance of SQL Server, SSRS and SSIS servers.

Resolve data challenges across layers and organizational functions.

Install and upgrade SQL Servers.

Refresh SQL Server database test and dev environments using database engine.

Administer database performance issues using system tables, SQL Server database tuning advisor, DBCC commands, built in functions and stored procedures.

Assist in the migration of SSIS packages and SSRS reports to a new server.

Assist in the migration of Oracle to SQL Server.

Install, configure and manage TFS.

Administer and manage AWS RDS.

Create SQL reports using SSRS as per business needs.

Create SSIS packages in visual studio to automate the manual tasks.

Assist in documentation of company-wide data organization.

Create dashboards in PowerBI as per executive team needs.

Environments: SQL Server 2008R2/2012/2014/2016, AWS, ETL, visual Studio 2015, SQL Server Analysis Services, SQL Services Integration Services, and SQL Services Reporting Services, TFS, Snapshots, Disaster Recovery, PowerShell, Linked Server, Oracle, Microsoft Office, PowerBI

Robert Half Technology, Minneapolis, MN April 2017 till April 2017

SQL Server Consultant

Worked with one of their client on a short-term contract.

Assisted the Sales team to understand SQL Server.

Homeownership Preservation Foundation, Minneapolis, MN August 2015 till March 2017

Technical Analyst II

Administered SQL Server Database on daily basis.

Performed backup and recovery of SQL Server databases.

Administered SQL Server high availability solutions.

Monitored and tuned performance of SQL Server environment using system tables, SQL Server database tuning advisor, DBCC commands, built in functions and stored procedures.

Created SQL reports using SSRS as per business needs.

Automated database maintenance tasks and perform ETL tasks in SSIS.

Created and deployed cube and dimension tables using BIDS.

Assisted in database design and modelling.

Assisted in data maintenance and analytics.

Created Ad-hoc SQL reports for Business use.

Performed weekly/monthly tasks related to IT system management.

Updated/analyzed data based on IT support tickets and data anomalies info.

Translated requirements to programming specifications through design documentation: system design, database design, flowcharts, and workflows.

Assisted in SQL QA testing and provide performance metrics to the Management Team to ensure that the assigned applications are implemented bug free.

Assisted in IT Security and data privacy audits such as SSAE SOC 2 Type I and Type II (audit prep/evidence gathering/onsite audit process/gap analysis) and security policy development.

Assisted in SharePoint Management

Assisted users in resolving their day-to-day IT problems.

Assisted servicers in resolving the data specification to load it in database.

Helped in improving Information Security policies, procedures, and standards. Also, helped in System architecture and configuration management to support HPF’s security policies and disaster Recovery planning.

Environments: SQL Server 2008R2/2012, SQL, Disaster Recovery, ETL, SQL Server Analysis Services, SQL Services Integration Services, and SQL Services Reporting Services, Disaster Recovery, Microsoft Office, Rackspace, MDM, Tableau, JIRA, SharePoint, Visual Studio, PowerShell, Windows 7/10, Windows Server 2012

Marist College, Poughkeepsie, NY September 2014 till May 2015

Academic Technology Technical Consultant

QA Testing and simulations for new technology rollouts prior to significant upgrades by participating in student QA and bug testing teams, using agile methodologies on open source applications.

Quality Assurance and regression testing of the Sakai open source LMS following scripted test cases.

Developed and designed a workshop attendee database for Faculty improvements.

Created documentation for cleaning trouble ticket data using excel and QMF verifying succinct attribute tagging for consistent analysis of problem reports.

Supported clients in learning analytics conference and prepared reports.

Supported non-technical clients online and face to face in iTeam.

Tata Consultancy Services (TCS), India Dec 2011 till Dec 2013

Client: Wyndham- USA

SQL Server and Oracle Database Administrator, India

Administrated SQL server and Oracle (RAC & Standalone) databases.

Applied patches and up-gradation on Oracle database environments.

Installed and upgraded SQL Server databases.

Refreshed oracle database environments using RMAN, Data pump, export/Import.

Refreshed SQL Server database environments using database engine.

Monitored and scheduled SQL server Agent jobs.

Worked on SQL Server high availability solutions.

Performed backup and recovery of SQL Server databases.

Monitored Oracle environment using OEM, SCOM and UNIX scripts.

Converted DTS packages to SSIS in SQL Server.

Tuned performance of Oracle environment using AWR, ADDM, SQL Advisory, Toad, SQL Developer and OEM.

Monitored and tuned performance of SQL Server environment using system tables, SQL Server database tuning advisor, dbcc commands, built in functions and stored procedures.

Worked on SQL Server Analysis Services, Reporting Services and Integration Services.

Developed and modified some Oracle backup and recovery scripts.

Used Oracle backup utility RMAN to implement Oracle backup.

Wrote effective SQL, T-SQL, PL/SQL programming to generate Database triggers and Stored Procedures.

Performed capacity planning and sizing of databases based on input from business.

Environments: Oracle 11gR2/11g/10g/9i, SQL Server 2000/2005/2008/2008R2/2012, SQL, PL/SQL, ETL, TOAD, OEM, RAC, SQL Server Clustering, Disaster Recovery, Data guard, SQL Server Analysis Services, SQL Services Integration Services, SQL Services Reporting Services, PowerShell, Microsoft Office

Tata Consultancy Services (TCS), India Nov 2010 till Nov 2011

Client: Ceridian- UK

Desktop support Specialist

Supported the customers in Desktop computing and Telephony configuration

Prepared Daily Availability Checklist including a check for all the domain controllers, Intranet, Citrix Desktops, Exchange Server, VMware Servers, DFS Replication and share with management and Client.

Created users in Active Directory and synced them to their MacAfee account.

Access management

Configured Outlook and setup system of clients.

Monitored Blackberry server.

Environments: Windows XP/7/8, Windows Server 2000/2003/2008, Blackberry Server, VPN, Microsoft Office

TECHNICAL SKILLS

RDBMS: SQLServer2000/2005/2008/2008R2/2012., Oracle9i/10g/10gR2/11g/11gR2, PostgreSQL

Markup Languages: HTML, XML.

Operating Systems: Microsoft, Red hat Linux.

Languages: C, C++, Core Java

HONORS:

Academic Recognition for being the College Topper in India

ACADEMIC PROJECTS :

‘Grocery Store’ data warehouse and data mining project using MS SQL Server 2012 Analysis Services, MS Visual Studio 2012, Excel and Weka.

‘Imagine Duchess’ and ‘Malaria Was Here’ system design projects.

Network Design for ‘Quality Sounds’.

‘Grocery Store’ database project in DBMS using PostgreSQL.

‘Charlie game’ in Software development using NetBeans.

Contact this candidate