We provide IT Staff Augmentation Services!

Sql Resume

Miami, FL

Dedicated IT Professional with database (SQL Server 2005/2008, Oracle, MySQL) and Business Intelligence experience (SSRS, SSIS 2005/2008) and other Reporting Tools.

Summary Of Qualifications:

  • Extensive experience in MS SQL Server 2008/2005 with Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services of 2008/2005.
  • Expert in creating Report Model Using Report Builder (1.0/2.0).
  • Strong SQL Server Developer skills including writing stored procedures, views, query writing, functions, dynamic report functions.
  • Excellent knowledge of PL/SQL, T-SQL, MySQL Query.
  • Excellent understanding of security given to each and individual reports and query using for reports.
  • Expert in creating Reports using SSRS 2005/2008, Crystal Reports, Cognos (Report Studio and Query Studio), BIRT (Eclipse), Excel and ProClarity.
  • Experienced in upgradingSQL server 2000 to 2005.
  • Over 3 months of experience in PPS (Performance Point Server 2007) Dashboard Designer (Planning, Analysis and Monitoring Tool).
  • Expert in creating Scorecards, KPIs, Dashboards and Filters.
  • Extensive knowledge of Power Pivot in the Excel for creating the user friendly reports.
  • Excellent Technical, Communication and Interpersonal Skills with strong Customer Orientation and Client Interfacing Skills.
  • A self-motivated professional and natural communicator possessing good technical, initiating, leadership and problem-solving skills and has proven to be a good team player.

List of Clients:
Miami-Dade County Public School (Miami), CBS Corporation (New York), Microsoft (Seattle), SUNY Downstate Medical Center (New York), Polytechnic University (New York), KV Pnuematics (Mumbai), Gujarat Otofilt (Ahmedabad).

EDUCATION:
Master of Science
Bachelor of Engineering

Computer Skills:

Business Intelligence Tool

SQL Reporting Services (SSRS), SQL Integration Services (SSIS), SQL Analysis Services (SSAS). 2005/2008, Performance Point Server (PPS).

Programming Language:

MS SQL Server 2005/2008, Cognos Reporting tool, Crystal Reports, BIRT Reporting (ECLIPSE), ProClarity, Power Pivot in Excel, P.L.C. Programming, SCADA (Industrial Automation Software).

Database:

MS SQL Server 2005/2008, Orcale 10g, MySQL 5.1.

Design:

Matlab, LABVIEW.

General:

Microsoft Office Suite, MS Visio, Documentum.

Testing Tools

Win Runner, QTP, Test Director / Quality Center.

Others:

LIMS, SDMS, 21 CFR Part 11, cGxP, VMP, GAMP, IQ, OQ, PQ, RTM, SOP, Summary Reports, Audit Trails, GAP Analysis.

EXPERIENCE:

Project Name:WCPS(Capital Payment Systems)

WCPS application is based on .net framework to give the user to maintain their vendors list and how many vendors are working on a single project and how much money they need to be paid. Depending upon the projects the applications has many different types of reports that user can easily identify and make their life easy and accordingly management can plan their budget.
Client:Confidential, MIAMI, FL
Duration:July 2009 - Current
Designation:Senior SQL Report Developer / Data Migration Expert
Responsibilities:

  • Created Reports and forms for the WCPS Applications.
  • Created many Sub-Reports in order to get user friendly reports just by clicking one print button.
  • Converting all the R-reporting reports to SSRS 2005 Reports.
  • Wrote T-SQL for the retrieval of the data.
  • Identified the Data Source and defining them to build the Data Source Views.
  • Identified and worked with Parameters for parameterized reports in SSRS 2005.
  • Created database objects like View, Stored Procedures, and Functions.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2005.
  • Created charts for data analysis which is better used for management team to review where the money is going to which project and how much they have paid and what is the balance.
  • Created the model which was used by the user using power pivot in excel where they can just drag and drop the field for analyzing the data.
  • Successfully Migrated Sybase data to SQL Server 2005. Involved in cleaning the data and taking the back-ups using all the business rules for this project.
  • Ensured accuracy of the data by defining and building necessary audits and controls.
  • Created SSIS package to run weekly to migrate the old data while still going into production.
  • Responsible for ongoing maintenance to existing reports and optimize report performance.
  • Provided Documentation support on SSRS 2005 as assigned.
  • Trained and managed developers the best practices used in developing Reports using SSRS.

