PROFESSIONAL SUMMARY:

Over 7 years of experience in Database Design, Development, Implementation and administration of SQLSERVER 2008/2005/2000 and providing ETL/Business Intelligence solutions using Microsoft components. Good team player with strong analytical skills and communication skills.

SQL Server Development:

• Extensive working experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

Analysis Services (SSAS):

• Proficient in designing Data Mart and DataWarehouse using Erwin Star and Snowflake Schemas.
• Wide experience in creating OLAP cubes, identifyingdimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
• Hands on experience in creating the MDX cubes and dimensions.
• Used DMX to create data-mining models.
• Well versed in using multi dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing reports from Multi Dimensional OLAP Cubes.
• Good Knowledge on creating scorecards and dashboards using MS Office performance Point Server (MS ProClarity Analytics) Dashboard Designer and integrated them with SharePoint Web Services.

Integration Services (DTS/SSIS):

• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle,Teradata and DB2) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.
• Involved in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• Experience in implementing functionality using C#.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• ETL implementation using SQL Server Integration Services (SSIS).
• 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 configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Reporting Services (SSRS):

• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• 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.

Worked with report manager for deploying the reports across all the environments.

Technical Skills

SSRS, SSIS, SSAS, MS Visio, Erwin, Crystal Reports XI, ProClarity, Performance Point Server.

Tools: & Packages

SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligent studio (BIDS), DTS, Crystal Reports9.0, Visual SourceSafe6.0, Visual Studio .NET, ETL, Spotlight.

RDBMS

MS SQL Server 2000/2005/2008, MS Access 97/2003/2005/2008, Oracle 8i/9i/10g.

Language

T-SQL, PL/SQL,MDX, DMX, C, VB.net, C# (.NET)

Operating Systems

Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.

Application Packages

MS Office, MS Outlook, Windows SharePoint Services.

Educational Qualification:

Bachelors of Science

Professional experience:

Confidential

SQL Server BI Developer

Location: Plano, TX

Role & Responsibilities:

• Designing and modifying database including creating tables, finding proper indices and primary keys which support requirement and improve performance.
• Loading delimited files, looping through OS directory structures and files within a directory and created SSIS packages to extract the data.
• Created SSIS packages for pulling large volume of data into data warehouse using SSIS packages and Staging stored procedures implementing business requirements.
• Used C# in script tasks for implementing some functionality.
• Implemented error handling and logging in all SSIS packages and deployed using file system deployment.
• Created CLR objects using C# in SQL server.
• Created SSAS project in 2008 R2, added new dimensions, and facts inside BIDS.
• Created new Hierarchies and semi additive measures using new features in SSAS 2008 R2 and calculated Measures using MDX implementing business requirement.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Created complex SSRS reports on merchant data like total transaction details, totals per processor etc
• Used Shared Data Sets and new features in SSAS 2008 R2 for creating reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Writing code and creating jobs to automate repetitive tasks.
• Processed SSAS Cube after refreshing data in Prod with all upgraded SSIS packages.
• Troubleshooting performance issues and fine-tuning queries and stored procedures

Environment: SQL Server 2008 R2, SSIS, SSRS, SSAS, SSMS, PL/SQL, C#,UNIX, T-SQL, ERWIN 4.0, Team Foundation Server, CITRIX, Windows XP.

Confidential

SQL Server Developer/SSIS Developer/SSRS Developer

Location: Dallas, TX

Role & Responsibilities:

• Involved in system analysis & design of the Enterprise data warehouse implementation.
• Presented developed projects and use cases to the manager and co workers.
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Index, Views, Complex Stored Procedures, Triggers, Cursors andappropriate User defined functions to implement the business logic.
• Creation of database tables and procedures to update and clean the old data.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
• Developed OLAPcubes using SSAS and calculate the metrics that were revealed in the functional analysis.
• Expertise in Software Development Methodologies like SDLC and Agile methodologies.
• Created MDX script for representing Cube Calculation using SSAS.
• Developed several MDX calculations to get the weighted averages for metrics such as Weighted Average Gross Margin, Weighted Average Term
• Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Proficient on and designing Dimensional modeling or Kimball methodology and Data Warehouse using Erwin in Star and Snowflake Schemas.
• Wide experience in Creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005).
• Extraction, Transaction and Loading was done using different Components and different expressions using Ab Intitio.
• Extensively used Ab Intitio for ETL processing.
• Used data stage designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Well-versed in using multi dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing Reports from Multi Dimensional OLAP Cubes.
• Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2005.
• Development of Data Source, Info Objects, Info source, Cubes.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Using Try Catch to write logic separate action and error handling code
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance

