Sql Server Computer Science

PREETHA MOHAN - Valid US Work Permit (EAD Card)

Email ID: **********@*****.*** Mobile: +1-669-***-****

Current Location: Round Rock, Texas

Professional Summary

Programmer Analyst with close to 8 Years of experience in Management Information Systems, Reporting and Application support

Proficiency in Microsoft Excel functions (Pivot Table, Macros, VLookup and Aggregate), VBA, SQL Queries

Exposed to the entire software development life cycle, various programming practices and techniques. A proven team player with good analytical, organizational, interpersonal and communication skills

Periodic data analysis for Generating Reports to improve application efficiency

Exposure to C, C++ Programming Language

Skill Set

Operating Systems: Windows

Office Automation Software: Microsoft Office and Tally

Programming Languages: C, Exposure to C++

Front End Software: VBA, Visual Basic 6.0, Exposure to C#.Net, Asp.Net, VB.Net

Database: Oracle 8i, SQL Server

Web Designing Tools: Exposure to HTML, ASP, XML, VB and Java Script

Experience Summary

Organization

Duration

Department

Designation

Computer Science Corporation

Bangalore, India

Feb 2013 – July 2015

Application Support

Programmer Analyst

SutherLand Global Services

Chennai, India

Sep 2007 – Feb 2013

MIS/Reporting Analyst

Sr. Executive

Educational Qualification

Master of Computer Applications, Aggregate Mark 70 %

University of Madras, Chennai, India

Bachelor of Commerce, Aggregate Mark 60 %

University of Madras, Chennai, India

Programmer Analyst, Computer Science Corporation (Feb 2013 – July 2015)

Monitoring & supporting 49 mine-site applications and 25 servers.

Researching on unresolved issues, determining the technical root cause of issues and publishing solutions according to that.

Enhancements / bug fixing of client applications.

Releasing / deploying the applications and upgrading software versions.

Performed all of the associated Help-Desk Software entry, Service Call Incident tracking, monitoring, updating, interconnected administration and business process and ensured each call met the Service-Level-Agreement (SLA) commitments.

Generating & maintaining day to day MIS Data and updating the management.

Determined required data by analyzing MS-Access databases and created customized reports.

Handling SQL queries for data manipulation and retrieve on SQL server.

Reporting by using MS Excel & VBA (Macro) at Operational and Client level.

Extensive usage of MS Excel (Aggregate function, VLookup, Pivot table, Macros)

Done Ad-hoc reports Monthly reports and duties as assigned

Completion of Service requests and incidents using Remedy v7 within specified SLA for 1st to 3rd level client support

Investigated, assessed, and resolved software problems on systems.

Isolated and resolved performance issues.

Assisted internal users experiencing operational, hardware, or network connectivity problems with their computer systems and provides basic support for the office productivity software used within the organization.

Asset Management and infrastructure operations.

Platform: Ms Access, Ms Excel, ASP.Net, C#.Net, SQL Server

Sr. Executive, SutherLand Global Services (Sep 2007 - Feb 2013)

Develop MIS system for customer management and internal communication using VBA & Macros.

Understand customer problems and provide appropriate technical solutions.

Analyze business information to identify process improvements for increasing business efficiency and effectiveness.

Participate in cross-functional meetings to resolve recurring customer issues.

Provide customer support and assistance in issue troubleshooting and resolution.

Identify critical to process issues and develop workable solutions for Business Operations

Stack ranking the employees on regular basis.

Confirming Billing inputs to the client.

Supporting Service Delivery team in their template creation and new reports as per their requirements.

Employee and team wise performance tracker and productivity reports.

Sending Program Dashboard to managers on time with accuracy

Updating Table F on monthly basis

Done other Ad-hoc reports and duties as assigned

Provide support and maintenance to existing management information systems (MIS).

Generate and distribute management reports in accurate and timely manner.

Platform: Ms Access, Ms Excel, SQL Server

PREETHA MOHAN

Contact this candidate