SUMMARY

• 5 years of IT experience in System Analysis, Design, Development and Testing in Software Development, MS SQL Server 2005/2008 in production environments.
• Familiar with different SDLC methodologies like Waterfall, XP also understanding of various phases in these methodologies.
• Excellent experience in designing and writing complex SQL code and working with Tables, Stored Procedures, User Defined Functions and Indexes according to the business requirements.
• Highly proficient in the use of Microsoft SQL Server programming languages and technologies such as SSIS, and TSQL scripting to develop custom data warehouses.
• Experience in Data Modeling, Multi - dimensional Data modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool.
• Efficiently used T-SQL in constructing Triggers, UDFs, Views, Stored Procedures, Indexes, relational data models, and data integrity.
• Created and optimized complex stored procedures and triggers for several purposes like ETL, data profiling and parameterized reports.
• Involved in gathering business requirements that will facilitate the planning and the implementation phase of a data warehouse.
• Excellent in High Level Design of ETL & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, SQL Server, Oracle, Flat File, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Lookup, Bulk Insert, Merge and Union all.
• Optimized data mart structures by changing some snowflake schemas to a star schema for better performance and added aggregates and Surrogate keys to the fact tables to link to most of the dimensions.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports using SQL Server Reporting Services 2005/2008
• Experienced in deploying, subscribing, and scheduling the reports and uploading files to a report server catalog from the report manger.

TECHNICAL SKILLS

Operating Systems: Windows 95, 2003Server 2008R2, XP, NT

Databases/Data Access: MS Access, OLAP, OLTPSQL Server 2000/2005/2008 SQL Reporting Services 2005/2008R2SQL Integration Services 2005/2008R2SQL Analysis Services 2005/2008R2

Languages/Tools: T-SQL, JUnit C, C++, Java, Eclipse, BIDS Erwin, TFS, Android EmulatorMS Visio 2003T-SQL, PL\

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

SQL/BI Developer

Responsibilities:

• Worked closely with Business Owner, Project manager, subject matter experts and system architecture to define business requirements and create business requirements documents for signoff and agreement.
• Initiated JAD sessions with the development team to explain the project specification and the requirements of the end client in a detailed and thorough manner to all the team members.
• Developed functional/technical specifications such as Business Scope Document and High Level Design Document.
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by end users.
• Modified database structures as directed by developers for test/development environments.
• Analyzed the historical data and extracted required data using both T-SQL and SSIS to support the management decisions.
• Designed ETL Scripts for the migration of data from one data base to another using SSIS.
• Managed Package Configurations to efficiently deploy ETL Packages from Test Development Environment to production Environment.
• Created new and modified existing stored procedures for better performance and also for documentation.
• Designed and implemented OLTP database using Microsoft SQL Server 2008.
• Analyzed the index fragmentation and created SQL Scripts to handle the index fragmentation of various tables as a part of performance tuning.
• Created new and modified existing stored procedures for better performance and also for documentation.
• Created ad-hoc reports, and complex Enterprise reports (parameterized, drill down, and drill through reports, Parameterized reports, cascading report) using SQL Server Reporting Services.

Environment: SQL Server 2008/2008 R2, TSQL, SSIS, SSRS, BIDS, TFS, Management Studio

Confidential, San Ramon, CA

SQL/Data Warehouse Developer

Responsibilities:

• Extensively involved in gathering business requirements that will facilitate the planning and the implementation phase of a data warehouse.
• Created new and modified existing stored procedures for better performance and also for documentation
• Generating scripts and schemas by using reverse engineering through Erwin Data Modeler.
• Convinced the Project Manager that Analysis Services MOLAP Warehouse was a better option based on facts in the reports including performance differences.
• Designed and implemented OLTP database using Microsoft SQL Server 2008.
• Created objects such as: Stored Procedures, Triggers, User define functions, Indexes, Views, and Indexed views.
• Analyzed the historical data and extracted required data using both T-SQL and SSIS to support the management decisions.
• Optimized the existing queries to improve performance with the use of SQL Profiler, DTA and Execution Plans.
• Involved in scheduling packages through SQL Server Agent and setting up shared schedules.
• Involved in full life cycle of Reporting starting from the Authoring phase, the Management phase all the way to the Delivery phase.
• Handled the reporting server and was actively involved in creation of various types of complex reports
• Created several reports using SSRS like drill down, drill through, parameterized, linked and sub reports.
• Responsible for identifying and defining the Datasets for the report generation, writing the queries for the drill down reports, and identifying and adding the report parameters.
• Assisted in the scheduling and the deployment of the reports and assisted in uploading files to report server catalog from the report manger.
• Created and Maintained security (system level as well as item level), subscriptions and delivery on managerial requirements.

Environment: SQL Server 2008/2008 R2, SSIS, SSAS, BIDS, Management Studio, Server Agent, Windows Server 2003

Confidential, Carlsbad, CA

ETL Developer

Responsibilities:

• Generated scripts and schemas by using forward/reverse engineering techniques through Erwin Data Modeler.
• Created tables, views, stored procedures, functions using SQL Server 2005 T-SQL. These objects were created based upon the functional specification.
• Involved in extracting the data using SSIS from OLTP pre-staging to OLAP staging.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Responsible on making weekly backup databases by using SQL Server 2005 and restore these databases in a standby server.
• Responsible for configuration, security, and maintenance of SSIS and SSRS.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.
• Migrated data from different sources including flat files, MS Access, Oracle 8i/9i to SQL Server 2005 by using SSIS.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Generated daily, weekly and monthly reports regarding assigned projects to designated managers and clients.

Environment: SQL Server 2005, Erwin 7.0, Excel and Access 2007, SSIS, SSAS, SSRS, Microsoft Server 2003

Confidential

SQL Server Developer

Responsibilities:

• Actively supported business users for change requests.
• Created several databases in various Development and Test server by using SQL Server 2005.
• Responsible for installation, configuration, security, maintenance, restoration of SSRS on Windows Server 2003.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.
• Migrated data from different sources including flat files, MS Access, Oracle 8i/9i to SQL Server 2005 by using SSIS.
• Developed and implemented strategies for improving and further leveraging existing reports in order to transfer / convert to SQL Server Reporting Service.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Generated daily, weekly and monthly based reports to designated managers and clients.
• Applied security to web server and database server that affects report server installation. Managed role-based security to reports and reporting resources.
• Responsible for back up and restoration of SQL Reporting Service.

Environment: SQL Server, SSIS, SSRS, SQL Profiler, Management Studio, BIDS, Access