SUMMARY

• Over 7+ years of IT experience in Database Administration/Database designing and Development using MS SQL Server 7.0/2000/2005.
• Expert of MS SQL Server 2005 suite of Business Intelligence products SSRS, SSIS and SSAS.
• Expertise in scripting T - SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.
• Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Strong experience in working with BCP, SSIS (DTS, DTSX) packages for Data Integration Services.
• Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Expertise in creating Property Expressions, Script Tasks for SSIS packages.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Good experience building Star schema and Snowflake schema depending on the business data requirements.
• Involved in Full Life Cycle Implementation of Data Warehouse.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience in Diagnosing and Troubleshooting performance issues in sql using DMV’s and DTA.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Excellent communication, interpersonal and analytical skills.

TECHNICAL SKILLS

Operating System: Windows NT/98/2000/XP/2003 server

Languages: Pascal, C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL,HTML,XML

Tools: DTS, SSIS,SSRS,SSAS, Erwin

DATABASE: MS Access, MS SQL Server 7.0/2000/2005/2008 , Oracle8i/9i/10g, DB2

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio 2003/2005

Software: MS Office, Visio, MS-Project 2000

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth TX

SQL Server Developer/ SSRS/ SSIS/ SSAS Developer

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Used XML and environmental variables in the package configuration for Deploying SSIS packages.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Designed SSAS cube to hold summary data for Targit dashboards.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• Successfully migrated content from MS Access to SQL Server 2000,SQL server 2000 to SQL server 2005, SQL Server 2005 to Oracle 10.g,
• Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
• Involved in creating windows installer to install the application in SIT/UAT/Production environments.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2000, .Net 2002, MS SQL 2005/2008,SSIS,SSRS, Windows 2000 Advance Server, ASP, VB .Net, XML, T-SQL, MS Excel, SharePoint Portal Server 2003/2007, Targit, MS Access. Visual Studio 2005, Oracle 9i/10g

Confidential, Torrance CA

MS SQL Server Developer/SSRS/ SSIS/SSAS Developer:

Responsibilities:

• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints
• Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Created SSIS packages to get data from different sources, consolidate and cleanse the data and merge it into one single source.
• Scheduling Jobs and Alerting using SQL Server Agent.
• 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.
• Responsible for ETL operations using SQL Server Integration Services (SSIS) and Worked with users in training and support and also has experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Built SSIS Packages for Processing cubes and Dimensions.
• Developed Custom Sales, Inventory and financial reports for seasonal, quarterly, monthly and weekly using SSRS.
• Developed various kinds of Tabular, Matrix, Drill-down, Drill-through, Charts, and web receiving reports using SSRS.
• Responsible for scheduling the reports based on the subscriptions defined.
• Generated and formatted Reports using Global Variables, Expressions and Functions, designed and implemented stylish report layouts.
• Responsible for creating dimensional and fact tables and building cubes using SSAS.
• Responsible for maintaining and tuning existing cubes using SSAS.
• Worked with the Planning team to forecast the business requirements.
• Experience in Designing, building the Dimensions, Cubes on star and snowflake schema using SQL Server Analysis Services (SSAS) for business analysis.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in developing applications using ASP .NET /C# /SQL Server.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.

Environment: .NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2000, SQL Server 2005, SSIS, SSRS, SSAS,VisualStudio.NET IDE.

Confidential, Greenville SC

MS SQL Server Developer/SSIS/SSAS Developer

Responsibilities:

• Created T-SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.
• Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Created Drill Through and Various Cross tabbed reports using SSRS.
• Developed various kinds of Tabular, Matrix, Drill-down, Charts, and web receiving reports using SSRS.
• Defined calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created the Cubes and Dimensions.
• Upgraded Analysis Service 2000 to SSAS 2005.
• Identified and Defined Key Performance Indicators in SSAS 2005.
• Defined relationships between Measure groups and Dimensions.
• Conceptualized and Designed Logical and Physical Data Models using ERWIN.
• Analyzed the project database requirements from the user.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
• Transformed the complex business logic and calculations into coding.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Worked with Exception handling with @@error and with Try/catch.
• Defined granularity with in a measure group and drill through actions.
• Maintained Security Role and Database Users.

Environment: MS SQL Server 2005 Enterprise Edition, MS Analysis Services 2005, Analysis Services 2000, MS Access, SSIS, Erwin 4.1, Windows XP Professional, MS-Access, Oracle 9i.

Confidential, Overland Park KS

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with end users in designing and creating the Global Enterprise Data warehouse.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.
• Managed Up gradation of DTS packages to SSIS packages.
• Involved in the complete data warehouse development life cycle and solely responsible for the design, development and maintenance of 8 cubes.
• Implemented transactional replication among different servers.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed application and database code production pushes, following production release procedures.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.
• Audited and enforced database security, code and procedural standards.

Environment: MS SQL Server 2000, MS Analysis Services 2000, MS-Excel, DTS, Visual Studio.Net 2003

Confidential, Atlanta GA

MS SQL Server Developer /SSRS

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures & Triggers
• Was involved in writing Triggers and Stored Procedures.
• Actively involved in Normalization & De-normalization of database.
• Was involved in performance tuning of the Database
• Used SQL Profiler and Data Base Engine Tuning Advisor to performance tune the Database.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created User logins at the server level.
• Created logins, roles, and groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Developed custom reports using Microsoft reporting Services.
• Created Stepped and Block reports using Microsoft reporting services
• Created Drill Through and Various Cross tabbed reports using Microsoft reporting services.

Environment: SQL Server 2000, Enterprise Manager, UML, MS Project, Windows 2003 Server, .NET, C#, ASP.NET, DTS, Microsoft reporting Services.

Confidential

SQL Server Developer/SSIS developer

Responsibilities:

• Designed, coded, tested and implementeduser interfaces, procedures and functionsfor new and existing softwareapplication requirements.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Install, tune, maintain and monitor SQL Serverfor the Production environment
• Created DTS package to get data from different sources, consolidate and merge into one single source.
• Created variety of reports for business to provide them with critical information about business status.
• Actively involved in Normalization & De-normalization of database.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Involved in System testing.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.

Environment: SQL Server 2000, Access 2000 & Windows 2K platform ADO.NET, MS Project