SUMMARY

• Over 8+ Years of experience as SQL Developer, BI Developer (SSIS, SSRS, SSAS) as well as Database Administrator. A very good experience in Analysis, Design, Architecture and Development of Software Applications, BusinessIntelligence projects in the Microsoft SQL Server Suite of Products on various business domains like Insurance, Health&Pharmacy, Banking, and Tele - Communication.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions. Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
• Experience in using Try Catch Block introduced in SQL Server 2005.
• Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, DMV’s and efficient coding standards.
• Experience in using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries thereby optimizing query execution plan.
• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in creating packages to transfer data between ORACLE and SQL Server.
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in writing Stored Procedures in DW environment and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data.
• Experiencein Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Experience in Kimball methodology, ER Modeling, Star Schema / SnowflakeSchema, FACT and Dimensional tables, and Operational Data Store (ODS).
• Created and Configured Data Source &Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s&MDX Queries using SQL Server 2005 Analysis Services.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes using Report Designer as well as Report Builder.
• Experience in generating Drill down reports, crystal Reports, Parameterized reports, Linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Hands in creating Adhoc, Dynamic reports using templates.
• Experience on performance point server and dashboards, scorecards, building reports and created management reports.
• Worked on pro-clarity to create cost-effective reporting and analytical solutions.
• Good knowledge of PPS.
• Creating and managing roles for security in Reports.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, Replication Services, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Expertise in planning and implementing SQLserverSecurity and databasepermissions, creating roles and managing user permissions.
• Solid knowledge and recent experience with all aspects of SQLServer Management Studio (SSMS) including Query Editor, Server objects, SQLServer Agent, Management and Notification Services .
• Expertise with job scheduling using SQLServer Agent to perform hourly/daily/nightly updates.
• Excellent communication skills, analytical skills, understand business requirements in various domains. Effectively manages time spent on multiple projects to meet deadlines.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, .NET, SQL, TSQL, PL/SQL

RDBMS: MS-SQL Server 2000/2005/2008 , Oracle 9i/10g, Microsoft Access, DB2

IDE Tools: Visual Studio.Net 2005/2008

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008, DTS

OLAP Tools: SQL Server Analysis Services (SSAS) 2000/2005/2008

Reporting Tools: SQL Server Reporting Services (SSRS) 2000/2005/2008 , Crystal Reports, Report Studio

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer.

Markup Languages: XML, HTML, DHTML

Data Modeling: ERWIN, MS Visio, Informatics

Software Testing: Manual Testing, Automation Testing(QTP, Win runner, Roadrunner)

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003, Windows NT, Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

MS BI/SQL Developer

Responsibilities:

• Writing stored procedures, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Experience in creating joins for complex queries involving multiple tables.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, views.
• Involved in query optimization and tuning stored procedures for better performance.
• Configured and maintained Report Manager and Report Server for SSRS and Spotfire.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Created data loads and Upgrade scripts for data migrations and validations.
• Involved SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Building and improving data model (Physical/Logical) to serve different Fund types involved in the module.
• Managing and coordinating releases throughout different environments.
• Debugging and testing support of Module in all environments and coordinating with QA on defects and performance issues.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008, Visual Studio 2008,PL-SQL, Share Point, Liferay, Spotfire, Oracle 10g, MS Access, Windows Server 2003.

Confidential, Sherman oaks, CA

MS BI/SQL Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Experience in creating joins for complex queries involving multiple tables.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Involved in query optimization and tuning stored procedures for better performance.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on different kinds ofTransformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc)inSSISas per the clients Requirement.
• Experience in providing Error handling by using Event Handler for SSIS Packages.
• Worked with different methods of logging in SSIS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Created stylish Report Layouts and Deployed the Reports using SSRS 2005.
• Identified and worked with Parameters using complex expressions for parameterized reports in SSRS 2005.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Hands in improving performance of reports by caching them.
• Created data loads and Upgrade scripts for data migrations and validations.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data warehouse.
• Involved SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point 2007/SharePoint Server.
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.

Environment: MS SQL Server 2005/2008 Enterprise Edition, SSIS/SSRS/SSAS 2005/2008, Visual Studio 2008,PL-SQL, Share Point, Performance Monitor, Query Optimizer, Oracle 10g, MS Access, Windows Server 2003.

Confidential, Irving, TX

MS BI/SQL Developer

Responsibilities:

