SUMMARY:

• Excellent 6+ years of experience as aMicrosoft SQL Server Developer/DBA.
• Extensive working experience inInstalling, Configuring, Managing, monitoring and troubleshootingSQL server 2000/2005/2008 and SQL Server 2005 suite of products like SSIS,SSRS and SSAS.
• Expert experience inMigratingSQL Server 2000 and existing applications to SQL Server 2005.
• Expert experience in ETL processes transferring/rewritingDTS packages to SQL Server IntegrationService(SSIS) programs.Proficient in SSIS project design,implementation and troubleshooting.
• Usedmultiple transformations and integrationsin SSIS to meet the business requirments by collecting data from heterogeneous sources like Excel, CSV, Oracle,flat file,Text Format Data to SQL Server databases using SSIS.
• Highly proficient in generating/using/deploying Visual Studio 2005 Business Intelligence Reports,SQL Server 2005 Reporting Services (SSRS),ad - hoc reports,Crystal Reportsand also some 3rd party tools likeDundas Charts and Dundas Maps.
• Experts in designing and handlingSQL Reports,Sub Reports and Drill Down Reports.Proficient in designing report layout,sorting the data, defining subtotals for the reports using SSRS 2005/2008.
• Expert in the using/creating T-SQL for developing complexStored Procedures, Triggersand user defined Functions.
• Expereinced tomigrate Windows Server 2000 to Windows Server 2003
• Hands-on working experience inSQL database architecture, data modeling, logical and physical database design utilizingErwin Data Modeler.
• Experienced in creatingTables,Views,Indexes and other SQL joins,complex query writing withPerformance TuningandQuery Optimization.
• Working experience inbackup and recoveryusing BCP,litespeed, Red Gate.
• Experience in industry standard systems analysis techniques including data modeling,process modeling,data flow diagramming, unified Modeling Language(UML), E-R Modeling and Design Patterns.
• Expertise indeveloping desktop applicationsusingC#,VB.NET, VB6, Win32, VBScript and other MS technologies.
• Experience in developing desktop applications usingHTML,Java Script, XML, CSSfor client side development and ASP,ASP.NETfor server side development.
• Experience with software development life cycle(SDLC) and project methodologies.
• Capable of forming and maintain positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS:

Databases/Data Access: SQL Server 2000/2005/2008 \ SQL Server Reporting Services\ SQL Server Integration Services\ SQL Server Analysis Services\ MS Access, ODBC, OLE DB

Operating Systems: Windows 2000/XP/Server 2003\

Languages: C,C#.Net, VB .Net,VB Script,\ T - SQL, PL/SQL

Tools: and Utilities: MS Visual Studio 2005, MS Visio 2003\FrontPage, ERWIN 4.0\LiteSpeed\Red-Gate\ Crystal Reports 9/10

Web Technologies: ADO.NET,ASP.NET, HTML, XML, Web Services, Java Script\

PROFESSIONAL EXPERIENCE:

Confidential, Brooklyn, NY

SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Extracted from various sources of different departments in HRA like ORACLE, Informix Database,transformation and loadinginto thetarget SQL Serverdatabases using ETL tools, SSIS 2005.
• Created SSIS packageswith which data resources such as Excel and XML were loaded daily in order to create and maintain a centralizeddata warehouse.
• Redesigned/MigratedDTS packages to SSIS programs. Hands on working experience with configuring every aspects of SSIS 2005.
• Migrated the database from SQL server 2000 to SQL server 2005
• Createdalerts, notifications, and emailsfor scheduled SSIS packages execution.
• Troubleshootand fixed issues in existing cubes in SSAS.
• Proficient inData warehousing and SSASskills:MDDB/MDX,OLTP, OLAP(MOLAP, HOLAP, and ROLAP), Relational and dimensional modeling skills (star schemaandsnowflake schema).Strong experience in design and construction of data marts anddata warehouse
• Coordinated other Reporting Analysts in analyzing data and creating management reports.
• Utilized strong knowledge of relational database modelingprinciples, techniques and dimensionalmodeling togenerate SQL/Crystal reportsusing OLTP data source or SSAS cubes.
• Assessed internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS) orCrystal Reporting Service. Broadcasting of Reports.
• Developed reports without formal specifications often.
• Created and developed thestored procedures, triggers, views, and user-defined functionsto support application development.
• Monitoringthe daily as well as periodic data loads/jobs
• Communicating with the team lead about the robustness of the chains and the system in general.
• Worked closely with IT project managers, programmers, and testers.
• Making sure of the background jobs and processes.
• Participated in the development ofWeb Application. UsedC#for web programming. Solid knowledge and experiences with .NET programming.

Environment: SQL Server 2000 Enterprise, SQL Server 2005/2008Enterprise, Windows Enterprise Server 2003, MS XP Professional,IIS 6.0/7.0,MS SQL Server Integration Service 2005,Visual Studio .NET 2005/2003, Microsoft Analysis Service, MS SQL Server Reporting Services 2005, MS SQL Server Analysis Services 2005, Crystal Report 10

Confidential, New Jersey

SQL Server BI Developer

Responsibilities:

• Performance tuning, and optimization of procedures and queries.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Used Microsoft Reporting Services (SSRS) for efficient report creation.
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Daily Monitoring of Process workflows
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Used Agile Methodology to efficiently plan the life cycle & Development of the data.
• Experience on performance point server and created management reports.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2005 in Test environment with latest service packs and migrated few databases.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Involved in migration from SQL Server 2000 to SQL Server 2005 as well as migration of Windows server 2000 to Windows server 2003.
• Maintenance of documentation of the daily loads, process chain status, etc.
• Developed database monitoring and tuning strategies.
• Taking care of Daily / Weekly / Monthly Sales Flash and other Flashes as per client requirements.
• Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000 and 2003 servers in very large environments.

Environment: Microsoft Windows 2003 Advanced Server, Microsoft SQL Server 2000 Enterprise Edition, Microsoft Visual Basic 6.0, SQL LiteSpeed, OLAP, Hardware: Compaq Proliant 8500 Server.

Confidential, Hicksville, NY

Sr. SQL Server Developer / SQL Server DBA

Responsibilities:

• Designed SSIS packageto load customer information from flat files.
• ConvertedOLTP databases to OLAP databaseused in SSAS
• Designed SSAS cubes to meet business requirements such as trackingloan repayment, analyze customer’s creditand allow users to perform fast queries.
• Generate reports according to customer’s requirement usingSSAS cubesas data source.
• UsedSQL Profilerfortroubleshooting, monitoring, optimizing SQL Serverand T-SQL statement from developers and testers.
• Involved inmigration of SQL server 2000 to SQL server 2005using Windows server 2003
• Createdalerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Created, managed, anddelivered interactive web-based reportsusing SSRS to support daily operations and drive decisions.
• Created complex StoredProcedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code toimplement business rules.
• Designed and implementeddata access stored procedures and triggers for automating tasks.
• Designed index, optimized queries by using execution plan forperformance tuningof the database.

Environment: SQL Server 2005, Windows Enterprise Server 2003, IIS 6.0, MSMQ,C#, .NET, RationalRose Enterprise, Erwin 4.1

Confidential

Sr. SQL Server DBA

Responsibilities:

• Createdlogical and physical database design, data structures, and implemented large databases using Erwin
• Generated databaseSQL scripts and deployed databasesincluding installation and configuration
• UpdateSQL Server 2000 to SQL Server 2005 and migrated data to SQL Server 2005.
• Automated and enhanceddaily administrative tasksincluding space management, object alteration, database backup and recovery.
• Created anddevelopedthe stored procedures, triggers to handle complex business rules,history data and audit analysis
• Developed and createddata dictionary, tables, views, indexes, and functionsadvanced queries for databases by usingQuery AnalyzerandSQL Server Enterprise Manager
• Generated test data and tested database to meet the functionalities deliverables in the projectdocumentation and specifications
• Scheduled and monitoredall maintenance activities of SQL Server 2005 including database consistency check, and index defragment
• Monitored database status includingCPU, memory, I/O, space, and dead lockusing SQL Server Utilities
• Created the lookup tables andgenerated the lookup datato meet the specification
• Generated databaseSQL scripts and deployed databasesincluding installation and configuration
• Set up SQL Server 2005Failover Clustering
• Plannedand co-coordinated databasesecurity measures
• Communicated regularly with internal technical staff to ensurethe database integrity and security
• Created and updated databasedocument
• Supported development effort by providingT-SQL statement tuning and optimize data loading processes
• Maintainedday to dayoperating proceduresfor SQL Server databases
• Provided back-end support forfunctional testing and performance testing
• Developed DTS packages to migratedatafrom multiple sources
• Scheduled and monitored allmaintenance activitiesof SQL Server 2000 including database consistency check, and index defragment

Environment: Windows Enterprise Server 2003/2000, SQL Server 2000 Enterprise, SQL Server 2005 Enterprise, Windows XP Professional,IIS 6.0

Confidential

SQL Server DBA/Developer

Responsibilities:

• Designeddynamic DTS Packagesfor Landing-Pad to transfer data between servers, load data into database, and archived data file from different DBMS.
• Automated andscheduled SFTPto transfer data from other systems.
• Created and developed thestored procedures, triggers to handle complex business rules, history data and audit analysis
• Generatedtest data and tested database to meet the functionalitiesdeliverables in the project documentation and specifications
• Scheduled and monitoredall maintenance activities of SQL Server 2000including database consistency check, and index defragmentation.
• Migrated databases from UAT to Pilotand then Production environment.
• Maintainedcluster serversto providehigh availability.
• Set updatabase backup and recoverystrategies.
• Worked with development teams in thedesign of physical databasesand in modification
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Provided technical support to internal developers and external clients

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server 2003, IIS 6.0, Microsoft Visio 2003, SFTP

Confidential

SQL Developer/ Administrator

Responsibilities:

• Involved in requirementgathering, analysis, design, development, change management, deployment and user
• Involved inER diagrams and mapping the datainto database objects
• InstalledandConfigured SQL Server 2000successfully
• Designof thedatabaseand thetables
• Build table relationships and wrotestored procedureto clean the existing data
• Coordinated with the front-end developer to put in thebusiness rules. Wrote procedure to check some of the rules at the backend at the time of entering data
• DevelopedSQL scripts to Insert/Update and Delete data in MSSQLdatabase tables
• Evaluated databaseperformance and performed maintenance dutiessuch as tuning, backup, restoration and disaster recovery
• Developed the project using iterative approach
• Managed database changes based on feedback

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, VBS, Crystal Reports, ERWIN, MS Office & Windows 2K platform