SUMMARY

• A Microsoft Certified BI Consultant with over 7 Years of experience in MS SQL Server 2008/2005/2000 across Financial, Insurance, Energy & Telecom Domains.
• Experience in MSBI Suite of products SSIS, SSAS, SSRS, OLTP, OLAP and Data Migration.
• In - depth knowledge of database programming using T-SQL (DDL, DML and DCL).
• Experience in Migration of Data from Excel, Flat file using DTS, SSIS and other ETL Tools.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Experience in Database Design activities including Data Files,Capacity Planning, Data Partitioning and Data Normalization.
• Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Broad experience in Query Optimization and performance tuning of stored procedures, Functions
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in SQL Server Analysis Services (SSAS) in SQL Server 2008/2005.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005) using Multi-Dimensional Expression (MDX), mathematical formulas, and User-Defined Functions.
• Developed cubes using Partitions, added the Key Performance Indicators (KPI), Perspectives, and Slowly Changing Dimension (SCD).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008/2005 Analysis Services.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Ad-hoc reports using SSRS.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Exposure in using Team Foundation Server as a source control, source repository and project tracking solution.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks, can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS

Environment: SQL, T-SQL, PL/SQL, Dynamic SQL, MDX, SQL*Plus 3.3/8.0, HTML, XML, DHTML, C, C++,VB Script, Shell Scripting, Power shell, C# .NET,VB .NET, ASP .NET, ADO .NET, Visual Studio, XML, HTTP, ActiveX, MS Access

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C# (.NET), ASP .NET, VB.NET, XML, HTML, DHTML, HTTP, Shell Scripting

RDBMS: SQL Server 2008/2005/2000 , Oracle 10g/9i/8i, Sybase Server, Teradata V2R5, IBM DB2 UDB 8.2/8.0, MS Visual Source Safe 2005, and MS Access 2003/2000/97

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX, SUSE LINUX9.0

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports, Cognos, Hyperion

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Business Objects,, Web Services, SOAP, ProClarity

Version Control and Configurations: Visual SourceSafe 6.0/2005, Visual Studio Team Foundation Server (VSTS), Remedy Change Management, Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. SQL/ BI (SSIS/SSAS/SSRS) Developer

Responsibilities:

• Involved in user requirement gathering and specification analsis provided by the client.
• Participated in Designing and Implementing POC for the EDW (Enterprise Datawarehouse) and implemented datadictionaries and data mappings from various source systems
• Developed SQL scripts /libraries for various data loads and validation for both OLTP and OLAP systems
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end applications created and altered Databases, Tables, Views, Indexes and Constraints with business rules usingT-SQL across all SDLC environments
• Used Temporary tables, Table variablesandCommon Table Expressions (CTE)depending on the requirements.
• Worked onPerformance tuning,query optimizationandexecution planof queries for better performance.
• Worked with SSIS Packages for transferring and reviewing data from heterogeneous sources like Flat file, Excel, CSV, DB2, Oracle.
• Implemented SSIS features for Incremental Data Loads, Slowly Changing Dimensionsfor updating and maintaining the history of the records.
• Conducted and automated theETLoperations toExtractdata from multiple data sources, transforminconsistent and missing data to consistent and reliable data, and finallyloadit into theMulti-dimensional data warehouse.
• Extensively used SSIS forTransformations, Aggregations and Lookups.
• Worked on Dimensional modeling in defining Relationships betweenDimensions and Measure Groupslike Fact Relationship,Many-to-Many Relationship, and Dimension Granularity within a Measure Group.
• Designed and DevelopedKPIs, Aggregations, hierarchies and Cube Partitions.
• Develop and Deployment of SSAS Cubes to the production server.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed and developed over 100+ Enterprise SSRS reports based on client specifications.
• Generated Monthly and quarterly Reports in the form of bar chart reports for the management using different techniques like Drill down, Tabular reports, Matrix reports, List reports, Parameterized, Pie charts, Graphs, Linked Reports, Drill Through using Expressions, Global variables and Functions.
• Deployed SSRS reports inShare pointfor web based access for multiple end users.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.
• Worked on Change Control and Code reviews for Production Deployments

