PROFESSIONAL SUMMARY:

• Having around 7 years of IT experience with extensive implementations in Microsoft SQL Server, Business Intelligence tools like SSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Experience in designing Logical and Physical Modeling using Visio, ERWIN Tool and ER Studio.
• Experience in High Level Design of ETL - DTS Packages &SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Involved in migration of SSRS reports .Proficient in OLTP, OLAP and Data Warehousing Design concepts
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation
• Experience in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2017/2014
• Experience in dimensional data modeling and Cube development, partition, aggregation and optimization using SSAS
• Experience in advanced reporting skills using SQL Server reporting services (SSRS).
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment
• Experience on reporting tools like Power pivot, Power BI, Power View, Tableau, Qlik View
• Created SSIS packages with script task using .net code to perform business requirements which are not provided by default SSIS components
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

ETL developer

Responsibilities:

• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
• Worked with T-SQL to create Tables, View and stored Procedures
• Created triggers on DML actions for security purpose
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables
• Encapsulated frequently used SQL Statements into stored procedures and reduced the execution time
• Scheduled jobs to call the packages and Stored Procedures as per business requirement
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle, Teradata)
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database
• Made dynamic SSIS packages which did data scrubbing, including data validation
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS 2008
• Created Cross-Tab and Sub-Report using RDL
• Promoted RDLs to Reporting Service Server
• Used Visual Source Safe (VSS) for version control.

Confidential, Mc Lean, VA

SQL /Power BI Developer

Responsibilities:

• Responsible for gathering/refining requirements from the business for developing dashboards.
• Worked on Software life cycle development (SDLC) involving in all stages of development.
• 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 Power BI Dashboards and integrated them to share point.
• Used star schema in designing cubes for creating SSAS packages.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Building, publishing customized interactive reports and dashboards, report scheduling using SSRS 2016.
• Implemented and enhanced existing reports like Group By, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.

Confidential

SQL Developer

Responsibilities:

• Worked on Software life cycle development (SDLC) involving in all stages of development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Transferred the data using SSIS packages.
• Worked in Extracting, Transforming and Loading (ETL) data from Sybase database to MS SQL Server by using SSIS 2012.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps) and integrated them to share point.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Migrated old data from MS Access and Excel into SQL Server 2012 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

TECHNICAL SKILLS:

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Databases: MS SQL Server 2012/2008/2005/2000, MS Access 97/2000

Languages: SQL, C, T-SQL, .Net, Visual Basic.

Database Tools: SQL developer, Toad for MySQL & Oracle, SQL*Loader

Operating Systems: Windows Server 2003, Windows 2000 advanced Server, Windows NT/95/XP.

Reporting Tools: SSRS, SSAS, Crystal Reports, Tableau.

Development skills: PL/SQL, SSIS/SSRS, SQL PLUS, Power BI