Software developer .net/sql/ssis/ssrs/ssas

Srivani Erukulla

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

506-***-**** (Home) 506-***-**** (Work)

Certifications:

Microsoft Certified Application Developer

Certified Course in .NET

Certified Course in SQL Replication

Certified Course in Requirements Gathering

Certified Course in IT Project Management

Certified Course in ABAP/4

Certified Course in BW

Education:

Bachelor of Technology in Computer Science (Btech Computers)

Experience summary:

Over 5 years of in-depth experience in the following:

· Experience in development and design of computer applications in developing application software using VB.NET, ASP.NET, Web services, ADO. net, Share Point, ABAP/4, BW, XML, SOA, SQL Replication, SQL Server 2000, SQL Server 2005, C, C++, Visual Basic 6.0, ASP, Business Objects, Crystal Reports, VB script, Java Script, Integration services( SSRS, SSAS, SSIS), IIS.

· Excellent interpersonal communication skills and analytical skills

· Very extensive in Application Software and Database development

· Excellent written and oral communication skills

· Excellent Presentation Skills

· Ability to grasp new concepts quickly, and to provide practical and efficient solutions

· Have very good work ethics thrive for improving quality and productivity

Technical Skills:

ERP: Software: Languages:

ABAP/4 4.7, BW 3.5 Visual Basic, VB.NET, SQL, SQL*PLUS, COBOL

Ms-Office, Visio, HTML, DHTML, XML, XSL,

Skelta Java2, JSP, ASP, C, C++, CSS

VB.NET, ASP.NET

Operating Systems: Networks: Databases:

MS-Windows 98, XP IIS, LAN, WAN Oracle8i, 9i, MS Access

MS-Windows NT /2000 SQL Server 2000 & 2005

SCO Unix V 5

Project experience:

Client McCain Foods Limited Mar 05-Current

Project 1 Ivara .NET Interfaces

Software VB.net, Share point, SQL Server 2005, ADO.NET, SSAS, SSIS, SSRS, Performance point, Business Objects, Visual source safe, XML

McCain Foods Limited is a privately owned Multinational leader in frozen food industry. McCain Foods is the largest producer of frozen French Fries and the manufacture of other quality food products sold in more than 110 countries It has many webs catering to different products, different regions and in different Languages.

Description: CMMS – Computer Maintenance Management System is used to maintain plant machinery with in McCain plants. The IVARA has been selected as go forward application for all CMMS implementation. The CMMS has two key interfaces which are PRMS and Ariba. The PRMS is used for all static master data as single source of entry as well as for General ledger entries and invoices. The Ariba is E-procurement application used as purchasing solution.

Considering the different platforms of the surround applications and the complexity involved, a main interface engine named IVARA INTERFACES has created using VB.net technologies to transfer data like Vendor master, Exchange rates, Account master, Account payable, General ledger from Ivara to PRMS and Item master, Purchase order interfaces has created to transfer data from Ivara to Ariba and that will reside in Ivara application server. The interface database will be logically partitioned so that the data is secured between companies and also enhances control of the interfaces. Menu bars, buttons, and other required screen attributes are used to make the interface easy to use and configurable across multiple implementations.

Role:

· Analyzed business requirements.

· Developed the Business layer for all business validations per user requirements VB.NET, ADO.NET

· Developed the interface in a more systematical way by separating presentation, data and business layers.

· Designed the Connectivity layer between the application to the database using ADO.NET

· Design the interface.

· Designed database tables. Created stored Procedures, Triggers, Views, User defined functions, Indexes using SQL 2005

· Tested, fixed, and modified application per user requirements.

· Created Reports based on user requirements Business Objects and using SSRS and publish them in Share point site.

· Created Charts, graphs using SSRS.

· Used Web parts as required from Share point, like created security for SSRS reports based on regions.

· Maintain the development code and did version control using ALDON and Visual source safe.

· Created DTS, SSIS packages and also converted some DTS to SSIS packages.

· Used ETL(SSIS) tool for cleaning data before creating Cubes

· Used SSAS for creating cubes for analysis purpose.

· Created Technical documents and activity diagrams using Visio.

· Created KPI’s, dashboards using Performance point.

Project 2 New Product Development

Software ASP.NET, ADO.NET, Share Point, Skelta, XML Web Services, SQL Server 2005, Microsoft Application blocks, Integration services(SSRS, SSIS), VB Script, Java Script, IIS, Business Objects, Ajax

Description: New Product Development is the Web site which is used by Administrators for managing the data with all the validations as well as Users for viewing reports, adding data, uploading the Documents into the Share point and downloading the Documents from the Share Point and converting them to PDF format before viewing by the Users for security purpose by using the latest technologies like Microsoft Ajax, Microsoft Application blocks etc. This Website is used the SQL 2005 as well as Share Point Lists as the backend database at the same time, So that Skelta will use the Share Point List for triggering the Work flows and for Reports the data from SQL 2005 will be used.

Role:

· Involved in Collection of the Requirements

· Design the Web site, Prepared documentation

· Created web pages and uses Ajax technologies to prevent refreshing the page each time users update the data.

· Designed, Developed interface between application and Share point Data

· Managing the Data records using SQL 2005 and the Share Point Lists as a backend database

· Designed Connectivity for the database and front-end by using Microsoft Application blocks and Connectivity for the Share point and Front end using Share Point Web Services

· Design database

