Resume

Sql Server Sales

Location:

Fremont, CA

Salary:

100

Posted:

May 24, 2016

Contact this candidate

Resume:

SUMMARY OF ADITHYA (DW/BI/Sr SQL Developer Architect)

acuxa5@r.postjobfree.com

Cell#901-***-****

EXPERIENCE SUMMARY

•Has been working as a Business Intelligence Developer and SQL Support Engineer, with 6+ years of Information Technology experience including Database Administration, Development, Configuration Management, Analysis, Design, testing, Integration and deployment with MS SQL Server 2005/2008/2008 R2

•Extensive experience in migrating and upgrading SQL Server from 7.0.to 2000, 2000 to 2005 and 2005 to 2008/R2.

•Experience in designing ELT (SSIS) process to extract data from other data sources like TERADATA, MSSQL, Oracle, XML, Flat Files, and EXCEL.

•Experience in usage of performance monitoring and troubleshooting, extensive use of profiler, Performance monitor, extended stored procedure, DBCC and DMVs for troubleshooting the performance issues.

•Extensive experience in support and maintenance of real time production databases.

•Database Development (Database Design, T-SQL, Linked Server, DB Mail, SQL Mail, E-R diagram, CDC and new SQL Server 2008R2 features)

•Extensive experience in design, development and administration of SQL Server databases.

•Experience in SSRS design and deployment of Parameterized, Drilldown, Drill through, Sub, Linked, Snapshot, Cached, and Ad hoc Reports

•Very good experience in TERADATA SQL for writing in the MACROS to run ETL process as well generating reports from front end (UI).

•Performance and Tuning of the SQL Server, databases and Procedures

