Professional Summary:

• 7 plus years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of SDLC, using MS SQL Server 2008/2005/2000 DTS/SSIS, Reporting & Analysis Services.
• Extensive SQL Development experience in a Banking & Healthcare environment & Financial with a strong understanding of data & analytics.
• Extensive experience with different phases of project (project initiation, project requirement and specification gathering, designing system, coding, testing, and debugging new and existing client - server based applications).
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin 7.2.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.
• Proficient in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation, data consistency and complex business logic using Batch Files.
• Skilled in SQL 2005 Business Intelligence tools, Data Warehousing and ETL processes & strategies using SQL server Analysis and Integration Services.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Familiar with Data Warehousing designs in Star and Snow flake Schemas.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005 Analysis Services.
• Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Expertise in building and migration of various DTS packages.
• Experience in using Windiff for comparing files and highlighting & disparity.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Extensive experience in report writing using SQL Server Reporting Services like Table report, Matrix report, Chart Report, Pie charts & column report.
• Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Experience in SharePoint & Performance Point Servers.
• Expertise in database optimization using tools like Index Tuning Wizard, SQL profiler, File groups, DBCC utilities and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
• Connected remote SQL Servers as Remote and Linked Servers to run distributed queries between SQL servers and other data sources like Excel using ODBC, OLE DB Drivers.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Good knowledge of Computer Science theory & strong in modern programming languages.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

Skills Summary:

RDBMS/DBMS: MS-SQL Server 2008/2005/2000/7.0, Oracle 8i/9i/10g, MS Access.

Programming Languages: T-SQL, PL/SQL, C, C++, C#, HTML, XML, Java, ASP .NET, VB .NET

Software/Databases: MS SQL Server 2008R 2/20 /7.0, MSSQL Server Reporting Services 2008R2/ 2008/2005/2000 (SSRS), MSSQL Server Analysis Services 2008R2/20082005(SSAS), MSSQL Server Integration Services 2008R2/2008/2005 (SSIS), Data Transformation Services (DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP).

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server.

Version Control: Team Foundation Server (TFS), Visual SourceSafe (VSS).

Web Servers: IIS 6.0, Apache, SharePoint & Performance Point Server.

IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2005.

Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

Design Methodology: Unified Modeling Language 1.1 using Rational Rose.

Professional Experience:

Confidential, Tallahassee, FL

SQL Server BI Consultant - Integration Services (SSIS) & Data Warehousing (SSAS) & Reporting System (SSRS)

The Florida State University Foundation, Inc. is to enhance the academic vision and priorities of The Florida State University through its organized fundraising activities and funds management. The project involved designing, developing, and testing a data warehouse for gifts and transactions and Constituents. There are 300 million rows, 120 tables and 2.1 TB data involved in this data warehouse. Data is centrally stored and input through the friendly Excel interface.

• Performed Server installation and configuration using SQL Server 2008.
• Design, Implement and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Automate tasks using active x script (similar to VB script). Be able to implement failure alerts using email in SSIS.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Involved to develop the VB Script, C#, and ASP.Net, VB.Net and .Net framework creation IN SSAS and SSIS.
• Created and used extended stored procedure (pointing DLL using C#) in SSAS.
• Snapshot Replication was been used to synchronize the data between their Different Stores.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Involved in SQL Server Mirroring and Database optimization.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designed logical/physical data models and defined primary key, foreign key using Erwin tool
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Based on Windows Script Host manipulated the files using VB Script.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Used DBCC commands to troubleshoot issues related to database consistency.

Environment: SQL Server 2008, Oracle, MS Access, Excel, Teradata, Windows Server 2008, IIS, Visual Source Safe, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML Parsing, VB6, VB Script, and C#.

Confidential, Vienna, VA

SQL Server BI Consultant

Navy Federal Credit Union Bank is an armed forces bank. Serving the Navy, Army, Marine Corps, Air Force, and Veterans.

The project scope was to assist the marketing and sales departments to categorize their customers based on portfolio of services like checking accounts, savings accounts, personal loans and also categorizing them demographically, Because of the company’s growth and so growth of database that was 4.3 TB with 84 servers.

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the new system.
• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Created Triggers to enforce data and referential integrity.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Successfully migrated data from Microsoft SQL Server 2000 to Microsoft SQL Server 2005 using SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Used DataDefractor tool to normalize semi-structured Spreadsheets, fed it into the SSIS pipeline in the form of normalized output of factual data and contextual metadata.
• Reduced the repetition of the particular group in the Excel sheet using the Vertical Sub-Pages and Horizontal Sub-Pages Layout features using DataDefractor Tool.
• Deployed the packages on staging and production.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• 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.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.)
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Created Report Snapshots Report Snapshots to improve the performance of c.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Fine-tuned SSAS cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Identified the dimension, fact tables dimension, fact tables and designed the data warehouse using star schemas
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Used Script Logic Script Logic Quest Lite Speed dramatically to reduce storage costs by quickly compressing data up to 95%.
• Migration of an MS Access application to SQL Server 2000.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Installed FTP service by default with MSIIS 6.0.
• 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.
• Used to support the data processing engine in database intensive operations like query

