SUMMARY

• Over 7 years of IT industry experience with Design and Technical Management using Microsoft SQL Server 2000/ 2005/2008/2008 R2/2014, SSIS/SSRS/SSAS, OLAP as SQL Developer and Data Warehouse Implementation/development for Pharmaceutical, Finance, Health Care, Telecommunications and Sales (POS) business sectors.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Solid understanding of RDBMS database concepts and experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation and have excellent knowledge of DDL and DML in T - SQL.
• Very good understanding and experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
• Experience in SQL Server Data Transformation Services (DTS) and SSIS (Integration Service) package design, constructing, and deployment.
• 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).
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in Data Modelling, Normalization and building Referential Integrity Constraints, Database Design, and Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2005/2008/2008 R2/2012/2014 for both OLTP & Business Intelligence applications.
• SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• Thorough understanding of Kimball’s’ theory, KPIs, SQL Architecture.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, handling parameterized reports, defining subtotals in SSRS.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Developed reports using global variables, expressions and functions using SSRS.
• Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, FrameworkManager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Excellent knowledge on Object Oriented Analysis and Design concepts.
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes
• Extensive experience of designing and developing software applications with the .NET Framework 1.0/1.1/2.0/3.0/3.5 using C#, ASP.NET and VB.NET.
• Strong understanding of Framework Manager, Query Studio and Report Studio for Model design, ad-hoc reporting and advanced report authoring.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

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

Languages: T-SQL, PL/SQL C, C#, .NET, VB.NET, Visual Basic 6.0, HTML, XML

Databases: MS SQL Server 2000/2005/2008/2014 , MS Access, MS Excel, Oracle 8i/9i

BI Tools: SSIS, SSAS, SSRS, Crystal reports, Business Objects, Import/Export wizard, TFS, Tableau

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence(SSBI) Enterprise Manager, SQL Profiler, Query Analyzer, Data Transformation services (DTS), MDX scripting, ODBC

Dimension Data Modeling: Star Join Schema Modeling, Snow-Flake Modeling, Erwin 7.2/4.5, MS Visio, Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential, Conway, AR

SQL Developer SSIS/SSAS/SSRS

Responsibilities:

• Collected business requirements from users and translated them as technical specifications and design documents for development.
• Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.
• Used Recursive CTEs while creating multiple complex stored procedures for various purposes like database maintenance, index maintenance, auditing, data profiling.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• 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-Report using RDL.
• Formatted the SSRS reports using the Global variables, expressions and Functions.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) 2008 and Worked with users in training and support and also have experience in incremental data loading.
• Migrated from DTS packages to SSIS packages
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Experienced technical support, troubleshooting, report design and monitoring of system usage using Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Involved in Analysing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX. Identified and defined Fact relationships in SSAS.
• Scheduled and monitored various jobs like package execution and cube processing using the SQL Server Agent.

Environment: SQL Server 2008/2005 Enterprise Edition, SSRS, SSIS, SSAS, SQL Server 2005 Partitioning, Visio 2003, MS IIS, Tableau, Windows 2000/2003 Advance Server, C#, HTML, XML, MS Excel, Access and Visual source safe.

Confidential, Minnetonka, MN

SQL BI Developer SSIS/SSRS/SSAS

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Transferred data from various data sources systems including MS Excel, MS Access, Flat Files to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with Incremental load.
• Created logging 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.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters) to minimize the report execution time and to limit the no of records required.
• Created Crystal reports in visual studio 8.0 and worked on all types of report like tables, matrix, charts, sub reports etc.
• Developed dimensional model, DTS solution, Analysis Services cubes and ProClarity
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in dimensional modeling (Star &Snowflake) and creating the Data Source Views (DSV), Cubes using the identified Fact and dimension tables.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.

Environment: MSSQL Server 2008/2005, Visual Studio 2005. Reporting Services (SSRS 2005/2008/2008 R2), Business Intelligence Development Studio (BIDS), MS Office 2007, MS Access, SQL Server Analysis Services (SSAS), ETL, Performance Point Server 2007, ProClarity, Visio, MS Excel.

Confidential, Arlington, TX

SQL Developer/DBA

Responsibilities:

• Created Indexes on columns having high selectivity and low density to speed the execution of data retrieval queries and stored procedures.
• Wrote stored procedures, triggers, and constraints to ensure data integrity, data consistency and to meet the business rules.
• Converted various T-SQL statements into stored procedures thereby reducing the number of database accesses.
• Created T-SQL triggers, tables, views and SQL joins and queries for the application.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Implemented constraints on tables. Database tuning and performance planning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Developed SQL Server Stored procedures and SSIS packages to extract data from database.
• Involved in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS 2008/2012), DTS, Bulk Insert and Bulk Copy Program utility.
• Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Performed query optimization and checked performance tuning.
• Created joins and sub-queries for complex queries involving multiple tables.
• Proper use of Indexes to enhance the performance of individual queries and enhance the StoredProcedures.
• Created SSIS packages for transferring the data from different systems.
• Designed and implemented DTS package for data transformation and migration.
• Design and developing SSIS packages to import data from various large volume encrypted files into SQL database for data warehouse.
• Transformed data from various data sources using OLEDB connection by creating various DTS packages.
• Responsible for cleaning the data and maintaining the accuracy and quality of the data load from the files into the database objects.
• Created linked servers for data retrieval using OLEDB data source and providers.

Environment: Microsoft SQL Server 2008, Windows Server 2003, SQL Profiler, SSIS, BIDS, Performance Tuning, Visual Studio, VB.Net, T-SQL.

Confidential, Austin, TX

SQL Server Developer/DBA

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2005.
• 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 withcoding,designandperformance tuning.
• Involved in Security Administration in creating Schemas, Logins, Users, Roles, granting permissions.
• Data extraction, translation and loading (ETL) using DTS from a wide range of sources Excel, flat file, DB2 and Oracle.
• Implemented different types of Replication Models, Database Mirroring modes and Clustering environments (active/passive and active/active) to further increase scalability and stability of business critical systems.
• Maintained the Security on multiple servers and multiple databases with Windows authentication and SQL authentication.
• Exposure to .NET Framework (V3.5, V3.0, 2.0)
• Expert in Designing, testing and implementation of high availability solutions of databases for large, medium and small customers.
• Managed user-access, created and managed new security accounts. Backupandrestoredatabases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created theDTSPackagethroughETLProcess 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.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005/2008, T-SQL, DTS Designer, SQL Server Management Studio, MS-Office, Ms-Excel, VSS, SSIS, SSRS.

Confidential 

SQL Server Developer

Responsibilities:

• Participated in development efforts to analyze client server applications using Visual Basic 6.0 as front-end tool and MS SQL Server Database.
• Involved in converting existing SQL stored procedures, triggers, functions and script to T-SQL.
• Performed data extraction from OLTP to OLAP for decision making using SSIS. Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved.
• Performed Data validation Checks during Staging, and then loaded the data into the Data warehouse.
• Implemented error handling and roll back process in ETL load
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.
• Created cascaded parameterized reports, drill down, and drill through reports using SSRS.
• Deploying SSRS Reports across multiple environments including Test, Production and supporting environments.
• Involved in Database Administration activities like Back up, Security, Migrations in the Development servers.

Environment: MS SQL Server 2000/2005, T-SQL, SQL SSIS, SSRS, Visual Studio 6.0, MS Excel, Data Analyzer, Visual Studio 2005, Advanced Windows 2000 Server.