Post Job Free
Sign in

Visual basic 6, Sql SSMS,entry level C#

Location:
Farmington, MI
Posted:
August 16, 2017

Contact this candidate

Resume:

Name : BabithaSudhir

Position : Senior Software Engineer.

Contact number : +1-248-***-****

Email ID : ac1uur@r.postjobfree.com

Profile Overview:

Overall Experience - Minimum 6.5 years overall IT experience that will include 4.5 yrs in developing applications using all the process of SDLC And ability to write T-SQL . Most of the Technologies used are VB.6 and SQl Server 2000/2005.

2 yrs in giving support for the existence product and making changes in the product code by adding SQL queries or code changes as per business. Also have experience on Testing like unit testing, integration testing and system testing.

Knowledge on SSRS-Reporting services.

Key Skills – Visual Basic 6,SQL Server (2000/2005/2008/2012), Active-X,

Learning C#, Asp.Net,

Responsibilities – Analysis, Designing, Coding, Debugging and Unit testing.

Domain/Vertical Exposure – E-Learning

Platform- Microsoft .Net, Visual Basic

Project Execution Methods / Process – SDLC.

A strong team player with excellent interpersonal and communication skills and ready to take an independent challenge.

Application Programming

Visual Basic 6, Visual Basic .Net, c# ASP.NET,VB.Net

Platforms

.NET Platform (Exposure to ASP.Net, Web Service)

Web Development

ASP.Net

Database Skills

SQL Server, Microsoft Access, SSMS,SSRS

Tools

Visual Basic, Visual Studio 2005 and 2008.

Testing Methods

Functional Testing and Unit testing.

Responsibilities:

Understanding the requirements from customer

Study & analysis the requirements

Create detailed software development plan with dataflow diagrams

Create detailed software requirements documentation based on customer and internal specifications, reviews and clarifications.

Develop Front end, Active-X, Com and back end

Unit testing for changes made

System testing

Test the product and deploy it to test environment

Coordinate the implementation with the team to ensure systems requirements, deadlines and priorities are clear and attained.

Support queries from the client to deal with.

Coordinate daily work assignments with onsite and offshore development team.

Interactions with a SQL-based database

Discuss the problem with concerned manager if it is a major issue, get approve for software changes.

Prepares status reports for management regarding the software development progress.

perform unit and integration level test

Escalate the product issues and suggest product improvements

Mentor junior team members

Estimate how complex each task is by giving the task points

Check site monitoring and error logs to make sure there have been no issues during the night that need dealing with.

Generating reports using crystal reports (Basic knowledge).

Code changes, query modifications,Modifications in interface etc

Respond to the emails which require quick attention

Register Dll files

Close the issues/Tickets for which solution was given in BMC Remedy Tool.

Escalating the issues to other concerned team for solutions.

Employment Details:

4) Payroll Company: Trigent Solutions

Compnay: Accenture

Duration: Jan-2013 to April-2014.

Project Summary: EmailToDB built by ParkerSoft used to check Spam emails related to sales and orders.

Email2DB’s is used to receive an email, then parsing out data and specific keywords. Once the keywords and other data from the email is obtained, this is sent to a web service provided by Cisco that will decide which “section” of the case management system the email should be stored in. Email2DB will then store the data in the SFDC and OTS system, or reject the message based upon the web service response.Emails that failed parsing / routing (i.e. for which keywords have not been identified) will be sent to in order for CSR users with a specific role to take a manual decision (i.e. have the email deleted if it is a Spam or and OOO or have a case created for it).

Responsibility: Support the system by checking weather all the triggers are running successfully. Raise P1, P2, and P3, P4 issues if any problem raises and support the team in solving it. Manually check the emails for spam and segregate them, search emails which are not spam in Excel which sent by DataEntry department (Infosys) and search the same in EmailToDB and trigger them to the router.

Trouble shoot the Tickets raised by users and close them in BMC remedy Tool. Run JVM

Achivement: Manually searching the emails and running them in EmailToDB was consuming too much of work almost 10-12 hrs which then reduced by writing a small stored procedure which reads the excel data and upload to SQL Server by marking which is spam and which is not. Then selecting all the emails in one short and sending them for further process which was taken care by triggers in EmailToDB. The 10-12 hrs job got reduced to 15-20 mins.

3)Payroll Company: Crown Solutions

Company: TCS

Duration: Sep-2012 to Oct-2012.

Project Summary: This is a window based application, which involves capturing Insurance details for marine, earth quake etc

Responsibility: Support the system by checking the data in sql, make changes in data using simple queries. Raise P1, P2, and P3, P4 issues if any problem raises and support the team in solving it.

Analyze user needs and develop software solutions. Work with project manager and users to meet specification needs. Recommend software upgrades to optimize operational efficiency. Collaborate with other developers to design and optimize code

