SUMMARY

• Over 5 years of IT experience in the use and design, development, Testing, support and migration of Microsoft SQL Server 2008 database.
• Worked on requirement gathering, system analysis, design, development, testing and implementation of client/server and web - based applications using SDLC.
• Experienced in complex SQL Stored Procedures, Cursor processing, User Defined functions, Indexes, Constraints, Locking and Views.
• Involved in Query Optimization and Performance Tuning using SQL Server Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Proven knowledge of Enterprise Reporting and Business Intelligence.
• Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS).
• Worked on DTS packages for data Transformation and Loading to SQL Servers databases from various relational and non-relational data sources.
• Involved in Deploying and Scheduling DTS/SSIS packages in SQL Server to run successfully.
• Experience in developing and deploying reports using SQL Server 2005 Reporting Services (SSRS).
• Developed reports using Tabular, Sub Reports, Matrix, Chart Reports by assigning the Report Parameters, Drill through and Drill down mode.
• Experience in Deploying the RDL file in SSRS to the Reporting Server and assigning Roles to the Recipients to render the Reports.
• Developed complex store procedures and views to generate various Drill-Down reports, parameterized reports, Cascaded reports, Dynamic Reports and linked reports using SSRS.
• Worked with OLAP and Data warehouse application along with star schema, implemented SSRS, SSAS to support large scale Data Conversion.
• Experience in Designing, Developing and Maintaining Web Applications using Visual Studio .NET, ASP.NET, C#, VB.NET, ADO.NET.
• Expert in data/file security, user logins, database role and database permission.
• Involved on administration tasks such as Backup and Recovery, Creating Databases, Files, File groups and Transaction log shipping.
• Can effectively work in a team or as an individual contributor and consistently exceeded expectations with aggressive deadlines.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/2005/2008/ R2, SQL Server 2000, 7.0, Microsoft Access, IBM DB2, IMS DB, Oracle 9i/10g/11G

Languages: C, C++, C#, Cobol, T-SQL, PL/SQL

Operating Systems: Windows 95/98/NT/XP/Vista/7, Linux/Unix

Networking: Internet Information Server (IIS), MS-Front Page, TCP/IP, LAN, WAN

Reporting Tools: SQL Server Reporting Services (SSRS), SharePoint Server

ETL Tools: DTS, SSIS

SDLC Methodology: Waterfall, Agile

Modeling Tools: Erwin 4.0/4.2

Tools: /Utility: SQL Server Management Studio(SSMS),Business Intelligence Development Studio(BIDS), SQL Server Analysis Services(SSAS), SQL Profiler, Query Analyzer, Visual Studio, Erwin, Mercury Quality Centre, MS Office Suite, BizTalk Server, ASP.Net, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Sr. SQL Server Developer/SSIS/SSAS/SSRS Consultant

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Generated Monthly and quarterly Reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Experience in writing MDX queries for calculating members and measure groups.
• Created static reports using MDX queries and created MDX based report definitions.
• Created advanced KPI’s from cubes using PROCLARITY.
• Generated pivot tables using the cube data in SSAS and delivered reports using SSRS by using the connection string as SSAS.
• Created an analysis Data Mart and Multidimensional Cube in SQL Server Analysis Services.
• Analyzed and optimized Microsoft SQL Server Analysis Query performance.
• Created Calculated Measures and Key Performance Indicators in SSAS using MDX.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed the reports in to the report server.
• Involved in testing various SSIS packages from development to production.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed many SSIS packages to conduct transformations on inconsistent data.
• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Involved in creating Data mappings in SSIS and created data models using ERWIN tool.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Created Cubes and used basic MDX to retrieve the result set for Calculations using SSAS.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.

Environment: SQL Server 2005/2008 Enterprise, Windows Enterprise Server 2003, SSAS, SSIS, SSRS, Server 2004, Share Point Portal Server 2007 (MOSS 2007),MDX, IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008, ASP.Net 3.5, VB.Net, MDX, OLAP, OLTP

Confidential, San Leandro, CA

Business Systems Consultant

Responsibilities:

• Attend meeting with business to understand their business needs.
• Cross group collaborative work with other groups to make code modification required for smooth running of interacting subsystems.
• Fully utilized SDLC processes including requirements gathering, design, development, implementation, quality assurance and maintenance.
• Connected various applications to the database.
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Expert in Performance tuning and optimization of SQL queries using SQL profiler and query analyzer.
• Created T- SQL queries for data retrieval. Monitored performance and optimized SQL queries for maximum efficiency.
• Troubleshooting performance issues with Fragmentation using Profiler, System Monitor and DMV’s.
• Used @@ERROR, @@ROWCOUNT and TRY CATCH for exception handling.
• Experience in migration of Data from Excel, Flat file, MS Access to MS SQL Server by using DTS and SSIS packages.
• Expert in FTP task, ETL script task, look up transformations and data flow tasks to load staging databases.
• Extensively used SSIS 2005 for migrating data from DTS packages to SSIS packages.
• Played active part in the development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Experience in creating multiple (SSRS) reports in Drill mode using tables, financial tables, crosses tabs and charts.
• Designed and developed report layouts including report parameters, Created parameterized, drill down and aggregation reports using SSRS 2005 for business partners.
• Developed custom ad-hoc reports, Parameterized reports and Linked Reports by using SQL Server Reporting Services (SSRS).
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008.
• Created MDX queries to retrieve data from the cubes and also to display SSRS report.
• Perform and troubleshoot various data loads.
• Developed Web Forms using ASP.NET under Microsoft Visual Studio.net environment.
• Implemented Snapshot and Transactional Replication models and Validation of Replicated data.
• Streamlined and optimized cubes using MDX to introduce custom calculations and dimensions attributes.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Connectivity and Database Consistency Checks using DBCC Utilities.
• Performed daily tasks including backup and restore by using SQL Server 2005/2008 tools.

Environment: SQL Server 2005/2008, SSIS, SSRS, T-SQL, Visual studio 2005, Windows XP/NT/2000/2003, MS Office 2003/2007, MS Visio.

Confidential

Assistant Systems Engineer - SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Participated in Design and Architecture meetings and proposed technical solutions to resolve business requirements.
• Performed data transfers using BCP and BULK INSERT utilities. Was involved in the design and implementation of Disaster Recovery.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Reduced T-SQL overhead successfully by avoiding unnecessary use of UNION, <> statement and using the TOP operator to limit the Select Statement in certain Queries.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in Database Conversion from DB2 to MS SQL 2005.
• Defined and developed data migration strategy between different sources and platforms using DTS and SSIS Platform.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005.
• Used multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created transformations to handle XML formatted data to load into tables.
• Maintained nightly and weekly data loads by scheduling the corresponding ETL job in SQL Server Agent.
• Created subscription for the windows file share and implemented three layer securities for the reports in SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Running DBCC consistency checks and fixing data corruption in application databases.

Environment: SQL Server 2005, SSIS, SSRS, T-SQL, Visual studio 2005, DB2, QMF, COBOL, Easytrieve, Windows XP/NT/2000/2003, MS Office 2003/2007.