•Very good experience in SSIS, SSRS,SSAS development using BIDS(Business Intelligence Studio

•Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

•A quick learner that strives for new technical knowledge ability to communicate with all levels of corporate personnel

•Has the motivation to take independent responsibility as well as ability to contribute and be a productive team member.

EDUCATION Bachelor of Technology (B Tech)

UNIVERSITY J.N.T.U(Hyderabad), INDIA

TECHNICAL SKILLS:

LANGUAGE

JAVA

SOFTWARE TOOLS

TERADATA SQL Assistant,VSS 6.0

RDBMS

MS SQL Server 2005/2008R2, MS Access 2003/2007/2013, TERADATA 13.0

INTERNET TECHNOLOGIES

HTML, DHTML, VB Script, JAVA Script

WEB/APPLICATIONSERVER

IIS

REPORTING TOOLS

BIDS/SSRS 2005/2008 R2

TOOLS

BIDS, Reports Builder 3.0,SSDT(SQL Server Development Tools),Visual Studio 2008/2010/2013,SQL Developer,SQL Assistant tool

UNIX, WINDOWS NT, WINDOWS 2003/2008 R2, WINDOWS XP, OS/2, LINUX,VISTA

Scripting

VBScript, JavaScript, ASP, JSP, Perl, Windows

WORK EXPERIENCE

FedEx, MEMPHIS, TN Jul’ 13 to Till date

Domain: Logistics, Sr SQL Server/MSBI Developer

Description:

FedEx is one of the world's largest logistics companies that revolutionized the delivery of packages and information.Corporate, Field Sales, Inside Sales, World Wide Sales (WWS) representatives will generates reports to check territory productivity.

Sales Team launched multiple Territory Score Card reports to access across the regions sales/non-sales reps like USA, LAC, APAC, EMEA etc.

The Sales reports using GUI (.NET), SSRS 2008 R2 to generate and render the reports from EDW (TERADATA).

The following reports are accessed from www.sales.fedex.com site:

Territory Scorecard – Customer Listing/Ranking

Territory Scorecard – TS- Summary

Territory Scorecard – 24 Month History

Global Daily Shipment Volume (GDSV)

Global Customer Trends (GCT)

Roles & Responsibilities:

•Developing MACROS to generate the reports using SSRS from TERADATA(EDW)

•Developing ETL MACROS to process the data from multiple sources like CRP, SFDC, SDW, SCAN, ISH, CASH, iMARKET etc.,

•Creating Stored Procedures with required parameters based on the report requirements

•Monitoring and Performing health check with all iSELL Reporting production Servers.

•Monitoring and Maintenance of SSIS/ETL critical jobs,

•Weekly/Monthly maintenance window patches installation/test support for all production servers

•Monitoring and Maintenance of SSIS/ETL critical jobs,

•Weekly maintenance window support with all production servers

•Setting up new properties and users for reports access setup

•Monitor and maintain SQL Servers in Production, QA, Test and Development Environments

•Create/modify; tune stored procedures, triggers, functions, indexes, views, and schemas.

•Identify, diagnose, and resolve database application deadlocks on production systems.

•Create/modify; tune TERADATA MACROS, stored procedures, triggers, functions, indexes, views, and schemas.

•Identify, diagnose, and resolve database application deadlocks on production systems.

•Verify backups and error logs on the servers and troubleshoot any failures or alerts, open RT tickets for support team to remedy and troubleshoot hardware/SAN drive issues

•Supporting and Developing of MACROS,SSRS 2008 R2 reports and SSIS packages

•Working on SQL Server Reporting Services to provide the RAS(Risk Assessment) metrics to Microsoft using MBSA tool

•Responsible to releases from development to test to production environments

•Providing weekly and monthly status reports to higher management

•Onsite & Offshore co-ordination to lead the team & provide the quality deliverables on time

Environment: UNIX, Windows Server2008 R2, Visual Studio 2008, MS SQL SERVER 2008 R2,TERADATA SQL Assistant,SSIS,SSRS,BIDS,.NET Framework 3.5, Visual Studio .NET, C#, ASP.NET,ADO.NET

Scholastic Inc, New York, NY Jan’ 12 to Jun 13

Domain: EDUCATION, Sr SQL Server/MSBI Developer

Description:

Scholastic Corporation (NASDAQ: SCHL) is the world’s largest publisher and distributor of children’s books and a leader in educational technology and children’s media. Scholastic creates quality educational and entertaining materials and products for use in school and at home, including children's books, magazines, technology-based products, teacher materials, television programming, film, videos and toys. Scholastic distributes its products and services through a variety of channels, including proprietary school-based book clubs and school-based book fairs, retail stores, schools, libraries, television networks

SCHL is having multiple products across the organization using SQL Server 2005 to support DAM(Digital Asset Management) products using for large volume of digital products downloads and uploads via Mass Transit FTP application.

Roles & Responsibilities:

Monitoring and Performing health check with all production Servers.

Monitoring and Maintenance of Mass Transit,

Weekly maintenance with all production servers

Setting up new TeleScope vendors and Novelty vendor setup

Fail Over Clustering Installation with SQL Server 2008 ( both nodes)

Syndicating the data using SSIS packages, Importing XML/XL data using SSIS packages

Verifying all functionalities, performance Testing, Conducting UAT

Monitor and maintain SQLServers in Production, QA, Test and Development Environments

Create/modify; tune stored procedures, triggers, functions, indexes, views, and schemas.

Identify, diagnose, and resolve database application bottlenecks on production systems.

Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments

Implemented Log-Shipping as high availability solution using both Enterprise and Standard SQLServer.

Data Center monitoring, backup, archiving, upgrades and Implementation of all servers.

Supporting and Developing of SSRS 2008 reports and SSIS packages, as well upgrades of previous version of SSIS packages.

Configured Report Server(native) and SharePoint mode, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint.

Created cubes on SQL server 2005/2008 using SSAS,integrated with portal environment to provide dashboard metrics to end users access through CUBES

Security/Configuration management with CUBES and Reports Access

.NET Data provider configuration for Teradata for SSRS/SSAS 2008.

AD/LDAP maintenance/administration, Outlook admin, Terminal services configuration.

Working on SQL Server Reporting Services to provide DAM download/Distribution reports

Working Integration Services to copying the DPD files from source to destination using FTP

Responsible to releases from development to test to production environments

Providing weekly and monthly status reports

Environment: UNIX, WindowsServer2003, Visual Studio 2005/2008,MS SQL SERVER2005/2008,SQL CLR Integration, TERADATA,MOSS 2007, Erwin, J2EE/JAVA,CORBA,Broker Services, Web Objects, LDAP/ADSI,Quest Lite Spped,SSIS,SSRS,SSAS,BIDS,.NET Framework, Visual Studio .NET, C#, ASP.NET,TeleScope Application, SiteScope, MQ Series, ADO.NET, Business Intelligence Suite,Microsoft Operations Manager 2005,Quest tools, Remedy Tool.

Tekriti Software Private Limited Jan 11 to Dec’ 11

Domain: Rating Domain, SQL Server Developer

Description:

The Entertainment Software Rating Board (ESRB) ratings are designed to provide consumers, especially parents, with concise, impartial guidance about the age-appropriateness and content of video games and mobile apps which would help in making informed decision about the ones they deem suitable for their children and family.

Roles & Responsibilities:

• Involved in Database programming.

• Worked on creating stored procedures, Functions, Triggers and Indexes.

• Working with Profilers and Execution plans for improving performance of stored procedures. • Worked on optimizing queries and Performance Tuning.

• Use of pre-existing scripts and utilities for processing and manipulation.

Environment: SQL 2008R2.

National Institute for Micro, Small and Medium Enterprises Jan’ 10 to Dec 10

Domain: Marketing Domain, SQL Server Developer

Description:

PRISM is a worldwide content management application that serves to aggregate and syndicate HP’s product content across different business units and geographies. This project serves to reduce total cost of publishing for various product data publishers in HP. It acts as a single source of repository for storing the content of all the HP Products worldwide. A critical aspect of content management is the ability to manage versions of content as it evolves. PRISM receives altered and edited contents or versions of products as input called feed. The feeds are received from many other applications. Various processes are scheduled to run on a timely basis which will process the required input feed. These processes are scheduled as Job/Process in TIDAL.

Roles & Responsibilities:

• Involved in Database programming.

• Worked on creating stored procedures, Functions, Triggers and Indexes.

• Working with Profilers and Execution plans for improving performance of stored procedures.

• Developing SSIS Packages to carry out data processing and transferring to downstream systems. • Written optimized scripts for moving data from one database server to other database server.

• Worked on optimizing queries and Performance Tuning.

• Use of pre-existing scripts and utilities for processing and manipulation.

Environment: SQL Server 2008R2, SSIS

EDUCATION: Bachelor’s Degree in Engineering (B E)