SUMMARY

• 7+ years of experience in IT, as MS SQL Server 2008/2005/2000/7.0 Database Developer in Windows environment in financial, insurance and retail companies.
• Expertise in writing T - SQL Queries using Joins, Sub queries and Cursors in SQL Server 2008/2005/2000/7.0
• Proficient in creating Indexes, Views, Complex Stored Procedures, appropriate functions, and Performance tuning.
• Extensive experience wif Database Modeling, logical and physical database design using Erwin and MS Visio
• Strong experience in SQL Server 2005/2008 wif Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Experienced in design and development of reports using SQL Server
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Expertise in generating reports using Performance Point Server, Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Expert in creating dashboards/scorecards using ProClarity, SSRS etc
• Designed DTS/SSIS Packages to extract, load data into database, archive data file from different legacy systems using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy teh data, Scheduled teh jobs to do these tasks periodically
• Expert in extracting and transforming data using DTS Import Export Data, DTS Packages, Bulk Insert and BCP.
• Experienced wif designing Dimensional Model for Data Warehouse, SSAS cubes, Fact and Dimension Tables, Data Mining and deploying and processing SSAS Objects
• Sound knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements.
• Experience in developing MDX queries and OLAP cubes using SSAS (SQL Server Analytical Services)
• Knowledgeable in planning and implementing SQL Server Security and Database Permissions.
• Experience in version control tools such as Microsoft Visual Source Safe, Team foundation server etc.;
• Hands on experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008.
• A well-organized, goal-oriented, highly motivated effective team member wif excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Operating Systems: Windows 3.x/9x/ME/NT/2000/XP/2003

Database: SQL Server 2008/2005/2000/7.0 /6, MS Access

ETL Tools: DTS (Data transformation services),SQL Server Integration Services(SSIS), SQL Server Analysis Services, OLAP cubes

Database /Utility Tools: SQL Profiler, SQL Query Analyzer, Management studio, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe 2005.

Languages: ASP .Net 2.0, Java,C ++, C#

Reporting Tools: SQL Server Reporting Services (SSRS), ProClarity 6, Crystal reports 8.0/9.0/10.0 , MS Excel, Performance Point Server.

Others: SharePoint Server 2007, Windows SharePoint Server(WSS) 2003

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr.SQL (SSIS) Developer

Responsibilities:

• Created and customized SSIS packages and used SSIS to load data from difference sources.
• Deployed teh SSIS Packages from development server to production server.
• Implemented teh Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Configured SQL Mail agent for sending Automatic emails when a SSIS Process is Failed or Success
• Involved in SSIS Performance Tuning Using Counters, Error handling, Event handling,
• Involved re-running of SSIS Package using Checking Points and Scripting wif VB.NET in SSIS.
• Designed best practices document for migration from DTS to SSIS, running and Scheduling SSIS Packages, and Fuzzy Look-up for cleansing bad data, validating data using SSIS.
• Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Involved in Clustering, Replication, Data Modeling (Physical and Logical) Using ERWIN
• Created package to transfer data between OLTP and OLAP databases.
• Active part in building Star schema and Snow flake schema based on teh business requirements
• Configured and managed data sources, data source views, cubes, dimensions, roles and hierarchies.
• Optimized queries using SQL Profiler and Database engine tuning advisor.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers.
• Optimized teh performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Create joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Creating Triggers, Stored procedures, Tables and queries. Import and export of SQL objects from and to various sources.

Confidential, Milwaukee, WI

Sr. SQL (SSIS/SSRS) Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers
• Wrote efficient stored procedures for teh optimal performance of teh system
• Monitored performance and optimized SQL queries for maximum efficiency
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating teh integrity of teh data
• Involved in user requirement gathering to find teh exact specifications for teh SQL reports.
• Generated custom and parameterized reports using SSRS
• Configuration and Deployment of all teh Reports(RDL,RDS) across various SDLC environments
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Used Report Builder for Ad-hoc reporting.
• Reviewed and fine tuned database objects and queries before production migration to ensure efficient data retrieval.

Environment: SQL Server 2008/2005 Enterprise Edition, SSIS, SSRS, .NET Framework, C#, ASP.NET, ADO.NET, Erwin, T-SQL,NET IDE, Windows 2000/2003 Server,, MS Excel, MS Access, Visual Studio 2005

Confidential, Jacksonville, FL

Sr. SQL (SSRS) Developer

Responsibilities:

• Involved in user requirement gathering to find teh exact specifications for teh SQL reports.
• Interacted wif teh DBA's and project manager to get teh various sources of data.
• Extracted data from teh existing micro strategy reports and stored in a data mart for teh reporting purposes.
• Involved in writing complex stored procedures to extract teh data from teh data mart we created for teh reporting in SQL.
• Developed reports using SQL Server 2008 and added key performance indicators using SQL Server 2008 R2.
• Involved in teh back up of teh database assisting teh DBA.
• Provide support for any issues in teh reports developed in SQL Server.
• Responsible for rebuilding teh indexes and tables as part of performance tuning
• Used SQL Server Agent for scheduling jobs and alerts
• Performed Query optimization & Performance Tuning
• Optimized queries using SQL Profiler and Database engine tuning advisor

Environment: SQL Server 2005/2000, MS Access 2000, SSAS, SSIS, SSRS, MS Excel, Visual Studio 2005, Windows Server 2003.

Confidential, Detroit, MI

