Sql Server Data

Suneet George

SUMMARY

* *****' experience as SQL Server Developer/Workflow

Developer/DBA/Interface specialist.

Microsoft Certified Professional, Microsoft Certified Technology

Specialist on SQL Server.

Created custom workflow's for moving large amounts of data for invoice

automation.

Implemented business rules at various stages of workflow/processing.

Installed, administered and maintained SQL Server databases in Production

and Test.

Experience with query optimization and performance tuning;

have utilized estimated query plan, database tuning advisor and

SQL profiler.

Experience with Database backup and Disaster recovery procedures.

SQL object experience with Tables, Stored Procedures, Views, Indexes and

Triggers.

Have lead data scoping sessions and designed, developed,

tested and supported interfaces between various ERP systems

including Oracle EBS, JDE, Lawson, IBM WebSphere MQ Tool, XML,

and flat file-based integrations.

Experience with writing and reading data to and from XML documents.

Experience with XPATH statements to retrieve data and XSD documents.

Experience using XSLT to transform data.

Extensive experience scripting with XML-based languages.

Have administered and supported Microsoft Dynamics GP security.

Experience working with ASP.NET and C#.

Trained in Hadoop Ecosystem and related Big Data technologies such as -

HDFS, Map Reduce, PIG, HIVE, FLUME, SQOOP, OOZIE.

TECHNICAL SUMMARY (Representative Sample)

Databases MS-SQL Server 2000/2005/2008, Oracle 11g,

MySQL, Access

Web Technologies HTML, XML, ASP.NET, XPATH, XSD, XSLT

Operating Systems Windows, UNIX

. Net Development C#.NET, ADO.NET, ASP.NET, Windows Forms, Web

Forms

Development Tools Visual Studio .NET 2008/2005/.NET 2003.

Other SSIS, SSRS, Microsoft Dynamics GP, Cognos,

Applications/Tools SalesForce, Visual Source Safe, SVN, Idera

SQL Safe, Preactor, Virtual PC, VM-Ware,

Oracle Virtual Box, Notepad++, IBM WebSphere

MQ, SQL Developer

PROFESSIONAL EXPERIENCE

RR Donnelley Warrenville, IL (Apr 13-Current)

Senior Workflow Developer

The role of the workflow developer is to take client data and move it

through different processes from the input stage to the output stage in an

SOA environment and communicate with various core systems during the

process.

. Transformed business/functional requirements to technical requirements.

. Implemented the workflows and associated Business Rules.

. Deployed and supported the workflows.

. Created tables, views, indexes, Stored Procedures.

. Performed query optimization.

. Performed Extract, Transform and Load (ETL) functions.

. Worked extensively with XML Documents.

. Used XSLT to transform the XML Documents.

. Interviewed, Trained and Mentored new consultants.

. Estimated tasks, projects and work as a lead developer on projects.

Environment: SQL Server 2008 R2, SQL Server 2012, Stored Procedures, T-

SQL, XML, XSLT, XSD, C#, SQL Red Gate

Basware Inc, Rosemont, IL (Apr 10 - Apr 13)

Interface Specialist (Extract Transform Load Specialist)

With over 1,500 clients in more than 60 countries, company is the global

leader in purchase-to-pay solutions. Company specializes in providing

solutions to automate entire invoice life cycle. Company's primary software

integrates with all major ERPs, including Oracle EBS, Lawson, PeopleSoft,

JDE and SAP to import and process Invoice and PO Master data and then

transfer the modified payment information into the appropriate ERP system.

. Created databases, tables, views, indexes, Stored Procedures and

triggers.

. Performed query optimization and database tuning.

. Performed Extract, Transform and Load (ETL) functions.

. Performed database backup and restore functions.

. Lead client data mapping sessions.

. Planned inbound and outbound data extracts.

. Troubleshot issues using SQL profiler.

. Created reports using SQL queries and Stored Procedures.

. Performed data Imports into SQL Server from XML, Flat files, Oracle and

SAP using SQL Import/Export tool.

. Mentored new consultants.

. Authored "How to" Guides for SQL Server to perform basic functions.

. Created custom product (Price List Matching) and implemented for invoice

automation.

. Extensive experience implementing business rules per client requirements.

. Extensive experience scripting interfaces using proprietary XML-based

language (anyERP).

