SUMMARY

• 8 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.
• 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 monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Test & Deploy code across various SDLC Environments like DEV, TEST and Production.
• 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.
• 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.

ETL Tools: Data Transformation Services (DTS), SSIS, Informatica

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, MD

SQL BI Developer

Responsibilities:

• Gathered Business Requirements from HCA, Health care Analytics and involved in Analysis, design development and deployment of the QSC Reports for the year 2016.
• Analyzed the specifications provided by the client and gathered the requirements for design and development
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS
• Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from data sources.
• Extracted data from internal data warehouse system to SSRS
• Designed and configured SSIS packages to migrate the important data from Oracle, legacy System using various transformations.
• Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures
• Validated and tested all packages on development server
• Coding, troubleshooting and performance tuning SQL and complicated SSIS packages.
• Generated customer reports using SQL Server Reporting Services 2012/2008R2from the OLTP data sources.
• Involved in Building SSRS reports to generate PDF reports
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
• Generation of Drill Down reports which have the combination of Stored Procedures and Portal Development
• Source SSRS reports and Stored Procedures after Cube Development is complete
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option pdf reports
• Portal calls Reports service to fetch the details of the reports. Drill Down/Stored Procedure reports are displayed in front end UI
• 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.
• Created report snapshots and cache for better performance.

Environment: MS SQL Server 2012, Visual Studio 2008, SSRS, SSAS, SQL Server Stored Procedure, SharePoint, Windows7

Confidential, Virginia Beach, Virginia

SQL BI /SSRS/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 Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• 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.
• Developed SSIS solution for developing a full-fledged data warehouse solution
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes
• 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.
• Involved in Database Administration activities like Back up, Security, Migrations in the Development servers.
• Configured Subscriptions and Security for all critical reports
• Followed Agile Methodology to Implement the Application.

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
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications.
• 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.
• Created Informatica mappings with PL/SQL Procedures / Functions/ Triggers to build business rules to load data
• 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, Window

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.
• Worked Extensively with MSBI - SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
• 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.
• Created packages using MSBI (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• 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.
• 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

MSBI 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.
• Worked on MSBI (SSRS) in developing the reports such as Data Bar Reports, Drilldown Reports, Dashboard Reports, Map Reports, and Pie chart Reports, Parameterized reports.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Responsible for scheduling the jobs to streamline and automate cumbersome repeated tasks.
• Modified the existing MSBI (SSIS) packages to meet the changes specified by the users.
• 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.