SUMMARY

• 11 years of IT experience with strong SQL Server Database development and Administration.
• Experience in logical and physical data modeling including defining database tables and indexes, referential integrity, constraints etc on those.
• Expert in Database Design and data interaction process between Web server and Database server.
• Experience in designing dimensional data modeling using cubes in SSAS.
• Possess SQL Server Developer skills including writing DB scripts, Query writing, stored procedures and views.
• Good experience in Designing and Creating BI Business Intelligence projects.
• Hands on Experience in designing, implementing and maintaining data warehouse applications.
• Experience in Object Oriented Analysis concept implementation, design and programming technical skills.
• Experience in handling global development team, multiple tasks and capable of handling responsibilities independently.
• Having experience in working all phases of the Software development life cycle.
• Good amount of experience in utilizing ETL tools SSIS SQL Server Integration Services and DTS Data Transformation Services .
• Good experience in creating SQL server Analysis Projects SSAS using SQL Server 2000/2005/2008.
• Expertise in creating various types of reports using MS SQL server reporting services SSRS .
• Experience in Administrator tasks like installation of MS SQL Server 2008/2005/2000, performance analysis, tuning, capacity planning, implementing backup and recovery strategy for application and database.
• Expertise in using Visual Source safe VSS as version control tool.
• Expertise in creating complex reports using Crystal reports Business Objects reporting tools.
• Experienced in handling Web based Intranet/Internet application using ASP, HTML, VB Script and JavaScript in IIS / MS FrontPage / Visual Interdev environment.

TECHNICAL SKILLS

OS

Windows 2000, Windows Server 2003, Windows server 2008

Databases

SQL Server 2008/2005/2000, PL/SQL, Oracle 11g/8.0i, Microsoft Access 2000/8.0

Languages

C .Net, VB.Net, XML, ASP.NET, T - SQL

Scripting Languages

HTML, XML, Java Scripting, VB Scripting

Web Tools

C .Net, ASP.Net,VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script

ETL Reporting

SSRS 2005/2008, SSIS 2005/2008

Hardware

IIS 6.0/5.0/4.0

Version Defect Control

Microsoft TFS, MS VSS, Synergy, HP Quality Center Jira

Others

MS Office, Erwin, Crystal Reports XI, Visio, Microsoft Business Intelligence Studio, Service Oriented Architecture SOA SQL Server Notification Services, SQL Server 2000/2005 Analysis Services SSAS, Visual web developer, MS FrontPage, Windows Scripting Host

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL Server Analyst

Responsibilities:

• Creating tables, procedures, views and triggers for business needs.
• Modifying tables and .ctl files in accordance with the source file changes.
• Designing SSIS packages for the daily and weekly data loads and scheduling them using SQL agent.
• Modifying SSIS packages for business logic enhancements.
• Creating SSRS reports for the sales team.
• Creating SSRS email subscriptions for the onsite sales team.
• Writing/modifying VB scripts for sales file moments and data loads.
• Writing/modifying batch files to kickoff the SSIS packages from the windows environment.
• Designing .CTL files to load the data into database tables using flat files as the source.
• Creating VB script files to manage the daily and weekly file feeds and their names then move the historic files to archive folder.
• Migrating SSIS packages from 2005 to 2010 visual studio shell.
• Modifying vb script files for enhanced business logic.

Environment: SQL Server 2005/2008, MS SQL Server Reporting Services 2010/2005 SSRS, MS SQL Server Integration Services 2005/2008, Microsoft Business Intelligent Studio, MS SQL Query Analyzer, SQL Profiler, Microsoft Visual Studio 2010 Shell, SQL Plus.

Confidential

SQL Server Analyst/BI, SQL Developer update

Responsibilities:

• Implementing business logic of Prime Services group by creating stored procedures.
• Creating reports for Funded Assets, ReHypo, and Secured Funding balance using SSRS 2008.
• Designing packages for the business date data loads from across the globe using SSIS 2008.
• Writing VB Script code for managing different business dates in different countries.
• Writing logic to decide the most profitable funds across the multiple regions like Americas, Europe, APAC etc
• Creating yearly reports so that the switched account performance can be compared.
• Conversion of SSRS reports from 2005 to 2008.
• Using timely subscriptions for the report delivery to the business.
• Resolving the tickets assigned to MIX support team.
• Creating tables, views, stored procedures and indexes using T-SQL.
• Designing reports to export the data to various data sources like Excel, XML, Acrobat PDF and CSV formats.
• Creating database triggers to maintain the business rules.

