Post Job Free

Resume

Sign in

Sql Server Data

Location:
Los Angeles, CA
Salary:
98,000
Posted:
May 15, 2017

Contact this candidate

Resume:

McDaniel Belony

Phone: 909-***-**** Email: ac0blq@r.postjobfree.com

Address: **** * ********* ***, **** Beach, CA 90805

Professional Summary

7+ years of professional experience. I am Microsoft Certified Profession: Querying Microsoft SQL Server 2012. My experience includes designing, developing and leading windows and web application projects in Microsoft .Net framework, C#, ASP.NET and database in MS-SQL 2008/2012 Sever. Experience with SQL Server 2008/2010/2012 Business Intelligence development using SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS) and SQL Server Integration Service (SSIS). Expertise in creating Business Intelligence Reports using SQL Server Reporting Services (SSRS), Power B.I, PowerPivot, Excel, Report Designer, SharePoint, Performance Point, Tableau, OBIEE, Cognos Analytics and Report Builder. Expert in handling parameterized reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining the data source and subtotals for reports using SSRS. Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert. Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation. Great working knowledge of software development life cycle, (Agile), data life cycle, database design, RDBMS, Data Warehousing and data modeling concepts. Summary of my experience and skills is presented below.

Technical Skills

Microsoft B.I Tools: SSIS, DTS, SSAS, SSRS, BIDS, SSMS, Microsoft Office, SharePoint Server,

Excel, Report Designer, Report Builder, PowerPivot, Tableau, Performance Point, IBM Cognos Analytics

Languages: C#, SQL, T-SQL, PL/SQL, VB, CSS, HTML

Databases: SQL Server 2008/2012/ 2014, Oracle, MS Access, MySQL, Teradata

Front End Tools: MS Visual Studio, 2013/2012/2010,2008, BIDS

Internet Technologies: ASP.NET 2.0,4.5, XML, HTML, CSS

Other Skills: Microsoft Word, Excel, PowerPoint, Outlook, Business Object, CrystalReport, Team Foundation Server (TFS), Windows /2003/XP/NT/Vista, Windows 7, Windows 8 Advanced Server

EDUCATION

Felician College, Lodi, NJ

Bachelor of Arts Major – Mathematics Concentration – Computer Information Systems

CERTIFICATION

Microsoft Certified Profession: Querying Microsoft SQL Server 2012

PROFESSIONAL EXPERIENCE

Auto Club Enterprise Date: August 2014 – Present

Project: DIGITAL DISPATCH SYSTEM Role: Business Intelligence Developer

Responsible:

Installed & configured database software, associated database tools and performance monitoring software.

Used ADO.NET for data interaction between the Web application and the Database using Datasets and Data Adapters.

Involve in taking project through the full life cycle from requirements gathering to UAT to deployment and maintenance.

Reviewed the Logical and Physical database design and Technical Specification.

Wrote T-SQL Queries, Store Procedures and Triggers to build specific logic as well as checking constraints, preserve referential integrity and provide additional application functionality.

Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's using Tableau.

Created different KPI using calculated key figures and parameters

Optimized the performance of the queries by using SQL profiler and SQL optimizer with modification and creating index.

Developed reports using SSRS and deploy to SharePoint sever 2010 and published as PDF, Excel and CSV formats.

Used SSRS to create reports, customized reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in Tableau.

Involved in designing, developing, testing of the extract, transform, and load (ETL) strategy to populate Employee, Members and Contractors data from various source systems feeds using SSIS.

Good experience in creating pivot tables and charts in Excel, Tableau using data sources (SQL Server, SSAS cubes) and power pivot.

Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Participate in data modeling of data marts, my knowledge features Structure, Attributes, Hierarchies, Star Schemas and Snowflake of data marts.

Created Parameterized Reports by identifying and creating Dataset with the Parameter.

Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data from online transaction Processing (OLTP) databases to data warehouse databases and involved in Data cleansing in the data transfer.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, FTP task, WMI Event Watcher Task and Execute Package Task, Execute Process Task, Bulk insert Task, File System Task, For each loop Container, For loop Container, Sequence Container, etc. to generate underlying data for reports. Also, to export cleaned data from Excel Spreadsheets, Text file, and MS Access and CSV files to data warehouse.

Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.

Implemented Business Intelligence dashboards using Power Pivot, Tableau and Power BI.

Used SQL Profiler for Debugging issues, Query optimization and performance, tuning whenever necessary.

Developed & maintained scripts, utility jobs or implement needed software for database maintenance.

Create database objects such as tables, views, indexes, stored procedures, functions, triggers and relations using SQL Server Management Studio.

