Resume

Sign in

Microsoft Office Sql Server

Location:
Elmwood Park, New Jersey, United States
Salary:
70 k
Posted:
February 06, 2018

Contact this candidate

Resume:

SHARANYA

ac4c72@r.postjobfree.com

732-***-****)

PROFESSIONAL SUMMARY:

●Over 2 years of IT Experience in Database Design, testing, Development and business intelligence of Microsoft SQL Server 2005/2008R2/2012/2014/2016 in Development, Test and Production Environments on various business domains.

●Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008 R2/2012 /2014/2016.

TECHNOLOGY PORTFOLIO:

EXPERTISE:

Experience in working with Windows and Mac Operating Systems.

Strong skills in Microsoft Office and Internet Handling.

Experience in working with Embedded C.

Extensive experience in working with Mat lab.

Thorough knowledge in C, C++, C#, T-SQL.

Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Excellent knowledge on OLTP and OLAP systems.

Experience in executing Selenium automation scripts written in Java.

Strong knowledge of Developing SQL Stored Procedures and Queries for Back end testing.

Experienced in data analysis using SQL, PL/SQL and many other queries based applications.

Involved creation of extended dimension modeling tables like snowflake for OBIEE.

Great write simple and complex SQL Queries to connect with different databases.

In-Depth Knowledge in creating SSIS/DTS packages, SSRS, SSAS.

Having experience in SCRUM and Agile Methodologies.

Great knowledge on Data modeling, Data conversion and Data migrating techniques.

TECHNICAL EXPERTISE:

SQL Server tools:

Enterprise Manager,SQL Profiler, Query Analyzer,DTS, SSIS, SSRS, SSAS, BI, Development studio, Analysis Manager, Visual Studio.

Database:

MS SQL Server 2016/2014/2012/2010, 2008 R2, 2005, SQL CMD, Microsoft Office.

Methodologies:

SDLC, Agile, Waterfall.

Language:

C, C++, XML, TSQL, MYSQL, Pl Sql, VB.NET, ASP.NET, C#.

Operating System:

Windows XP/7/8/10, IOS, UNIX.

RDBMS:

Oracle, MY SQL, MS SQL Server.

Tools :

Erwin Data Modeler, MS Visio, MS Access, Crystal Reports 8.5,10, XI, R2, Microsoft office 2003/2007/2010/2013, Team Foundation Server (TFS), EXCEL, Toad, Selenium IDE/RC/Web driver.

ETL TOOLS:

SQL server integration system (SSIS), Data transformation services (DTS), T-SQL stored procedures.

ACADEMIC DETAILS:

YEAR

DEGREE

GPA

2016

Master of Science, State University of New York, New Paltz, USA

3.13

2014

Bachelors of Engineering, JNTU-HYDERABAD, INDIA

3.74

PROFESSIONAL EXPERIENCE:

CLIENT: BAANYAN SOFTWARE SERVICES INC.

ROLE : SQL SERVER DEVELOPER March2017–Till Date

Environment: MS SQL Server 2016/2014/2012, Visual Studio2012, SSIS, SSRS, Query Analyzer, Database Engine tuning wizard, MS Access, TFS, MS Excel, ERWIN, Oracle 11g, Toad, MS-Visio, ETL Informatica.

Responsibilities:

Worked on Agile/SCRUM methodology for iterative and incremental development.

Installed and Configured SQL Server 2014 successfully.

Worked on latest version of all software's like Visual Studio 2012 ultimate, Management Studio 2014.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.

Designed and implemented basic SQL queries for QA testing and report/ data validation.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.

Responsible for Deploying, Scheduling, Alerting and Maintaining SSIS packages.

Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.

Assisted the QA team in designing the test plan and test cases. Performed User Acceptance Testing

Used Execution Plan to optimize and enhance the performance of SQL Queries.

Created SSIS packages to import data from MS Access, Excel to SQL 2014.

Converted few reports from crystal reports to SSRS.

Explored Erwin for Data Mapping and Modeling.

Created alerts, notifications, and e-mails for system errors.

Performed unit testing for every package created.

Deployed and scheduled tidal Job a job for SSIS Package for different environment.

Client: DELLOITE April 2014 – Dec 2014

ROLE: SQL SERVER BI DEVELOPER/QA TESTER

Environment: MS SQL Server, Visual Studio2012, SSIS, SSRS, Query Analyzer, Jira, Database Engine tuning wizard, MS Access, TFS, MS Excel, ERWIN, Windows Server,Selenium Web Driver, Oracle 11g, Toad, MS-Visio,

RESPONSIBILITES:

Gathered requirements to identify and create database objects such as tables, views, triggers and indexes, User defined functions, Cursors, Stored Procedure, Constraints and Roles.

Involved in Normalization of the database and bringing it to 3NF.

Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.

Performed data conversions from flat files into a normalized database structure.

Created Views to enforce security and data customization.

Used SQL CMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.

Automated Regression test cases using Selenium, Web Driver and Web Driver Backed Selenium

Involved in system testing, data integrity testing and ETL testing. Written and implemented System level Test plan, test cases and test scripts.

Created Non-Clustered indexes to improve query performance and query optimization for maximum efficiency

Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.

Tested to optimize the Stored Procedures and Triggers to be used in production.

Worked in Enterprise Manager for job scheduling and batch queries.

Managed and monitored the use of disk space.

Reported defects using JIRA in Agile methodology.

Developed an automated report subscription process using SSRS.

Used Report Builder to do Ad-hoc Reporting. Created report links to refer other reports in a report.

Resolved any deadlocks issues with the Databases/Servers on a timely basis. In-Depth working knowledge of ODBC.

Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases.

GRADUATE PROJECTS:

Client: BRAVO BIZZ SOLUTIONS Aug 2016 – Dec 2016

ROLE: SQL SERVER BI DEVELOPER( INTERN)

Environment: MS SQL Server, Visual Studio2012, SSIS, SSRS, Query Analyzer, Jira, Database Engine tuning wizard, MS Access, TFS, MS Excel, ERWIN, Windows Server,Selenium Web Driver, Oracle 11g, Toad, MS-Visio,

RESPONSIBILITES:

Gathered system requirements, performed system analysis, feasibility study and understand technology paradigms.

Designed and tested real time Web applications while working with a select group of experienced software engineers.

Learned to frameworks and followed design patterns.

Work on identifying Business requirements, Technical requirements, Database Design and Troubleshooting.

Worked closely with DBA Team to deploy the code changes into Test, Integration and later into Production environment.

Involved in Effort Estimation and work scoping.

Performed root cause analysis on issues.

Tracked bug trends and made recommendations along with the team.



Contact this candidate