SUMMARY

• 8+ years of IT Experience in Database Design, Development and business intelligence of Confidential SQL Server 2008/2005/2000 in Development, Test and Production Environments with various business domains like healthcare, financial, pharmaceutical and manufacturing.
• Expertise in writing T - SQL Queries using joins, Sub queries and Cursors in MS SQL Server 2000/2005.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in deploying created reports in various sources like Web browser, XML and VBA Excel.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Expertise in report writing according to the business requirement in SSRS.
• Expert in creating SQL Server Reports using SSRS 2008 in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc reports.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Expert in creating the MDX cubes and dimensions.(SSAS)
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports.
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces with BIDS.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Confidential .NET framework for SSIS packages.
• Knowledge on integration of BI suite of products with Confidential Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Excellent skills in designing Logical and Physical Modeling using ERWIN.
• Strong analytical, administration and problem solving skills dedicated to maintain the high quality standards. Good communication skills, ability to work independently.

TECHNICAL SKILLS

Database Tools: SQL Enterprises Manager, SQL Profiler, Query Analyzer SQL Server setup, Security Manager, Service Manager, SQL Server Analysis Services (SSAS).

ETL Tools: Data Transformation Services (DTS), SQL Server 2008/2005/2000 Integration Services (SSIS), Import Export Data, Bulk Insert, BCP.

Data Modeling Tools: ERWIN 7.3, Power Designer 12.5, ER Studio 8.0.1, MS Visio 6.0.

Programming Language: T-SQL, PL/SQL, C, C++,C#, Assembly, HTML, Java Script, XML, .NET 2.0, Visual Basic 6.0, Visual FoxPro 5.0.

Web Tools: MS-Front Page, MS-Outlook Express.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9/10, MS Access, MS Excel.

Databases: SQL Server 7.0 / 2000/ 2005 , Oracle 8i /9i/10g/11g, MS Access.

Operating Systems: Windows 9x/NT/XP/Vista, MS-DOS, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Concord, CA

SQL Server Developer

Responsibilities:

• Developed SSIS Packages to migrate data from Oracle, Access, flat files and Excel into Repository for further Data Analysis and Reporting using multiple transformations
• Responsible for developing, monitoring and deploying SSIS packages.
• Created complex SSIS packages using proper control and data flow elements
• Created complex SQL queries, stored procedures, functions, joins and SSIS packages.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Custom logging using script tasks and event handlers in SSIS packages. 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.
• Created SSRS reports from Analysis Services using MDX and DMX Queries.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Deployed the SSIS Packages from development server to production server using package configurations.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.

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

Confidential, Bellevue, WA

SQL Server Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Used Query Analyzer to optimize SQL Queries.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created Dimensions with the cube wizard and also individually.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Report Design.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.

Environment: SQL Server 2008 Enterprise Edition, SSAS,MDX,OLAP, SSIS, T-SQL, SSRS, Windows Server 2003, Performance Point Server 2007, MS Access, Visual Studio 2005, .Net 3.5.

Confidential, Oakland, CA

SQL Server Developer

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Involved in project planning, scheduling for database module with project managers.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS)
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Reviewed and developed data models and database designs with development teams
• Performed DBA tasks through Enterprise Manager, Query Analyzer, Import Export wizard
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005/2008.
• Provided via the phone, application support. Developed and tested Windows command files andSQLServerqueries for Production database monitoring in 24/7 support.
• Good exposure in running jobs in enterprise manager using job scheduling tool.

Environment: MS SQL Server 2005/2008, MS Visual Studio 2005, Windows 2000/2003, SSIS, SSAS, MDX, OLAP, SSRS.

Confidential, Fort Worth, Texas

SQL Server Developer

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created and when required, modified already existing stored procedures, triggers, views, indexes.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Tested queries to optimize the procedures and triggers to be used in production.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Created the SSIS /DTS packages and scheduled them.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated the Existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.
• Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
• Involved in Performance tuning and Query Optimization.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Created and managed the databases in development environment.

Environment: MS SQL Server 2005, Windows 2000/NT/XP, SSIS, SSRS, SSAS, T-SQL, OLAP, OLTP, MDX, ProClarity, ADO.Net, Query Analyzer, Data Mart, ETL, MS Office 2003.

Confidential

SQL Server Developer

Responsibilities:

• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, and Indexes.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Coordinated with the front-end developer to put in the business rules. Wrote procedure to check some of the rules at the backend at the time of entering data.
• Performed troubleshooting operations on the production servers
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Environment: SQL Server, Visual Basic.Net, ADO.net, HTML, Crystal Reports.

Confidential

Jr.SQL Server Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS.