We provide IT Staff Augmentation Services!

Data Analyst Resume

Washington Dc, UsA

Summary

  • Experienced in all the stages of the System Development Life Cycle from Analysis, Design, Development and Implementation.
  • Extensively worked on SQL-Server in database design, implementation, query tuning. And also got good exposures on DTS/SSIS and Analysis Manager in SQL-Server 7.0/2000/2005.
  • Extensive experience in writing T-SQL scripts and Stored Procedures.
  • Strong Data Warehouse skills and excellent skills with various data models, Star Schema and Snow Flake Schema.
  • Experience in working with different complicated DTS tasks involving ActiveX Scripting.
  • Worked on Data warehousing, Data Marts, DTS Packages, and OLAP Cubes using Microsoft Analysis service and gone under extensive training under Cognos data warehousing tool.
  • Having good working knowledge on Load Runner for performance testing of database server
  • Experienced in designing and implementing three tier applications using COM, ActiveX, ODBC and OLEDB
  • Experience in Web Application development using ASP3.0, Visual Basic, DOM, ADO 2.0, Visual InterDev 6.0, IIS 5.0/6.0 and Windows NT/98 environments and Windows 2000
  • Experienced in working directly with clients to define requirements, project work planning and management, design, development and successful implementation of applications on time.
  • Astute people management and excellent motivational skills that have consistently delivered to the satisfaction and appreciation of clients.

TECHNICAL KNOWLEDGE

GUI Tools/Programming Languages Visual Basic.NET, C#, Visual Basic 5.0/6.0, Visual Interdev 6.0, Forms 4.5, JAVA, C, C++, Basic, Fortran, Pascal, 8086 (assembly languages)

Data warehousing Tools Microsoft Data warehousing Framework, OLAP Manager, Microsoft Repository, Analysis server, Cognos 7.0 (Powerplay)

Internet Programming VBScript, JavaScript, ASP, HTML, DHTML, XML

Databases SQL Server 2005/2000/7.0 (database implementation and designing, administration and data warehousing), Oracle 7.1, MS-Access

Operating Systems Windows NT 4.0/2000/2003, Windows 95/98/Me, UNIX, and DOS

Other IIS 5.0, Exchange Server 5.5 Commerce Server 2000, Site Server Commerce Edition 3.0, COM, MTS, MS-MQ, MS-Digital Dashboard, MS-Office 2000, Front Page 2000, MS-Project 2000, Outlook 2000

EDUCATION

Master of Information Technology
Bachelor of Computer Science

PROFESSIONAL CERTIFICATION

Microsoft Certified Solution Developer (MCSD) Certificate (Since 1998)

Developing and Implementing Web Applications with Microsoft Visual Basic .NET
Developing and Implementing Windows-based Applications with Microsoft Visual Basic.NET
Designing and Implementing Databases with Microsoft SQL Server 2000
Developing XML Web Services and Server Component with Microsoft Visual Basic .NET

PROFESSIONAL TRAINING

JAVA
National Institute of Information Technology Bangalore, India

Developing Distributed Applications using Visual Studio 6.0

National Institute of Information Technology Bangalore, India

Implementing & Designing Data Warehouse using Microsoft SQL Server 7.0

National Institute of Information Technology Bangalore, India

Oracle 7.1, Forms 4.0, Reports 2.0, Visual Basic 4.0
PCS Computers (P) Ltd. Bangalore, India

UNIX and ‘C’
Digital Equipment (I) Ltd. Bangalore, India

PROJECT EXPERIENCE

Project : Special Education Data System (SEDS)

Client:Confidential,Washington DC, USA

Duration:August 2008 August 2009

Role:Data Analyst

The solution for special education management can help Washington DC schools to achieve federal and state compliance while improving processes and service in special education program. Program closely tracks changes to the Individuals with Disabilities Education Act and continually adapts to meet the changing needs of education stakeholders, from teachers, administrators, and other education experts to parents.

  • Data Extraction from excel and .txt file and transfer and loading data into Reporting Server.
  • Cleansed data pump it to SQL Server Database (reporting server) using SSIS
  • Wrote SSIS Package to import data from ftp server to the Reporting Server
  • Wrote stored procedure and views to create ad hoc reports.
  • Understand business rule and modify the Stored Proc for better performance.
  • Execute performance tool SQL Profiler and Performance monitor to fine tune the stored procedures.
  • Generated cross tab report based on client requirements.
  • Generated report using Business Objects to get the data from Easy-IEP to reporting server.
  • Scheduling and maintain database backup and restore jobs
  • Migrated the data from earlier version to present data base and fine tune the database.
  • Publish and maintain reports in Share point server.

Environment: MS SQL Server 2005, T-SQL, SSIS, Access, MS-Office 2007, Share Point 2003, Business Objects (BO), MS Access
Project : CCH Inc.,

Client:Confidential, Seattle, WA, USA

Duration:August 2007 July 2008

Role:Database Administrator (DBA)