Experience in generating on-demand and scheduled reports for business analysis and upper management using SQL Server Reporting Services.

Participate in designed and Implemented SSAS cubes architecture, facts and dimension table to perform analysis.

Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manager.

Developed MDX expressions for cube calculations and Key Performance Indicators (KPIs) in the OLAP.

Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.

Developed complex stored procedure to retrieve data from backend SQL database.

Designed, Developed and Deployed cascaded reports, tabular reports, Dashboards in MS SQL Server environment using SSRS and integrated to share point server.

Coordinating with the offshore and onsite team in assigning, task, and time reporting to client.

Environment:

MS SQL Server 2008R2/2012, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point 20010, ASP.NET, C#.NET, HTML, XML, Microsoft Source safe, CSS, JavaScript, ADO.NET, Window7

Hanson Pharmacy Date: May 2013 – September 2015

Project: PHARMACY MANAGEMENT SYSTEM Role: Business intelligence Analysts

The main aim of the project is the management of the database of the pharmaceutical shops. This is done by creating a database of the available medicines in the shop. The database is then connected to the main program by using interconnection of the c# program. The management system is used to generate reports as per the user’s requirements. The software can print invoices, bills, receipts etc. It can also maintain the record of supplies sent in by the supplier.

Responsible:

Installed & configured database software, associated database tools and performance monitoring software.

SQL Server 2012/2014, SSRS, Micro Strategy, MS Access, SSIS/ETL

Participated in the data models for Data Warehouses/Marts using dimensional design techniques, snowflake, and star schema designs, identify data quality issues and support data governance initiatives by participating in necessary activities including data profiling.

Created customized SSRS reports, which are rendered via a .Net application (ERP System). The application enables users to create their own private reports by selecting or hiding parameters, fields, groupings and filters that are available in a template rdl file. Customization requires custom code in the template rdl which is used by the application to copy and piece together a new rdl (based on user selection) resulting in a new customized report.

Senior level experience using SQL Server, designing backend processes and database objects such as stored procedures, functions, views, tables, triggers, indexes, CTE's, etc.

Participated in managed the master data, using an in-house tool where metadata was loaded, mapped, transformation rules were documented and master data status reports were generated. This initiative was aimed to maintain data quality and the overall confidence in the data.

Designed and developed report models to be used by Tableau.

Used Team Foundation Server for source control and project management following the Agile development methodology.

Trending Reports by Products, Customers, Affiliates, Territories

Review DataMart design to assist in resolving bad data, ETL/SQL/Query issues.

Healthcare, Clinical Informatics & Decision Support

Working in an agile environment to deliver higher-quality software far more rapidly.

Successfully organized initial set of requirements into master list of Use Cases

Involved in development of Web Forms, classes using ASP.NET that incorporates both N-Tier Architecture, and Database Connectivity.

Used Visual Studio 2013 to design the web pages, develop and debug the web application

Worked on different aspects of .NET framework like ASP.NET 4.0 and on middleware ADO.NET

Involved in designing User Interface with CSS 3, HTML 5 and JavaScript

Modified Web Services to interact with the other applications and exposed them using SOAP and HTTP

Used AJAX to trade data with a Web Server without reloading the page

Used SOAP to implement Web Services and Consumed and published XML Web Services in the application

Developed extensive Stored Procedures and Triggers on SQL Server

Involved in Unit Testing and Integration Testing of the web application

Environment:

MS SQL Server 2008R2/2012, SQL Server Integration Services (SSIS), Tableau, SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point 20010, ASP.NET, C#.NET, HTML, XML, Microsoft Source safe, CSS, JavaScript, ADO.NET, Window7

R & J Money Transfer Date: May 2011 – April 2013

Project: MONEY MANAGEMENT SYSTEM Role: BI and .NET Developer

This system offers a platform independent of transferring money from one place to another at any time and on every day of the week. The main aim of this project is to improve on existing money transfer systems. To achieve this aim the use of CVC (card verification code) and randomly generated numbers on a token to provide a secure system for transferring money. This project is not just the development of standard software or just the implementation of a money transfer system but a portal that solves some issue when it comes to transferring of money, which in this case we focused on the security and the aspect of a friendly and simple system.

Responsible:

Act as a bridge between the financial business team and the IT team.

Translate high-level financial requirements into technical solutions.

Review and approve technical solutions for the IT scrum team.

Provide support for all entities around the world who report their financial data thru our system to the Foreign Central Bank. This is a combination of functional financial troubleshooting and technical database troubleshooting.

Lead BI analytics

