Sr. Software Consultant Resume

SUMMARY:

Software Developer with over 13 years of software development experience.
Ability to learn new emerging technologies and adapt quickly.
Experience in developing Data warehouse ETL processes using SQL Server DTS and SSIS.
Experience in developing Business Intelligence projects using SSAS SQL Server 2005.
Performance Tuning using SQL Profiler traces in Database Tuning Advisor(DTA)
Expert in Conceptual, Logical, Physical database design and perform normalization/de - normalization in OLAP, OLTP database and Dimensional Modeling
Created and modified complex queries, SSRS Reporting, views, stored procedures and triggers.
Ability to handle multiple tasks and demonstrate initiative, adaptability and capable of handling responsibilities independently as well as a proactive team member.
Green Card - Permanent Resident of United States of America

EXPERIENCE:

Confidential

Sr. Software Consultant

Responsibilities:

Work on Call center product, create Reports, Develop Sementic models, Installation, Extension of Business Intelligence Model - Integration Services, Reporting Services and Analysis Services.

Confidential

Business Intelligence Consultant

Responsibilities:

Develop and run weekly and monthly SSIS Packages to prepare data for Business/Data Analyst.
Develop complex stored procedures, functions and views.
Perform Dimensional Modeling for developing SSAS cubes for NPEasy Asp.net application.
Regularly use Performance Monitor, SQL Server Profiler and Data Tuning Advisor (DTA) to fine tune database.
Developed Datamining Models for Statistical Analysis.

Confidential

Consultant

Responsibilities:

Developed Intelligence solution for PharmaNET and BizNET online application using Microsoft BI Stack (SSIS, SSAS, SSRS and Excel 2007).
Perform - Database Design - Conceptual, Logical, and Physical and Dimensional Modeling. Designed multi-dimensional cube, dimension modelling (Star and snowflake design) for staging data-warehouse.
Consumed cube over http using Excel 2007. Performed Database tuning using DTA and SQL Server Profiler.

Confidential

Student

Responsibilities:

Competed training in Microsoft Business Intelligence through AppDev.com Learned SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services.

Confidential, Bridgewater, NJ

Consultant

Responsibilities:

Created Dimensional Modeling for Prototype Datawarehouse related to Confidential Industry.
Created SQL Server SSIS Packages for Facts and Dimension Tables.
Developed multi-dimensional cubes using SSAS.
Used Excel 2007 to consume data from cube to create pivot tables in Excel 2003.
Used SQL Server SSRS to create reports for various stakeholders.

Confidential, Boston, MA

Consultant

Responsibilities:

Created and consumed web services for MS Access application. Created e-mail automation routine for MS Access application.
Completed migration of an MS Access application to SQL Server 2005.
Created Windows Smart client Application Launcher using VB.net and SQL Server 2005.
Currently working on creating Windows CE 5.0 barcode scanning application on Motorola Symbol MC 9090-G hand-held scanner using VB.net.
Designed relational database model logical and physical design, indexing and wrote stored procedures.
Passed 7-526 VB.Net Microsoft Certification Exam.

Confidential, Boston, MA

Consultant

Responsibilities:

Enhanced existing VB 6.0 Appraisal application and added error trapping module for Confidential Bank.
Error trapping module provides support for initial error processing, stack unwinding and tracing, persisting error report, ADO errors, system exceptions, aborting ADO transaction, application-raised exceptions, closing opened files, releasing COM objects, and has some other features.

Confidential, Boston, MA

Consultant

Responsibilities:

Developed VB.net Application with Oracle backend at Simplex Grinnell.
VB.net application was designed for data-entry and reconciliation of existing data.
Wrote complex SQL Queries and stored procedure.

Confidential

Consultant

Responsibilities:

Developed, maintained and enhanced Revenue Assurance Process(RAP) application in MS Access 2003 for Confidential .
Developed complex queries for adhoc reporting. Used Business Object queries to pull data for Datawarehouse into RAP.
Developed data entry forms, data analysis, data modeling and reports for OTIS using MS Access.