Environment: SQL Server 2005/2008, MS SQL Server Reporting Services 2008/2005 SSRS, Microsoft Business Intelligent Studio, MS SQL Query Analyzer, SQL Profiler, Rapid SQL.

Confidential

SQL Server Reporting Analyst/BI, SQL Developer

Responsibilities:

• Writing PL/SQL packages/Procedures for the new business logic.
• Designing SSIS packages for the data extraction and modification for customer service portal data sent from multiple meeting locations across USA.
• Creating sub reports and linked reports for the business.
• Designing YTD matrix reports for the business using SSRS 2008.
• Enhancing existing reports look and feel using the latest version of SSRS.
• Modifying packages to take care of the new membership rules.
• Writing custom VB script to provide the values for the parameters of daily/weekly reports.
• Using SQL server 2005 as well as Oracle 10G as backend for SSRS reports
• Using timely subscriptions for the report delivery to the business.
• Resolving the tickets assigned to engineering services group through service now.
• Checking the reports and database scripts to IBM Rational Synergy version control tool .
• Writing scripts to create tables, views, stored procedures, indexes etc.
• Designing reports to export the data to various data sources like Excel, XML, Acrobat PDF and CSV formats.
• Writing math functions in VB Script for calculating Gym Commissions and Sales Consultant Commissions.

Environment: SQL Server 2005/2008, MS SQL Server Reporting Services 2008/2005 SSRS, Oracle 8i/10G,Microsoft Business Intelligent Studio, MS EXCEL 2003, MS Access 2003, MS SQL Query Analyzer, C, ASP.NET, SQL Profiler, Windows 2003 Server, Share Point Portal Server, Visual Source Safe and Visual Studio.Net 2005, XML, VB Script.

Confidential

SQL Server BI Analyst

Responsibilities:

• Designing and coding multiple reconciliations like Arctic/CS, RAM Notional, Genesis Notional Etc
• Designing reports using SQL Server Reporting Services 2008 for keeping track of recon stats like recon run times, schedules and run times etc
• Designing SSIS packages for the data extraction and transformation while looking up the data with golden source.
• Writing stored procedures for multiple business requirements across credit risk/market risk sources.
• Designing ETL process to load the data from golden sources using packages designed in SQL server Integration Services 2008.
• Developing distinct business logic for MTMs and Notional across various sources.
• Query tuning for the better performance of the reconciliations.
• Monitoring recon runs and debugging failures if there are any.
• Automation of report generation using data driven as well as regular subscriptions.
• Designing multiple filter and categories to place the breaks/matches in correct buckets
• Resolving the bugs assigned in Jira tool.
• Checking the Table scripts, procedures, views, reports and database scripts to Microsoft TFS Team Foundation Server, version control tool.
• Designing reports to export the data to various data sources like Excel, XML, Acrobat PDF and CSV formats.

Environment: SQL Server 2008/2005, MS SSRS 2005, Microsoft Business Intelligent Studio, MS SQL Query Analyzer, C, ASP.NET, SQL Profiler, Windows 2003 Server, Share Point Portal Server, Microsoft TFS, Jira.

Confidential

SQL Server 2008/2005 SSRS, SSIS, Oracle 10G Developer

Responsibilities:

• Designed more than 300 reports for different divisions of Weight Watchers like BOSS, Call Center, Community, Corporate Solutions Portal, Marketing, National Accounts, Quality Center and Store.
• Designing reports using SQL Server Reporting Services 2008/2005 for different operating countries of weight watchers like USA, Canada, France, UK, Australia, China Etc.
• Creating SSIS packages for meeting data extraction and loading to data ware house.
• Writing queries for the SSRS reports based on the business requirements.
• Using SQL server 2005 as well as Oracle 10G as backend for SSRS reports
• Query tuning for the better performance for the reports.
• Using external tables as the source for Oracle tables and then writing the reports on top of those tables.
• Automation of report generation using data driven as well as regular subscriptions.
• Writing custom VB Script for the reports for date range requirements like last Sunday to Saturday, last week, last month, fiscal month, fiscal quarter Etc.
• Resolving the tickets assigned to engineering services group through Quality Center.
• Checking the reports and database scripts to IBM Rational Synergy version control tool .
• Writing scripts to create tables, views, stored procedures, indexes etc.
• Designing reports to export the data to various data sources like Excel, XML, Acrobat PDF and CSV formats.
• Writing math functions in VB Script for calculating Gym Commissions and Sales Consultant Commissions.

Environment: SQL Server 2005, MS SQL Server Reporting Services 2005 SSRS, Microsoft Business Intelligent Studio, MS EXCEL 2003, MS Access 2003, MS SQL Query Analyzer, C, ASP.NET, SQL Profiler, Windows 2003 Server, Oracle 11g, Share Point Portal Server, Visual Source Safe and Visual Studio.Net 2005, XML, VB Script.