. Performed XML based integrations, reading inbound and writing outbound

XML files.

. Experience troubleshooting issues with XML files.

. Experience storing XML files in SQL Server and retrieving data using T-

SQL.

. Wrote XPATH statements to retrieve data from XML documents based on XSD.

. Wrote out XML files as part of data extracts to ERP systems.

. Used XSLT to remove empty nodes from XML document.

. Used XSLT to display company specific fields while generating PDF print

documents.

. Used XSLT to display invoice images for eInvoices.

. Created virtual environments on Virtual PCs, VM Ware and Oracle Virtual

Box.

. Performed quality checks and advised other consultants on best practices.

Environment: SQL Server 2005/2008, Stored Procedures, T-SQL, SSIS,

SSRS, Oracle 11g, XML, XSLT, XSD, C#, IBM WebSphere MQ tool,

Oracle EBS, JDE, People soft, Lawson

Optimum Nutrition, Aurora, IL (Apr 09 - Apr 10)

Database Administrator/Data Analyst

Optimum nutrition owns and operates two brands of nutritional supplements

with state-of-the-art production facilities. It manufactures items in

every product category such as nutritional bars, protein powders, ready-to-

drink sports beverages, or vitamins, essential minerals, and herbs.

. Administered and maintained SQL Server 2005 databases.

. Managed and administered security for Microsoft Dynamics (GP).

. Worked with Director of IT and Business Analyst on various programming

and reporting requirements.

. Wrote SQL scripts to integrate Preactor with Great Plains.

. Created Custom SQL Server integration packages (SSIS) using Visual Studio

2008.

. Maintained Multiple Database environments, including Test, QC, and

Production.

. Created reports using SSRS for Preactor.

. Wrote code and creating jobs to automate repetitive tasks.

. Developed custom .NET applications using C# and ASP.NET.

. Implemented database backup/recovery plans.

. Planned, designed, and implemented complex triggers, Stored Procedures

and views.

. Created XML files using T-SQL and readied for processing.

Environment: SQL Server 2005/2000, Microsoft Dynamics (GP) 10.0,

ASP.NET 3.5, C#, HTML, Visual Studio 2008, SSIS, SSRS, Cognos

8.4, Windows XP, Stored Procedures, XML, T-SQL

Snider Advisors, TX (Dec 08 - Apr 09)

Database Administrator/Application Developer

Snider WEB is an online portal used by clients to browse, signup, and

download course material. Registered clients can then use the application

to view courses and services, or to upgrade to a higher level of service.

Company uses this portal to sell products, for customer interaction, and

also to maintain client information.

. Administered and maintained SQL Server 2005 databases.

. Planned and designed tables, views and Stored Procedures.

. Transformed business/functional requirements into technical requirements.

. Developed web application using ASP.NET and C#.

. Used Visual Source Safe and SVN (Subversion) for version control.

. Created reports using SSRS.

Environment: SQL Server 2005, Stored Procedures, C#, Visual Studio

2008, ASP.NET, VSS, Ajax, SSRS

BCS Inc INDIA (Jun 05 - Jul 06)

Jr Database Administrator/Application Analyst

Worked with senior DBA to administer, maintain and support SQL Servers.

. Assisted in Administration, maintenance and support of SQL Server

databases.

. Designed and developed databases.

. Wrote SQL queries and Stored Procedures.

. Created tables, views and indexes.

EDUCATION

. Masters at Indiana State University, Mathematics with concentration in

Computer Science

. Bachelor of Engineering in Computers, Bangalore, India

CERTIFICATIONS/TRAINING

. 70-463 SQL Server 2012, Implementing a Data Warehouse with Microsoft

SQL Server 2012(SSIS, Data Warehouse).

. 70-462 SQL Server 2012, Administering a Microsoft SQL Server 2012

Database(Database Administration).

. 70-432 SQL Server 2008, Implementation and Maintenance (Database

Administration).

. 1Z0-007 Introduction to Oracle 9i: (Oracle Certified Associate)

. 1Z0-052 Oracle Database 11g:Administration 1 (Oracle Certified

Associate)

. PRO: Designing and Developing Web-based Applications by Using the

Microsoft .NET Framework (C#).

https://mcp.microsoft.com/Anonymous//Transcript/Validate

Transcript Id : 812969

Access Code : suneet27[pic][pic]

Contact this candidate