Environment: MS SQL Server 2008 R2, TSQL, SQL Integration Services (SSIS), SQL Reporting Services (SSRS),Data Warehousing(SSAS),MSIIS, MDX,SAP BPC,MS Access 2003/2005,VB.NET,C#, SQL Profiler.

Confidential - San Mateo, California

SQL Server BI Consultant

Franklin Resources Inc. is an investment firm specializing in conservatively managed mutual funds. It offers products under the Franklin, Templeton, Mutual Series and Fiduciary brand names. The sales feed from Central Data Warehouse (CDW) to the CRM had to be modified to fit the new Salesforce.com architecture, as the existing process was bound to the old schema which was to be discontinued. Project was to alter the process to meet the new business requirements associated with the Salesforce.com

• Extracted required mapping fields from different sources (schema, CDW) to Sales Force Warehouse for Staging Table.
• Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales is available in CDW for migrating the data to Sales Force.
• Analyzed and performed Data mapping which involves identify source data field, identify target entities and their lookup table ids, and translation rules. Evaluation of data groups and data critically and developed automated conversion process.
• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions.
• Developed Store Procedure and Staging table for data push from CDW to Sales Force.
• Preformed QA Testing for all the Store Procedures to validate the sales results.
• Developed SSIS Packages not only for particular table’s fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created Packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import to Sale Force from different data sources and other ongoing tasks for mapping.
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Created SQL server configurations for SSIS packages and XML & Windows event logs.
• Used sub reports functionality for complex report calculations.
• Created parameterized reports passing parameter through report screen.
• Rendered reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.
• Using MDX created calculated members for customized calculated measures.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Documented all database objects, procedures, views, functions & packages for future references.
• Performed all QA testing and match results for different environments.
• Documented all old and migrated Store Procedures and scripts for future references.

Environment: Windows XP/2003 Enterprise edition, MS SQL Server 2005/2008, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.

Confidential, Southfield, MI

SQL Server Developer (SSIS/SSRS) - Healthcare Information System (HIS)

TRG Healthcare, LLC is a full-service management consulting firm, dedicated to serving the needs of the healthcare industry. HIS is a complete solution for a TRG Healthcare corporate which includes modules like patient registration system, doctor scheduling, lab track system, discharge system billing system, and deposit system. It is a multi-user system with great search facility. It has a dynamic facility for adding the registration type for each patient. An advanced search facility has helped clients, patients and doctors to search their desired records easily.

• Responsible for Data Modeling based on the client requirements.
• Prepared the Technical and Function specifications based on the project requirements.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.
• The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Modified stored procedures to meet current design and used them in SQL Server.
• Developed queries in Data Warehouse in OLTP/OLAP environment.
• Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Modified web pages to do database inserts, deletes, modify.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Created report models from OLTP & OLAP.
• Trained 10 business users so that they can create reports from the report model I created.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Involved in Development, Review and testing of the new system by implementing business rules and transformations.

Environment: Server 2000 Enterprise Edition, T-SQL, Enterprise manager, VSS, ERWIN, MS Office & Windows 2K platform SQL Server 2005 Enterprise Edition, Microsoft Visual Studio, VB Script, SQL Server Reporting Services, SQL Server Integration Services, SQL Profiler, SQL Server Agent, SQL API, XML, Windows Server 2003, MS Visio, IIS 6.0.

Confidential, Hyderabad, India

Junior SQL Developer/ DBA

The purpose of the project was to enable the optimum utilization of the resources to maintain inventory. This is achieved by facilitating the up to the mark and timely, information about the status of the inventory and restricting entry of quality items only, evaluating vendor suitable for a particular requirement. It gives accurate report on the status of the inventory, order placed to vendors, vendor evaluation, deliveries received and due to be delivered.

• Created and configured the database, with 2 file groups, created the tables having required constraints.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Worked on Log Shipping, Replication to restore Database backup.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assisted in coding, design and performance tuning.
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS Packages through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Updated the statistics info for both the old and new servers.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.

Environment: MS SQL Server 2000 Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, Index Tuning Wizard, and MS Access & Windows NT platform.