Environment: MS SQL Server 2008/2005/2000 , VS2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, MDX, Microsoft Office SharePoint Server (MOSS ) 2007, Performance Point Server 2007, Oracle 10g/9i, Toad, MS Excel, Visual Source Team Foundation Server (VSTS),ProClarity, Team Foundation Server(TFS), .Net (Asp .Net, C# .Net)

Confidential, Huston, TX

SQL/BI (SSIS/SSRS) Developer

Responsibilities:

• Actively Participated in gathering User Requirements and System Specifications.
• Performed Installation and Configuration of SQL Server 2005 and SQL Server 2008
• Created new Stored Procedures, functions and database triggers according to the complex business logic.
• Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Performed the query tuning to optimize the procedures and triggers to be used in production.
• Developed and executed SSIS packages to extract and populate the data from the various data sources.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Performed the Migration the Existing DTS packages to the SSIS Batch jobs.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with report parameters and performed Parameterizedand cascading parameterized reports using SSRS.
• Developed logical and physical data models using Erwin.
• Scheduled and Maintained jobs for data messaging from development server to test server for generating daily reports
• Created and managed the databases in development environment.

Environment: MS SQL Server 2005/2008, T-SQL, MDX, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ETL, Business Intelligence Development Studio (BIDS), MS Excel, Data Analyzer, Erwin, Advanced Windows 2005 Server, Visual Source Team Foundation Server (VSTS),Proclarity,TFS, VB Script, Oracle 10g/9i,Toad, XML

Confidential, Richmond, VA

SQL/BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Implemented Complex Logging in SSIS Packages.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created Perspectives of the cube to simplify the process of browsing for the end users.
• Used MDX to create calculated members in the cube.
• Fine-tuned SSAS cube.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Created Report Snapshots to improve the performance of SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Migration of an MS Access application to SQL Server 2005.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, ProClarity, Team Foundation Server (TFS) Oracle 10g/9i, VBScript.

Confidential, New York, NY

BI/SQL Developer (SSIS)

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• Actively participated in gathering of User Requirement and System Specification.
• Worked extensively on Database space management, performance monitoring and alert management.
• Maintained security by creating users and giving appropriate permissions to users.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Involved in migrating databases from MS SQL server 2000 to MS SQL server 2005.
• Created Jobs and scheduled jobs according to the requirements.
• Implemented transactional replication between Primary Server and Sub Systems.
• Created database, tables, Indexes and views.
• Created linked server between SQL servers.
• Dropped and recreated the indexes on tables for performance improvements.
• Involved in performance tuning and query optimization.
• Worked with SQL server Profiler to generate traces.
• Data transfers between various servers using BCP, DTS and SSIS.
• Extensively used SSIS to move data from heterogeneous data sources to SQL Server.
• Extensively used SQL server reporting services for designing reports.
• Provided on - call 24X7 support.

Environment: Windows 2003 Server, MS SQL Server 2000, MS SQL Server 2005, T-SQL, Crystal Reports, SSRS, DTS, SSIS, BCP, SQL Profiler.

Confidential

SQL Developer

Responsibilities:

• Defined Check constraints, Business Rules, Indexes, and Views.
• Migration of data from text files to SQL Server 2000 using BCP and DTS packages.
• Wrote DTS packages to move data between production, staging and QA environment.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Fine- tuned Procedures, Functions and Triggers for optimum performance.
• Created T-SQL triggers and Stored procedures encompassing business rules.
• Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.

Environment: Windows 2000, MS SQL Server 2000, TSQL, MS access, VB script

Confidential

SQL Developer

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on Servers.
• Applied patches and service packs to keep the database at current patch level.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults,
• User defined data types and functions.
• Implemented database standards and naming convention for the database objects.
• Implement and maintain database security.
• Fine tuning Stored Procedures using Execution Plan in T-SQL for better performance.

Environment: Windows 2000, MS SQL Server 2000, TSQL, MS access, HTML.