Sr SQL Developer & Analyst

Suman Jupudi

**********@*****.***

510-***-**** (C)

Summary:

• 14 years of IT experience as a Sql Server Developer 2008/2005/2000 and PeopleSoft in various Industry verticals like Automobile , Customs, Finance and Transportation.

• Extensive experience in Sql Server 2008/2005/2000, Business Intelligence in Sql Server Integration Services, Sql Server Reporting Services and Sql Server Analysis Services.

• Expert in Developing SSIS Packages to Extract, Transform and Load ETL or DTS data into the Data warehouse from Heterogeneous databases like Oracle, DB2, Sybase and Access.

• Extensive experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for Sql Server/Oracle/ Sybase databases.

• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like Sql Server 2000, Excel and Flat file to Microsoft SQL Server and Oracle Database by using SSIS and DTS utility of SQL server 2005.

• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.

Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005.

• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.

• Maintained positive communications and working relationships at all business levels.

• Worked in all phases of the software life cycle including analysis, design, development, testing and implementation

• Demonstrated ability to translate complex business process into technical specification and solutions.

Excellent communication skills, has clear understanding of business procedures and ability to work as an individual and also as a part of a team.

Technical Skills:

Database: SQL Server 2008/2005/2000, Oracle 10g/9/8i, Sybase, Informix 7.x/5.x

Reporting Tools: SQL Sever Reporting Services SSRS 2005,Crystal Reports,

PS Query, SQR

DBMS Tools: SQL Server Management Studio, TOAD,

Languages: T-SQL, SQL, PL/SQL, Informix 4GL, Html, XML/XSL, Visual Basic

Development Tools: Visual Studio 2005/2003, SSIS 2005, Power Builder

Operating Systems: Windows 2003/2000/NT/9.x, MS-DOS, UNIX, SUN Solaris

Version Control: Visual Source Safe

ERP: PeopleSoft Supply Chain – Order Management, Inventory, Purchasing

EXPERIENCE

New United Motors Manufacturing Inc.

New United Motor Manufacturing, Inc.(NUMMI) is the pioneering joint venture of GM and Toyota. Established in Fremont, California, in 1984, NUMMI helped change the automobile industry by introducing the Toyota Production System and a teamwork-based working environment to the United States.

Fremont, CA 05/2003-Till Date

PeopleSoft and SQL Server Consultant

Projects

One for One Package Returnable (OFO) Project

• Lead NUMMI IT Team to Implement and Support One for One Returnable Packaging (OFO) Project for Car and Truck Dock.

• Involved in gathering data and documenting it for further reference.

• Designed and Developed Maintenance, Logistics, Variance and Plant side Reports using SQL Server Reporting Services (SSRS).

• Designed, and implemented SQL Server database objects (stored procedures, functions and views, complex T-SQL/queries) to support data integration (SSIS) and various business processes.

• Conducted peer-review on existing stored procedures/functions and performed optimization.

• Installed And Configured the Multi Slot Printers for the Application to printer on any of the configured slot by Region.

• Developed Stored Procedures to Load Skid Manifest data in to Ticket Master Table from the Main Frame, for the floor team members to scan and print the returning packaging.

• Created SSIS packages to extract data from Flat Files to Sql Server and scheduled Jobs to call the packages and Stored Procedures.

• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.

• Developed and maintained enterprise reporting (SSRS Reporting Services / Crystal Reports) based on specifications and business needs and modified existing reports as needed.

• Designed, Developed and Deployed reports in Sql Server environment using SSRS-2005.

Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

• Created reports to retrieve data using Stored Procedures that accept parameters.

• Involved in upgrading from SQL Server 2000 to SQL Server 2005.

• Fine tuned SQL Queries for maximum efficiency and performance.

• Provided documentation for all kinds of reports, DTS and SSIS packages.

• Supervised and trained newly-hired analyst / developer in business process, practice standards, and data applications.

• Designed and developed test plans, test cases & test data. Also involved in System testing of the programs with actual production data, also involved in production support after go-live, resolved issues and provided resolutions

