SUMMARY

• Over 8 years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005/2000.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Extensive experience in T-SQL to write: stored procedures, triggers, functions, CTE’s, Cursors, Indexes and relational database models.
• Excellent Experience in monitoring SQL Server Performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.
• Expertise in Extracting, Transformation and Loading (ETL) data using Bulk Copy Program (BCP), Import/Export data, DTS packages and SQL server Integration (SSIS).
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Expert in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Excellent Experience in creating OLAP cubes using SQL Server analysis services (SSAS).
• Hands on Experience in Extracting, transforming and loading data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Excellent experience in developing SSRS reports using Global variables, Expressions and Functions for the business users.
• Extensive experience in creating several reports such asDrill Down Reports, Parameterized Reports, Linked Reports, Sub Reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services.
• Knowledge on relational database management (RDBMS) concepts and experience in creating XML files and XSD schema files.
• Good knowledge of Data Marts, Data warehousing, OLTP, OLAP, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

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 2008R 2/2008/2005/2000 (SSRS), MSSQL Server Analysis Services 2008R2/2008/2005(SSAS), MS SQL Server Integration Services2008R2/2008/2005 (SSIS), Data Transformation Services (DTS), Oracle 8i/9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler.

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

Version Control & Web Servers: Team Foundation Server (TFS), Visual SourceSafe (VSS) &IIS 6.0, Apache, SharePoint & Performance Point Server.

IDE, BI Tools: Datamodeling Tools

Design Methodology: SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2005 & Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose Unified Modeling Language 1.1 using Rational Rose.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SQL Server Business Intelligence Developer (SSIS/SSRS)

Responsibilities:

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2012 and Flat files
• Used Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Actively involved in upgrading from SQL Server 2008 to SQL Server 2012.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Worked on designing and creating Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Worked in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
• Involved in Planning, development, and testing of disaster recovery strategies and procedures to restore the production environment to a production state
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Used Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Involved in design, programming, deploy and Unit Testing of requested Reports.

Environment: SQL Server 2012/2008 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Kansas City, MO

MS SQL Server/ Business Intelligence Developer

Responsibilities:

• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Worked on analyzing the existing reports in Report.Net, Actuate and their data sources
• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Created queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Parameterized and Cascading Parameterized reports were designed and analyzed using SSRS.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Generated various reports by comparing the growth of sales based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of sales with respect to customers.
• Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• 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.
• Used Visual Source safe for repository and maintaining versions.
• Extensively used formula fields, parameter fields, Running Total, Group selection and record selection in Crystal reports for writing new formulas.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Environment: MS SQL Server 2008 R2, Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Microsoft Performance Point Server 2007, Microsoft Share Point Server, T-SQL, NET, C# MS Access and Excel.

Confidential, Indianapolis, IN

MS SQL Server Developer/ SSRS/SSAS/SSIS

Responsibilities:

• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Migrated data between heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• UsedSQL Analyzerand Profiler for monitoring the SQL statements and procedures.
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2008 r2.
• Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.
• Optimized theT-SQL query performancewith modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Worked with Logical and physical models in Erwin
• Expertise in forward and reverse engineering using Erwin.

Environment: T-SQL, MS SQL Server 2008, MS SQL Server Analysis Services 2008, MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008.

Confidential, Westlake Village, CA

BI/SQL server Developer

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Interact with ODS, Data warehouse and Salesforce teams to understand the source/target systems.
• Develop the audit process to evaluate the source systems for data integrity and availability.
• Designed and developed stored procedures, functions (UDF), views, joins and sub-queries to support the ETL rule component for the merger process.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Worked extensively with SSIS transformations such as lookup, derived column, data conversion, aggregate, conditional split, SQL task, script task and send mail task.
• Implemented C# scripting to validate the different source systems like flat file, excel and also provide the dynamic error message to business analyst by using task factory tasks.
• Implemented full and differential backups and also created and managed DB objects
• Created the test scenarios and test scripts for data quality assurance and maintenances.
• Work around with production services team to promote the ETL objects across the different environments and create the workflow job plans.
• Develop the data source files for easily deployment of ETL objects across different environments.
• Review and implement performance strategies on ETL solutions to run with in the expected time intervals.
• Responsible for providing design and implementation document about how to handle the early facts in the data warehouse environment.
• Documented of all processes involved in maintaining the database for future reference.
• Troubleshooting Database performance issues and implementing necessary database changes
• Attend the daily scrums to present the status and highlight if any road blocks.

Environment: Microsoft SQL Server 2008R2 Enterprise edition, SISS, DTS, SSRS, BIDS, visual C#, and MS Excel 2007.

Confidential

Application/SQL server Developer

Responsibilities:

• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Followed and maintained standards and best practices in database development.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Involved in tuning of database by creating efficient stored procedures and T-SQL statements.
• Development of Business rules implemented as Constraints, Triggers and or Stored Procedures.
• Created Clustered and Non-Clustered Indexes for improved performance.
• Documented the data flow and the relationships between various entities.
• Created new Database logical and Physical Design to fit the new business requirement and implemented the same using SQL Server.
• Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Developed new Stored Procedures, Functions, and Triggers.
• Implemented Backup and Recovery of the databases.
• Actively participated in User Acceptance Testing, and Debugging of the system.

Environment: MS SQL 2000/2005, Windows 2000/XP, SQL Query Analyzer and Enterprise Manager, MS Access 2000 & Windows NT platform.