Confidential,is the Flagship Product of CCH Group, who is major players in Taxation related products (CompleteTax®) subsidiary of Wolters Kluwer. Real-time Web-Reporting System is being designed to provide real-time access to Tax Payers the current status of their tax Return.

  • Understand the table schema and add/modify the index to fine tune the query. And rewrite the query for better performance.
  • Responsible for the Redesign the Design of the Databases
  • Modify the table structure for better performance on out put of query execution time.
  • Understand business rule and modify the Stored Proc for better performance.
  • Involved in load testing of database and fine tuned the Query, Stored proc and views.
  • Configure and Run performance tool like Data Tuning Advisor, SQL Profiler and Performance monitor to fine tune the stored procedures.
  • Create server logins and database permissions
  • Configured and tested on Load Runner for performance testing of database server
  • Configure SQL Server box for better performance on execution time.
  • Organize the meeting with different stake holder of this project for better clarity on changes in database.

Environment: MS SQL Server 2005, SSIS, Reporting Server SSRS, T-SQL, SQL Profiler, XML, Apex SQLDiff, Load Runner

Project : Confidential,

Client:Confidential,Houston, TX, USA

Duration:February 2007 July 2007

Role:Application Developer / DBA

SigniaDocs takes pride in maintaining an extensive, up to date library of forms monitored for legal and regulatory changes in the mortgage industry on both the federal and state levels. This application guarantees that custom mortgage loan products are maintained and compliant at all times. Advanced integration makes it possible for online TIL calculations and high cost analysis at the federal, state, county, and municipal levels eliminating chance of violation. These features combined with over 200 error checks and edits on each transaction; make Signet Direct a user-friendly tool that ensures accuracy for all levels.

  • Create/modify database tables and stored procedures, views
  • Fine tune the stored procedure and views
  • Scheduling and maintain database backup and restore jobs
  • Used VBScript and Java script as scripting language in order to develop or modify the ASP Pages

Environment: MS SQL Server 2000, T-SQL, Dream weaver, Vault Server, ASP, VBScript, Java Script.

Project : Encore Data Management (Interface)

Client:Confidential, MD, USA

Duration:November 2006 January 2007

Role:SQL Server Developer / DBA

This client develops product called ENCORE for special education data management system. This is the most sophisticated and comprehensive system for Special Education. ENCORE minimizes hands-on administrative tasks, monitors forms completion for compliance, and provides ready access to information needed for managing and monitoring the day-to-day tasks. Increased focus on student outcomes often leads to greater staff satisfaction and to reduced staff turnover and its attendant costs.

  • Data Extraction, Transfer and loading (ETL) Data with DTS
  • Wrote stored procedures, views, DTS Packages for scheduling the data loading into Application Server.
  • Creating Stored Procedure, Triggers in SQL Server
  • Generating Ad hoc Queries and Reports based on Management Requirement
  • Product Interface setup in the client Machine and Maintenance
  • Backup / Restore, regular maintenance and troubleshooting of data

Environment: MS SQL Server 2000, DTS Package, Access 2000, VSS, MS- Office, Windows 2000/NT.

Project : Data Migration

Client:Confidential,California, USA

Duration:June 2006 October 2006

Role:SQL Server Developer

In this conversion program migrated the data from existing Texas Jewel Auto database to new application called MRM Insurance Portal database.

  • Responsible for collecting requirements.
  • Responsible for mapping data from existing database to new database.
  • Responsible in writing Stored Procedures to migrate the database.
  • Responsible in testing the data based on the Business Rule in new database.
  • Programming using T-SQL scripts required in database migration.
  • Responsible for working with Business users.

Environment: MS SQL Server 7.0 and 2000, T-SQL, Windows 2003

Project : Market Analytic

Client:Confidential,

Duration:October 2005 April 2006

Role:SQL Server Developer

Market Analytic is integrated into back bone of day to day business operation application. Market Analytic pull the historical data from main system and push the data to different mart to develop granular level of analysis. Market Analytic is an OLAP tool taking advantage of the great variety of data available in Market database. It provides online standard and customized reports to measure both Business Performance and Market performance based on different analysis.

  • Responsible for sourcing data from various source systems.
  • Involved in designing and creating new database objects including tables, Stored Procedures
  • Responsible for creating various packages to implement the logic and load the data to database using T-SQL.
  • Involved with SQL Server installation and administration of SQL Server security.

Environment: MS SQL Server 2005, SQL Server Integrated Services SSIS, MDX, Microsoft Analysis Services (SSAS), T-SQL, Windows 2000.

Client:Confidential,

Duration:November 2002 September 2005

Role:Technical Consultant

  • Involved in-house application development team.
  • Involved in system study and develop data base design for application development using SQL Server.
  • Also involved in writing stored procedures, views for the data retrieval and data modification of the SQL Server Database.
  • Coordinate with different department and understand their business requirement and guide the team to develop application.
  • Develop Hands-On-lab manual for VS.NET and Windows 2003 server workshop and deliver.
  • Organizing and managing Hands-on-Lab sessions across India.
  • Organizing the .NET Blitz presentation and followed with training work shop all over India. We have delivered 95 presentations all over India in the span of eight months.
  • Content provider for the Microsoft India SQL-Server

Environment: VS.NET, SQL-Server 2000, VM Ware, ConnectiX, Windows 2003

Hire Now