Sql Server Data Analyst
Resume:
Professional Summary
Over * years of IT experience in database design and development in Microsoft SQL Server Suite of Products.
Expert in working with the BIDS and SSDT which includes SSIS, SSAS and SSRS.
Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
Extensively used Proc SQL for highly advanced matching and merging between large datasets.
Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
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 Control flow, Data flow, Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
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.
Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
Experience with data warehouse concepts and implementation to provide reporting solutions for the organization. Including experience with slowly changing dimensions, star schemas, conformed dimensions.
Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling. FACT & Dimensions tables and Logical & Physical data modeling.
Developed Linked, Drill Down, Drill Through and Sub Reports using SSRS.
Design functional specs for BI front end applications including dashboards and reporting, considering appropriate data flow and capture.
Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
Designed Subscriptions and Security for Reports.
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
Experience in writing reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power Query, Power View.
Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing.
Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.
EDUCATION: Bachelor of Technology in Computer Science from JNTU University, India
Technical Skills
Languages
T-SQL, C, C#, Python
Databases
SQL Server 2012,2008/2005, MS Access, Teradata, Oracle, DB2 and MySQL
Tools
SSIS, SSAS, SSRS, Tableau, Visual Studio 2010/2012/2015, Microsoft Test Manager, Team Foundation Server, Rapid Miner, MS Project
Reporting Tools
SSRS, MS Excel, Oracle Report Builder, Power BI, Power View.
Application Packages
MS-Front Page, Microsoft Office Suite, SSIS, SSAS, SSRS,MDX.
Operating System
Windows 7/8/10,
Professional Experience
Inovalan, Bowie, MD Apr’15 to Present
Sr. MSBI Developer/SSIS/SSRS/SSAS
Responsibilities:
Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
Created ETL Projects using SSIS 2012 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
Developed SSIS packages that fetches files from FTP, did transformation on those data base on business need before I loaded to destination.
Created ETL process using SSIS to transfer data from heterogeneous data sources.
Expertise in creating Metadata tables to log the activity of the packages, errors and change of the variable. Various techniques such as CDC, SCD and Hash bytes were used to capture the change of the data and execute incremental loading of the dimension tables
Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
Acted as single point of contact for support of SSIS packages in production. Collaborated with external teams and partners to resolve production issues
Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
Configured and Tuned SQL Server 2012 Analysis Services (SSAS) Tabular and Multi-Dimensional Cubes
Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
Robust audit and notification functions were designed in the packages.
Created Reports on top of the cubes.
Expertise in creating SQL code for extracting, summarizing, aggregating or presenting data from database systems using report writer.
Designed SSAS cube to hold summary data for Target dashboards. Developed Cube with Star Schema.
Expertise in SQL Server Reporting Services (SSRS), Created Tabular, Matrix, Drill Down, Bar Chart reports to analyze critical data in SSRS.
Experience in writing reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power Query, Power View, Power BI.
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.
Environment: SQL Server 2012R2, T-SQL, MS Office, Visual Studio 2015, SQL Server Management Studio, SSIS, SSRS, SSAS, Power BI
Duquense Light, Pittsburg, PA Oct’14 to Mar’15
Sr. MSBI Developer/SSIS/SSRS/SSAS
Responsibilities:
Involved in the migration of the data across different databases and different servers using SSIS, Import/export tools.
Tested to optimize the procedures and triggers to be used in production
Creation of new database, planning the location of data, index, and transaction log files on the disks
Created custom data flow items for different SSIS packages using the VB.Net script.
Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
Worked on performance tuning of T-SQL queries and Stored Procedures
Deployment and End-to-End testing of Tabular Models.
Extensively used Proc SQL for highly advanced matching and merging between large datasets.
Developed Shell scripts to extract data from the URLS for specific exchanges.
Assisted in development by recommending alternative solutions to technical problems for the business people.
Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages. Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions
Configured and Tuned SQL Server 2012 Analysis Services (SSAS) Tabular and Multi-Dimensional Cubes
Experience in creating named Queries and Named calculations in Data source views
Created SSAS cubes using various dimensions and measure groups
Worked on performance tuning of SSAS cubes by creating partitions and hierarchies
Deployment and End-to-End testing of Tabular Models.
Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.
Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
Environment: MS SQL Server 2008R2/2012, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, Facets, Microsoft Access.
AT&T Inc., Atlanta, GA Oct ‘13 to Sep’14
BI Developer/SSIS/SSRS/SSAS
Responsibilities:
Created SSIS packages to integrate data from text files and excel files and file Transfer from one location to the other using FTP tasks
Performed Normalization and De-Normalization techniques from both OLTP and OLAP system in creating Database objects
Used control flow tasks like For Loop Container, for each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks
Designed and Developed matrix, tabular and parametric Reports using SSRS.
Developed Tabular Reports, Sub-Reports, Matrix Reports, drill down Reports and charts using SSRS
Created dash board to show the business performance.
Created partitions and designed aggregations in Cubes.
Performed sorting, formatting and grouping to custom reports in SSRS and published reports to the report server virtual directory
Created ETL package for data conversion using various transformations tasks.
Created Cubes from which data can be retrieved rapidly by enterprise information consumers.
Created perspectives in SSAS and configured security levels for the Cubes.
Designed KPI's in SSAS and imported them to Excel.
Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
Designed Subscriptions and Security for Reports.
Developed Linked, Drill Down, Drill Through and Sub Reports using SSRS.
Work with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions.
Design functional specs for BI front end applications including dashboards and reporting, considering appropriate data flow and capture.
Environment: SSMS- Enterprise Edition, T-SQL, SSDT (SSIS, SSRS, SSAS), XML, Agile, Microsoft Visual Studio 2010 w/.NET Framework 3.5
State Bank of Hyd, Hyderabad June’11 to Sep’13
SQL Server Developer/ETL Developer
Responsibilities:
Involved in writing complex SSIS Packages to Load Data into both OLTP and OLAP systems.
Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS
Extensively used various control flow tasks like FTP, Bulk insert task, Transfer job task etc. and different data flow tasks like merge join, look up, data conversion etc.
Gathered user requirements from users and managers to better understand the business logic of the company and create database that fits their needs
Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/ DTS packages.
Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters, and Cascading Parameters.
Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks
Preparation of project documentation.
Created SQL server Reports using SSRS. Identified the data source and defined them to build the data source views.
Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then we use conditional split to select that new records before inserting into the database.
Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.
Detection and resolving of blocking and deadlocks using Profiler.
Designed the system architecture that is used to structure, plan, and control the process of developing an information system.
Used Recompile and with option query hints to avoid parameter sniffing problems.
Involved in tuning long running reports and handling tickets assigned out of production.
Optimized SCD task by implementing the same in T_SQL using SQL Server Intersect, Except and Merge operators.
Environment: MS SQL Server 2008/2008 R2, MS Access 2003, Import & Export Data, Enterprise Manager, SSRS, SSIS, TFS, Power view.
MASTEC Inc, Hyderabad June ‘09 to May ‘11
JR.SQL Server Developer
Responsibilities:
Created complex Stored Procedures and Functions to support the front-end application.
Wrote database triggers in T-SQL to check the referential integrity of the database.
Involved in performance tuning of the database and T-SQL queries using Explain Plan.
Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
Developed SQL Server Stored Procedures, Tuned SQL Queries
Involved in designing high level dashboards per business requirement using SSRS2005.
Formatted the reports using Global variables, Expressions and Functions using SSRS 2005.
Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
Created joins and sub-queries for complex queries involving multiple tables.
Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written T-SQL procedures for transactions, created indexes for performance tuning. Responsible for understanding the customer requirements and database administration.
Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
Created and maintained Databases and created logins and assigned roles and granted permissions to users and groups and created SSIS packages to deploy packages between development, testing and production.
Involved in Query Optimization using Index implementation and Index Tuning Wizard SQL Server 2008
Environment: SQL Server 2005/2008 MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio, DTS
Contact this candidate