Lalitha B Nagaraj

**** ****** ***** **** *

Irving TX 75063

316-***-****

accmfl@r.postjobfree.com

PROFESSIONAL SUMMARY

• Over 6+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005/2008/2012 in Development, Test and Production Environments on various business domains like Financial, Tax and Accounting and Insurance.

• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008 R2 and 2012.

• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.

• Great ability to create and manage various database objects like tables, views.

• Experience in using T-SQL in SQL Server 2005/2008 and 2012 platforms and proficient in Performance Tuning and Query Optimization.

• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

• Expert in creating Parameterized Reports.

• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

• Excellent in Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

• Hands on experience in Creating Star Schema and Snow Flake Schemas.

• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations.

• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

EDUCATION

M.S Electrical Engineering, Wichita State University, May 2011 GPA - 3.89

B.S. Electronics and Communication Engineering, VTU, India, June 2007

CERTIFICATIONS

Completed Data Warehousing and Business Intelligence training at Mindtree Ltd, Bangalore

Attended Microsoft SQL Server 2008 Training for 3 days conducted by Microsoft, Bangalore in 2008

CAMPUS CONNECT conducted by Infosys in 2006-2007. It is an initiative where selected students were imparted training in in the field of Information Technology (Computer hardware and software concepts, OOPS, RDBMS, user interface design and web architecture are some of the topics).

Attended extended training on C and C++ conducted by Aptech Computer Education, Bangalore

Working towards achieving MCSE certification.

EXPERIENCE

5+ Years of SQL

3+ Years of C Programming

6 Months of C++ Programming

6 Months of Java

WORK EXPERIENCE

Since Apr 2013 – IT Support Analyst at CCH Inc, Wichita KS(Works from Home)

Microsoft SQL Server (2005,2008,2012) and BI Suite

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 different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Used cascaded parameters to generate reports from different Data Sets.

Proficient in Query Optimization techniques that increase the performance of a Report.

Developed Reports for business end users using Report Builder with updating Statistics.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.

Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Database Development and Administration

Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor.

Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.

Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.

Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.

Developed Physical data models and created DML scripts to create database schema and database objects.

Employed Server Group Management, new to SQL Server 2008 which enables T-SQL queries to be issued against multiple servers from a single central management server.

Performed Debugging on the Stored procedures for the requirement to handle the errors.

Played an active role during the requirements gathering, analyzing and designing of the system.

Sept 2012 – Feb 2013 - DB Analyst/Programmer at POET Ethanol Products, Wichita KS

Database maintenance and back up responsibilities.

In constant touch with invoicing, accounting and scheduling teams to refresh reporting data and identify data mismatch.

Developed queries and code to generate complex reports accessible to end users.

Extensive hands on experience in Microsoft SQL server 2008.

Worked with complex data model that involved business logic with numerous underlying tables.

Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.

Coding of several procedures and functions to achieve business requirements and integrating them to front end application.

Providing real time solutions to issues encountered by invoicing team (end users).

June 2012 – Sept 2012 - Full Time Test Contractor at Work Force Logic onsite Netapp, Wichita KS

Running automated tests in Performance Benchmarking Team using TAS.

Successfully completed Skill Set Development Tutorials recommended for a new hire which includes various topics of Product Testing and Interoperability with Superior and Good grades from proctors.

Sufficient hands on experience on tools like TAS, host Software Management Tool(Santricity) and SANscan

Experience in Functional, system, Integration, Regression Testing and User Acceptance Testing with experience in using Automation Tools: TAS and VdBench.

Exposure to several performance metrics and reports.

October 2007– October 2008 as Programmer Analyst at Mindtree, Bangalore, India.

Worked in the field of Data warehousing and Business Intelligence.

Attended extensive training on Data warehousing concepts and database design.

Proficient in various fields of Data Warehousing like Data modeling, reporting and Data Integration. Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and packages for testing purposes.

Worked on projects that involved gathering business requirements, develop a data model base on those requirements and then designing data warehouse to meet them.

Worked on ETL tools like Informatica and SSIS.

Developed Data Warehouses for insurance and manufacturing data. Also, developed ETL (Extract Transform Load) routines that extract data from older mainframes, then transform, format, normalize it, and load it into relational databases. Experienced in end-to-end ETL processes including Data Extraction, Transformation/Mapping and Loading from source systems.

Developed reports and views that allow end users and customers to access their data according their business requirements. Also, maintained and provided customer support for those reports.

Developed and tested reports using tools like Business Objects – Crystal Reports, Cognos and SSRS.

