SUMMARY

• Around 7+ Years of Experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2005/2008/2012/2014.
• Expert in using Microsoft SQL Server products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Experience in gathering user requirements, preparing and analyzing Business Requirement Documents (BRD), Functional Requirement Document (FRD), and propose changes as per various internal and external requirements gathered for process improvement.
• Expert in Data warehousing & OLAP technology.OLTP Experience:
• Developed & supported various mission critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in scripting T-SQL queries, complex stored procedures, user defined functions (UDF).
• Experience in Implementing Change Data Capture (CDC) on databases.
• Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases using DMV’s and DTA.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Test & Deploy code across various SDLC Environments like DEV, TEST and Production.ETL, SSRS and OLAP Experience:
• Integration Services (SSIS):
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Synchronous and Asynchronous Transformations.
• Reporting Services (SSRS):
• Experience in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008/2012 across various environments.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Experience in designing Enterprise reports using SQL Server Reporting Services, generated drill down reports, drill through reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2012.
• Sound Knowledge in designing Parameterized and Cascaded reports.
• Experience in Developing in Data Models and Calculations using Power Pivot.
• Experience in Creating PowerPivot workbooks and Publishing them to SharePoint.
• Analysis Services (SSAS):
• Experience in developing OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.
• Good knowledge in Cube designing and to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Used various third party tools to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps etc.
• Effectively maintained positive and productive working relationships in internal/external and team environments.
• Good leadership and time management skills.

TECHNICAL SKILLS

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

Languages: T-SQL, PL/SQL, MDX, C, C++, C#, Java.

Tools: and Package SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligence Development Studio (BIDS), DTS, SSIS, Visual Studio .NET, Visual SourceTeam Foundation (VSTF), SharePoint, TFS.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS)SQL Server Analytical Services (SSAS), Performance Point Server.

Business and System: MS Project, MS Visio, MS Office Suite (Excel, Word, Publisher, OutlookAnalysis Tools PowerPoint, One Note), MS FrontPage, Rational Rose Requisite Pro.

Application Packages: MS Office, MS Outlook (Microsoft Office Suite).

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, Virginia

SQL/SSIS/SSAS Developer

Responsibilities:

• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Created SSIS Packages to populate data from various data sources.
• Created packages using SSIS for Data Extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules.
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
• Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery.
• Developed database procedures and UNIX shell scripts.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Reviewed Reporting Requirements and Created Aggregated Tables and Stored Procedures for the Dashboard for Management systems.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Handled the database components (Code migration, Change control) for application releases.
• Worked with Data migration utilities (Import & Export - BCP, Bulk Insert) from text to SQL Server.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes
• Involved in Database Administration activities like Back up, Security, Migrations in the Development servers.
• Configured Subscriptions and Security for all critical reports.

Environment: MS SQL Server 2012, MS SQL Server Reporting Services 2012, SSIS 2012, SSAS 2012, SharePoint Server, MDX, UNIX Shell Scripting, Windows 7, MS Office.

Confidential, Houston, TX

SQL BI Developer/SSIS Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams
• Designing Logical and Physical Data Model with Erwin r4.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server
• Wrote variousT-SQLqueries,Stored Proceduresand used them to build packages.
• Involved in designing the physical databases model on SQL Server 2008R2 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing Constraints and Triggers for data integrity in development database.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package Configuration wizard to allow packages run on different environments
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008.
• Developed Complex SSRS Reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed Reports, created Report schedules and subscriptions. Managing and securing reports using SSRS.
• Built Ad-Hoc Reports using SQL Server Reporting Services (SSRS).
• Developed automated notification of Emails, using Unix shell script, to the users in case of failure in the process from time to time
• Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa.
• Work with project teams for upgrading SQL Server 2005 to SQLServer2008R2.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Conducted data import and export operations using the DTS wizard.
• Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.
• Monitored Performance and Fine-Tuned the database objects and server to ensure efficient data retrieval.
• Scheduled the Main Stored procedure on a schedule basis by creating a SQL Server Job Agent and also implemented efficient error handling techniques
• Created and executed unit, functional and integrated testing.
• Responsible for Drafting, Documentation for describing the Metadata and writing technical guides.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.

Environment: MS SQL Server 2008 R2/2008/2005, SQL Server Integration Services (SSIS), SSRS, MS SQL Server 2008 Management Studio, T-SQL, SQL*Profiler, SQL*loader, DTS, Unix shell scripts, Windows 2008/XP, Erwin r4, Windows.

Confidential, Richardson, TX

SQL/ SSIS /SSRS Developer

Responsibilities:

• 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.
• Maintained data integrity by performing validation checks.
• Optimized Queries, Tuned and Monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
• Developed SSIS solution for developing a full-fledged data warehouse solution.
• Developed, monitored and deployed SSIS packages.
• Assisted in migrating denormalized report DB into a Star Schema design.
• Build several Unix Shell scripts for SQL programs to schedule them on Control M
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Responsible for creating the reports basing on the requirements using SSRS 2005.
• Defined the report layout.
• Identified the database tables for defining the queries for the reports.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports and cascaded reports.
• Identified and added the report parameters.
• Deployed the generated reports on to the server.
• Formatted the reports using the Global variables and expressions.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005,MS SQL Server Integration Services 2005,Unix Shell Scripting, Windows Vista, MS Office.

Confidential

SQL Developer/ SSIS/SSAS Developer

Responsibilities:

• Gathered Requirements from the end user and checking the structure of the schema.
• Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
• Updated functional specification and technical design documents.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• Created the data source views for security reasons.
• Involved in defining d Relationships with the measure groups and fact tables.
• Defined Granularity within a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Responsible for scheduling the jobs to streamline and automate cumbersome repeated tasks.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SSAS, SSIS, MS Access.