Environment: SQL Server 2005/2008, SSIS, SSRS, VB.Net, UNIX, ASP.NET (2.0), T-SQL, ERWIN 4.0, Team Foundation Server, CITRIX, Windows XP.

Confidential

SQL SSIS Developer/SSRS Developer/DBA

Location: Jersey City, NJ

Responsibilities:

• Responsible for Requirements gathering, BusinessAnalysis and Design.
• Prepared technical specifications for the development of SSIS (ETL) packages to load data into various target tables and defining ETL standards.
• Created logical and physical data models using Erwin.
• Extracted Data using SSIS from Oracle, flat files, Excel and XML files performed transformations and loaded the data in to SQL Server Data warehouse for E-File Payment application.
• Implemented SSIS with SQL Server stored procedures for data manipulations.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings.
• Writing business and data access components (as separate assemblies) in C# utilizing ADO.NET transaction management.
• Responsible for transferring the data using SSIS packages from OLTP to OLAP.
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type I and type II changes.
• Worked on SSIS, for removing duplicate records with data standardization.
• Created mappings for conditional split, merge, merge join, export column, import column, audit and SCD transformations.
• Created Data Conversion package which converts columns to different types and adds columns to datasets.
• Working on Hash functions and checksum for loading large amount of data on Target system.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the ETL loadings.
• Created maestro schedules/jobs for automation of ETL load process.
• Configured SQL Mail agent sending Automatic emails when a SSIS Process is failed or succeed.
• Preparing and using test data & test cases to verify accuracy and completeness of ETL process.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services (SSRS).
• Generated various reporting services RDL'S using SSRS for Financial DW reports.
• Used SSRS to create customized reports and ad hoc reports.
• Create reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts
• Created Period reports: shift or daily report, weekly, monthly and annual reports, till and employee reports.
• Developed Reports with different styles using Table, Sub Reports and Matrix.
• Experience in installation, upgrade and configuration of MS SQL Server in clustered and Non Clustered environments.
• Experience in Tuning SQL queries & improving the performance of the Database.
• Vast experience in creating maintenance plans, Jobs, Sending Alerts using SQL Mail.
• Designed backup strategy and implemented Log shipping for disaster recovery.
• Performed all aspects of database administration, including backups andrecovery.

Environment: SQL Server 2005, SSIS, SSRS, C#. Net, ASP.NET (2.0), T-SQL, Windows XP, ERWIN 4.0, Oracle 10g, Microsoft Source safe, Unix

Confidential

SQL Server Developer

Location: St. Louis, MO

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Developed several MDX calculations to get the weighted averages for metrics such as Weighted Average Gross Margin, Weighted Average Term
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Provided via the phone, application support. Developed and tested Windows command files andSQLServerqueries for Production database monitoring in 24/7 support.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models using ERWIN.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administering SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk I/O and Networking).
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Environment: MS SQL Server 2005/2000/7.0, DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, Erwin, MS Visual Source Safe, FTP Communication, MS-Visual Studio, Oracle 10g, UNIX, XML,XSLT, ADO.Net.

Confidential

SQL Server Developer

Responsibilities:

• Designed and Implemented an ETL framework using SQL Server Integration Services (SSIS).
• Designed a Master Data Management solution for the Strategic Business Unit with over 10,000 active oil wells.
• Designed multiple data and application databases for various applications across the enterprise.
• Provided solutions based on Enterprise Architecture for numerous business projects.
• Designed and developed over 100 Entity / Business services adhering to Enterprise SOA guidance and Industry Standard Interfaces such as PRODML, WITSML and MIMOSA.
• Played a key role in a Business Intelligence (BI) Portal project that involved Data Integration (SSIS), Data Analysis (SSAS) and Reporting (SSRS, Performance Point Server 2007 and Excel 2007).
• Wore multiple hats such as Solution Architect, Service Architect and Project Manager at various junctures during the project lifespan.
• Solved numerous SQL Server performance bottlenecks by working closely with the Chevron IT Team and received multiple appreciation awards.
• Source System Analysis and Investigation that leads to Source to Target documents.
• Built a Data Warehouse with Kimball philosophies.

Environment: Windows XP/2000, SQL Server 2000/2005, MS Office Suite, SQL, T-SQL, DTS Packages, SSIS, SSRS, SSAS, ETL Framework, Performance Tuning, Data Warehousing Concepts.