SUMMARY:

• 8+ 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, Lombard, IL

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, Jersey City, NJ

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.
• 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, Madison Ave, NY

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.
• 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, Forest Hills, NY

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.
• 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, Nutley, NJ

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, Macon, GA

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, Schaumburg, IL

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.