2)Payroll Company: Idenizen pvt Ltd,

Product: Smart Campus.

Duration: Sep-2011 to Sep-2012.

Project Summary: This is a window based application, which involves capturing all the details which requires running an Educational Institute. Starting from Admission to capturing the details of all passed out students. Payroll, Hostel, Transportation modules are also the part of the product.

Skills used: Visual Basic 6, Sql Server 2000, Crystal Report, Smart Draw

Responsibility: Analysis, Developing and involved in Maintenance and Enhancements.

1)Payroll Company: RangaRao & Sons

Duration: Jul-2006 to Jan-2011.

Brief on the role performed –Analysis, Designing, Coding, Debugging, Unit testing and Writing store procedures.

Projects Summary:

1.ERP(Microsoft Navision ): Business Process mapping of entire company which consists of various departments like production, marketing, dispatch, accounts, finance and Hr. ca\l coding client application coding.

2. ISR Management System: Isr(Interim Sales Representative) is sales representative appointed by the distributors. This project consists of 5 modules (Isr profile, proposal, expenses, Tpar and console). This project involves capturing all the day to day activities of Isr like area covered, Target achieved and his allowance details. Based on these details payment recommendation and various reports will be generated by the system.

3. Generation of Employee Appointment: Generation of appointment letter which contains salary details and company norms and conditions.

This project consists of two modules where one module used to enter the entire details of the new employee including his/her salary details. The other module used to generate the appointment letter with preferred format. If needed can be sent to respective employee through Email.

4. Imprest Account System: This Project involves maintaining the Expenditure details of every single department. Budget will be allocated for each department. Every department head will send proposal regarding the required amount to be spent with a proper reason. If it is within the budget the system will ask for the approval once approved the amount will be issued with receipt. Various reports like budget utilization report, expenditure report will be generated.

Basically this project consists of three modules where one module used to enter the budget details of every department. Second module is used to send the proposal for the required amount. The other module used to approve the proposal and generate various reports.

5. Payroll Automation: This project involves capturing all details of a given employee like attendance, company Name earnings, deductions; Loan Details. Depending on these details pay slip will be generated for the specific period.

6. LIMS (Laboratory Information Management System): To maintain a log of analytical data of various results so whenever needed, can be retrieved for comparison

7. Yield calculating system: Navision data is being ported to Excel to manipulate the data using visual basic code, data is saved to SQL database. Generation of various reports using Calculation of yield IGTM wise, total number of Stick per output, total consumption of sticks in kg, size wise, fragrance wise YEILD report, moving average, comparison report with respect to Packer.

8. Online Sales Portal: Business process for online shopping of products and customer relationship management process.

9. Advertisement: It involves streamlining of entire Advertisement activity in the

organization. Advertisement activity can be divided into two separate processes like Above The Line (ATL) (TV, Radio..etc) and Below The Line(BTL) (Stalls, Hoarding, News Paper etc) .State wise Budget will be allocated for these two types of advertising .Based on this budget proposal will be sent. Advertising process triggers from receiving the proposal from the field and approving and generating the payment recommendation, after getting the actual advertisement details. Claims processing involves comparing the actual sales and expenses with the planned sales and expenses, calculation of sales to expense ratio (product wise, campaign wise, state wise).

10. Sales Promotion Automation: It involves streamlining of entire Sales Promotion activity in the organization. This triggers from receiving the proposal from the field and approving and generating the payment recommendation for the same proposal in the corporate office. Claims processing involves comparing the actual sales and expenses with the planned sales and expenses, calculation of sales to expense ratio (product wise, Campaign wise, State wise).

11. BTMS (Business Travel Management System): Business process mapping to develop web based application, which involves capturing the tour program, lodging details; Plane, train and Bus schedules and expenses based employee allowances.

12. ARKUM: It involves streamlining the purchase of aroma materials and the quantity required to blend the fragrances to sprinkle on agarbathi’s. It is one of the biggest, challenging and very confidential projects developed only for the CEO of the company.

Educational Details:

Course

Institution

Year of Passing

Percentage

Mca

Mahajana college, Mysore, Karnataka, India

2006

72

Bsc

Maharani college, Mysore, Karnataka, India

2003

58

Puc

Mahajana college, Mysore, Karnataka, India

2000

54

SSLC

Mahajana school, Mysore, Karnataka, India

1998

70

Date of Birth : 29th October, 1982

Linguistic Ability : English, Kannada, Hindi.

Hobbies/Interests : Listening to music, playing Badminton, Chess, and Reading Books, Watching movies, cooking

Personal Address : BabithaSudhir

#35849, Woodington Square apt 107,

Building 40 Farmington hills, MI 48335

I hereby declare that the above written particulars are true to the best of my knowledge and believe

BabithaSudhir



Contact this candidate