Data Sql Server
Resume:
BHASKAR AVISHA
*********.******@*****.*** 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