Sql Server Data
Resume:
RAM
****.*****@*****.***
Summary:
Around 4+ years of IT proficient experience as SQL Server BI (SSIS, SSAS & SSRS) Developer in various domains such as Banking, Healthcare and IT.
Experience in Database Design, Development, Testing and Production Environments as a SQL Server Developer 2000/2005/2008/2012R2
Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
Experience in creating database, tables, indexes, complex queries, stored procedures, views, triggers, user defined functions, complex joins, loops T-SQL, DTS/SSIS using MS SQL Server 2008 R2/2005/2008/2012.
Strong at developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS
Extensive experience in SQL Server 2000/2005/2008/2012R2, Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
Worked extensively on Extraction, Transformation, Loading (ETL) data from Oracle, SQL Server, DB2, Teradata, Access, Excel, Flat Files and XML using DTS and SSIS Services.
Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
Configured SSIS packages using package logging, Breakpoints, Checkpoints and Event handler to fix the errors.
Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like SQL Server, Oracle Database, Excel and Flat file to Microsoft SQL Server by using SSIS and DTS utility of SQL server2005/2008/ 2012 R2.
Experience in Debugging, Error logging, Error Handling and Production support for SSIS.
Extensive experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle databases.
Experience in SQL Server & SSRS Reports Migration from SQL Server 2000 to SQL Server 2005, SQL Server 2008 to SQL Server 20012 and SQL Server 2008 to SQL Server 2012 R2.
Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/ 2012R2.
Experience in creating ad-hoc reports by using Report Builder in SSRS.
Excellent report creation skills using Microsoft Reporting Services (SSRS)
Knowledge and experiences in designing, developing and deploying Reports and Dashboard.
Experience in deploying created reports in various sources like Web Browser, XML and PDF.
Skills in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.
Creating, Modifying Cubes, Measures, Dimensions Attribute relationships, Named Calculations and Hierarchies.
Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS2008 and Create Calculate member in MOLAP cube using MDX in SSAS 2008.
Capable of Monitoring strategies, processes and procedures to ensure the Data Integrity and maintained the required level of security for production and test environments.
Excellent verbal and written communication skills, excellent presentation, interpersonal skills, problem solving skills and also adapt quickly new technology with ability to take new roles in minimum time and little training.
Education
Masters in computer science
Bachelors in Engineering, Major: Electronics and Instrumentation
Technical Skills:
Microsoft SQL Reporting Services (SSRS), Store Procedure, SQL Integration Services (SSIS), SQL Analysis Services (SSAS), C#.NET, XML, PL/SQL, T-SQL, VB Script, XHTML, HTML, CSS, Microsoft Enterprise Library, MS SQL Server 2008/2005/20012, ERWIN, MS Office, Oracle 10g/9i, DTS, BCP, Business Intelligence Studio(BIDS), Query Analyzer, SQL Management Studio, SQL Server profiler, Microsoft Visual Source Safe, Power BI, Tableau.
Professional Experience
Department of Health Care of Finance, Washington DC Dec 2016 to Till Date
SQL/ BI Developer
Project Description: The scope of the project was to create a data mart based on an existing data warehouse for EMR data to minimize the data lag for the reporting application. The objective of project was to create multitude of reports and interactive dashboards for better patient analysis using SSRS and Excel Power BI.
Responsibilities:
Wrote technical design specification documents based on the BRD.
Created stored procedures, functions and triggers per FRD.
Optimized indexes to improve queries analyzing execution plan, resolving parameter sniffing problem, rebuild/reorganize indexes, and SQL profiler.
Interacted with DBA's about database issues and performed applications tuning by analyzing trace files, index maintenance and execution plans.
Developed complex Stored Procedures and views to generate various Drill-down/Drill-through reports using Power BI
Worked on developing Power BI reports and dashboards from multiple sources.
Generated reports based on the analysis of the data from various time frame and division using Power BI
Developed SSIS packages to extract, transform, and load data from multiple input sources such as Excel with multiple sheets and Oracle database into SQL Server OLAP database.
Wrote DAX Expressions, Power Query, Functions in Power BI
Implemented data cleansing operation with different transformations such as data conversion, derived column, fuzzy lookup and conditional split.
Implemented event handlers, loggings, breakpoints, and data viewers for effective debugging of packages.
Implemented package configurations available for SSIS packages such as XML files and SQL server tables to ensure packages are dynamic; deployed the packages to the SSIS server.
Scheduled package execution in integration services server with the use of SQL Server Agent jobs.
Experience in creating the MDX cubes and dimensions (SSAS).
Created and Modified reports utilized MS SQL Server Reporting Services (SSRS)
Developed complex reports such as drill capabilities, complex freehand SQL queries, functions, master detail, and cross tab with multiple breaks.
Designed several scorecards and dashboards with the use of Power Pivot to display information requirements requested by differing departments to include senior management.
Optimized reports at the server, report, and item levels.
Manipulated TFS to synchronize data with differing sources.
Experience in writing DAX Functions
Environment: MS SQL Server 2008 R2, SSIS, SSAS, SSRS, BIDS, TSQL, Erwin, TFS, Power Pivot.
Spring Bank, Bronx, NY May2016 –Dec 2016
SQL Server BI Developer
Project Description: Played a key role in a Power Business Intelligence (BI) project that involved Data Integration (SSIS) and Reporting (SSRS) My role in this project is to design and implement an ETL using SQL Server Integration Services (SSIS). Also, designed multiple data and application databases for various applications across the enterprise. The project involved designing data models, logical and physical databases, schemas and loading data into data warehouse using SSIS and generating reports on the customers who applied loan, approved, denied using SSRS.
Responsibilities:
Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
Integrated Custom Visuals based on business requirements using Power BI desktop.
Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
Developed Power BI reports using query logic based on business rules, and visuals selected by Clients.
Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, and Reporting tools. Designed, deployed, and maintained various SSRS Reports in SQL Server 2008.
Responsible for building Power BI Dashboards using Tabular and Multidimensional Models. Design and model data sets with Power BI desktop based on measure and dimension of dashboard needs
Define reporting needs and implement SSRS reports to satisfy needs using Power BI
Developed Perl script for SQL Server maintenance routines.
Created ODBC data source to connect SQL server database from Perl.
Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008. Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
Provided maintenance and development of bug fixes for the existing and new Power BI Reports.
Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
Environment: SQL Server 2005/2008, Windows 2003/2005, SSIS, SSRS, SQL Server Management Studio, SQL Server Business Intelligence Studio, MS Access, VB.NET, C#, SQL Profiler
Tanla solution Ltd Hyderabad, India Jun 2012 - Dec 2014
Client: United Health Care
SQL Server BI Developer
Project Description: The project was to give critical support for data migration of SSIS packages and also track the transactions that take place in the Financial Department across different data centers across the world.
Responsibilities:
Installed upgraded and migrated Packages from MS SQL Server 2005 to MS SQL server 2008.
Involved in Designing ER diagrams and mapped the data into database objects.
Involved in the analyzing and solved problems doing the Client Application system's installing, upgrading and running stages.
Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008.
Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
Monitored the overall performance of the database to recommend and initiate actions to improve optimize performance.
Designed and created ETL packages in MS SQL Server 2008 using SSIS
Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
Configured SQL mail Agent for sending Automatic emails on Errors
Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements
Environment: Microsoft SQL Server, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), IIS, ERWIN.
Contact this candidate