SUMMARY:

• Over Six years of excellent experience in teh 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 wif 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 wif teh 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 wif 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 wif teh team members smoothly by positive attitude and strong communication skills.

TECHNICAL SKILLS:

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

Programming Languages: TSQL, PL/SQL, SQL, XML, XHTML, C#, C, C++, Java, VisualBasic, 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, SQLServer Management Studio, SQL Server BusinessIntelligence (SSIS, SSAS, SSRS), Development Studio andSQL Server Profiler

Reporting Tools: SQL Server Reporting Services, Crystal Reports 10.0

Other Tools and Utilities: MS Visual Studio, MS Office 2000/2007, Informatica, InfoPath, Visual source safe, PVCS, FoxPro and AdobePhotoshop

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

MS SQL Server/ Business Intelligence Developer

Responsibilities:

• Gathered requirements from teh 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 teh SSIS packages wif different transformations, precedence constraints, configuration settings, check points and security levels while gathering data from different sources.
• Created OLAP cubes on top of teh data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2008 and refined teh existing cubes by adding teh new attributes to teh dimensions and defining teh relationship between teh new attributes and teh measure groups.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, and sub reports using SSRS 2008 and migrated teh reports from SSRS 2005 to SSRS 2008.
• Wrote complex MDX queries to develop teh Calculated Members and while gathering teh data from teh OLAP cubes while generating teh reports in SSRS.
• Integrated teh reporting services wif MS SharePoint while deploying teh reports.
• Scheduled teh reports to run on daily/weekly/monthly basis and email teh results to teh business users in teh required format.
• Worked wif SQL Profiler, Tuning Wizard, Execution Plan and Performance Monitor in order to analyze and optimize teh queries, procedures.
• Added/modified Users, Groups, folders, rights and implemented log shipping, mirroring to maintain teh high availability of teh servers.
• Ran/Tested required queries, reports before publishing and scheduled teh tasks to run every day to update changes in teh base tables.
• Published teh 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 teh project steps and presenting to teh 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 teh data sourcing and data flows, data quality analysis, working in conjunction wif teh data warehouse architect on teh 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 wif technical team and application users as per agile methodology.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from teh OLTP to OLAP wif teh halp 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 teh database tables for defining teh 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 teh 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 teh reports and fixed bugs in teh stored procedures.
• Managed teh Metadata associated wif teh ETL processes used to populate teh 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 teh 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 teh 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