Environments: Visual Studio 2008/2005, SQL Server 2008/2005, T-SQL, SSRS, SSIS, Visual Source Safe, Remedy

Trailer Tracking

• Implemented and Support Trailer Tracking Weight (Gate8) Tickets System, which create tickets for Inbound Trailers, to track Trailers Weight, maintain Trailer Certification, and any Hazardous Commodities.

• Developed, Implemented System to process Logistics Advanced Shipment Notice (ASN) for Inbound Production Parts, EastBound and Westbound file transmissions received from Union Pacific for hourly Train Activity.

• Developed, Implemented procedure to load the Logistics and Local Advanced Shipment Notice (ASN) to PeopleSoft Finance Accounts Payable (AP) module for three way matching.

• Developed many Reports to print on Zebra printers using Zebra Printing Language (ZPL).

Environments: Visual Studio 2005, SQL Server 2005/2000, T-SQL, SSIS, SSRS, PeopleSoft 9(AR,BI), Oracle 10g, Toad, ZPL, Visual Source Safe, Remedy

Just in Time

• Implemented and Support Just in Time (JIT) System which track the Trailer movement IN and Out of NUMMI.

• Developed the Shipper Scan Module to Scan and Update the PeopleSoft Shippers, which is used to calculate the Delivery Due Date (DDD) for the Service Parts Orders.

Environments: Visual Studio 2005, SQL Server 2005, T-SQL, Oracle 10g, Visual Source Safe

Peoplesoft Order Management - Service Parts Project

• Lead NUMMI IT Team to implement PeopleSoft Order Management, Production Planning, and Manufacturing modules for PeopleSoft Service Parts Project.

• Lead testing of functional processes including EDI and manual order processing, for Service Parts, custom production modules, and interfaces.

• Created an Outbound Interface between PeopleSoft Manufacturing and Main Frame to transmit ASN (Advanced Shipment Notice) for Service Parts Orders.

• Created an Inbound Interface to Load data into PeopleSoft Service Parts Tables, for all New Model Toyota Tacoma Truck Service Parts.

• Created SQR Report to monitor Due Delivery Date (DDD) for Service Parts Daily Plan vs Actual Shipments, Daily Packaged, Month to Date Ship Actual, Daily, Monthly and Outstanding Back Orders and Shipment Variance.

• Kaizen PeopleSoft system to fit NUMMI’s business processes.

• Lead data analysis and data conversion from Existing PeopleSoft Service Parts to Non Vehicle Ordering System (NVOS).

• Design, Develop and Implement data interfaces from Trailer Tracking System to PeopleSoft Accounts Payables (Standard Freight) for 3 way PO matching.

• Designed and developed test plans, test cases & test data. Also involved in System testing of the programs with actual production data, also involved in production support after go-live, resolved issues and provided resolutions.

Environment PeopleSoft 7.54/8.4, Order Management 7.5x, Inventory 7.5x, Production Planning, People Tools 7.5x, SQR 4.0, Crystal Reports 6, TOAD, ZPL, Oracle 8.x, Win NT

Trade Ship Inc. Melville, NY 02/2001-04/2003

Project: Trade Depot System

Prepared the Trade Depot Maintenance System to manage the daily yard and repair shop activities in a Depot using PowerBuilder and Sql Server 2000.

• Creating report dynamically in PowerBuilder (8.0/7.0).

• Used Cross Tab, Tabular etc. type of Data window to design the given report.

• Performance tuning of the developed report was also done.

• Prepares flow charts and diagrams to illustrate sequence of steps program.

• Worked with a system using SQL Server 2000 database

• Responsible for developing Stored Procedures, Triggers and Functions using T-Sql and PL/SQL

• Designed and implemented a user interface to access data using PowerBuilder

• Ability to write SQL Server 2000 queries using techniques such as correlated sub queries, multi-

table joins and conditional logic

• Data Transformation Services.

• Management of our SQL Server databases.

• Version control using Visual Source Safe.

Environments: PowerBuilder 7.0, SQL Server 2000, T-SQL, Oracle 8.1.6/8.1.7, PL/SQL, Citrix Meta Frame XP, ICA Client, Visual Source Safe, Java, XML, Mercator 5.0

