Sql Server Manager

SUMMARY

• Four years of professional experience in the IT industry, background includes extensive experience with all phases of software development, from requirements gathering to post-implementation support and maintenance.

• Experience with all variety of Databases with strong SQL query skills.

• Experience in SSRS reports generation with SQL Server.

• Experience in SSIS with SQL Server and Visual studio.

• Experience in Development and customization of crystal reports.

• Programming background in diverse facets of .NET development, encompassing analysis, design, development, and execution of business applications.

• PeopleSoft Techno-Functional experience in different roles as part of Implementation/ Upgrade/ Conversion/ Development/ Testing/ Production Support teams.

• Experience in Design, Development and implementation in PeopleSoft HR, Payroll, Ben Admin, Benefits and Time & Labor.

• Work collaboratively with team members to achieve common goals, while maintaining individual responsibilities.

• Result oriented team member, excellent oral and written communication skills with sharp analytical abilities.

EDUCATION

Masters in Software Engineering, University Of Wisconsin, La Crosse.

Bachelors of Science, Kakatiya University, India.

TECHNICAL SKILLS

Platforms: Windows

Programming: C#, .NET, Java SWT , SSIS and Visual Basic.

Databases: Oracle8i/9i, MS Access, MS SQL Server2005/2000, DB2

Reporting Tools Crystal Reports, SQR , SSRS

ERP Tools Application Designer, Application Engine, SQR, PeopleCode, Security Administrator, People Tool Utilities, Process Scheduler, Data Management tools, Query, Workflow Administrator, Application Engine, Message Catalogue, Seagate Crystal Reports and Process Monitor.

GUI: Developer 2000, Microsoft Visual Studio

Web scripting: HTML, XML

Domain Knowledge: Human Resources, Global Payroll and Data Quality

MSE Projects - University Of Wisconsin, UWL

Meeting Scheduler Application (GA- Spring 2008) Jan’08-March’08

It is an application for scheduling meetings for CS department in the university.

Responsibilities:

• Meeting scheduler is an existing application in CS department. One of the major problems identified with this application was the User interface.

• Task to modify the existing User interface and refactoring some of the modules within the application was assigned to me.

• Changed each page so that it is more user-focused and user-friendly.

• Worked on the functionality which was not working properly.

• Information security is provided with different functionalities.

• Provided simple and intuitive navigation across all screens.

Environment: ASP.NET.

Student Evaluation of Instruction (Capstone Project) Apr’09-Dec’10

It is a web application for Student Evaluation of Instruction.

Responsibilities:

• Developing the web forms for filling the evaluation form.

• The graphical user interface is developed for multiple tasks.

• Maintains the data for the user and displays the required information.

• Developed web page will be applicable to all the departments.

• Data Security and validity must be maintained. Information security is provided with different functionalities.

• Reports are generated for analysis for sophomores.

• The implementation process should produce a numerical summary of the evaluation results, showing responses by category (dept, instructor, course and section), in a printable format.

Environment: ASP.NET, MYSQL and Excel.

Professional Experience:

Authenticom, La Crosse, WI Mar’11-Mar’12

SQL Server Developer

Authenticom is a leading provider of data services in the automotive industry. It is a specialize in Dealer Management System Integration to define and schedule the data management jobs. It also provides Data Hygiene services such as CASS, NCOA Standardization, Phone append, Phone validation, Email append and Email validation.

Responsibilities:

• Developed SSIS using SQL Server Management Studio.

• Implemented all the data transformations using SSIS tool.

• Developed SSIS package to load customer data into the target tables which includes customer name, address, phone and email information.

• Generated SSIS package, for Phone Match, which includes matching the provided phone numbers and inserting the new numbers if it doesn’t match.

• Developed SSIS package, for Email Match, which includes matching the provided email addresses and inserting the new email if it doesn’t match.

• Developed SSIS packages to load Phone Email information for the given customer.

• Updated the DPE jobs by replacing the old job steps with the new ‘Execute SSIS Package’ step, to execute the newly created package.

• Created new DPE jobs to convert the existing batch files into the appropriate job steps.

• Worked on Ace process to add the new NCOA address for the given customer list.

Environment: SSIS, SQL Server 2005, Microsoft Visual Studio 2005 and Windows NT.

Kaplan Schweser, La Crosse, WI Aug’10-Mar’11

Report Analyst

Kaplan is a leading global provider of financial and accounting educational products and services. Helps individuals achieve their career goals. It is a dynamic, customer-focused, technology-driven organization.

Responsibilities:

• Developed adhoc reports using SQL Server Management Studio.

• Report generation includes analyzing business requirements, designing analysis, developing the query and exporting to excel sheets.

• Developed SSRS reports for interactive and printed reports using microsift visual studio report designer.

• Generated SSRS reports, defined by RDL, in a variety of formats suchn as Excel, csv, pdf and other formats.

• Reports are generated with shared data sources, building expressions and stored procedures.

• Developed dynamic reports in tabular format with conditional formatting and aggregates.

• Reports are designed to provide the educational and financial information in the required format, according to the given list of requirements.

Environment: SSRS, SQL Server 2005, Microsoft Visual Studio 2008 and Windows NT.

SAP-Business Objects, La Crosse, WI Aug’09-Aug’10

Graduate Intern

