PROFESSIONAL SUMMARY:

• Over 7 years of extensive experience in database design, development and administration wif MS SQL Server versions 2008/2005/2000/7.0 using SSIS, SSAS, SSRS in Finance, Banking, Retail and Healthcare industries.
• Conversant wif all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS) of MS SQL server 2005/2008.
• Experienced in Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MS SQL Server Enterprise manager.
• Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Marts and OLAP technologies.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP wif the help of SSIS.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) wif MS SQL Server 2000/2005/2008.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2005/2008.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Extensively worked wif third party tools like SQL LiteSpeed, Spotlight, SQL Watch, Red-Gate, Erwin, Toad, and DBArtesian.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Technologies: MS SQL Server 2008/2005/2000/7.0, MS SQL Server 2005/2008 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS),, Business Intelligence Development Studio (BIDS), BCP, SQL Profiler, Enterprise manager, Management studio, Microsoft Access 2000, ERWIN 4.0/4.1/4.2/7.2, Microsoft Visio 10.0/11.0, T-SQL, ASP.NET, C#, VB.Net, HTML, XML, XSL, Oracle 9i/10g, Crystal Reports 8.5/9/10/11, Visual source safe 2005, MS office 2003/2007, Windows 2000/2003 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE

Confidential, NY

MS SQL SERVER DEVELOPER/ SSRS/SSIS/SSAS DEVELOPER

Responsibilities:

• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created Subscription of Reports in different formats like pdf, excel etc to be executed automatically on daily, weekly or monthly basis using MOSS (Microsoft Office SharePoint Server) tool.
• Created reports from complex SQL queries and MDX queries.
• Created and implemented the staging database prior to the final data warehouse.
• Involved in Migration of different DTS packages to SSIS packages.
• Created and scheduled SSIS packages to load the data form OLTP source system to data staging environment and then to data warehouse environment.
• Designed the SSIS Package for the Scheduling the task for the different operations like extracting the data, to perform appropriate transformation and Loading purposes.
• Involved in the performance tuning for the OLAP Cube.
• Involved in the SSAS partitions and calculation of queries wif MDX, developing reports using MDX and T-SQL.
• Worked wif SharePoint Server 2007 while deploying SSRS reports.
• Used Team foundation server (TFS) as a source control.
• Used Performance Point Server 2007
• Responsible for maintaining UAT (User Acceptance Testing) and Production environment.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, SQL Server Analysis Services 2005, Windows XP, VB.NET, Excel, Acrobat Reader, Microsoft Office SharePoint Server, Team Foundation Server.

Confidential, NY

SQL Server Developer/ BI Developer

Responsibilities:

• Involved in reviewing the Investments application and interacting wif business users to understand the user requirements.
• Reviewed old table structures and used Erwin to design new tables which adhered to the new database design standards.
• Created and maintained database mapping document which mapped the old tables to the new ones.
• Developed stored procedures, user-defined functions, triggers, indexes and views.
• Involved in query optimization for faster processing of queries.
• Created allocation and other reports using SQL Server Reporting Services (SSRS).
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Loaded flat files into SQL Server tables and vice versa using SSIS.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Created XML configuration files (.dtsconfig files) to dynamically alter package properties.
• Developed error handling routines for packages using both script task as well as in the error handling tab.
• Developed Unit Test Plans for SSIS packages.
• Responsible for allocating responsibilities and coordinating ETL efforts among team members to ensure best practices are used.
• Involved in regular code inspections to ensure business and system requirements are met.
• Scheduled package execution using SQL Server Management Studio to execute packages on a daily/weekly basis.
• Documented ETL processes and prepared project status report updates/audit reports/ list of issue items dat need to be reviewed.
• Involved in project scope, schedule planning and project impact assessments.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008, MS SQL Server Analysis Services 2005/2008, T-SQL, MS SQL Server Integration Services 2005/2008, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, ASP.Net, C#.

Confidential, NEW YORK, NY

SQL SERVER DEVELOPER / SSRS/SSIS

Responsibilities:

• Actively involved in gathering, understanding and validating the project specifications.
• Developed various reports like Tabular reports, drill down reports, maps and charts.
• Building parameterized reports and returning subsets of the data wif query parameters, mapping report parameters to query parameters.
• Generate New Reports using Stored Procedure and Functions.
• Created SSIS packages dat would transfer data among servers and perform other data transformations. Scheduled the same SSIS packages by creating the corresponding job tasks.
• Developed, monitored, deployed and scheduled SSIS packages for execution.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) (BI Microsoft Visual Studio 2005) environment.
• Built synchronous and Asynchronous scripting component for different modes of output.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Run the various Optimization technique to optimize the performance of queries by avoiding unnecessary use of The UNION, <> into statements & by using the TOP operator to limit the Select Statement in certain Queries .
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2005, MS SQL Server Reporting services 2005, MS SQL Server Integration Services 2005, OLTP