• Efficiently used Microsoft SQL server 2008/2005, SQL server management studio and BIDS. And participated in designing a data warehouse to store all the information from OLTP to Staging and Staging to Enterprise data warehouse at the center to do better analysis.
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from various RDBMS and Non-RDBMS systems.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoints in SSIS Package model.
• Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
• Created SSIS Packages to load data from transactional system DB2 (SYSTEM21), SQL Server 2005/2000(Gateway System, D2L) to staging (ODS) and staging to Enterprise Data-warehouse.
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
• Created deployment utility to deploySSIS packages over Production, QA and Local System.
• Created ad-hoc packages and used Import/Export utility to load data from QA to Dev Server, Dev to QA Server and Prod to QA for proper packages testing and data validation.
• Defined parent and child relationship by using common table expression for certain Dimension Load.
• Design SSIS package to load data in to DW along with dimensions & facts with the use of slowly changing dimension and maintain the historical data too.
• Created cubes using SSAS on which SSRS Reports were generated.
• Created/edited sales job module in SQL Agent in development and participated in production deployment.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Designed and developed various complex reports such asDrill down, Drill Through, Cross TabbedusingMS Reporting Services.
• Responsible for stylish design layout likePie charts,GraphsandLinked Reports.
• Involved in designingParameterized Reportsand alsocascaded Parameterized Reports.
• Involved in design and deployment ofReport Modelsfor generatingAd-Hocreports as per the client requirements.
• Strong working experience on Multi Dimensional Data Modeling
• CreatedReport SubscriptionusingSSRS 2005.

Environment: MS SQL Server 2008, Windows server 2003, MS Excel 2007/2003, SQL Server Business Intelligent Development Studio.

Confidential, NJ

MS BI/SQL Developer

Responsibilities:

• Performed Server installation and configuration using SQL Server 2008.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views, Rules, Defaults and complex SQL statements.
• 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.
• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Created automated stored procedures for day end operations using SQLServer 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.
• 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.
• Created and monitored database maintenance plans for checking database integrity in SSIS.
• 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.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Used DBCC commands to troubleshoot issues related to database consistency.

Environment: SQL Server 2008, Oracle, MS Access, Excel, Tera Data, Windows Server2008, 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#.

Confidential, San Antonio, TX

MS DBA/BI/SQL Developer

Responsibilities:

• Performance tuning, and optimization of procedures and queries.
• 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).
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Maintain disaster recovery strategies for the database and failover methods.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Have deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2008 in Test environment with 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/2008 as SSIS Packages.
• Created SQL Server Profiler traces & used with 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/2008.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Written DDL / DML Triggers as per company policy.
• Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Rebuilding indexes on various tables.
• Developed database monitoring and tuning strategies.
• Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000 and 2003 servers in very large environments.
• Managing the use of disc space, memory and connection.
• Worked with development teams in the design of physical databases and in modification.

Environment: Microsoft Windows 2003 Advanced Server, Microsoft SQL Server 2005/2008 Enterprise Edition, Microsoft Visual Basic 6.0, SQL LiteSpeed, OLAP, Hardware: Compaq Proliant 8500 Server.

Confidential, NJ

DW/OLAP Developer

Responsibilities:

• Prepared high-level design specification document, Informatica Mapping specification documents for all the Transformations used in the project.
• Developed Informatica Mappings using heterogeneous sources like flat files and different relational databases, Mapplets, Mappings using Power Center Designer.
• Experience with index Analyzer and Query analyzer for SQL 2000. Involved in Backup and Recovery Strategies and Point in Time Recovery.
• Creating, Managing and Troubleshoot SQL Server Agent Jobs.
• Experience in Configuring Linked Servers.
• Hands on experience in Importing and Exporting Data from/to Oracle to SQL Server and other database servers.
• Experience with routine DBA activities like Query Optimization, Performance Tuning and Effective SQL Server configuration for better performance and cost reduction. Installed and configured SQL Mail client for SQL 2000.
• Experience in writing Stored Procedures in DW environment and then created packages in SSIS to load the data into Data Warehouse. SSIS package calls these stored procedures for loading the data.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Extracted and transformed Data from OLTP databases to the specific database designed for OLAP services (was involved in the creation of all objects for that database) on off-peak hours.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2000.

Environment: Informatica 6.2, SQL Server 2000/2005, DTS, Windows 2000, T-SQL, PL/SQL, Crystal Reports, Query Analyzer, Sun Solaris.

Confidential

SQL /Oracle DBA

Responsibilities:

• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers, Primary and Foreign Keys.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.
• Design and Creation of logical storage (Table spaces, Segments etc.).
• Designed E-R Diagrams, logical and physical data modelling.
• Interacting with business users in getting the reporting requirements.
• Created roles and managed roles of Security.
• Performed installations of Oracle 8i and SQL server databases.
• Backup and Recovery of Oracle database using Recovery Manager (RMAN).
• Developed Database Triggers and Stored Procedures for populating and updating data into different tables on ORACLE 8i Database Management Systems.
• Used FTP and SCP for keeping important files safe and secure.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database
• Created tables, indexes, stored procedures and functions.
• Developed and integrated code for enhancement of the application.
• Responsible for optimizing the queries and application tuning.
• Scheduling Jobs and Alerting using SQL Server Agent
• Developed custom reports using Microsoft reporting Services.
• Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database.

Environment: Windows, SQL server, Oracle 8.1.7.0.1/ 9.2.0.1.0 , T-SQL, Query Analyzer, Data Transformation Services.