SAP provides business software to help companies clearly understand all aspects of their business. By using SAP solutions, companies of all sizes–including small and midsize–can reduce costs and optimize performance. SAP provides the tools and applications companies need to better organize and manage information, optimize everyday business activities, and improve the way employees work.

Responsibilities:

• Worked full cycle with Development team for Business Objects Data Services Aurora Release .

• Primary responsibility is to assist in Crystal Reports development, Java based web interface development and bug fixes.

• Developed Crystal reports for collecting and analyzing enterprise data.

• Responsible for customizing the existing reports with enhancements. Implementing fixes and enhancements.

• Design and developed Data Quality batch jobs within the Business Objects Data Services Environment

• Wrote database scripts for Oracle, DB2, MySQL, Sybase and SQLServer.

• Developed web interface using Java(Servlets and JSP) to Data Quality Address Validation certification logs and reports.

Environment: SQL Server 2005,Oracle,DB2,Sybase,Eclipse,Java,Crystal Reports, Data Sevices, Business Objects Enterprise, Microsoft Visual Studio 2008 and Windows NT.

Trane, La Crosse, WI Mar’07-Oct’07

Peoplesoft Technical Consultant

Trane is a leading global provider of indoor comfort systems and comprehensive facility solutions, with current annual sales approaching $5 billion. Its offerings include energy efficient heating, ventilating and air conditioning (HVAC) systems, top-notch service and parts support, sophisticated building controls and financial solutions, including the Performance Agreement for Comfort from Trane

Responsibilities:

• Developed main SQR interface to convert legacy system data to Peoplesoft Application tables.

• Responsible for developing data validation SQR process which sends control table information to legacy

• Modified existing Crystal Report Formats and added new Reports using PS/Query to generate reports of the Customized application as per the user requirement.

• Generation of various Standard Reports using Crystal Reports like balance amount summary information by customer and item, Unapplied amount information by Business Unit with specified periods called buckets.

• Providing resolutions to the user to resolve deficiencies, which involved extensive debugging of PeopleCode, and SQR.

• Responsible for communicating with Peoplesoft users to gather business and reporting requirements.

• Responsible to contact various sales office and load customer data into peoplesoft tables.

• Worked on many queries for tuning purpose using Query Manager.

Environment: PeopleSoft HRMS 8.8, PeopleTools, SQR 6.14, App Engine, Query Manager, PeopleCode, Crystal Reports, Process Scheduler, SQL Server 2005 and Windows NT.

WPS Resources Corporation, GreenBay, WI Sep’06-Mar’07

PeopleSoft Technical Consultant

WPS Resources Corporation is a regulated electric and gas utility serving Northeast and Central Wisconsin and an adjacent portion of Upper Michigan.

Responsibilities:

• Responsible for data conversion from legacy system to PeopleSoft.

• Extensive use of SQR, App Engine, Datamover and SQL Server.

• Studied the basic user requirements and analyzed, designed the specifications, developed and tested the daily, weekly, monthly reports using SQR reports.

• Developed new SQR reports from scratch like, Number of employees in each Benefit Program, and List of employees in each major Benefit Plan, like Medical, dental, and Life AD/D, etc.

• Customized several pre-delivered Payroll Crystal Reports.

• Designed and developed interfaces, reports for HR/Benefits and accessed related tables for Benefits including Health Benefit, Dependent Benefit, Dependent Coverage, Health Dependent Coverage and Health Dependent.

• Writing Interface SQR Reports to send the employee’s data to United Way Contribution.

• Tuned SQL/SQR’s to improve performance using advance SQR features like Load lookup and Arrays.

• Involved in writing Control files for SQL*Loader in the process of loading data from flat files of legacy databases to Oracle Database.

Environment: PeopleSoft 8.0 SP1, PeopleTools, App Engine, SQR, Crystal Reports, Query Manager, SQL Loader, Windows NT, SQL Server 2000.

Kaiser Permanete, Oakland, CA Apr’06-Sept’06

PeopleSoft Consultant

Kaiser Permanente is a health care and insurance company. It is one of efficient America’s health care solutions.

Responsibilities:

• Worked with the Team to analyze the user requirements.

• Customized reports, inbound/ outbound Interfaces in HRMS modules using SQR.

• Developed complex SQR programs to Migrate data from the legacy system to PeopleSoft tables.

• Designed and developed many complex SQR's for Interfaces and Conversion reports utilizing various SQR methods like Break Logic, Load-Lookup, Arrays and Multiple reports in HRMS environment.

• Customized SQR reports such as Employee Summary, absence history, Department salaries, Salary plans, Earnings, Deduction, payroll summary and tax summary.

• Developed and customized several reports using Crystal Reports such as Local/ State/ Federal Tax reports, YTD Earnings/Deduction reports, leave accruals, employees details in each Benefit Program, and in Benefit Plans like Medical, dental and Life Insurance.

• Used Data Mover to move the data in between different databases.

• Used Component Interface and Application Messaging for integrating applications.

• Responsible for assisting QA teams in their development and execution of system tests.

•

Environment: PeopleSoft HRMS 8.8 (HR, Benefits Admin, Payroll, Time & Labor), PeopleTools 8.45, SQR 6.14, PeopleCode, App Engine, Workflow, Component Interface, App Messaging, Crystal Reports,DB2, SQL Server 2000, Windows NT.

Contact this candidate