Data Manager
Resume:
SARA LEDI **********@*****.***
SUMMARY:
•A SQL Developer with 7+ years of IT experience in database design, development and administration with MSSQL Server 2016/2014/2012/2008 using SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS) in Finance, Banking and Healthcare industries.
•Conversant with all phase of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance.
•Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
•Experienced in ETL processes, Data warehousing methodologies and concepts including Star schemas, Snowflake schemas, Dimensional modeling, Reporting tools, Operations Data Store Concepts, Data Marts and OLAP technologies
•Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services
(SSIS ), Data Transformation Services (DTS), Bulk Copy Program (BCP)
•Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
•Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins and query writing.
•Efficient in up-gradation and migration from MS SQL Server 2000 to MS SQL Server 2014/2012/2008/2005/2000
•Experience in developing Custom Report, different types of Tabular Reports, Matrix Reports,
Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
•Experience in some basic development of coding in C# while working with SSIS.
•Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split,
Aggregate, Derived Column and Data Conversion Transformations
•Experience in using Audit functions and extensively used Exception Handling for catching and reporting errors
•Extensive experience in creating enterprise reports using SSRS 2005/2012 using Report Manager, Report Builder, and BIDS
•Created many Drill Through, Drill Down, Parameterized reports using SSRS 2005/2012
•Excellent knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models for developing SSAS Cubes using MDX
•Self-motivated and possesses ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
TECHNICAL SKILLS
Languages
Transact SQL, PL/SQL, XML, C, Visual Basic 6.0, Java, and HTML.
Databases
SQL Server 2016/ 2014/2012/2008/2008/2005/2000R2,MS Access, Oracle 9i, Oracle 10g/11g, MySQL, DB2
Analysis/Reporting Tools
SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).
ETL Tools
DTS, SSIS, Data Stage, Informatica, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Crystal Reports 8.5/9/10/11,
Data Modeling Tools
Erwin, Microsoft Visio
Operating Systems
Windows 98/XP/NT/2000/2003/2008/10, UNIX, LINUX, Mac OS
Database Tools
SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management
Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer,
Analysis Manager, Reporting Server
Professional Experience:
March 2018 to Present
Care source – Dayton, OH Sr. SQL Server / BI Developer
Responsibilities:
•Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
•Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2
•Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
•Experience in developing reports using SSRS 2008 and SSRS 2008 R2
•Created cubes and dimensions and measures and calculated measures according to the business requirements
•Performed the task of data transfer from files in remote server to folders in another server using FTP.
•Created database maintenance plans and deleting of history data using SSIS packages.
•Deployed SSIS packages and Reports to Production Servers.
•Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
•Generated reports from the cubes by connecting to Analysis server from SSRS.
•Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
•Created Tableau scorecards, dashboards using stack bars, bargraphs, scattered plots, geographical maps, Gantt charts using show me functionality.
•Worked on SSIS Script component using Visual Basic Applications, VB.NET and C#.
•Understanding and translation of various existing SSRS reports to Tableau dashboards.
•Developed and published interactive reports, also scheduled reports using Tableau Server.
•Experience in creating snapshots of static reports and configure subscription.
•Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables. Browsing the cube for analysis and validation of the data. Processing the cubes and dimensions on a daily basis using the SSIS tasks.
•Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2008.
•Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
•Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
•Altered existing OBIEE reports as per the new requirements.
•Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
•Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
•Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
•Build database queries and test cases for the testing team to test the reports.
•Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS
Excel, PDF, HTML, and XML etc
Environment: SQL Server 2016/2014/2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), T SQL, Tableau Server, Erwin, MDX, Pro Clarity, MS Excel
Work Experience:
Pharmaceutical Product Development (PPD) - Morrisville, NC Jan 2016 to Feb 2018
Sr. SQL Developer Responsibilities:
•Key role in team of 4 in bringing 2008 SQL database environment to SQL 2016 by migrating, converting and re-writing DTS packages and updating them to SSIS packages.
•Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
•Used SQL Server Package Configuration technique to make Dynamic configurations.
•Used Text Files/ SQL Server Logging for all SSIS packages.
•Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
•Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
•Deployed and configured the reports in the Report Server.
•Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2016 using SSIS.
•Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
•Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
•Worked with various SSIS packages which involve Transactions, Restorability and roll back techniques. Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
•Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
•Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
•Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
•Created SSIS packages using script task by C#.
•Schedule the packages to keep extracting the data from OLTP at specific time intervals.
•Responsible for rebuilding the indexes and tables as part of performance tuning.
•Monitored performance and optimize SQL queries for maximum efficiency.
•Used SQL Server Agent for scheduling jobs and alerts.
•Configuration and Deployment of all reports across various SDLC environments.
•Deployed the packages to production using XML package configuration
Environment: SQL Server 2016/2012/2008R2/2008/2005, SSRS 2012, DB2, Visual Studio 2005, XML, C#, XSLT, MS Office and Visual source safe
The Vanguard Group- Malvern, PA NOV 2014 to DEC 2016 SQL Server BI Consultant
Responsibilities :
•Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
•Involved in developing creative MS SQL solutions including Store Procedures, Views, Functions, User Defined Data Types, DTS/SSIS jobs, and job schedules assuring optimal functionality and adherence to corporate coding Specifications.
•Used ETL to implement the SCD transformation, to maintain historical data in data warehouse.
•Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
•Responsible for creating database objects like table, Views, Joins, Store Procedure, Triggers, Functions etc using T-SQL to store data and to maintain database efficiently.
•Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc in SSIS packages.
•Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse.
•Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
•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.
•Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
•Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
•Used calculations, sorts, filters and sections to enhance data presentation in reports. Created many Cascaded parameters in the reports using SQL SSRS.
•Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS). Also created many multi valued parameters in the reports.
•Used Reporting Services to consume data from SharePoint sites and display reports and dashboards on SharePoint sites.
•Identified and worked with Parameters for parameterized reports in SSRS 2008 R2.
•Generated Reports using Global Variables, Expressions and Functions for the reports.
•Delivered comprehensive BI through MS solutions including MS Excel, Microsoft Office SharePoint Server (MOSS), and Performance Point Server 2007 Improved Report Performance and performed unit testing.
Environment: MS SQL Server 2008, Visual Studio 2008, MS SQL Server Management Studio, SSIS, SSRS, Report Builder, SSIS-2005, Unix, Tera data, Team Foundation Server (TFS), Office, Excel.
Angel Investors - Pittsburgh, PA
SQL/SSIS Developer NOV 2013 to OCT 2014
Responsibilities:
•Involved in Gathering end user requirements, developed applications and different audit functionalities depending on the requirement acting for both system analysts and application developer.
•Composed user requirement documents, created technical specs and design documents for various projects.
•Generated complex T-SQL queries, sub-queries, co-related sub queries, dynamic SQL queries etc.
•Programming in SQL server using stored procedures, triggers, views, user-defined functions
•Involved in database design, normalization, de-normalization in building data warehouse and reporting systems.
•Involved in query tuning by creating cluster and non-cluster indexes on tables, and used index tuning wizard.
•Worked with several control flow tasks, data flow tasks, transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SSIS packages.
•Used event handlers for event handling which includes on pre execute, post execute and error.
•Involved in package logging in both standards (SQL server and file based) and custom logging using customer stored procedure and tables.
•Involved in monitoring and deployment of SSIS packages across dev., uat, and production environments using command prompt with .bat files etc.
•Involved in installation, configuration, maintenance, deployment and troubleshooting SSRS reports.
•Created complex reports like table report, matrix report, cascading report, sub reports, drill down, drill through and chart reports using complex data set queries, stored procedures, views in SSRS 2005/2008.
•Created adhoc reports more often based on end user requirements.
•Performed daily DBA activities, security assignment, user setup, backup, restore and job monitoring on MS SQL Server
•Generated and formatted reports using global variables, expressions and functions.
•Involved in developing parameterized reports using single values, multi values and cascading parameters.
•Built effective queries for high performance reporting and rendered them to html, xml, pdf, MS word and excel formats using SSRS (2005/2008).
Environment: SQL server 2000/2005/2008, SQL Query Analyzer, SQL profiler, Enterprise Manager, ERWIN
Data Modeler, SSIS, SSRS, SSAS, Windows Server 2003/2008, OLTP, OLAP, DTS, HTML, XML, Visual Studio
2008, ETL, MS Access
EDUCATION
BACHELOR DEGREE (SRI -SAI UNIVERSITY COLLEGE)
Contact this candidate