· Prepared queries, Stored procedures, Views, Triggers, user defined functions and code required for accessing data from database as required

· Did the performance tuning, created the indexes as required so as to decrease the time the system will take to get the data from the database.

· Developed the Web Site using different layers like Presentation, Data, Business and using Web services to separate the code in more systematic way.

· Configure the project using IIS.

· Created SSIS packages,

· Developed reports using Business Objects and SSRS.

Project 3 Customer Relation Management, Customer Management Tool

Software VB.NET, ADO.NET, SQL Server 2005, Microsoft Application blocks, Crystal XI, Replication, Integration Services(SSAS, SSIS,SSRS)

Description: The Customer Relation Management is a Client/Server project, which is mainly used by the McCain Sales Representatives all over the world. They used this UI interface for managing the data with all functionalities like searching, adding, deleted, updating, Printing, maintaining the data for different groups like Administration, Users and Viewing the same data in both Form and Grid modes and much more. Sales Representatives use this interface to manage the data locally in offline mode and then they synchronize the data so that by Replication process all the data will be stored back to the production database. Customer Management Tool is somewhat similar to Customer Relation Management with some more enhancements like maintaining data in hierarchy and using the new technology like Microsoft Application blocks, Visual Basic 2005, .Net 2.0 framework.

Role:

· Involved in Collection of the Requirements.

· Designed and developed the quality GUI application by using VB.Net

· Prepared Business logic for validating the data.

· Proven technical analysis - data flow diagrams, ERDs, process flow diagrams.

· Prepared the Connectivity for the database and front-end by using Microsoft Application blocks.

· Implemented Design patterns like the Model View Controler, Facade and others.

· Managing the Data records using SQL 2005 as a backend database

· Prepared Stored Procedures, User defined functions, triggers, Views, indexes and code required for accessing data from database as required

· Understand and adhere to technical coding standards for implementing new

systems and supporting existing systems.

· Use Unified Modeling Language to document system designs.

· Contributing to team meetings, troubleshooting development and production problems.

· Coordinate and track problems, reports to closure with internal development groups

· Created SSIS packages. Used SSAS for creating cubes for analysis pusrposes.

· Created Crystal Reports SSRS reports based on user requirements.

· Using Replication synchronize offline data back to production

Project 4 Product information Repository to FRM Transfer

Software VB.NET, ADO.NET, SQL Server 2000 , Crystal Reports

Description: The Product information Repository (PIR) to FRM Transfer is a Client/Server project, which is mainly used by the McCain users all over the world. They used this UI interface for managing the data with all functionalities like searching, adding, deleted, updating and much more. PIR and FRM are two out sourcing JAVA applications where in different data will be stored regarding products prepared by McCain. And so the data can be extracted only in the form of XML and as it is difficult to view and work with this information by users, we have created a program, which first loads the data from XML to SQL tables. And then created a UI interface which is friendly to users to view the data using VB.net and ADO.net.

Role:

· Involved in Collection of the Requirements, Design

· Managing the Data records using SQL 2000 as a backend database

· Extensively worked on designing the GUI forms writing code by using VB.Net

· Prepared the Connectivity for the database and front-end by using .net technology

· Prepared Stored Procedures, User defined functions and code required for accessing data from database as required

· Prepared documentation

· Created Crystal reports

Client Netcom Jun 03-July04

Software VB.Net, ADO. Net, Oracle, SQL

Project Insurance Management System

Description: This Insurance Management System deals with the insurance for customers. First it accepts all the customers who are interested in insurance. Then all the data about the customers is stored in database giving a unique policy number to each customer. And many categories are maintained like the type of policy for the customer, who is the agent for the customer. Money should be retuned to customers based on the insurance they are used. At the same time all the agents should be given commissions based on the number of customers they are compromising to accept the different polices. Frequent updating should be done without missing.

Role:

· Involved in Design and Development

· Involved in Collection of the Data

· Managing the Data records using Oracle as a backend database

· Updating the data frequently

· Prepared documentation and designed the GUI forms by using VB.Net

· Prepared the Connectivity for the database and front-end by using ADO.Net

· Prepared queries and code required for accessing data from database as required

Client Defence Research and Development Laboratory Oct 02-Apr 03

Software Unix V, C++

Project Implementation of Redundant Control Center

Today DRDO is 50 labs strong and is deeply engaged in developing defence technologies covering various disciplines like acrobatics, armaments, electronics, Combat Vehicles, engineering systems, instrumentation, missiles, advanced computing and simulation, special materials, naval system, life sciences, training information systems and agriculture.

Description: This project was done in partial fulfillment of Bachelor of Technology In Computer Science.

To alleviate the problem created by using centralized control mechanism we use decentralized (distributive) method of controlling the system i.e. control is distributed over the system. Each of the elements present in the system in distributed system acts as a Control Center (CC) in case of failure of any other CC.

In the first step towards the decentralization we try to develop a shadow or slave or hot standby CC for the Existing CC which takes over the control of the system in case of any failure in the existing CC and relinquishes back the control when it comes up.

Then this Shadow CC is then replicated over all the system elements and priorities are assigned statically for them, which lead to a complete decentralization of the system

Role:

· Analyzing the existing system

· Extracting the system design, control flow, classes used and interfaces between them.

· Prepared class diagrams for the control center.

· Performed the System Analysis and System design

· Did the Feasibility study

· Design and development of control center has done by using C++

Contact this candidate