Environment:
MS SQL Server 2005/2008 Enterprise Edition, MS SQL Server Reporting Services 2005/2008, SSIS 2005, Windows XP, MS Access 2000, TFS (Source Control) and R-Reporting.

Project Name:ORION

The Orion application is used to allow users/clients to view airing schedule, manage/generate airings, make a deal and generate the billing process for CBS Corporation. The Orion reporting framework is used to launch the reports. This application is to develop a world-class sales and traffic system that improves efficiency, flexibility, and competiveness within CBS.
Client:Confidential, MANHATTAN, NY
Duration:Nov 2007 - Sept 2008
Designation:SQL Reports Developer
Responsibilities:

  • Analyzed Business requirement for reporting purpose.
  • Identified the Data Source and defining them to build the Data Source Views.
  • Developed Query for generating drill down reports in SSRS 2005.
  • Designed and implemented stylish report layouts and Sub-reports.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Identified and worked with Parameters for parameterized reports in SSRS 2005.
  • Created database objects like View, Stored Procedures, and Functions.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance. (SSRS)
  • Performed Report Testing and Verification as per Internal Reporting system requirements.
  • Trained and managed developers the best practices used in developing Reports using SSRS.

Environment:
MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Windows XP, VisualStudio.NET, MS Access 2000, TFS (Source Control) and BIDS.

Project Name:Performance Point Server

Microsoft Office Performance Point Server 2007 is an integrated performance management application that enables business people to monitor, analyze and plan the business. Performance Point Server 2007 is a proven platform for business intelligence, data integration, and reporting. Performance Point Server 2007 provides the tools and connections to make Microsoft Office the interface for decision makers, Share Point Server the way to deliver information, and SQL Server 2005 the data integration and collection engine.
Client:Confidential, REDMOND, WA
Duration:Aug 2007 - Oct 2007
Designation:Application Developer
Responsibilities:

  • Created highly visual and interactive scorecards that can keep the business up to date on what is happening in the organization.
  • Created Key Performance Indicators (KPIs) that can help business to monitor things as progress on a specific initiative and progress against sales forecasts.
  • Designed a dashboard which is a collection of graphs, reports, KPIs and Scorecards.
  • Created Strategy maps, Analytic charts and grids, Reports, Scorecards (subset of scorecards), multi-select filters.
  • Deployed dashboard to Microsoft Office SharePoint Server 2007. And then exported the dashboard to Excel.
  • Worked with MDX query in order to provide calculated members in the scorecards and as well generating Time filters and Geography Filters in the dashboard level.
  • Worked on PPS migration from one environment to other environment.
  • Created same scorecards using Excel with cube member and cube value functions in order to give business different variety of taste.

Environment:
MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Performance Point Server 2007, Dashboard Designer, ProClarity, MS SQL Analysis Services.

RESEARCH WORK:
Confidential, BROOKLYN, NEW YORK Aug 2006 - May 2007
"Diffuse Optical Tissue Simulator"
(Working on DYNOT machine used for brain imaging)

  • Achieved the best instrumentation and calibrationprotocol for imaging dynamic features in dense-scattering media by optical tomography consisting of 32 Source - Detector pair.
  • Ability to recognize the dynamic behavior of the phantom / tissue from image time series by performing good calibration of the detectors and optical efficiency coefficient.
  • Measurement of gain amplification and calculating oxy and de-oxy hemoglobin by MATLAB.
  • Achieved the best simulator that can mimic as optical properties of hemoglobin. Currently using Liquid Crystal Display. Introduced dynamic behavior into LCD for different background media and cell depth.

Confidential, MUMBAI Aug 2003 - May 2004
"PLC Based Instrumentation System Design for Actinide Separation Process".

  • Project involved analysis of the Actinide Separation Process, monitor the measurement of various parameters like Pressure, Temperature, Interface, Level, Flow etc and transfer the liquid from one tank to another by various methods like Air lift and Steam jet.
  • Designed and implemented logical interlock write up by using PLC (Eurotherm) (Functional Block Diagram Programming) and made completely accessible from the control room with the help of SCADA (Intellution Fix), industrial automation software.

Graduate Assistantship Aug 2005 - May 2006

  • Worked in the chemical lab under Prof. Richard Gross at Polytechnic University on HPLC data management.
  • Worked under Prof. Schmitz in a group called Optical Tomography Group at SUNY DOWNSTATE MEDICAL CENTER in a project of developing an instrument for recovering an image from an infant, which is kept in incubator.

References Available Upon Request.

Hire Now