Priya Dasari
La Grange, KY ***31.
Email: ************@*****.***
Mobile: 502-***-****
Home: 502-***-****
SUMMARY
• Experienced software professional having 10+ years of IT experience involved in all phases of Software development life cycles.
• 3+ years of experience in Application development of web based client/server applications and Database applications using ASP.NET, C#.NET, ADO.NET, SQL server 2005, .NET Framework 2.0/3.5, Visual Studio.NET 2005/2008, SQL Server Reporting.
• Expertise in developing .NET Controls such as Server Controls, Validation Controls, User Controls and Custom Controls
• Expertise in working with Data Controls such as Grid View, Data Grid, Data List, Details View, Repeater.
• Expertise in working with ADO.NET Components such as Dataset, Data Table, Data Adapter and Data Reader.
• Expertise in generating Reports and using SQL Server Reporting Tool.
• Experience in Deployment of ASP.NET components that include .NET Remoting/Web Services on IIS.
• Experience in Database Design, Database Programming and Normalization using SQL Server 2005.
• Experience in developing, testing, debugging, and supporting C#, ASP.Net in different internet browsers.
• Experience in developing WEB SERVICES using .Net framework .
• 2 years of Experience in Datawarehousing with ETL development using Informatica.
• 7 years of Extensive experience on IBM iSeries (AS/400) with proficiency in ILE RPG, CL, DB2, SQLRPGLE and Advantage-2E(Cool-2E/Synon).
• Excellent interpersonal ability and a very good team player with good communication Skills. Out-standing problem solving, ability to work under pressure, decision making skills and fast learning and grasping capability of new emerging technology.
TECHNICAL EXPERTISE
LANGUAGES: C#, C/C++, VB.Net and VB 6.0, PL/SQL, Embedded
SQL, ILE RPG, CL, COBOL
OPERATING SYSTEMS: MS Windows (XP/2K/NT), OS/400, HP Unix
RDBMS: MS SQL Server 2005, Oracle 9i & DB2
WEB TECHNOLOGIES:
Markup Languages: HTML,XML
Scripting Languages : Java Script
.NET TECHNOLOGIES: ASP.NET 2.0/3.5, .NET framework 2.0/3.5, Visual Studio 2005/2008, Web Services, ADO.NET, AJAX, Infragistics
APPLICATION SERVERS: IIS 5.1/6.0
INTERFACES: MQ Series, EDI
ETL Tools: Informatica
Reporting Tools: SQL Server Reporting
INDUSTRIES: Warehouse, Manufacturing, Health Care, Pharmaceutical, Financial, Distribution, Publishing, Merchandise Marketing, Retail & POS.
EDUCATION
• 1989-1993 Diploma in Computer Engineering, State Board of Technical Education & Training, AP, INDIA.
EXPERIENCE
Southern Graphic Systems, Louisville, KY 1/2009 – Till Date
.Net Technical Consultant
SGS is a proven leader with more than 60 years of Consumer Product and Retail branding experience. Clients with diverse needs benefit from SGS' technical expertise and strategic locations across the globe.
SGS services include package design, prepress, imaging and management of the entire brand development and execution cycle.
SGS provides innovative "Design-2-Print" solutions to enhance brand identity and improve clients "Speed-to-Market" demands.
Responsibilities:
• Involved in the Maintenance and Enhancement of the existing system(MYSGS – Order Entry System).
• Involved in requirement gathering and analysis process of the new System(VIPOR – Invoicing System)
• Developed the Web Application in ASP.Net using most of the .Net Framework Controls, User Controls, Java Script, Infragistics Grids, Web Services, AJAX Tool Kit.
• Used SharePoint for Document Maintenance.
• Developed custom class libraries in C# implementing object oriented concepts.
• Implemented role based security and customizable workflows based on a user's role.
• Involved in migrating the data from Virtual Ticket database (SQL Server) to MYSGS(SQL Server) database.
• Developed new Reports And also converted existing Reports from AS400 by using SQL Server Business Intelligence Tool.
• Developed stored procedures and Functions for saving network traffic and improving the performance of database transactions.
Environment: Visual Studio 2005/2008, .NET Frame Work 2.0/3.5, SQL Server 2005, Java script, C#, SharePoint, Visual Source Safe, Win XP Professional
Kindred HealthCare, Louisville, KY 10/2008 – 12/2008
.Net Technical Consultant
Clinical Systems
Involved in fixing the bugs and developing the enhancements during QA & UAT testing of the Clinical Systems Application which includes Resident Profile, Care Plans & Conferences.
Environment: ASP.NET 2.0/3.5, C#.Net 3.0, Visual Studio 2005/2008, .Net framework 2.0/3.5, SQL Server 2005, JavaScript, IIS6.0, XML, HTML, AJAX Control Toolkit, AJAX Extensions 1.1, Win XP Professional, Visual SourceSafe
Walgreens, Deerfield, IL 10/2006 – 8/2008
.Net Technical Consultant
Promotional Merchandise Marketing
Involved in the Maintenance and Enhancement of the existing system (Ad Bltn and Group Sheet Applications). Created detail design (Macro) to program specification (Micro) level, based on system requirements.
Also involved in modifying the Bottle Deposit programs of Merchandise Systems – Direct Store Delivery Application.
Responsibilities:
• Involved in requirement gathering and analysis process.
• Developed the Web Application in ASP.Net using Master Page, Themes & skins to maintain the consistent look and feel throughout the application.
• Used Grid View and Details View Controls to display formatted data on the Web forms.
• Developed and designed custom Web Controls and User Controls providing code reuse and ability to inherit complex UI.
• Implemented Validation using Validation Server Controls -- RequiredFieldValidator, CompareValidator, Validation Summary etc.
• Developed custom class libraries in C# implementing object oriented concepts.
• Implemented role based security and customizable workflows based on a user's role.
• Incorporated delegates in C# for event handling in User controls and Custom controls.
• Maintained Session, Application and View State Objects.
• Used AJAX Extensions 1.1 and AJAX Controls Toolkit to improve performance
• Performed Client-Side and Server-Side form validations using JavaScript and ASP.NET Validation Controls
• Implemented Custom Error Handling to handle exceptions
• Developed stored procedures and Functions for saving network traffic and improving the performance of database transactions.
• Worked on Triggers, Transactions, Locks, Advanced Queries, Distributed Queries and SQL Cursors
• Documented release notes, test scripts, user manuals and estimation reports.
• Interacted with business users and handled change request to the system.
• Developed test cases, test plans and worked on bug fixes.
• Involved in Module testing, Unit testing, User Acceptance testing and maintenance.
• Organized test data to be used for UAT by querying across various databases
• Trained production support teams by facilitating knowledge transfer sessions.
• Peer review.
• Imparted training to the end client about the usage and the features of the application.
• Worked extensively and understand the Onsite -- Offshore model.
• Attended Informatica training and Involved in some Data warehousing activities like developing ETL transformations using Informatica and generating reports.
• Developed ETL transformations by using Active, Passive, Connected, & Unconnected transformations.
• Involved in design, develop, and implement data extraction, staging, transformation and loading to populate a SQL Server operational data store (ODS) and enterprise data warehouse (EDW) from multiple data sources.
• Used SQL Server Reporting Tool on web platform from various databases to generate reports based on viewer customization.
• Deployed the application on the production sever by creating the Web Setup project in Visual Studio.NET
Environment: ASP.NET 2.0/3.5, C#.Net 3.0, Visual Studio 2005/2008, .Net framework 2.0/3.5, SQL Server 2005, Informatica, JavaScript, SQL Server Reporting Tool, ADO.NET, IIS6.0, XML, XSLT, XSD, HTML, DHTML, AJAX Control Toolkit, AJAX Extensions 1.1, Win XP Professional, Visual SourceSafe
Midwest Express Group, Columbus, Ohio 11/2005 – 8/2006
AS400, Synon Technical and Functional Consultant
Manufacturing Warehouse & Logistics
Midwest Express Group is the warehouse of Honda Manufacturing of America. I have involved in the entire life cycle of the new and enhancement projects, to consolidate and send the parts to HONDA as per their day to day production requirements.
Responsibilities:
• Fixed bugs produced as a result of System Testing and User Acceptance Testing.
• Created Test Plans, Unit testing and Bug Fixing and Enhancements.
• Involved in Analysis, design, and development of AS400 & Synon Applications.
• Developed various reports using SQL Server Reporting Tool.
Utilized Advantage-2E (Cool-2E/Synon), AS400, SQL Server, RPG ILE and CL programming, Implementer
RR Donnelley, Lisle, IL 3/2005 – 9/2005
AS400, Synon Technical and Functional Consultant
Warehouse Business System(WBS) This Application includes: Receiving, Pick Wave, Inventory Management & Shipping.
Created MQ Interface Programs to Upload/Download data between WICCS (Warehouse Distribution Center) and WBS (Warehouse Business System).
Involved in Design, Development and Testing of WBS Application Enhancement to support Numbered Items(Critical Number Ranges).
Responsibilities:
• Involved in Analysis, design, and development of AS400 & Synon Applications.
• Developed various reports using SQL Server Reporting Tool.
Utilized Advantage-2E (Cool-2E/Synon), AS400, SQL Server, RPG ILE and CL programming
Johnson Diversey, Racine, WI 5/2004 – 2/2005
AS400, Synon Technical and Functional Consultant
Johnson Diversey is an SC Johnson Company. I was involved in a Conversion Project to Move DB2 Database in to SQL Server. Analyzed, Designed and developed SQL Server Database and developed ASP Application for data import from DB2, EXCEL to SQL Server.
Responsibilities:
• Involved in Analysis, design, and development of AS400 & Synon Applications.
• Designed and maintained the company's SQL Server database
• Created Stored Procedure(s), Functions, Views and Triggers for updating and display of data
• Wrote functional specifications catering to the end users preference
• Developed various reports using SQL Server Reporting Tool.
Utilized Advantage-2E (Cool-2E/Synon), AS400, SQL Server, RPG ILE and CL programming
North American Stainless, Ghent, KY 5/2003 – 1/2004
AS400, Synon Technical and Functional Consultant
Created customized programs and modifications to existing programs as requested. Also involved in various other tasks as needs arose.
Utilized Advantage-2E (Cool-2E/Synon), SQL, RPG ILE and CL programming
Scholastic, Secaucus, NJ 1/2002-3/2003
AS400 Consultant
This project is to migrate the database from non-relational to relational database (DB2) and modify the existing Application, which runs on non-relational database, to support product database (relational).
Designed and developed the database by mapping the fields between 2 databases, Developed/Modified the existing process to support new database and verify the Application and Database after the migration.
Utilized AS400, ILE/RPG400, COBOL400, CL400, DB2400, SQL400, QUERY400, MQ Series, DOORS Suite, TEAM TRACK, Show Case STRATAGY, NIKU Portfolio Manager Client.
Citibank, Monterrey, Mexico 1/2001 – 12/2001
Citibank, Tampa, FL 5/1999 – 12/2000
AS400 Contract Programmer (Functional & Technical Analyst)
Involved in Numerous Projects utilizing RPG, RPG-ILE, SQL, CL, MQ Series for a wide variety of projects, systems and applications. Below are some selected Projects.
Production Support, BAU & QA for CORE Application: Regional Technology Center (RTC) provides the total technology solution to Citibank in Latin American countries (Venezuela, Chile, Columbia etc.), Mexico and International Personal Banking (IPB – San Francisco, New York, Miami and Los Angeles).
The Consumer Oriented Retail Environment (CORE) System is a batch and on-line banking system based on an U.S. commercial banking package marketed by New trend Inc. The system has been selected as the basis of a common base banking system, which is being made international in scope.
• Involved in various new projects for Citibank’s LACB business in the areas like Credit
Card Application, Transaction Subsystem, Time Subsystem, Bill payment, Teller Subsystem, Telephone Banking, Home Banking, Back office, Money Market, Commercial, Installment and Mortgage Loans, CIF Subsystems in CORE and GL subsystem, Account/Payables, Receivable (AP/AR), Data Ware Housing, CITIFUNDS, GRB applications.
• Maintained the application according to the business requirements
(Modifications/Enhancements) which involves analyzing the system, Design, Coding, Testing, Implementation & Post implementation (support) activities.
• Provided daily Production support services for nightly batch process and online support to the Citibank CORE Banking Application for Venezuela, Mexico & IPB.