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.