Project: Malaysia International Shipping Corporation Sealiner 09/2000-01/2001

Kaulalampure, Malaysia.

Developed the Shipping Line software Sealiner System using PowerBuilder and Sql Server 2000.

Responsibilities

• Created non-visual objects, added user functions to the non-visual objects.

• Created data windows on the server and client side using stored procedures as data source

• Inherited objects from their ancestor objects and added additional functionality to the child objects

• Developed tab pages and windows, inherited from the ancestor for the client side of the application.

• Worked with a system using SQL Server 2000 and Oracle database.

• Developed the Import and Export Documentation modules which create the Bill of Lading

from Booking Information.

• Responsible for developing Stored Procedures, Triggers and Functions using T-Sql

for the Import and Export Documentation Modules.

Environments: PowerBuilder 7.0, SQL server 2000, T-SQL, Oracle 8.1.6/8.1.7, PL/SQL, Citrix Meta Frame XP, ICA Client, Visual Source Safe

Jamaica Customs, Kingston, Jamaica 07/1998 – 08/2000

PowerBuilder Consultant

Project: Revenue Accounting System

Prepared the Revenue Accounting System for the revenue collected and the Disbursements made for Jamaica Customs Department using PowerBuilder 6.5/7.x.

Responsibilities:

• Designing the screen as per specification.

• Coding for the given screen as per coding standard, set for the application.

• Extensive use of Quick Select /Sql Select/ Store procedure type data windows

• Extensive use of Cursors to port data from flat file to Informix database.

• Extensive use of data pipeline painter.

• Developed the System to Downloaded the data from another Informix Server.

• Designed and implemented a user interface to access data using PowerBuilder 6.5/7.x

Environments: PowerBuilder 6.5/7.x, PFC, Informix 4GL, Informix 7.x, AIX-Unix, Help Breeze

Jamaica Customs, Kingston, Jamaica 11/1996-06/1998

PowerBuilder Consultant

Project: C83 Entry Processing System

Prepared the C83 Entry Processing System for clearing the non-commercial

Goods, provide better controls when automating cargo processing, and facilitate better accountability the revenue collected and the Disbursements made for Jamaica Customs Department using PowerBuilder 6.5/7.x.

Responsibilities:

• Worked with a system using Informix database.

• Setting Coding Standard, Window standard, Program Execution standard etc.

• Getting user requirement and resolving user needs by setting validation rules.

• Creating Data Windows, Windows, Menus using PFC.

• Creating Visual and Non-visual Objects.

• Developed the System to Downloaded the data from another Informix Server.

• Designed and implemented a user interface to access data using PowerBuilder 6.5/7.x

Environments: PowerBuilder 6.5, PFC, Informix 4GL, Informix 7.x, AIX-Unix, Help Breeze

Ram Informatics 03/1996-10/1996

Programmer

Project: Integrated Financial Accounting System

Prepared the Integrated Financial Accounting System that provides the normal CASH BOOK, LEDGER SALES, PURCHASE Registers, JOURNAL Registers, DEBIT note and CREDIT NOTE Registers as the principal books of Accounts and further the financial statements generated thereon viz., the TRAIL BALANCE, PROFIT & LOSS and Balance Sheet using PowerBuilder 5.0.

Responsibilities:

• Worked with a system using Sybase database.

• Creating Data Windows, Windows, Menus using PFC

• Creating Visual and Non-visual Objects

• Getting user requirement and resolving user needs by setting validation rules

• Creating Data Windows, Tables. Setting Primary and Foreign Keys

• Designed and implemented a user interface to access data using PowerBuilder 5.0

Environments: PowerBuilder 5.0, Sybase System 10.0, T-SQL, AIX-Unix, Help Breeze

PROFESSIONAL QUALIFICATIONS

• Bachelor of Engineering (Electronics and Communications) from Bharathiar University.

• Certificate of Completion in SOA (BPEL, ESB)

• Certificate of Completion in Oracle 6.0

• Certificate of Completion in Unix & C

• Certificate of Completion in PowerBuilder

Contact this candidate