Post Job Free

Resume

Sign in

SQL and Business Intelligence Consultant

Location:
Cerritos, CA
Posted:
March 13, 2019

Contact this candidate

Resume:

TE

OBJECTIVE

I aim to work in a professionally managed organization, where I can deploy all my logical, technical and managerial skills to aspire for personal and professional growth in the organization.

SKILLS

Expert in SQL Server, T-SQL, Java and C#

Microsoft SQL Server, SSAS, SSIS and SSRS.

Microsoft Azure and Cloud Computing.

Data backup and retrieval ; Database design ; Expert in disaster recovery

Troubleshooting and debugging Data management ;

TSQL specialist and Data analysis

Performance and scalability optimization

Strong verbal communication; excellent problem-solving abilities.

Customer service expert; Project management

TABITHA EMMANUEL

SQL SERVER AND BUSINESS INTELLIGENCE CONSULTING AND ANALYSIS

EXPERIENCE

ASSOCIATE • COGNIZANT TECHNOLOGY SOLUTIONS • OCT 2011 – APR 2015

Consulting, Designing and Implementing SQL Server databases and data warehousing techniques for companies.

Proficient in creating reports using Reporting Services and Stored procedures for different metrics.

Proficient in creating Analysis Server Cubes to pull reports via Reporting Services for various requirements within project.

Experienced in creating cubes and extracting data using Multi-Dimensional Expressions.

Also, proficient in extracting reports from cubes using SQL Reporting Services.

Expertise in creating, testing and validating packages with SQL Integration Services.

SPECIFIC PROJECTS

Project - Amex Application Migration factory

Duration: November 2013 to April 2015

Domain: Banking and Financial Services

Software: SQL 2000, SQL 2005, SQL 2008, SQL 2008R2 and SQL 2012

Responsibilities

Uplifting 15 Applications with SQL Server DB's from SQL 2000 or SQL 2005 physical environments to SQL 2008 R2 Cloud environments.

Setting up Source environment first as part of SQL Uplift and then migrate to (Target) SQL 2008 R2 Environments.

Prepare Data Masking Scripts using TSQL and then download the Data after applying masking scripts and then use it to setup source, QA and test environments as part of SQL Uplift.

Responsible for Base Line Testing in test environment, SIT in QA environment and UAT testing in target production environments.

Project : Amex DC 2015 Migration Project

Duration: November 2011 to October 2013

Domain: Banking and Financial Services

Software: SQL 2005, SQL 2008

We successfully migrated the current servers in IPC1 to another data center IPC2.

Role and Contribution

Responsible for all offshore activities.

Implementation of migration strategy.

Creating T-SQL Scripts to collect relevant information before migration.

Validating and verifying all SQL instances before and after migration.

Provide guidance to onsite DBAs during migration and also post migration support.

ASSOCIATE CONSULTANT • MICROSOFT • DEC 2010 – SEPT 2011

Worked as a SQL Server and Business Intelligence Consultant and my role involves working directly with customers on various engagements and also contributes to the overall individual and team development.

Expertise in the setting up High Availability features like Log shipping and Database Mirroring.

Monitoring jobs (Backup Job, Copy Job, Restore Job) involved in Log shipping.

Specialized in SQL Server Replication Design & Implementation and creating Distributor, Publishers and Subscribers.

Modification of schema objects participated in replication

Expertise in database Migration and upgrades from SQL Server 2000 to SQL Server 2005 or from SQL Server 2005 to SQL Server 2008.

Worked in T-SQL development. Ability to code stored procedures, triggers and functions and Resolving User related connectivity and Database access issues.

SPECIFIC PROJECTS -

Project : Pioneer Synchrologic-Replication Replacement

Duration: May 2011 to August 2011

Domain: Agriculture

Software: SQL Server 2008

We replaced the existing high availability solution "Synchrologic" with Merge Replication.

Role and Contribution

Responsible for designing the architecture of the solution and the Implementation and deployment strategy.

Implemented the DDL scripts in the Development environment to create the DB objects.

Creating the merge replication using UI and T-SQL Scripts.

Implementing the Backup and Restore Strategy.

Scheduling of Jobs and monitoring the same.

Involved in identifying performance bottle necks and providing recommendations to code changes in terms of performance.

Project : ContentBuilder – Test Management System

Duration: Feb 2011 to May 2011

Domain: Testing

Software: SQL Server 2008

ContentBuilder is the Test Management system for American Testing Institute. It’s Site where test definitions are managed and then published to the Testing system.

Role and Contribution

Responsible for Writing Stored Procedures, Functions, Views & Triggers,SQL Tuning and Testing and Defect fixing.

Applied the code change in the Development and Staging environment and Database User creation for application team.

Involved in identifying performance bottle necks and providing recommendations to code changes in terms of performance.

Provided technical support to application development teams and resolving User related connectivity and Database access issues.

SUPPORT ENGINEER • MICROSOFT • AUG 2006 – DEC 2010

Collaborating with SharePoint, Visual Studio, Platforms, Active Directory, Distributed Services, IIS, SBS teams in delivering a timely and technical resolution for database issues.

Collaborating with 3rd party product companies like Idera, CA, Symantec, EMC, Dell, HP, IBM to name a few.

Joined and contributed in Technical discussions/consultations with clients in planning phase of database management (Advisory cases).

Working with premier clients of Microsoft, like GM, Ford, Bankofamerica, Walmart, Wachovia, Citigroup, Morgan Stanley, JPMChase, Lehman Brothers, Dell, IBM, HP, Myspace.com, to name a few.

Installed software, modified and repaired hardware and resolved technical issues.

Provided base level IT support to non-technical personnel within the business.

Managed call flow and responded to technical support needs of customers.

Evaluated and responded to incoming sales leads and requests for technical support assistance.

Resolved customer issues in a clear, courteous and straightforward manner.

Demonstrated professionalism and courtesy with customers at all times.

Resolved problems with malfunctioning products.

Identified and solved technical issues with a variety of diagnostic tools.

Followed up with clients to ensure optimal customer satisfaction.

Technical Contributions:-

Regularly participate in knowledge sharing sessions (Technical Triages and Cube-side Triages).

Knowledge contribution by writing internal technical articles / solution objects.

Developing a mentee and guiding him/her for a smooth transition in Microsoft.

EDUCATION

BACHELOR OF TECHNOLOGY • MAY 2006 • JNTU, INDIA

Received 72% of 100. Passed with distinction.

ACCOMPLISHMENTS

Attended process trainings.

Conducted several seminars on SQL Server within the team. Attended language and communication training.

Successfully coordinated various triages within the team.

Successfully coordinated and managed a Family Day event for the entire department.

I won second prize at a National Level Technical Symposium held at Erode (TamilNadu), conducted from Aug 31st to Sep 2nd 2005, for paper presented on “Wet and Wild Computers (DNA Computing)”.

I also won first prize in seminar on “Virtual Reality” conducted at college level in Feb 2005.

I presented a paper on “Blue Tooth” at college level in Sep 2004.

I also presented a paper on “Hackers and Hacking techniques” at college level in Jan 2004.

I was a member in conducting a FETE—“ARPAN” in our college in Jan 2003. I also was an active member in different Social Service Activities, Sports Meet, Science Exhibitions and Seminars at both school and college level.

CONTACT INFORMATION

Email – ac8rzd@r.postjobfree.com

Ph. – 716-***-****

LinkedIn - www.linkedin.com/in/tabitha-emmanuel

.



Contact this candidate