SUMMARY

• Over 7 years as a SQL Server Developer with experience in system analysis, design, development, testing and maintenance of application system in various projects(Complete SDLC) executed in SQL Server and capable of handling responsibilities independently as well as a proactive team member.
• Good Business and System analysis skills to understand the requirements and customize client applications.
• Excellent experience in web and windows maintenance and development
• Proficient in Installing SQL Server 2008/2005/2000 and configuration of their tools.
• Excellent Transact - SQL/ T-SQL (DDL/DML) programming skills.
• Excellent backend skills in creating SQL objects like Tables, complex Stored Procedures, effective functions, Views, Indexes, appropriate Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and data consistency.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Experience with Business Inelegance Studio 2005/2008.(SSIS/SSAS/,SSRS)
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked as a SQL Server DBA in data warehouse environment; responsible for developing, support and maintenance for the ETL processes.
• Expertise in Creating Databases based on Functional Requirements and System Design.
• Having Experience in Database Backup, Recovery processes.
• Experience working in Production Support team and providing support on 24x7 basis; supported systems beyond regular hours/ weekends/ holidays.
• Extensive experience in dealing with different severity types (level 1/ level 2/ level 3) of issues and make sure production is up and running.
• Hands-on experience working in the environment containing geographically distributed teams - on site/ off site ; on site/ off shore; coordinate my activities, determine dependencies in these kinds of work environment; be aware of cultural issues.
• Extensively worked with QA, release team and developers to give the required environment.
• Hands-on experience working with several Software Development Life Cycle (SDLC) models/frameworks including Agile Process
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Excellent communication skills, both oral and written and pleasing interpersonal skills.

TECHNICAL SKILLS

DATABASE: SQL Server 2008/2005/2000,SQL Azure, MS Access, MySQL, Pervasive.

DATABASE TOOLS: SQL Server Management Studio, Enterprise Manager, SQL Profiler

DATA MODELING TOOLS: ERWIN, MS Visio.

PROGRAMMING LANGUAGE: T-SQL, CLR, ASP.NET, C#,VB.Net C, C++, SharePoint, Visual Basic 6.0

WEB TOOLS: Visual Studio 2010/2008/2005, XML, CSS, HTML, IIS.

REPORTING TOOLS: SSRS, Crystal Reports, MS Access, MS Excel

OPERATING SYSTEM: Windows (Vista/2007/2000/2003/XP)

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

SQL Server / BI Developer

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedure.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple Sources
• Provided Dynamic Configuration, Custom Package Logging, Error Handling, and Notification to SSIS template package.
• Created reports using SSRS for Sales and Marketing.
• Created Deployment utility to deploy SSIS packages.
• Generated Sub-Reports, Drill down reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Responsible for the Performance tuning of the Complex SQL Queries with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Responsible for Testing and Debugging the Stored Procedure, SQL Scripts, SSIS package and Reports.
• Created OLAP Cube for the Sale people
• Worked in on site/ off shore environment; coordinated my activities by proactively communicating with my counterparts in the off shore team and working closely with my manager.
• Experience working in Agile environment and supported iterative testing methodology.
• Documented all processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2008, MySQL, SFTP, MS SQL Profiler, C#, .Net, VB, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2010, MS Office 2007

Confidential, Diamond Bar, CA

Business Intelligence Developer

Responsibilities:

• Actively interacted with end user to gather business requirement, system specification and enhancement.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Creating Integration Services package to consolidate and transform data into data warehouse from pervasive database system.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL
• Involved in writing Transact SQL utilities to generate table insert and update statements.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler.
• Performed post upgrade tasks to ensure efficient data access.
• Created Analytical Reports using SSRS
• Constructed SSIS packages to load data from database on different servers.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and stored procedures.
• Version management using tortoise SVN.
• Worked on site/ off site environment; worked closely with a team away from my location.

Environment: MS SQL Server 2005/2008,Pervasive, T-SQL, SSIS/SSRS 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, C#, ASP, Visual Studio 2005\2008

Confidential, Ontario, CA

SQL Server\SSRS Developer

Responsibilities:

• Designing, developing and maintaining reports using SSRS.
• Gathered functional requirements from the client and translated into technical requirements
• Created and managed database objects.
• Define data model and table structure/relationships for the data warehouse
• Performance tuning of reports
• Writing Stored Procedures and function for database.
• Deployed reports to SharePoint site.
• Done SharePoint and Reporting services integration.
• Version management using tortoise SVN.
• Created parameterized, drill down and aggregation reports in MS SQL using SSRS.
• Generated daily, weekly and monthly reports for the managers.
• Role based security on users for accessing the reports

Environment: Microsoft SQL Server 2005, T-SQL, Windows Server 2003, SSIS, SSRS, VB Scripting, C#, ASP, ASP.Net, .Net, VB, Visual Studio 2005/2008.

Confidential, Diamond Bar, CA

.Net\ SQL Developer

Responsibilities:

• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Development and maintenance of application
• Testing
• Handling team
• Working on critical bugs
• Version management using tortoise SVN.
• Worked in on site/ off shore/ off site environment; coordinated my activities by proactively communicating with my counterparts in the other teams.

Environment: VC++, SQL Server 2005 Management Studio, C#.Net,Pervasive Database System, Crystel report