Resume

Sign in

Data Sql Server

Location:
Apex, North Carolina, United States
Salary:
85$/hr
Posted:
November 04, 2019

Contact this candidate

Resume:

BHASKAR AVISHA

adare1@r.postjobfree.com Home: 201-***-****

OBJECTIVE

A position that will utilize my years of experience in Database Development/BI Development, Database Administration or Programming both in SQL Server and MongoDB

EDUCATION

Master of Science in Computer Science, Dec 2008, Fairleigh Dickinson University, Teaneck, NJ, with G.P.A of 3.39

Bachelor of Engineering in Computer Science, May 2006,VASAVI College of Engineering, Hyderabad, India, with G.P.A of 3.4

CERTIFICATION

M101 and M102 - MongoDB Developer and DBA course completed and certified from MongoDB University

Microsoft Certified Technologist Specialist (MCTS) in Implementation, Designing and Maintenance of Databases (70-431)

Microsoft Certified Technologist Specialist (MCTS) in Microsoft® SQL Server™ 2005 Business Intelligence Development (70-445)

Microsoft Certified Technologist Specialist (MCTS) in Microsoft® SQL Server™ 2008 Database Development (70-443)

Microsoft Certified Technologist Specialist (MCTS) in Querying Microsoft SQL Server 2012 (70-461)

SUMMARY

Charles Schwab Jul 2014 – Present

Database Engineer

MongoDB:

Designed Mongo data models using Erwin data modeler version 9.5.

Responsible for database, collection design and maintenance for MongoDB databases.

Developed java scripts for CRUD operations.

Upgraded MongoDB database version from 3.0 to 3.2 and higher.

Designed and setup database with Replication and Sharding.

Provided production support for ROBO rebalancing critical trading systems which are responsible for billions under management.

Coordinated and implemented collection archiving and Sharding on MongoDB which resulted in 25% performance improvement and 20% reduction in data footprint.

Provided best practices and database access patterns reviews for all the application teams.

Good working knowledge of OpsManger.

SQL Server:

Designed data models using Erwin data modeler version 9.5.

Responsible for database design and maintenance.

Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables.

Worked on designing Views, Stored procedures, Functions, Triggers for the applications.

Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning

Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files, Csv files and Excel files

Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.

Developed complex VB.NET Scripts for SSIS packages to incorporate dynamic flexibility

Implemented Logging and Package Configurations for all the SSIS packages developed

Wrote different expressions for SSIS packages to build source paths, destination paths and names dynamically

Experience with Data migration using BCP, importing and exporting from flat files using format files to MS SQL server database.

Implemented Log Shipping using SQL Server 2008 R2 for different production servers

Implemented Always On using SQL Server 2012 for different production servers

Provide production support for patching, Report validation and Database validations, SSIS daily loads

Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.

Developed automated Power shell scripts to run ETL deployments, Database backups, evaluate policies on different production servers.

Developed applications as part of Agile Methodology, working knowledge of all the phases of Agile Methodology

Migrated different application databases from 2008 to 2012.

Acted as database point of contact for resolving production issues related to Portfolio Center product.

ENVIRONMENT: Windows 2012, SQL Server 2012, SQL Server Data Tools, Windows XP, MS SQL Server 2005, SQL Server Integration Services 2005, SQL Refactor, BIDS Helper, SQL Data Compare, Microsoft Visual Studio 2005, Team Foundation Server 2010, And SQL Server Reporting Services 2005, C# .Net and VB .Net, MongoDB 3.0 & 3.2 & 3.4 & 3.6

Populus Group (Charles Schwab) Sep 2012 – Jul 2014

Senior SQL Server Developer / DBA

Designed data models using Erwin data modeler version 9.5

Responsible for database design and maintenance.

Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables

Worked on Views, Stored procedures, table valued functions, Triggers

Involved with application team to optimize database objects like stored procedures, Triggers, Table valued functions and Views.

Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning

Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files, Csv files and Excel files

Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.

Developed complex VB.NET Scripts for SSIS packages to incorporate dynamic flexibility

Implemented Logging and Package Configurations for all the SSIS packages developed

Wrote different expressions for SSIS packages to build source paths, destination paths and names dynamically

Experience with Data migration using BCP, importing and exporting from flat files using format files to MS SQL server database.

Provide production support for CRD, MIDAS applications

Implemented Log Shipping using SQL Server 2008 R2 for different production servers

Implemented Always On using SQL Server 2012 for different production servers

Provide production support for patching, Report validation and Database validations, SSIS daily loads

Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.

Developed automated Power shell scripts to run ETL deployments, Database backups, evaluate policies on different production servers.

Developed applications as part of Agile Methodology, working knowledge of all the phases of Agile Methodology

Migrated different application databases from 2008 to 2012.

Working knowledge of Service Broker Architecture as part of MIDAS application.

ENVIRONMENT: Windows 2012, SQL Server 2012, SQL Server Data Tools, Windows XP, MS SQL Server 2005, SQL Server Integration Services 2005, SQL Refactor, BIDS Helper, SQL Data Compare, Microsoft Visual Studio 2005, Team Foundation Server 2010, And SQL Server Reporting Services 2005, C# .Net and VB .Net.

NTT Data Inc Jan 2012 – Sep 2012

Senior Consultant

Wholesale Credit Data Integration Reporting

Responsible for data maintenance.

Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables

Worked on Views, Stored procedures, table valued functions, Triggers

Involved with team to optimize database objects like stored procedures, Triggers, Table valued functions and Views.

Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning

Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files, Csv files and Excel files

Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.

Developed complex VB.NET Scripts for SSIS packages to incorporate dynamic flexibility

Implemented Logging and Package Configurations for all the SSIS packages developed

Wrote different expressions for SSIS packages to build source paths, destination paths and names dynamically

Developed a package to dynamically download file from SharePoint portal and convert them in to required format using metadata driven tables

Experience with Data migration using BCP, importing and exporting from flat files using format files to MS SQL server database.

Provide production support for the WCDIR application using AUTOSYS 4.5.1 version

Provide production support for patching, Report validation and Database validations

Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.

ENVIRONMENT: Windows XP, MS SQL Server 2005, SSIS, SSRS, BIDS Helper, SQL RedGate Tools, Microsoft Visual Studio 2005, Team Foundation Server 2010, C# .Net and VB .Net.

CVS Caremark Jun 2010 – Jan 2012

Programmer Analyst

Master Benefit Grid, AutomatedOutboundMessaging, State Extracts (Pharmacy, Claims Extracts), PDE Claims Extract - Worked as a SQL,SSIS and SSRS Developer

Dow Jones and Company Jun 2009 – Jun 2010

Intern

Capacity Planning - - Worked as a SQL,SSIS and SSRS Developer

Mindware Global Inc Apr 2009 – Dec 2009

MS SQL Server Developer/BI Developer

Business Critical Reporting - - Worked as a SQL,SSIS and SSRS Developer

REFERENCES

Available Upon Request

LinkedIn Profile



Contact this candidate