Sql Server Data Engineer
Resume:
Suneetha Parvathaneni
********.************@*****.***
Professional Summary:
Highly skilled Full-Stack Developer and Data Engineer with 10+ years of experience in all phases of the Software Development Life Cycle. Possesses expertise in requirements engineering, analysis, design, database development, coding, enhancements, testing, deployment, and ongoing maintenance. Proven track record building N-Tier web applications using C#, VB.NET, ASP.NET, ADO.NET, XML, XSLT, web services, Windows Forms, and Web Forms. Comfortable working with various versions of Visual Studio (2005-2022). Extensive knowledge of front-end technologies including JavaScript, HTML, CSS, and DHTML. Design and develop efficient databases (SQL Server). Leverage my expertise in SSIS, SSRS, and Power BI to transform data into actionable insights.
Experience in designing, developing, and deploying SSIS packages for data integration and ETL processes.
I am skilled in scheduling and monitoring SSIS packages using SQL Agent to automate data flows.
Experienced in incorporating .NET Interoperability with legacy COM components and .NET components and .NET Security Model using role-based security. Authentication and Authorization through Windows Authentication, Form-based Authentication, Passport Authentication and Impersonation.
Strong database expertise in ADO, ADO.NET, T-SQL, and PL/SQL. Proficient in creating stored procedures and triggers for SQL Server (2000-2014)
Proven experience with .NET Framework versions 2.0 through 4.8, as well as version control systems VSS, TFS, and Azure DevOps
Built a RESTful API using Visual Studio to enable seamless communication between multiple applications.
Experience in programming using 3rd party control like Telerik Rad Controls and KingswaySoft Integration Toolkit for SSIS.
Extensive experience in utilizing data visualization tools such as SSRS, Crystal Reports, PowerBI, and Telerik Reports to create insightful dashboards and reports
Skilled in SQL Database administration, encompassing database design, implementation, maintenance, and upgrade procedures
Experience with SQL Server Database Replication for Disaster Recovery.
Provided technical support for database-related issues and participated in on-call rotation for after-hours support.
Implemented database security measures and performed regular backups and restores to ensure data integrity
Collaborated with developers and system administrators to optimize database performance and resolve any issues
Extensive knowledge on 3rd party APIs like PLM, Config1, Dynamics XRM, Dynamics NAV etc.,
Developed and managed SSIS packages for data integration with various sources and targets, including SQL Server, flat files, SharePoint, XML, Excel, Oracle, SFTP, and APIs.
Involved in implementation on Microsoft Dynamics Navision. And Integrated PLM, Configurator and Nav databases using APIs and ETL(SSIS).
Proficient in report generation using Crystal Reports and SQL Server Reporting Services (SSRS). Developed a diverse range of operational reports, including drill-through, drill-down, sub-reports, charts, matrices, linked reports, and multi-parameterized reports.
Knowledge of Microsoft Excel, including the ability to create and work with Pivot Tables, SUMIF, VLOOKUP functions, and exposure to Macros.
Proficient in Software Testing Life Cycle, detecting & fixing program bugs.
Experience working with Power Automate.
Managing PowerBI gateways.
Proficient in utilizing Azure DevOps for source control, specifically working with Git repositories to manage .NET codebases.
Technical Skills:
. NET Platform and Languages
Microsoft .NET Framework 2.0/1.x/3.0/3.5/4.0/4.5, Visual C# .NET/2003/2005/2008/2010/2015, Visual Basic.NET 2003 / 2005, VisualC++2005, C; ASP.NET 2.0, ASP; ASP.NET, JavaScript, VB Script,VB.NET
Database
T-SQL, PL/SQL, SQL Server 2019/2014/2012/2008/2005, SQL Azure, ODBC, ADO.NET, MS ACCESS, Oracle 9i/10g/11g.
Web Technology
Ajax, XML/XSLT, XHTML, HTML, CSS, DHTML, Web Services Enhancements, WSDL, DOM, IIS 5.0/6.0/7.0/67.5, SOAP, FrontPage.
Reporting Tools
Crystal Reports 9/10, SQL Server Reporting Services 2016/2008 r2/2005/2000 and the version 15.0 and Excel, PowerBI
Business Intelligence Tools
SSIS, Power Automate, PowerBI, Layer2 etc.,
Development Environment
Azure DevOps, VSS, Team Foundation Server, Visual Studio, Microsoft Dynamics Navision.
Component Technologies
Custom Controls, COM, COM+, ActiveX, Web Services.
Operating System
MS-DOS, WINDOWS (9x, 2000, XP, 2003), UNIX and Linux
API, Libraries & Other Tools
. NET 1.1/2.0/4.5/4.8, Infragistics .Net Advantage for ASP.NET tools, AJAX TOOLKIT, HPQC OTA API, Telerik Rad Controls (Third Party Controls),PLM,Configurator(Autodesk),
Design Pattern & Concepts
Singleton, Object-Oriented Programming (C++, C#, Java), MVC.
Development Methodologies
Agile (XP/SCRUM/TDD), N-Tier Architectures.
Education:
Master of Computer Applications
Bachelor’s in computer science
Professional Experience:
BOA Technologies 11/09/2015-Till Date
Role: Sr Software Engineer
Duties:
• Creating and maintaining IT applications and workflows.
• Building and maintaining .Net applications, modify existing code with the web server, web integration and front end scripting will be daily tasks
• maintaining multiple forms with the SharePoint admin.
• building applications (both out of the box and custom features) and workflows with the SharePoint internal champions.
• Building SharePoint master pages, layouts and themes.
• Leveraging SSIS to build robust ETL pipelines
Involved in implementation of Microsoft Dynamics Navision
Integrated multiple systems like PLM, Navision 2016 and Config1 each other using APIs and ETL.
Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouses.
Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008. Upgraded SQL server to 2019
Prepared the complete data mapping for all the migrated jobs using SSIS.
Working closely with Operations, Accounting, Sales and finance team.
Managed Sales data in SQL server
Developed complete Warehouse Management System (WMS).
Also, developed Proforma Invoice and Packing Slips using Microsoft technologies.
#1 Project: WMS (Warehouse Management System)
Description: A warehouse management system, or WMS, is a key to control the movement and storage of inventory within a warehouse and process the associated transactions, including, receiving, put away, picking, Inventory Adjustments and in-Bin Transfer.
Involved in the complete life cycle of software development including gathering requirements, analyzing, design, development, coding, implementation, testing, supporting during different phases, deployment and maintenance of the project.
Provided technical and analytical assistance to associates and advice to superiors that involved contact with several levels of the client organization.
Provided guidance and support to Junior Programmers and Programmer Analyst as needed.
Involved in SQL database design, integration and implementation.
Created Technical Design Documents, Program Specification Documents, Interface Control Documents.
Provided session level security and role-based authentication using session objects and cookies.
Analyzed, debugged and found root causes of defects and fixed defects based on priority and severity.
Configure Azure cloud service for end point deployment.
Used SQL Profiler to analyze and monitor long-running queries and stored procedures.
Developed web pages and style sheets using HTML, Asp.net and CSS.
Used ADO.Net classes components SQL Connection, SQL Command, sqlDataadapter,.
Used SSRS, Crystal Reports for Visual Studio 2015 to generate reports and iTextSharp to merge pdf reports.
#2 Project: Proforma Invoice and Packing Slip
Description: A proforma invoice outlines how much a certain number of goods or services will cost. Because the customer may not yet have agreed to, or even seen, these numbers, a proforma invoice is designed to give the customer an idea of how much what they’re asking for will cost them. And Packing Slips or delivery lists or bills of parcel, packing slips are documents that accompany goods when they are delivered
Involved in Requirement gathering from the business users, Functional and technical specifications. Also involved in gathering data from all the sales tables and creating data models.
Developed business logic for CPQ and Restore modules for orders using ASP.NET, XML and C#. NET.
Used Master pages, Theme and CSS for consistent look and feel across all screens.
Designed and developed the Web application in ASP.NET, C#. NET
Developed and consumed web services.
Implemented template columns in nested grid views.
Written stored procedures, views, functions in sql server 2012/2016/2019.
Provided production support.
Label creation using SSRS reports
Skillset /Tools: C#.Net,IIS and Azure, T-SQL, SQL, Visual Studio .Net, ASP.Net, HTML, DHTML, JSP, XML, XSL, Web Services, WSDL, UDDI,WCF, JSP, SQL Server,SSIS,SSRS, PowerBI, MS Access, AJAX, HTML, DHTML, JavaScript, CSS, XSL,, PHP, Windows XP, Windows NT.
Gates Corporation, Denver, CO Apr 2012- Nov 2015
#1 Project: CPQ (Configure Price Quote)
Role: Senior .Net Developer
Description:
CPQ is a tool to configure price and Quote the gates industrial products Hydraulic Hose Assemblies (Hydraulic Cut Hose, Industrial Cut Hose and Engine Cut Hose),V-Belts and Curved Hose.
Each of these products utilizes an individual set of system tools and workflows through the Gates organization to define (configure) and subsequently establish a quotation for delivery to the customer. On a monthly basis, Gates processes roughly 1,500 unique quote requests for the IOE market, with response cycle times with existing workflows and tools ranging from 3 days to 20 days on average.
The primary benefits of developing a CPQ system for all IOE products are:
Protects organizational cost improvements
Insulates market from significant tpc/price shifts
Includes product positioning strategy – Good, Better, Best
Pricing will be linear over common part attributes
Potential significant cycle time improvement depending on deployment options
Enables future mobile quote estimate capabilities
Value-based math and a prototype CPQ tool was initially launched in April of 2013 and has been in service delivering the above benefits. It is envisioned that this CPQ tool will also cover all specification types of cut hose and a unique tool for these products also This tool maintains the unit prices, Material TPC for each product and also discount matrix for each customer of the Gates and maintains all the Gates product details to configure the customer orders. Depending on the quantity, unit price, Material TPC and discount this tool will calculate the total price of the each customer order and print the Quote letters to send the Quotation to the customers.
Responsibilities:
Involved in Requirement Analysis, development, testing and implementation of the project.
Developed business logic for CPQ and Restore modules for orders using ASP.NET, XML and C#. NET.
Used Master pages, Theme and CSS for consistent look and feel across all screens.
Designed and developed the Web application in ASP.NET, C#. NET
Participated in enhancements, design reviews, and ensured design meets functional and operational needs.
Developed user interface using ASP. Net, HTML, and CSS and used JavaScript to perform client-side validations.
Created web pages using ASP.NET with Telerik RadControls.
Used AJAX.NET to develop datasets and data tables on client side for performance improvement and faster web application.
Created XML documents, Flat files of the time entry data to be used by other existing applications.
Developed Business Logic Layer using C#. NET and Data Access Layer using ADO. Net.
Extensively worked on Data Adapter, Data Readers and Data Sets
Created Use Cases, Use Case diagrams for each web form developed.
Involved in exception management, troubleshooting and bug fixing activities.
Involved in providing technical support and maintenance for the application.
Actively participated in testing of the application by writing test cases for the Unit and System testing.
Experience on Tableau Business Intelligence/Business Analytics software.
Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
Developed various operational Drill-through and Drill-down reports using SSRS
Developed the application using Visual Source Safe for Security and Version control System.
Create class diagrams for team discussions and meetings.
#2 Project: Mectrol Specification System
Description: The Mectrol belt project delivered a belt specification system for the definition of a certain kind of belts manufactured by Gates. A belt specification defines the process parameters and materials necessary to manufacture finished good items. The belt specification system developed is a layered web application consisting of data, business logic and user interface layers. The system was developed using the Microsoft tool set consisting of Visual Studio, SQL Server, and SSRS (SQL Server Reporting System). Third party tools were also used with Visual Studio, notably the Telerik grid. The application layers interact across multiple distributed servers. The business group defined the required application functionality.
Created prototype and production-level object-oriented applications throughout software development lifecycle, including design, modeling, coding, testing, and documentation.
Created multi-tier architecture for the application.
Created Web Pages using Master Pages.
Used Grid View control extensively for data display, dynamic generation of rows, and user input inside template columns. Used Edit Item-Templates and Footer Templates extensively for editing and adding rows.
Used skin and Themes for the design of web pages.
Programmed Data Access Layer using ADO.NET which involved in accessing data from the Database using Connected Architecture which requires the strong OOPS concepts.
Used Java Script, HTML, DHTML, IIS and CSS for developing Web Pages.
Involved in AJAX Validations.
Involved in using Microsoft Visual Source Safe 2005 for Project Management and SQL Server 2005 for Database
Involved in writing complex queries using T-Sql programming.
Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation.
The code behind is implemented in C#.NET.
Implemented ETL tools in SSIS package.
Extensively involved in designing the SSIS packages to export data Oracle to SQL Server Database.
Created Complex queries and Stored Procedures.
Implemented HTML Server Controls, ASP Server Controls along with Validation Controls.
Environment: Visual Studio.Net, .NET Framework 4.0, C#. Net, ASP.NET, ADO.NET, CSS, Ajax, Java Script, SQL Server 2008 r2, IIS 7.5, SSRS, VSS,Telerik Rad controls.
Colas ISS, Denver, CO Sep 2011-Mar 2012
Role : Software Applications Developer
Project: Bid Management System (BMS)
Description: Bid Management System is a web application to store all the bids information of Colas across the US. This application is composed of 2 parts: a module that runs in the region where they input the data and a module for the corporate office which consolidates the regions and allow cross region reporting. Using BMS each client can enter the Budgets for every year for a single region, Regions are the main elements in BMS, Adding Bids, Budgets,Jobs (If the bidder owns the bid then the that bid has been converts into Job), Identifying the bid status according to their Ranks and Bid amount, Update Budgets, Bids and jobs. Administrators have the ability to add Bids, Budgets and Jobs.
Involved in Requirement Analysis, development, testing and implementation of the project.
Designed and developed complex Web Forms & User Interface (UI) Screens using C#, ASP.NET, HTML & Java Script.
Involved in plan, design, and development database, such as stored procedures and views.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Developed various User Controls for the application.
Developed Business Logic Components using C# for Server side business validations.
Used ADO.Net for Interacting with Databases
Configured Web.config for setting the Application
Created custom errors for Exception handling using Custom classes
Used Grid view control to display data obtained from the database.
Involved in Functionality testing of the system.
Developed crystal reports.
Involved in exception management, troubleshooting and bug fixing activities.
Actively participated in testing of the application by writing test cases for the Unit and System testing.
Environment: Visual Studio.Net 2010, C#. Net, ASP.NET, ADO.NET, XML, HTML, Ajax, Java Script, SqlServer 2008, IIS 7.5, Crystal Reports, VSS.
Life Technologies, Foster City, CA Jan 2011-Aug 2011
Project: Team Track to HP-QC Data Migration
Role: .Net Developer
Description: It has been determined at Life Technologies that existing software issues stored within a Team Track Issue Management system should be migrated into an HP-QC (Hewlett Packard – Quality Center) environment. The recommended import methods to use the OTA API functionality provided by HP-QC. The OTA API (Open Test Architecture Application Programming Interface) is a set of COM objects that allows the integration of external applications and scripts with HP-QC through the use of any COM enabled language such as VBScript, Visual Basic, C#, C++, etc… Through the use of the OTA API, individual defect items and their respective parts such as description steps can be created programmatically. This is an ideal situation. As the exporting of data proceeds, each Team Track record can be inserted into the HP-QC environment simultaneously creating the new record and setting its attributes.
Responsibilities:
Designed and developed complex Windows applications using C#. Net and Oracle database.
Utilized object-oriented distributed 3-tier architecture.
Used ADO.Net for Interacting with Oracle Database.
Extensive use of Data Controls for data manipulation.
Integrated the Team Track application with HP-QC using OTA API.
Interact with the Quality Center application without having to use the GUI front-end.
Interact with the QC database bypassing DBA.
Using OTAClient.dll creates the new Defect and Attachments for the existing Defect.
Unit Testing and extensively involved in Bug Fixing.
Environment: ADO.NET, C#, OOPS, VS 2008, Win XP, OTA API Client, Oracle Sql Developer.
Sharelogic Software, India May 2009 to June 2010
Project: eduCater
Role:.Net Developer
Description:
eduCater is a web based comprehensive collaborative tool, which will help students, staff and the management to work collaboratively and effectively in a same platform, It can be used to interact with each other, submit assignments, get messages, chat, and conduct online tests. It also helps the Institutes to assess and measure the teaching capabilities amongst the faculty and learning growth amongst the students, which enables them to take corrective measures and enhance capability and productivity and also bring innovation in the field of education.
eduCater is highly rich in content and also very easy to use, It helps the communities to coordinate and communicate with each other by giving access to useful reference material and helps the community to stay ahead of competition, It also supports great features such as forums, wiki's, blogs, timetable management, library management etc. Which add a lot of value and enhances the learning capability of individuals.
Responsibilities:
Modified existing ASP .NET Web Forms and implemented new ASP.NET pages by using C# as code-behind language.
Worked on WebPages, Master Pages, Custom controls, User Controls.
Managed gathering requirement, Designing, Developing the application with developers.
Created web pages using ASP.NET with Telerik RadControls.
To display the three levels of user data I have implemented three level hierarchies in radgrid.
Displayed the student information in the form of images and the details are shown by radtooltip.
Worked on assigned tasks and finished assigned task on estimated time.
Co-ordinate and actively participated with team players and DBA developers.
Involved with QA team for Unit Testing.
Environment: ASP .NET 2.0, C#, WebPages, Visual Studio 2005 OOPS, Microsoft Enterprise Library, Visual Source Safe, SQL SERVER 2005, JavaScript, CSS, Windows Vista, Windows Server, UNIT Testing, Telerik Rad Controls
Sharelogic Software, India
Project: Portal for Fertilizers Company
Role:.Net Developer
Description:
This tool is a complete portal for a company. It consists of company details like
Document Management System: Super admin will create the Categories and Subcategories. He will assign managers to each Category. Category Manager will upload the document. He will set the accessibility permissions on each document. Only the Category Managers can make any modifications regarding the documents. Only the authorized users can view the documents.
Employees List: List of the employees and their details like Personal Information, Contact Information, Job profile etc will be maintained.
Image Gallery: Images of the Company Events are maintained here.
Wiki: Wiki deals with the information regarding the company. Different pages are created under different Categories. Super admin will create the Categories and Subcategories. He will assign managers to each Category. Category Managers will create different pages under the Category to which he is Manager. He can also edit the description of the Categories to which he is assigned as Manager. Any user can view the pages but cannot edit the content only the Category manager can edit the content of the pages, which are under his category. Different versions of the pages are stored. Difference between each version is also shown. Search is also provided to retrieve the required information.
Polls: Different polls are created with different options.
Blogs: Any user can write a blog and post the comments.
Traits: Super Admin will give different traits to each employee. Traits can be modified. When a user logs in his traits are shown on the top of the Home page.
Generic Documents: Generic Docs are nothing but the public documents. Any user can upload/modify the documents.
Responsibilities:
Involved in designing and developing the GUI using Web Forms for Windows User
Developed Business Logic Components using C# for Server side business validations.
Generated stored procedures and Triggers for retrieval of information.
Designed Reports using Crystal Reports.
Used Crystal Report Viewer control and Report document component to view the reports.
Used grid view control for displaying the data.
Used XML classes to get and set the data from data sets and used XPATH \ XSL for display the data in grids.
Used Visual Source Safe as a Version Control tool.
Designed and developed complete database in MS SQL Server.
Involved in unit testing and whole testing of the product.
Involved in Functional & Integrated testing of the Application.
Environment: ASP.NET 2.0, ADO.NET, C#, OOPS, VS 2005, MS SQL Server, Java Script, Crystal Reports, CSS, Visual Source Safe, XML, HTML.
Marwicks Technologies, India May 2008 to April 2009
Project:CETAC
Role: Jr.Net Developer
Description:
CETAC is a web-based counseling for Consortium of the Association of Christian Professional Colleges and Organization for Minority Development. This project facilitates ICET-AC, EAMCET-AC and PGECET-AC 2009 students to register online into this website. After registering they can exercise options based on their priority of colleges and courses. The other users who use this project are the staff. They can verify the certificates and change the profile of the candidates.
Finally, candidates will be allotted into the seats from the options exercised. Allotment is made, depended on reservation categories given by government GO & the number of seats available in the selected option.
Responsibilities:
Performed Systems Analysis & Design.
Involved in designing web pages in Asp. Net.
Involved in coding of modules to meet the generated functional requirements using C#. NET.
Extensively worked on ADO.Net to develop the data accessing functionality.
Involved in designing the database schema and created stored procedures on MS-SQL Server 2000.
Created custom errors for Exception handling using Custom classes
Used Grid view control to display data obtained from the database.
Involved in Functionality testing of the system.
Used Crystal reports in .Net IDE for reporting system.
Environment:
VS.NET, ASP.NET, C#. NET, ADO. Net, SQL SERVER 2000, Web Service, XML, HTML, Java Script, IIS, Windows 2000, Crystal Reports, VSS.
Contact this candidate