SUMMARY

• Over 8+ years of experience in SQL Server database development and administration, extensively worked in OLTP, OLAP, Client - Server & Enterprise Data warehouse Environments.
• Hands-on experience in Upgrade/Migration of MS SQL Server using any suitable approach.
• Expertise on Business Intelligence Tools (SSAS, SSIS and SSRS).
• Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.
• Extensive experience in designing, developing and deploying SSIS 2008 packages.
• Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Extensive experience in migrating DTS packages to Integration Services Packages.
• Excellent experience in developing Reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Experience in defining Queries for generating drill down and drill through reports in SSRS2008.
• Experience in Designing, Building Dimensions, Cubes with Star schema and Snow-flake schema using SQL Server Analysis Services (SSAS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Good knowledge and experience in SQL 2008 new features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Experience in installing, configuring and monitoring MS SQL Server 2008/2005/2000 installations.
• Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Execution Plan.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures, disaster recovery and performance tuning.
• Strong knowledge in implementing Transactional, Merge and Snapshot replications.
• Good understanding of high availability SQL Server solutions using active-active and active-passive Clustering modes.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Extensive knowledge of Normalization and Database Design Concepts.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
• Experience in data modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Experience in developing front-end for the site written in ASP.NET, MS Visual Studio .NET, C#, VB.NET, XML, VBScript, HTML, DHTML, JavaScript, Dreamweaver.
• Experience in version control tools such as Microsoft Visual Source Safe, Team foundation server etc.
• A well-organized, goal-oriented, highly motivated effective team member with 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, Oracle 10g/11g

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#, SQL, Pl/SQL

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, Daly City, CA

Sr.SQL (SSIS/SSRS) Developer

Responsibilities:

• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries.
• Created and customized SSIS packages and used SSIS to load data from difference sources.
• Deployed the SSIS Packages from development server to production server.
• Implemented the 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 with 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).
• Created package to transfer data between OLTP and OLAP databases.
• Active part in building Star schema and Snow flake schema based on the 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 the performance of database servers.
• Optimized the 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.

Environment: Windows Server 2008R2, SQL Server 2008R2, SSIS, SSAS, SSRS, T-SQL, Oracle, ETL, MS Access, MS SharePoint

Confidential, San Francisco, CA

Sr. SQL (SSIS/SSRS) Developer

Responsibilities:

• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed, planed, and developed programs to optimally extract, transform, and load data between data sources.
• Involved in daily data extracts from production to application servers using SSIS.
• Developed SSIS Packages to migrate data from Oracle, MySQL, Access, flat files and ExcelintoSQL server for further Data Analysis and Reporting using multiple transformations.
• Performed database design by analyzing business requirements.
• Involved in SSAS Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Created complex SQL queries, stored procedures, functions, joins and SSIS packages.
• Worked with SSIS Variables, SCD, Scripting, event-handlers, package configurations and deployment.
• Developed reports in SSRS using Analysis services as data source.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Tested applications for performance, data integrity and validation issues.
• Created Daily automation jobs for data loads and monitoring.
• Troubleshooting SQL server performance issues and SSIS performance issues.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Diagnosed and resolved database performance issues.
• Maintained developed source code in the repository for all databases and kept all build programs up to Date.

Environment: Windows Server 2008 R2, SQL Server 2008 R2, SSIS, SSAS, T-SQL, Oracle, Toad, ETL, My SQL, MS Access, MySQL, UNIX.

Confidential, Lansing, MI

Sr. SQL (SSRS) Developer

Responsibilities:

• Involved in user requirement gathering to find the exact specifications for the SQL reports.
• Interacted with the DBA's and project manager to get the various sources of data.
• Extracted data from the existing micro strategy reports and stored in a data mart for the reporting purposes.
• Involved in writing complex stored procedures to extract the data from the data mart we created for the reporting in SQL.
• Developed reports using SQL Server 2008 and added key performance indicators using SQL Server 2008 R2.
• Involved in the back up of the database assisting the DBA.
• Provide support for any issues in the reports developed in SQL Server.
• Responsible for rebuilding the 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

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 the project.
• Applied conversion and transformation procedures according to business requirements.
• Designed and built cube (SSAS) and MDX developing with 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 the 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 the front-end application developers with 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

MS SQL Server Developer

Responsibilities:

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

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