Using SQL Server Reporting Services 2008,2012 and Tableau developed drilldown and drill-through reports for the Financial Services branch which enabled cross-system analysis resulting in significant cost savings for the company as critical data entry errors were exposed and resource intensive processes were eliminated

Participate in Data Modeling, Query Build and Web Intelligence Document architecture.

DSO/Cube/Transformation design

Ensuring full advantage of OLTP Master Data to drive flexibility and visibility to the business. Including training business on transactions/procedures to OWN their data.

Providing In-House Business User Training for Web Intelligence and BI Launchpad. Writing training manuals and delivering training to the end business users

Maintaining a CLEAR system by Policing Object Creation and removing old redundant architecture.

Interfacing with business to develop new reports and enhance existing ones. Tracing desired data from Business Process to OLTP Transaction Field to OLTP Table and delivering best method of Extraction.

Reduce Validation layers and Mitigate Object Maintenance by implementing Master Queries, Master Hierarchies and overall Master Data Standards.

Trouble shooting failed Jobs, short dumps, RFC Connections, Custom Programs/Customer Exits, failed data loads. Identifying Root Cause, Researching applicable SAP notes and working with BASIS team to apply. Writing guides for system reboot procedure.

Keeping development, quality and productive systems in proper sync.

Managing data load process. Providing support for failed loads. Building\Scheduling\Maintaining Process Chains.

CMC services: Instance Management, Session Management, Promotion Management, OLAP connections, Server/Service Configuration/Maintenance, Security and Role Assignment.

Analysis of the specifications provided by the clients

Involved in requirement gathering, functional and technical specification

Used N-tier architecture for Presentation Layer, Business and Data Access Layers using C#

Coding and debugging using ASP.NET and C#

Developed Web Forms using ASP.NET Server Controls and validated client side using JavaScript

Used ADO.NET objects such as Data Adapter, Data Reader and Data Set for consistent data access

Developed database Routines, Stored Procedures and fixing up standard specifications

Creating reports using the Crystal Reports for the report needed by Middle Office, Back Office users

Identified researched, investigated, analyzed, defined and documented business processes

Involved in enhancing the business layer to provide more interfaces and functions needed for the system

Environment:

MS SQL Server 2008R2/2012, SQL Server Integration Services (SSIS), Tableau, SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point 20010, ASP.NET, C#.NET, HTML, XML, Microsoft Source safe, CSS, JavaScript, ADO.NET, Window7

Sliq-IT INC. May 2010 – May 2011

Project: Supplier Information Management System Role: SQL B.I Analysts

Supplier Information Management is a data driven application and it was designed to streamline the processes used at GE like tender issuing, receiving quotations, supplier data entry, workflow approval and awarding contracts. The Supplier Information Management served as a central point of reference for GE's business stakeholders, external suppliers as well as the sourcing department for contracting process using real time supplier data stored in database. It was also used to generate management reports.

Responsibilities:

Created store procedures, triggers and functions for retrieval and updates of data in the database.

Used Index tuning wizard, SQL profiler and SQL Query analyzer for query optimization and performance tuning.

Involved in Extraction, Transforming and Loading (ETL) data flows using SSIS;

Creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

Created and scheduled jobs using the sql server agent for running SSIS packages automatically.

Created event handler on the package using SSIS for error handling, sending alerts and business analysis.

Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

Deployment of SSIS packages to the conversion server, also create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a daily, weekly basis. Experience in creating master and child packages.

Used .NET and XML as a frontend application sources and transformed data using SSIS.

Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.

Created report subscriptions and report snapshots for automatic generation and capture of the required reports.

Designed various web forms to fill their details online like company details, contact information, describe their capability, areas of expertise and provide formal accreditations, certificates, insurance and other supporting documents by way of attachments.

Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player

Designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.

Creating reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases

Wrote stored procedure to pull the work queues and issue data into the Supplier Information Management database.

Used C#, ASP.NET, ADO.NET, HTML, JQuery for the development and validation purpose.

Used SQL Server 2008 as database, created various tables, and stored procedures to provide data to front end GUI and update back the data.

Wrote C#.Net class modules for database connectivity and execution of stored procedures/ functions using ADO.NET.

Environment:

MS SQL Server 2008/2012, Erwin, Crystal reports, MS Access, MDX, XML, SSIS, SSAS, SSRS T-SQL, Visual Studio.Net 2010/2012, .Net Framework 4.0, ASP.NET, ADO.NET, C#, SQL Server Profiler, PL/SQL, JavaScript, JQuery, HTML, XML



Contact this candidate