Resume

Sign in

SQL Developer / reports Analyst

Location:
Austin, TX
Posted:
February 25, 2015

Contact this candidate

Resume:

Prasanna

Cell: 405-***-****

Email: acog5t@r.postjobfree.com

SUMMARY:

. Close to 6 years of software development experience.

. Work experience in reporting tools such as SSRS and SSIS.

. Good experience working with SQL Server, XML, Adobe flex, HTML, SVN,

MS Excel and Jasper iReport.

. Worked with users to ensure that development efforts are meeting the

user's needs.

. Document requirements and create detailed design specifications.

. Highly motivated, dependable trouble-shooter and problem-solver.

. Ability to learn and work efficiently as an individual and in groups

. Customer-focused performer who is committed to achieve quality in

every task - Won award "Pillar of Excellence" in the year 2012 for my

work that involves customer focus.

. Capable of supervising and mentoring multi-disciplinary teams,

including Test, Planning, Quality and Configuration Management.

. Involved in full SDLC of Testing which includes analysis, design,

development, unit testing, integration testing, System Testing, User

Acceptance testing, Certification Testing and Regression Testing.

. Proficient in using bug tracking tools such as Jira.

. Have experience working in Agile Methodology.

. Proficient in Designing Test plans, test cases, and test scripts and

Test procedures.

. Participated in requirements analysis reviews and working session to

understand the requirements and system design

. Experience and good understanding of using UNIX commands.

. Excellent team player with good communication skills and leadership

qualities.

. Experience working with SQL queries, Triggers functions, functions,

constraints, views, CTE, Temporary tables and Stored Procedures on

databases like SQL Server and MYSQL

. Excellent analytical,communication and inter-personal skills

EDUCATION:

. MS IT, California State University, Fresno, CA (2007-2009)

. B.E, Computer Science, Anna University, Chennai, India (2002-2006)

PROFESSIONAL EXPERIENCE:

Echelon Services, Houston, TX

07/14 - Transitioning

SQL Developer

This is in Oil and Gas Domain and this tool is used to get all the well

information, wells parameters like pressure, depth, production volume, cost

and building analytics based on the existing parameters for top 15 states

in USA.

Responsibilities:

. Automation of reading and loading the data by using oil and gas public

website domains in USA.

. Getting the attachments as excel files, and reading the data from

excel file.

. Getting the PDF files and reading the content from the files

. Creating databases and tables to store all the data in SQL Server.

. Storing the extracted raw data into the staging tables in SQL server.

. Developed complex SQL queries and Stored procedures to add the needed

calculations and analytic part to the tables.

. Finally integrating the transformed data into Google big Query.

Environment: C#.NET, ASP.NET, WCF, SQL Server 2014, TFS, Coded UI, WatIN,

Google Big Query, Big Data, Google cloud Storage, GoogleAPI's and Visual

Studio 2013.

Scantron Corporation, Atlanta, GA

12/12 - 07/14

Reports Analyst/ Reports Developer

Spectrum K12 School Solutions, Inc. is a wholly owned subsidiary of

Scantron Corporation and part of the Harland Clarke Holdings Corporation

family of businesses. Spectrum K12 is the market leader in providing

Student Achievement Management, Response to Intervention (RTI) and

Special Education software solutions, serving 11% of the U.S. K12 student

population including 20 of the top 100 school districts in the United

States. Our award-winning software has driven personalized learning to

over 5 million students in 29 states. Our EXCEED Student Achievement

Management Suite provides an advanced, enterprise framework that can be

configured to manage major educational programs within a school district,

as well as provide reporting on those programs.

Responsibilities:

. Establishing procedures for processing Reporting Requests.

. Gathering requirements from the clients for the reports.

. Reviewing the requirements with Educational Analysts and providing

recommendations.

. Developing Jasper Reports for the Education Industry.

. Involved in developing SSIS packages and complex extracts in T-SQL

that will be fed into the Student Information System by the districts

(Sandiego, Meridian, Oklahoma, Cherry Creek and Monterey) for

generating reports that need to be submitted to the state for funding

of their special education programs.

. Testing and validating the reports.

. Data analysis - When the client migrates from a Legacy system to

Exceed (Educational software for maintaining special education student

information) what are the data elements that need to be setup and

migrated over to meet the state reporting needs.