SQL (SSIS/SSRS) Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers
• Wrote efficient stored procedures for teh optimal performance of teh system
• Monitored performance and optimized SQL queries for maximum efficiency
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating teh integrity of teh data
• Created indexed views, and appropriate indexes to reduce teh running time for complex queries
• Used VB to create XML web services dat interface wif SQL server
• To keep track of data manipulations using Audit functionalities
• Generated custom and parameterized reports using SSRS
• Created reports dat call sub reports in SSRS
• Configuration and Deployment of all teh Reports(RDL,RDS) across various SDLC environments
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Responsible for creating datasets using T-SQL and stored procedures
• Created several packages in SSIS
• Scheduled teh packages to keep extracting teh data from OLTP at specific time intervals
• Used various transformation tasks to create ETL packages for data conversion
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Assisted in teh design of star schema and snow flake schema
• Responsible for rebuilding teh indexes and tables as part of performance tuning
• Used SQL Server Agent for scheduling jobs and alerts
• Active part in creating cubes from which data can be retrieved rapidly
• Performed Query optimization & Performance Tuning
• Optimized queries using SQL Profiler and Database engine tuning advisor

Environment: SQL Server 2008/2005 Enterprise Edition, SSIS, SSRS, .NET Framework, C#, ASP.NET, ADO.NET, Erwin, T-SQL, VisualStudio.NET IDE, Windows 2000/2003 Server, VB 6.0,XML, MS Excel, MS Access, Visual Studio 2005

Confidential, Grapevine, TX

SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Actively supported business users for change requests.
• Responsible for Installation, Configuration, Security, Maintenance, Restoration of SSRS on Windows Server 2003.
• Uploaded reports on to teh report manager and organized them in folders. And Delivered teh reports using ‘pulled’ and ‘pushed’ methodologies.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.
• Gauged teh effectiveness and efficiency of existing reporting systems. Develop and implement High Level Design of SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Monitored jobs and validating teh source data and destination data.
• Created complex Stored Procedures for writing teh SSIS package logs into a physical database table.
• Created weekly comparison report which validates teh process of ETL.
• Used Linked server for writing complex T SQL code on SQL Server to query on IBM DB2 tables.
• Worked on all teh 3 phases of Software lifecycle, Development, Testing and Production
• Involved in developing Technical Design specification documents for different interfaces.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created SQL Server Reports using SSRS 2005 and exported them to Excel format for managers and QA team for easy validation.
• Created partition function, schema and file groups for fact tables.
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Wrote T-SQL code for creating cursor and handling teh data validations.

Environment: SQL Server 2005 (Query Analyzer, SQL Profiler),Erwin, MS SQL Integration Services, MS SQL Reporting Services 2005, Share Point Server MOSS2007, VB. Net, Oracle 9i, MS Excel, Window 2003.

Confidential, Malvern, PA

SQL Server BI Developer

Responsibilities:

• Extensively wrote MDX queries for calculating measures.
• Design/ developing SSIS (ETL)/SSAS (OLAP) MDX developing components.
• Manage customer expectations by clearly documenting and maintaining project deliverables, plans, and status throughout life of teh project.
• Applied conversion and transformation procedures according to business requirements. Designed and built cube (SSAS) and MDX developing wif 10 dimensions in addition built partitions spanning 8 years by month
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Generated reports in various formats showing teh portfolio performance against benchmarks.
• Used SSRS for drill down reporting starting from client to holdings to lot info.
• Used SSRS for multi sectional reporting using sub reports and parameterized report.
• Used Report Builder for Ad-hoc reporting.
• Reviewed and fine tuned database objects and queries before production migration to ensure efficient data retrieval.
• Assisted teh front-end application developers wif their queries.
• Updated project status reports/created issue items for reviews/updated technical and transformation files on timely basis.

Environment: SQL Server 2005/2000, MS Access 2000, SSAS, SSIS, SSRS, MS Excel, Visual Studio 2005, Windows Server 2003.

Confidential, NY, NY

SQL Server/BI developer

Responsibilities:

• Logically and physically designed database for projects on basis of user requirements using ERWIN.
• Written Stored Procedures for Application Developers and some user defined functions.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Regularly monitored teh system for bottlenecks and suggest/implement solutions.
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created Jobs to extract data from different sources using SSIS packages.
• Stored Procedures called teh SSIS package dat would aggregate teh data and load them in globally temporary table, having teh same architecture as teh table for which teh import is done.
• Writing reports using Microsoft Reporting Services (SSRS)
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used SSIS packages to roll our data to Live Tables and to Claim Processing Database.
• Used SQL Server Reporting Services to generate different types of Ad-hoc Reports.
• Configured SQL Mail agent for sending Automatic emails when a SSIS Process is Failed or Succeed.

Environment: SQL Server 2005/2000, SSAS, SSIS, SSRS MS Access, SQL Query Analyzer, Enterprise Manage, DTS, SQL Developer, Visual Basic 6.0, Crystal Reports 8.5.

Confidential, Gainesville, FL

MS SQL Server Developer

Responsibilities:

• Developed backup and restored scripts for SQL Server to make teh database available at time of lose of database.
• Wrote various stored procedures for teh purpose of application development.
• Tuned SQL statements and Stored Procedures.
• Performed Disaster recovery and database maintenance plan.
• Performed Replication of Data to distribute teh load on single server.
• Designed and implemented data access Stored Procedures and Triggers for automating tasks.
• Involved in job scheduling and alerts to teh connected users.
• Designed and implemented user log in and security to ensure teh security of database.
• Resolved any deadlocks issues wif teh Databases/Servers on a real-time basis.
• Created many complex Stored Procedures / Functions and used them in Crystal Reports directly to generate reports on teh fly.

Environment: MS SQL Server v7, SQL Server v2000, T-SQL, Win NT v4, Win 2000, Win 2003.