Performed in several projects dealing with Microsoft SQL server 2008 and Oracle.

Taken the role of data modeler, ETL developer and Report designer.

Actively taken part in Business Intelligence projects with ability to gather business requirements quickly.

COMPUTER SKILLS

Operating Systems: Windows, Linux

Database Platforms: Microsoft SQL server, Oracle, SAP

Development Tools: MATLAB, Network Simulator (NS2), GridSim, Microsoft Access, TELNET, Eclipse

Reporting Tools: Crystal Reports XI, SSRS, Cognos.

ETL Tools: Informatica, SSIS

Hands on experience: on Cisco routers and switches during coursework. Extensive training on various networking protocols like RIP, OSPF, EIGRP, IGRP and BGP.

HONORS AND PROFESSIONAL AFFILIATION:

• Merit incentive awards for being the highest scorer in third and fifth sem E & C- Malnad College of Engineering, Hassan.

• Merit incentive awards for securing highest marks in Advanced Microprocessors, Solid State Devices & Technology during Jan 2006 examination and in Field Theory, Microprocessors Lab during July 2005 examination- Malnad College of Engineering, Hassan.

• Merit incentive awards for securing highest marks in Constitution of India and Professional Ethics, Image Processing during Jan 2007

• Certificate of Achievement in all India General Knowledge Examination-Centre of Human Resource Development.

• Certificate of Merit in Student’s Talent Promotion Examination-Children’s Welfare Trust of India, Chandigarh.

• A Seminar Report submitted on Provisioning of Survivable Multicast Sessions against Single Link Failures in Optical WDM Mesh networks as a curriculum.

A Technical Seminar on TECHNOLOGICAL ADVANCEMENTS AND SOCIETAL CHANGES in TAPSEM 04 organized by Department of Training and Placement, Malnad College of Engineering, Hassan.

RELEVANT COURSE WORK IN MASTERS PROGRAM

Data Communication Networks Principles of Database implementation Information assurance and security

Wireless Networks Discrete Event Systems Distributed Computing

Routing and Switching Linear Systems Optical Networks

XML Databases Network Flow and its Applications Concepts of Database Systems

COURSE PROJECTS

Load Balancing of Data Distribution in Sensor Networks – In this project, we describe an algorithm to accomplish load balancing in sensor networks. We also compare the results of this algorithm with the standard minimum cost flow algorithm for data distribution in sensor networks.

Programming Languages used: C programming for minimum cost flow algorithm and Java for the proposed algorithm.

Development of database to a School library - The database contains many relationships describing various user needs. A front end is created to carry out queries and other database related operations.

Programming Languages used: C Programming is used for User Interaction with the Database. SQL is embedded in C Program.

Encryption and Decryption in AES for various bit patterns.

Programming Languages used: C Programming is used in this project.

Fuzzy Discrete Event Systems modeling of Air-Conditioning System to achieve Cost Reduction and Effectiveness Maximization. - An algorithm is proposed to maximize the effectiveness and reduce the cost. Code is written to evaluate the maximum effectiveness. This code asks the user to enter various state vectors and weighted vectors for each node. Then calculates the effectiveness for each node and then evaluates the maximum effectiveness for all nodes.

Programming Languages used: C Programming is used in this project to calculate effectiveness in a network.

Design and Implementation of Chain Replication for Supporting Data Availability and Consistency in Storage System -

Programming Languages Used - Socket programming.

Building a Multi-Threaded Web Server – the goal is to develop a Web server in two steps. The server will be able to handle multiple simultaneous service requests in parallel. Socket programming is used to achieve the goal.(Data communication Network)

Programming Languages Used - Socket programming.

Energy Management in a Smart Home – A design project for a smart meter which makes use of a wireless communication network to communicate to the sensors attached to different electrical appliances at home. The goal of the project was to propose a wireless communication technology/infrastructure that would be best suitable for this.(Wireless Networking)

Survivability in Optical WDM Networks - This project includes the construction of optical WDM networks with least resources and hence of low cost. Integer Linear Programming (ILP) Technique is used for the same.

Tools and Programming Languages Used: Mathematica 5.2, Matlab & C programming are the tools used for solving ILP.

SOCIAL SERVICES

Working as a voluntary teacher in Vidya Vikas – School for teaching regional languages of India, Values and Principles for children.

Actively participating in several community services.

Status: Permanent Resident (Work sponsorship not required)

Reference: Available upon request.

Contact this candidate