Confidential, KY

Sr. SQL Server Developer/SSIS/SSAS/SSRS Consultant

Responsibilities:

• Attend meeting wif business to understand their business needs.
• Cross group collaborative work wif other groups to make code modification required for smooth running of interacting subsystems.
• Fully utilized SDLC processes including requirements gathering, design, development, implementation, quality assurance and maintenance.
• Connected various applications to the database.
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Expert in Performance tuning and optimization of SQL queries using SQL profiler and query analyzer.
• Created T- SQL queries for data retrieval. Monitored performance and optimized SQL queries for maximum efficiency.
• Troubleshooting performance issues wif Fragmentation using Profiler, System Monitor and DMV’s.
• Used @@ERROR, @@ROWCOUNT and TRY CATCH for exception handling.
• Experience in migration of Data from Excel, Flat file, MS Access to MS SQL Server by using DTS and SSIS packages.
• Expert in FTP task, ETL script task, look up transformations and data flow tasks to load staging databases.
• Extensively used SSIS 2005 for migrating data from DTS packages to SSIS packages.
• Played active part in the development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Experience in creating multiple (SSRS) reports in Drill mode using tables, financial tables, crosses tabs and charts.
• Designed and developed report layouts including report parameters, Created parameterized, drill down and aggregation reports using SSRS 2005 for business partners.
• Developed custom ad-hoc reports, Parameterized reports and Linked Reports by using SQL Server Reporting Services (SSRS).
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Proven ability in generating Drill down and Drill through reports wif Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
• Created MDX queries to retrieve data from the cubes and also to display SSRS report.
• Perform and troubleshoot various data loads.
• Developed Web Forms using ASP.NET under Microsoft Visual Studio.net environment.
• Implemented Snapshot and Transactional Replication models and Validation of Replicated data.
• Streamlined and optimized cubes using MDX to introduce custom calculations and dimensions attributes.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Connectivity and Database Consistency Checks using DBCC Utilities.
• Performed daily tasks including backup and restore by using SQL Server 2005/2008 tools.

Environment: SQL Server 2005/2008, SSIS, SSRS, T-SQL, Visual studio 2005, Windows XP/NT/2000/2003, MS Office 2003/2007, MS Visio.

Confidential, Connecticut

MS SQL Server Developer

Responsibilities:

• Carried out a developer’s role on MS SQL Server 2000, MS Access databases (using DTS, T-SQL, Scripts,
• Stored procedures and views).
• Logical and physical database development (using Erwin, normalization, dimension modeling and Enterprise manager).
• Looked at the reports and fixed bugs in stored procedures, tables and ETL process.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS.
• Created and automated regular jobs such as daily/weekly report generations.
• Managed and monitored system utilization.
• Developed complex T-SQL code for the application.
• Designed and implemented the stored procedures and triggers for automating tasks.

Hardware/Software: MS SQL Server 2000, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.

Confidential, St. Louis, MO

SQL Server Developer

Responsibilities:

• Involved in logical and physical database design using Erwin 3.5.2 and MS Visio 2003
• Maintaining the database consistency wif DBCC at regular intervals
• Designed and implemented comprehensive Backup plan and disaster recovery strategies to ensure high availability of data.
• Responsible fordatabase backups, database replication, encryption and database security
• Maintaining high security to patient records by creating and managing new security accounts and restricting user activity on it.
• Involved in trouble shooting and tuning of databases for its performance and concurrency using Database Tuning Advisor.
• Export/ Import data from other data sources like flat files using Import/Export of Data Transformation Services (DTS)
• Analyzing performance elated queries and tune the same using SQL Query Analyzer to optimize application and system performance.
• Wrote Stored Procedures / Transact-SQL scripts, Altered/Re-indexed tables as per the business need.
• Involved in creating database objects like Tables, Views, Triggers, User Defined Functions and User Defined Data types by coordinating wif the development team
• Assisted the development team in writing complex SQL scripts and SQL Joins
• Responsible for monitoring and making recommendations forperformance improvementin hosted databases.
• Involved in indexcreation, index removal, index modification, file group modifications,andadding scheduled jobstore-indexandupdate statisticsin databases.
• Assisted in handling escalating billing issues and propagating bug fixes in production environment.

Software Environment: SQL Server 2000/7.0, Enterprise Manager, Windows Server 2003, SQL Profiler, DTS, T-SQL, BCP, MS Excel