SUMMARY

• Around 7 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Strong technical knowledge on SSIS (2008, 2008r2) tool for importing data, data transformation and Export in different destinations.
• Knowledge in constraints, containers, variables, parameters in SSIS
• Strong knowledge on different Built in transformations as conditional script, sorting, union, joins, row sampling transformation, data aggregation, Data conversion, derived column, Audit, cache transform, Lookup and fuzzy lookup, Fuzzy grouping and others in SSIS.
• Extensive experience wif different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experience in data warehousing dimensional modeling to define dimensions and fact tables using Star schema and Snowflake schema design.
• Extensively involved in creating attribute hierarchy on cube dimensions, calculation of measures, defining relationships between dimensions and measure group, and creation of KPIs goal/forecast which is dimension dependent.
• Experience wif working on ProClarity Analytics server to analyze results produced in the Dashboard.
• SQL Server 2000/2005/2008 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working wif changing dimensions.
• Experience in creating and maintaining security mechanisms for reports, creating repository domains using Business objects Supervisor.
• Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.
• Knowledge on integration of BI suite of products wif Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• 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.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• High Knowledge in generating cubes and dimensions, defining many to many, referenced relationships in SSAS, defining granularity wifin a measure group and drill through actions, generated KPI’s and calculations.
• Experience in working creating Multidimensional cubes using SSAS for sales, Inventory, operational, merchandising and financial environment.
• Implemented a well-planned backup and restore strategy protects databases against data loss due to damage caused by a variety of failures.
• Worked wif DTEXEC and DTUTIL utilities for scheduling in SQL Server Integration Services (SSIS) and jobs in SQL Server.

TECHNICAL SKILLS

SQL Server Tools: SSMS, Profiler, Erwin, Export & Import (DTS), Lite speed, SQL Backup5

Statistical Tools: SPSS, Minitab, Microsoft Excel

Databases: MS-SQL Server 2000/2005/2008, MS Access 97 & 2000,My SQL, Oracle

BI Tools: SSIS,SSAS, SSRS

Languages: SQL, PL/SQL

Operating System: Windows NT 2000 Server/ Server/ Server 2003/server 2008/Professional/ 4.0, Win XP Prof/Standard, Win 98

PROFESSIONAL EXPERIENCE

Confidential, TX

SSIS Server Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Performance tuning, and optimization of procedures and queries.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS.
• Writing reports using Microsoft Reporting Services (SSRS)
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Designed, built and tested SSAS Cubes on SQL Server 2005.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process the cubes (SSAS), partitions as and when required.
• Enhanced performance using optimization techniques: normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Worked wif development teams in the design of physical databases and in modification.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created packages in SSIS wif error handling.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Worked wif different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Has deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2008/2005 in Test environment wif latest service packs and migrated few databases.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created SQL Server Profiler traces & used wif Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Involved in migration from SQL Server 2000 to SQL Server 2005.
• Implemented Complex business logic wif User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Written DDL / DML Triggers as per company policy.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000 and 2003 servers in very large environments.

Environment: MS SQL Server 2008/2005, SQL Server SSAS/SSRS/SSIS, MDX Cubes, OLAP, Microsoft Windows 2003 Advanced Server, ASP.NET, C#, ETL, Enterprise Edition, Microsoft Visual Basic 6.0, SQL LiteSpeed, OLAP.

Confidential, TX

SQL BI Developer

Responsibilities:

• Analyzing the FTA’s and the business requirements and building logical and physical data models.
• Creating high level design of the ETL process
• Creating three step ETL process to get the files from the server and load the data into database.
• Designing several ETL processes to Load data from Text or Excel Files
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Designing of SSIS Packages to get data files fromFTPandSFTPServer and decrypting thePGPfiles,batch processingof incoming data and purging of old files
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS wif error handling.
• Developed ETL process using SSIS wif Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi dimensional model.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Worked wif different methods of Logging in SSIS.
• Configured SSRS 2008 wif MOSS 2007 for directly deploying the report in SharePoint 2007.
• Generation of reports from the cubes by connecting to Analysis server from 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 complex Stored Procedures to validate and process the incoming data.
• Generating Validation Reports to notify the client wif the invalid data received.
• Used C# to merge multiple XML reports, convertXMLto HTML format usingXSLTfiles and sending Validation Report emails.
• WrittenPower shell scriptsto purge files
• Understanding of existing DTS packages and redesigning them into SSIS packages and facilitate batch processing
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
• Scheduling execution of ETL Packages using SQL Server Agent.
• Creating detail design documentation of the packages and creating release notes for each installs.

Environment: SQL Server 2008, Oracle, MS Access, Excel, Windows Server 2008, IIS, Visual Source Safe, Share point Server, Cold Fusion, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML Parsing, VB6, VB Script, Java Script and C#, SSAS, SSRS, SSIS, MDX Cubes.

Confidential, Denver, CO

SQL Server Developer/ SSRS Developer

Responsibilities:

• Writing stored procedures, triggers, cursors, and views to improve the quality of application, and manage mission-critical information using T-SQL.
• Develop and support reports built wif Microsoft Reporting Services on SQL 2005 SSRS.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation
• Ensure that periodic (daily, weekly and monthly) reports are delivered in a timely and accurate fashion using Reporting services SSRS.
• Using Integration Services (SSIS), built high performance Data Integration Solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Migrated data from the DB2 database using SSIS Packages.
• Optimized performance and capacity planning of various data transformation processes related to the reports.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Develop and support reports built wif Microsoft Reporting Services (SSRS) on SQL 2005.
• Maintain and monitor the data warehouse to ensure its proper operation, performance and availability.

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, MDX, OLAP, DB2, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows NT/2003, UNIX.

Confidential, Sunnyvale, CA

MS SQL Server Developer

Responsibilities:

• Involved in Migration of SQL Server 2000 to SQL Server 2005.
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Analyzed the project environment and sub systems of the project, and prepared a high level documentation for application designing.
• Interact wif the clients and gather the requirements and analyzed.
• Responsible for gathering business requirements, developing and reviewing of design documents
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintained the database consistency wif DBCC at regular intervals.
• Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.

Confidential, Jacksonville, FL

MS SQL Server / SSRS / SSAS Business Intelligence Developer

Responsibilities:

• Writing stored procedures, triggers, cursors, and views to improve the quality of application, and manage mission-critical information using T-SQL.
• Develop and support reports built wif Microsoft Reporting Services on SQL 2005 SSRS.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation
• Ensure that periodic (daily, weekly and monthly) reports are delivered in a timely and accurate fashion using Reporting services SSRS.
• Using Integration Services (SSIS), built high performance Data Integration Solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Migrated data from the DB2 database using SSIS Packages.
• Optimized performance and capacity planning of various data transformation processes related to the reports.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Develop and support reports built wif Microsoft Reporting Services (SSRS) on SQL 2005.
• Maintain and monitor the data warehouse to ensure its proper operation, performance and availability.

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, MDX, OLAP, DB2, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows NT/2003, UNIX.