Confidential

SQL Server 2008/2005 SSRS, SSIS, SSAS Developer

Responsibilities:

• Writing SQL scripts for adding new cities and new routes for JetBlue. Blue Cities added by me are the following: Puntacana PUJ, Hartford BDL and Washington Reagan DCA .
• Developing AQP Advanced Qualification Programming reports for pilot training activities using SQL Server Reporting Services 2008 for FAA analysis.
• Designing packages using SSIS 2008 for importing in flight entertainment data from LIVE TV Division of JetBlue based in Melbourne, FL and writing reports on the same data for revenue analysis.
• Involved in 2005-2008 migration for CSS cutover when Sabre took over Navitire for passenger data.
• Importing Cashless Cabin data using SSIS 2008 package for analyzing in flight sales data.
• Writing packages to import pilot laptop data for OPS Data drain application using SSIS 2005.
• Importing the website statistics data from Omniture A Division of Adobe using SQL Server Integration Services 2005.
• Resolving the tickets assigned to IT Data Services Group.
• Writing scripts to created tables, views, stored procedures, indexes etc.
• Designed SSIS packages to export and import data from various data sources like OLEDB SQL, Access, Flat files Comma and Pipe Delimited and EXCEL files.
• Involved in performance tuning for the report queries.
• Handling periodic Data Migration using various scheduled jobs.
• Used Report Manager to schedule and manage the subscription of reports to various users.

Environment: SQL Server 2005, SQL Server 2000, MS SQL Server Reporting Services 2008, 2005 SSRS, Microsoft Business Intelligent Studio, Business Objects Crystal Reports XI, MS EXCEL 2003, MS Access 2003, SQL Server Integration Services SSIS, SQL Server 2000 DTS, MS SQL Query Analyzer, UNIX, C, ASP.NET, SQL Profiler, Windows 2003 Server, Oracle 11g, Share Point Portal Server, Visual Source Safe and Visual Studio.Net 2005, XML, MS Office 2007, VB Script.

Confidential

SQL Server 2005 SSIS, SSRS, SSAS Developer

Responsibilities:

• Created DB objects like tables, views, stored procedures, indexes etc.
• Gathered requirements from the users to build transactional Data warehouse Database.
• Involved in logical and physical data model design using Erwin.
• Designed and developed ETL specifications and code to design data warehouse for source systems.
• Creating OLAP cubes for sales data under management using analysis services SSAS 2005.
• Writing Multi Dimensional Expression MDX queries on cubes.
• Executed Business Intelligence solutions including ETL SSIS, OLAP and Reporting SSRS requirements.
• Efficiently used SSIS to build Data warehouse and also load data files.
• Designing SSIS packages to export and import data from various data sources like Access, text and EXCEL files.
• Modifying data types during data loads using SSIS.
• Migrated SQL server 2000 DTS Packages to SQL 2005 SSIS packages.
• Providing support to web application features built in ASP.NET, ADO.NET and Cascading Style sheets CSS .
• Assisted Web team in developing the Custom Parameter tool in .Net for providing the predefined set of parameters to the Business Objects scheduled on Business.
• Fixing crystal report issues and implementing the same changes in reports designed in SSRS.
• Involved in Query tuning, procedure response time optimization using SQL profiler.
• Handling periodic Data Migration using various scheduled jobs.
• Providing access to multiple database servers.
• Used Report Manager to schedule and manage the subscription of reports to various users.

Environment: SQL Server 2005, SQL Server 2000, MS SQL Server Reporting Services 2008, 2005 SSRS, Microsoft Business Intelligent Studio, Business Objects Crystal Reports XI, MS EXCEL 2003, MS Access 2003, SQL Server Integration Services SSIS, SQL Server 2000 DTS, MS SQL Query Analyzer, UNIX, C, ASP.NET, SQL Profiler, Windows 2003 Server, Oracle 11g, Share Point Portal Server, Visual Source Safe and Visual Studio.Net 2005, XML, MS Office 2007, VB Script.

Confidential

SQL Server 2005 SSIS, SSRS, SSAS Developer

Responsibilities:

• Created database objects tables, views, stored procedures, indexes etc.
• Extensively Involved in Designing Logical and Physical of Customer Database.
• Wrote T-SQL for the retrieval of the data.
• Creating user defined functions and stored procedures for business logic and front-end support.
• Writing code to design data warehouse for source systems using ETL specifications.
• Designed various reports using Microsoft SQL reporting services SSRS .
• Designing OLAP cubes on sales, marketing data using SSAS.
• Writing MDX queries for querying OLAP cubes.
• Working with the web team to gather requirements and providing database code to support business applications written in ASP.net, C .
• Experience in using Toad to access SQL server databases.
• Converted multiple DTS packages to SSIS packages.
• Extensively used excel files to store ad-hoc reports with formulas.
• Wrote functions in VB.net to handle complex formulas and calculations used in the reports.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Created SSIS and DTS packages for data migration, conversion and transformation from production database to the development, staging QA and UAT reporting servers.
• Created various scheduled jobs to handle the data migration periodically.
• Experience in relational data modeling tools like Erwin.
• Extensively used Visual Source Safe VSS to handle version control of reports and SQL codes.
• Granted and managed the login and security issues on various servers.
• Used Report Manager to schedule and manage the subscription of reports to various users.

Environment: SQL Server 2005, SQL Server 2000, MS SQL Server Reporting Services 2005 SSRS, Microsoft Business Intelligent Studio, Business Objects Crystal Reports XI, MS EXCEL 2003, MS Access 2003, SQL Server Integration Services SSIS, SQL Server 2000 DTS, MS SQL Query Analyzer, SQL Profiler, C, ASP.NET, Oracle 8.0, Share Point Portal Server, UNIX, MS Office 2007, Visual Source Safe and Visual Studio.Net 2005, XML, VB Script.

Confidential

SQL Server 2005 SSIS, SSRS SSAS Developer

Responsibilities:

• Created database objects tables, views, stored procedures, indexes etc.
• Created and modified stored-procedures, triggers, views.
• Wrote T-SQL for the retrieval of the data.
• Created SSIS packages to export and import data from SQL Server to Access, text and EXCEL files.
• Converted DTS Packages to SSIS packages and also created new packages for data loading, conversion, transformation and to eliminate manual data loading.
• Created reports using MS Reporting services. Created jump reports and drill down lists.
• Extensive knowledge in creating reports using multiple datasets.
• Checked Performance and Tuning, Indexing, Query Optimization and Query execution plans.
• Used database consistency checks using DBCC Utilities.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Wrote distributed queries for Linked Servers.
• Good exposure in running jobs in Enterprise Manager using job-scheduling tool.
• Experienced with Query Analyzer.

Environment: SQL Server 2005, SQL Server 2000, MS SQL Server Reporting Services 2005 SSRS, Microsoft Business Intelligent Studio, MS EXCEL 2003, MS Access 2003, SQL Server Integration Services SSIS, SQL Server 2000 DTS, MS SQL Query Analyzer, SQL Profiler, Windows 2003 Server, Oracle 8.0,Share Point Portal Server, Visual Source Safe and Visual Studio.Net 2005, XML, VB Script, Crystal Reports XI.

Confidential

SQL Server Developer

Responsibilities:

• Programming database objects like stored procedures, triggers, indexes etc.
• Wrote T-SQL for the retrieval of the data.
• Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
• Worked on SQL server enterprise manager.
• Assisted in taking the backups of databases.

Environment: Windows 2000, MS SQL Server 2000, MS Reporting Services, SQL Server 2000 Analysis Services, C, VB.NET, VB Script, XML, VisualStudio.NET, Visio Enterprise

Confidential

SQL Server Developer

Responsibilities:

• Assisted in designing the Database.
• Involved in creation of database objects like tables, views, stored procedures, indexes etc.
• Created and modified stored-procedures, triggers, views
• Wrote T-SQL for the retrieval of the data.
• Assisted in administrative tasks for performing daily Backups and Recovery procedures.
• Hands on working with Enterprise Manager.

Environment: Windows 2000, MS SQL Server 2000, VisualStudio.NET, Visio

Confidential

SQL Server Developer

Responsibilities:

• Involved in modifying the existing DTS packages
• Involved in creating new DTS packages as per business requirements.
• Scheduling the DTS packages using jobs
• Wrote T-SQL for the retrieval of the data.
• Created Stored Procedures, Views and Functions.
• Worked extensively in Enterprise Manager for DTS package creation and modification.
• Using job-scheduling tool for DTS packages.

Environment: Windows 2000, MS SQL Server 2000, MS Reporting Services, SQL Server 2000 Analysis Services, C, VB.NET, VB Script, XML, VisualStudio.NET, Visio Enterprise.

Confidential

Responsibilities:

• Involved in designing windows based applications using VB 6.0.
• Designing HTML pages for the in-house websites.
• Involved in writing medium and complex SQL queries.
• Created Stored Procedures, Views and Functions.

Environment: Windows 2000, MS SQL Server 2000.