SUMMARY

• Over 8years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2005/2008/2012
• Experience in Azure SQL server.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
• Good understanding of Hadoop, Pig, Hive technologies, and worked on POC
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Expertise in MS SQL Server databases wif tools such as SQLProfiler, and WindowsPerformanceMonitor for optimal Performance.
• Experience in Interacting wif Business users to analyze teh business process and transforming requirements into screens, performing ETL, documenting and rolling out teh deliverables.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, Loading data from Oracle, DB2, SQL Server,ftp, Excel, Flat Files and XML using DTS, SSIS,
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Experience in data migration (using tools like Bulk Insert, DTEXEC and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server.
• Expertise in creating SQL server Reports using SSRS 2005/2008.
• Experience in PowerPivot and Power BI
• Very good understanding of Amazon Redshift and S3
• Expertise in writing MDX queries
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including teh measure groups and measures, cube dimensions and dimension relationships, calculations.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Experience in generatingDrill through and Drill down reports wif Drop down menu option, sorting teh data, defining subtotals in SSRS.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.

TECHNICAL SKILLS

ETL Tools: Data Transformation Services, SQL Server Integration Services, dashboards tools, web tools.

Databases: MS Access, MS SQL Server 2005/2008/2012 , Oracle8i/9i/10g/11i

Tools: /Utility: SQL Server Management Studio(SSMS), BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio 2010/2012, Team Foundation Server, SharePoint

Big Data: Hadoop, Amazon EMR, Amazon RedShift, Hive, Pig

Data Modeling: Erwin

Programming Languages: C#, Java, VB Script, T-SQL

Reporting Tools: SSRS 2005/2008 R2/2012, Crystal Reports, Report Builder 3.0, Excel 2010(v14..0)Power Pivot.

Operating Systems: Windows server 2008/2008 R2/2012, Windows 2010 advanced server, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, NC

Responsibilities:

• Analysis of existing Data warehouse and DataMart.
• Participated in business requirement meetings.
• Performed GAP analysis.
• Extracted Data warehouse script and checked in TFS and migrated changes to all environments through TFS.
• Monitoring ETL execution on Production Environments.
• Involved in Data warehouse architecture meetings.
• Analysis of existing Cubes and SSRS reports.
• Debugging and fixing current SSIS packages.
• Working on understanding and fixing existing SSRS reports.
• Understood existing monolithic stored procedures and modularized them.
• Created indexes both clustered and non-clustered indexes where every necessary.
• Created teh Cubes and Dimensions.
• Defined relationships between Measure groups and Dimensions.
• Defined granularity wif in a measure group and drill through actions.
• Implemented teh calculations to aggregate physical measures.
• Created various Tables and Views.
• Transformed teh complex business logic and calculations into coding.

Environment: SQL Server 2008/2012,MS Access, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Azure, XML, Visual Team Foundation Server, TOAD

Confidential, Rockville MD

Responsibilities:

• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS
• Migrated reports from Cognos and Micro strategy to SSRS
• Used XML and environmental variables in teh package configuration for Deploying SSIS packages.
• Delegated ETL and Cube jobs to Microsoft Global Delivery Team
• Used visual Studio database project to deploy database objects to different environments.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases.
• Created ETL process using SSIS to transfer data from heterogeneous data sources such as oracle, text files, csv files and ftp
• Responsible for gathering business requirements to create business user reports.
• Worked on performance tuning on existing stored procedures and existing reports for teh faster processing of reports.
• Created SSRS reports on cubes.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Created Table, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Used SQL profiler to view indexes performance to mostly eliminate table scan
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• 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.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created mapping documents and performed code reviews.
• Developed various operational, drill-through and drill-down reports using SSRS.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Used DBCC Statements to perform maintenance tasks on teh database. Executed DBCC commands like CHECKDB before backing up teh databases.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring teh performance of SQL Server databases.

Environment: SQL Server 2012/2008,Oracle, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Azure, XML, MS Excel and MS Access, Visual Team Foundation Server, Crystal Reports, TOAD, ERWIN

Confidential, Washington DC

Responsibilities:

• Built Data marts (Fact and Dimension tables) from teh warehouse tables.
• Created complex calculations to create SSRS survey reports.
• Implemented Safe Harbor rule in statistical bulletin using complex stored procedures.
• Applied complex regression equation to data.
• Generated Parameterized/dropdown SSRS reports.
• Created SSIS packages to migrated data from legacy systems to new data warehouse.
• Prepared ETL design documents for implemented work flows and loaded teh documents in teh project Share Point site.
• Created detailed design and requirements documents wif logic to halp team members understand teh requirements and design.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated test cases to meet teh functionalities deliverables in teh project documentation and specifications.
• Performs design/code reviews to make sure that teh design/code adheres to customers’ standards and meets industry’s best practices.
• Created .net web application to host SSRS reports.
• Used DBCC commands to check physical and logical consistency of teh databases and Rebuild indexes.
• Created indexes to improve teh performance of database.
• Created various Dash Boards using Power Pivot
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Identified and Defined Key Performance Indicators in SSAS 2008.
• Responsible for creating constraints, Indexes, and Views.
• Involved in Data modeling to develop teh database design using Erwin 4.0
• Given presentation of reports to higher officials and incorporated their feedback

Environment: Oracle, SQL Server 2008, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Azure, XML, MS Excel, Visual Team Foundation Server, SharePoint, Power Pivot

Confidential, Jacksonville FL

Responsibilities:

• Analyzed and designed software and database solutions.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Worked on other packages of teh SQL server 2005 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures and triggers.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created data mapping between two distinct models.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in Installation, Configuration of Share Point Form in Cluster Environment.
• Designed and developed Star and Snow Flake Schema.
• Reviewed Cube wif End user and changing teh cube according to their requirements.
• Involved in extracting teh data using SSIS from OLTP to OLAP.
• Created Indexes, Constraints and Rules on database objects.
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve teh efficiency of SQL Server Analysis (SSAS).
• Performed tuning to optimize SQL queries using SQL profiler and query analyzer.
• Created reports wif Analysis Services Cube as teh data source using SQL Server 2005 Reporting Services.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.

Environment: SQL Server 2008, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Azure, XML, MS Excel, Visual Team Foundation Server

Confidential, Raleigh, NC

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
• Gathered business requirements, defined and designed teh data sources, data flows, data quality analysis, worked in conjunction wif teh data warehouse architect on teh development of logical data models.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs 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.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Used XML and environmental variables in teh package configuration for Deploying SSIS packages.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.
• Created Jobs Performance report that queries system tables to track teh duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Designed SSAS cube to hold summary data for dashboards.
• Created User Defined Hierarchies depending on teh business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate teh cubes wif teh data.
• Created different measure groups and calculations using SSAS.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Populated data store wif CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• Successfully migrated content from MS Access to SQL Server 2000,SQL server 2000 to SQL server 2005, SQL Server 2005 to Oracle 10.g,
• Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
• Involved in creating windows installer to install teh application in SIT/UAT/Production environments.

Environment: SQL Server 2008, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, MDX, Azure, XML, MS Excel, Visual Team Foundation Server

Confidential

Responsibilities:

• Created SQL server Analysis Projects using MS SQL Server 2005.
• Created teh Cubes and Dimensions.
• Defined relationships between Measure groups and Dimensions.
• Defined granularity wif in a measure group and drill through actions.
• Implemented teh calculations to aggregate physical measures.
• Used SSASMDX to extract data from cubes and Created MDX script for representing Cube Calculations.
• Created calculated fields wif MDX code to meet additional measures needs that are calculated from existing measures.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• Created partitions (employed storage modes and usage based optimization), calculated members, KPI's and perspectives to enhance teh cube's utilization. Also used MDX to query them.
• Upgraded Analysis Service 2000 to SSAS 2005.
• Identified and Defined Key Performance Indicators in SSAS 2005.
• Maintained Security Role and Database Users.
• Developed SSIS project for transferring teh data.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAPdatabases.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified teh packages accordingly using teh advanced features of SQL Server Integration Service.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLsetc) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed new mappings using SSISLook Up/Aggregation transformations to match teh needs of teh business case.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Analyzed teh project database requirements from teh user.
• Defined aggregations required and granularity available and required in DW.
• Created various Tables and Views.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
• Transformed teh complex business logic and calculations into coding.

Environment: MS SQL Server 2005 Enterprise Edition, MS Analysis Services 2005, Analysis Services 2000, MS Access, SSIS, Erwin 4.1, Windows XP Professional