. Documentation of the Reports.

. Learned Jasper iReport and gained educational industry domain

knowledge on the job.

. Developing complex SSRS Reports (Drill Down, Drill Through, Sub

report, Cascading Parameters, Graphs) and deploying reports.

Environment: Jira, SVN, MS SQL Server, Apache tomcat

Spectrum K12 School Solutions Atlanta, GA

11/10 - 12/12

Implementation Engineer

EXCEED is a fully integrated system to manage and measure the day-to-day

activities, meetings, research based interventions and outcomes used to

help all students achieve academic success. In addition to intervention

management, EXCEED seamlessly facilitates the transition of students into

Special Education, while assuring evaluations, meetings and delivery of

services are completed appropriately. Throughout EXCEED intuitive visual

data displays enable the user to validate data, identify patterns, and

take a proactive approach to move every child forward.

Responsibilities:

. Delivering the customizations to our core product.

. Going through the requirements and create the IEP process for the

client configurations (State editions & District schools).

. Creating and applying the business rules to match the client

requirements.

. Troubleshooting the product functionality and implementation issues,

including interfaces to databases and authentication systems.

. Providing systems operational support, technical skills to monitor,

operate and maintain technical infrastructure.

. Installed and deployed application to web servers.

. Created user input screen forms using flex.

. Created print forms using iReport.

. Troubleshooting the implementation issues, including interfaces to

databases and authentication systems.

. Communicating with implementation architects, project managers,

education analysts, and customers to ensure that we deliver a high

quality solution.

. Documented detailed test scenarios and test cases.

. Involved in Backed Testing by writing SQL queries to ensure the data

integrity and validating the data.

. Performed extensive Regression Testing after every new build we

release to the client.

. Provided QA testing for configuration rules and processes.

. Executed test cases manually to check GUI and functional features of

the application.

. Responsible for managing monthly release cycle of the product.

. Have provided release notes about the fixed bugs and enhancements for

the release.

Environment: Jira, Adobe flex, SVN, MS SQL Server, JAVA, XML, Apache

tomcat, Design studio, Microsoft Office, Windows XP.

Verizon Wireless Seattle, WA

07/10 - 11/10

Junior Reports Developer

Project: Network Ordering and Provisioning System- Business Networks

Verizon Communications Inc., a Dow 30 company, is a leader in delivering

broadband and other wire lines and wireless communication innovations to

mass market, business, government and wholesale customers. Verizon Wireless

operates America's most reliable wireless network, serving 59 million

customers nationwide. Verizon Business operates one of the most expansive

wholly-owned global IP networks. Verizon Telecom is deploying the nation's

most advanced fiber-optic network to deliver the benefits of converged

communications, information and entertainment services to customers. BGW

(Broadband and Gateway) is a web based application for Provisioning and

Inventory, to replace the existing Granite system. GUI involves showing

different equipment's and paths from inventory, on the browser and Data

Migration typically involves loading data from existing systems running on

Mainframe.

Responsibilities:

. Was working in the production Support team

MQR Technology Solutions Chennai, India

07/06 - 07/07

Junior Report Developer

Project: Billing System

Dairyland Power Cooperative is a generation and transmission cooperative

(GandT) that provides the wholesale electrical requirements and other

services for 25 electric distribution cooperatives and 20 municipal

utilities in the Upper Midwest. Dairyland's service area encompasses 62

counties in four states (Wisconsin, Minnesota, Iowa and Illinois).

Dairyland has provided low-cost, reliable electrical energy and related

services for over 63 years

Responsibilities:

. Actively involved in different stages of Project Life Cycle.

. Documented the data flow and the relationships between various

entities.

. Actively participated in gathering of User Requirement and

System Specification.

. Followed and maintained standards and best practices in database

development.

. Involved in tuning of database by creating efficient stored

procedures and T-SQL statements.

. Provided assistance to development teams on Tuning Data, Indexes and

Queries.

. Developed new Stored Procedures, Functions, and Triggers.

. Implemented Backup and Recovery of the databases.

. Actively participated in User Acceptance Testing, and Debugging

of the system.

Environment: Java/J2EE, JSP, Struts, JNDI, Tomcat, BEA Weblogic 8.1, HTML,

JavaScript, MS SQL Server

References:

Available upon request.



Contact this candidate