SUMMARY

• Over Six years of excellent experience in the IT industry as a SQL Server/BI Developer.
• Proficient in MS SQL Server 2005/2008 suite of products.
• Expert in writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in SSRS 2005/2008.
• Expert in defining data source and building data source views.
• Highly experienced in design of logical and physical data modeling using Erwin data modeling tool.
• Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries.
• Proficient in data loads, database integration/conversions, performance tuning and optimization.
• Proficient in creating calculated measures and dimensions members using MDX, mathematical formulas and user defined functions.
• Expert in creating OLAP with the use of Erwin.
• Strong experience in writing complex Stored Procedures, Triggers, Cursor, Linked Server Query, UDF, and other SQL Server objects using T-SQL.
• Experienced in Using Performance Monitor/Profiler to solve dead locks/long running queries.
• Hands on experience in troubleshooting database issues.
• Expert in dealing with Alerts, Operators and Jobs through SQL Server Agent.
• Performed data migration between different versions of SQL Servers 2000/2005/2008.
• Worked on administration tasks such as data loading, batch jobs, data unloading, back up & Recovery, user and application table management, upgrades, creating databases/file groups/files/transaction logs.
• Capable of forming and maintaining positive and productive working relationships in internal/external team environments.
• Capable to deal with the team members smoothly by positive attitude and strong communication skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/2005/2000/7.0 , MS Access 2003/2000, DB2, Oracle10g/9i/8i, Sybase and MySQL

Programming Languages: TSQL, PL/SQL, SQL, XML, XHTML, C#, C, C++, Java, Visual Basic, ASP/VB.NET

Operating Systems: Windows NT 4.0, Windows Server 2003, UNIX and MS-DOS

SQL Server Tools: MS Enterprise Manager, SQL Server Query Analyzer, SQL Server Management Studio, SQL Server Business Intelligence (SSIS, SSAS, SSRS), Development Studio and SQL Server Profiler

Reporting Tools: SQL Server Reporting Services, Crystal Reports 10.0

Other Tools and Utilities: MS Visual Studio, MS Office 2000/2007, Informatica, Info Path, Visual source safe, PVCS, FoxPro and Adobe Photoshop

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

MS SQL Server/ Business Intelligence Developer

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008.
• Creating and managing schema objects such as Tables, Views, Indexes, Unique/Check Constraints and referential integrity depending on user requirements and converting them into technical specifications.
• Developed SSIS packages to transfer data from OLTP to OLAP database.
• Developed the SSIS packages with different transformations, precedence constraints, configuration settings, check points and security levels while gathering data from different sources.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2008 and refined the existing cubes by adding the new attributes to the dimensions and defining the relationship between the new attributes and the measure groups.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, and sub reports using SSRS 2008 and migrated the reports from SSRS 2005 to SSRS 2008.
• Wrote complex MDX queries to develop the Calculated Members and while gathering the data from the OLAP cubes while generating the reports in SSRS.
• Integrated the reporting services with MS SharePoint while deploying the reports.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Worked with SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize the queries, procedures.
• Added/modified Users, Groups, folders, rights and implemented log shipping, mirroring to maintain the high availability of the servers.
• Ran/Tested required queries, reports before publishing and scheduled the tasks to run every day to update changes in the base tables.
• Published the reports.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Managed all indexing, debugging, optimization and performance tuning using T-SQL.
• Created/modified SQL Joins, sub-queries, and other T-SQL and PL/SQL code to implement business rules.
• Involved in documenting the project steps and presenting to the team members.

Environment: MS SQL Server 2008/2005, SSRS 2008/2005, SSIS 2008, SSAS 2008, SSMS, MDX, ASP.NET, VB.NET, C#.NET, T-SQL, MS Share Point and Excel.

Confidential, Bingen, WA

MS SQL Developer/BI developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively used SSIS for transferring data manually from DTS packages to SSIS packages using SSIS 2005.
• Designed and developed SSIS packages to move data from SQL 2005 to SQL 2008.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Created parameterized, drill down and sub reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used Performance Monitor/SQL Profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Developed data access layer using C# classes.
• Established backup and recovery of SQL server 2005.

Environment: MS SQL Server 2005/2008, SSRS 2005, SSIS 2005, T-SQL, C#.NET 2.0, Visual studio 2005, ASP.NET, DTS, Data Analyzer, java script, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2, VSS 2005

Confidential, Louisville, KY

MS SQL Server Developer

Responsibilities:

• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Wrote complex queries, triggers and stored procedures, views and user defined function.
• Design and implement database Logical and Physical Schemas.
• Worked on Migration from SQL Server .
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003.
• Wrote complex T-SQL Scripts for generating reports
• Maintenance of Development, System test, Assemble test and Integration Servers and databases.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Developed the PL/SQL programs.
• Designed and developed DTS packages for data import and export
• Used Quality Center (Defect tracking tool) for Bug fixing and resolution details.
• Involved in mock testing and Unit Testing and Integration testing.
• Worked on DTS Package, DTS Import for Transferring data from Oracle and Teradata.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output.
• Importing and exporting of Databases using various techniques like BCP, DTS.
• Ensured Security by defining access control to data.
• Generated reports using SSRS.
• Query Tuning, Index Tuning and Performance Tuning.
• Worked on OLAP and OLTP.

Environment: SQL Server 2000/2005, .Net Framework, Asp.Net, Ado.Net, Windows 2000/2003