Summary:

• Over Four plus years of IT experience in design, analyzing, development, testing, implementation and installation of several applications related to both Client Server multi- tier architectureand Internet technologies.
• Extensive work experience as a SQL Server Developer and demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS and SSRS.
• Over 3 years of extensive reporting experience using SSRS and Crystal Reports, MS Reporting Services and MS ACCESS.
• Have worked with technologies and tools like Microsoft SQL Server 2000/2005, Oracle 9i/10g, SQL Loader, TOAD, MS Access 97/2000, Crystal Reports 7.0/8.0 and UNIX.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Extensive experience as a Programmer/Analyst in building Web Based and windows based applications using ASP.NET, C#.NET, ADO.NET, OOPS, VB, ASP and good working experience onSQLServer, Oracle, MS Access.
• Good exposure and knowledge on ETL tools and Data warehouse concepts.
• Actively participated in Test Planning, Functional Specification reviews, Design/Code reviews, Implementation/Engineering reviews, Guidelines, Process and Standards
• Well-versed with software QA testing procedures, involved in writing test plans, and test cases for both manual and automated testing.
• Creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures, Cursors and Triggers using T-SQL and PL/SQL in SQL Server 2000/2005/2008, Oracle.
• Experience includes developing Project User Manuals and Programming specifications.
• Performed Smoke, Functional, Backend, Integration, System, Regression,End to End and Black Box, White Box and Performance Testing
• Attended meetings with Project Manager, Team Manager, and other team members regarding the test procedures, Project Implementation, and support
• Expertise in Object Oriented Analysis, design and development at backend programming, configuring, client-server connectivity, query optimization, stored procedures and triggers.
• Good team player with excellent problem solving, technical, oral & written communication, multi-tasking and interpersonal skills.

Languages:

Servers:

IIS (5.0/4.0), Windows NT, 2000 Server.

Tools:

Quality Center9.0, TOAD9.1, HTML

SQL Server Tools:

Enterprise Manager, Query Analyzer, Export & Import (DTS), SQL Server Management Studio, SSIS, SSRS

Operating System:

Modeling:

Database(s) :

Reports:

Source Control Tool:

Testing:

Unit testing, System, Integration testing.

EDUCATION:

B.S. in Computer Science and Information Technology

Professional Experience:

Confidential, MA Oct’ 08 - Nov’ 09
Consultant
Description:
EDA_SFV is a project related to environmental and groundwater assessment and management. This deals with the development of innovative software tools for data processing and groundwater modelling. These software products are currently used nationally and internationally.

Responsibilities:

• Analyzed Software requirements, Business requirements and Functional Specifications documents to get a better understanding of the application from both technical and business perspectives.
• Actively participated in Test Planning, Functional Specification reviews, Design/Code reviews, Implementation /Engineering reviews, Guidelines, Process and Standards.
• Implemented the software development lifecycle (SDLC) to follow the Standards process of the application.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. exp/imp and Attach/detach for SQL servers 2005 futures.
• Designed and coded GUI screens using HTML.
• Designed and Developed Web based UI using ASP.NET, C#.
• Designed and developed the Test plan, Test Scripts, test goals for the applications and executed them.
• Developed Custom Reports using SSRS/SQL server BI studio.
• Build the SSRS environment for both development and test servers based on the individual client needs.
• Created Datasets in T-SQL, stored procedures for SSRS.
• Created Reports in SSRS with different type of properties like Chart controls, graphs filters, Interactive sorting, SQL parameters and deployed reports to web applications.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Developed complex stored procedures to create various reports.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Environment: ASP.net 3.5, C#, HTML, SQL Server 2008, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Access 2007, Windows XP/Vista, Quality Center.

Confidential, Jul’ 06 – Sep’ 08
SDET
Description:
WASPORT is a conversion project that will transform the current application software package to a web based enterprise application and integrate the port community extranets with the Port to enable the community user to process the requirements related to port operations on the VPT domain and remit the service charges on an e-banking mode, thus enabling the user community to process their requirements on-line.

Responsibilities:

• Analyzed Software requirements, Business requirements and Functional Specifications documents to get a better understanding of the application from both technical and business perspectives.
• Analyzed, designed, developed, fixed, implemented, documented and maintained the applications in client server technology using ASP.Net 2.0, C#, .NET Web Services and Reporting services.
• Actively participated in Test Planning, Functional Specification reviews, Design/Code reviews, Implementation /Engineering reviews, Guidelines, Process and Standards.
• Implemented the software development lifecycle (SDLC) to follow the Standards process of the application.
• Designed and developed the Test plan, Test Scripts, test goals for the applications and executed them.
• Maintained and modified to accommodate new changes to the software by interacting with development team and conducting meetings with partners and vendors
• Involved in preparation of USE case document
• The Visual SourceSafe tools were used for controlling and maintaining the application source code version.
• Performed End to End, system and User Acceptance test.
• Prepared test data for positive and negative test scenarios for functional testing.
• Worked with development team to understand assigned modules/new product features for the purpose of developing test cases.
• Compared SQL results with application results by writing SQL queries.
• Used SQL queries to test the migrated database for Back End Testing
• Involved in writing PL/SQL, T-SQL stored procedures and in writing SQL queries for obtaining results.
• Designed and Created reports using Crystal Reports with Standard, Summary, Cross Tabs, grouping, sub reports, report viewer to produce reports in Word and Excel and integrated the reports into web application for access to the end users

Environment: ASP.net 3.5, C#, ADO.net, JavaScript, HTML, SQL Server 2005, IIS 5.0, Windows XP, Visual Source Safe

Confidential, Jun’05 – Jun’06
Developer

Description:
This Project is related to M/s Visakhapatnam Port Trust Employee’s Payroll Calculation, which covers all Earnings and Deductions. It is a packaged program with Stored Procedures & Functions using Triggers & Cursors.

Responsibilities:

• Involved in full life cycle of project.
• Developed COM components and deployed these components with MTS.
• Designed and developed front end.
• Utilization of Visual Source Safe in development environment.
• Designed and created database objects.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Crystal reports are used for generating daily/weekly/monthly/quarterly/yearly.
• Involved in making the distributable package and deploying.
• Analysed system requirements and developed Test Plan, Test Cases and Test Scripts; Maintained and modified to accommodate new changes to the software by interacting with development team and conducting meetings.
• Worked in re-modelling database structures as well as created stored procedures, triggers, views, maintenance jobs, and user defined functions for Oracle.
• Involved in formats for report generations and coding SQL queries for the same.
• Performed in Manual testing, creating and executing test cases, reporting bug reports
• Executed the Test Cases Manually and reported the defects to Developers through Modification Requests (MR)
• Unit testing of screen’s functionality.
• Maintenance.

Environment: VB 6.0, VB Script, COM/DCOM, Oracle 9i, PL/SQL, Crystal Reports, Windows 2000.