Senior Bi Developer Resume
Baltimore, MD
PROFESSIONAL SUMMARY:
- Over 7+ years of Industry experience in Data warehousing experience with Microsoft SQL Server 2005/2008/2012 , SSIS/SSRS/SSAS/MOSS OLTP and OLAP.
- In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
- Extensive experience in creating interfaces using SSIS in MS SQL Server 2005/2008 and its different tools like SSMS (SQL Server Management Server), BIDS (Business Intelligence Development Server) and SQL Server Configuration Manager.
- Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
- Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
- Hands on Experience SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
- Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems.
- Experience in writing expressions in SSRS. Created many Drill through, Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports using SSRS.
- Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
- Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks).
- Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
- Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
- Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
- Created beautiful reports by mixing Excel, Charts & Power Pivot.
- Experience in using T-SQL in SQL Server 2000/ 2005/2008/2012 and 2014 platforms.
- Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
- Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
- Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
- Expertise with DDL and DML statements, RDBMS’s, data dictionaries and normal forms.
- Experienced in .NET Framework 2.0/3.0, Microsoft Visual Studio 2008/2010
- Excellent Analytical, Communication and Interpersonal Skills. Proficient in Technical Writing and Presentations and a Good Team Player.
- Intensive experience in monitoring database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
- Exceptional background in analysis, design, development, customization, implementation and testing of software applications and products.
- Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
TECHNICAL SKILLS:
Programming Languages: C++, T-SQL, PL/SQL
Databases: SQLServer 2000/2005/2008 , Oracle10g,Sybase,MS Access2003/2005
Tools: Performance Monitor, Backup Utility, SQL LiteSpeed, Spotlight, DB Artisan, SQL Server Management Studio, Query Analyzer, Enterprise Manager, Profiler
Other Tools: DTS, Business Intelligence Development Studio, SSRS, SSIS, SSAS. OPEN FT
Web technologies: HTML, XML,VB Scripts, IIS, PhP
Platforms: UNIX, LINUX, Windows 2003/2000, Windows XP, Windows NT
Network Topologies: TCP/IP,DNS,WINS,FTP,SMTP
PROFESSIONAL EXPERIENCE:
Confidential, Baltimore, MD
Senior BI Developer
Responsibilities:
- Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
- Created SQL Server Reports based on the requirements using SSRS 2012.
- Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
- Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
- Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008 (SSAS)
- Worked on OLAP Data warehouse, Model, Design, and Implementation.
- Developed Complex Stored Procedures, Functions, Triggers, Views and Temporary Tables as per the requirement.
- Created complex reports which involve more number of groupings and multi-value parameters
- Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
- Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
- Created multiple reports with drop down menu option having complex groupings within the report.
- Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
- Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
- Create an alternate work flow for Datastage ETL process using SSIS.
- Used Excel Pivot tables with Access data. Reported Access data using the Excel presentation layer Move data between Excel and Access using VBA, ADO and SQL.
- Worked extensively on Power Pivot and tabular modeling to meet the business requirements.
- Built SQL Server Queries for Power Pivot based reporting to deliver on managers reporting needs.
- Configured SQL Server2014 and SSRS using IIS .
- Installed and configured SQL Server 2014 on both cluster and stand-alone environment
- Experience in creating complex SSIS packages using proper control and data flow elements.
- Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
- Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
- Troubleshooting performance issues and fine-tuning queries and stored procedures.
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
- Scheduling the SSIS packages and Jobs.
- Worked in setting up the SQL Server 2014 configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
- Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
- Determined the SQL Server 2014 Installation. Installed SQL Server Management tools using SQL Server 2014 Setup Program.
- Worked very closely with Business Customers, End Users and resolved any business process related issues.
Environment: Windows server 2008, IIS 6.0, MS SQL Server- 2012/2010/2008 R2/2005 Enterprise Edition, Tabular, VBA,ETL,SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, Crystal reports, Java, OLTP, UNIX, Linux, DAX, MDX, Erwin, Oracle, Performance Point Sever, Tableau, Excel Pivot, Office-2007, DB2, C#.NET.
Confidential, Lorain, Ohio
Sr SQL Developer
Responsibilities:
- Worked on gathering requirements as a basis for the functional specifications from functional revenue and sales teams.
- Created SSIS packages to load the data from UPS data ware house system to UPS capital Database on a weekly basis.
- Imported data using SSIS packages and using custom SQL server stored procedures.
- Scheduled ETL packages to run on Daily, Weekly and monthly using SQL server Agent.
- Created and alternate process of migrating existing Datastage jobs and packages to ssis, built a new process in SSIS and integrated with existing framework.
- Involved in power pivot modeling such as building and maintaining power views .
- Exported Cube data in MS Excel to create Power pivot and Power View and added features like slicers to make interactive reports
- Worked on Data Migration and ETL operations using Stored Procedures and SSIS.
- Created SQL server Stored procedures, Scalar valued functions and table valued functions to supports SSRS reports.
- Optimized Stored Procedures, Views, and User-Defined Functions for reporting needs.
- Created Variety of SSRS reports, Summary and detailed revenue reports to support the business needs of UPS capital cash flow aspects.
- Developed data model based on the BA’s and the reporting Team using SSRS, SSIS
- Responsible for creating Tabular, Matrix and Drilldown Reports using SSRS
- Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL)
- Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle ).
- Created variety of Aging reports, calculated summary reports, Cargo reports, Cargo Customer reports.
- Good knowledge on Using Team Foundation Server (TFS).
- Developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for Developing Cubes.
- Expert in creating Star schema cubes using SSAS.
- Good knowledge on working with Dimension Usage properties, Dimension relationships, Dimension Hierarchies properties, SSAS Actions, perspectives and Browser.
- Developed Aggregations and calculated members for cube as per business requirements.
- Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.
Environment: SQL Server 2008,2012 SSIS,SSRS,SSAS, XML, Share Point 2010 and 2012,Infopath, C#,.Net
Confidential, Frisco, TX
SQL BI Developer
Responsibilities:
- Designed a workflow for Student Assessment Loading automation process.
- Implements a Student Analysis Business Intelligence Solution for Fulton County School Student Assessments.
- Worked on gathering requirements as a basis for the functional specifications of the Students automation process.
- Imported data using SSIS packages and using custom Sql server stored procedures.
- Worked on Data Migration and ETL operations using SSIS.
- Configured linked servers to fetch data from another server (in our case it’s Oracle).
- Develop Stored Procedures, Functions, Views, CTE’s, Joins and Sub queries to enforce the business rules. Fine-tuned SQL queries to improve query performance and to reduce runtime.
- Optimized Stored Procedures, Views, and User-Defined Functions for the Assessment Automation Application.
- Performed Debugging on the stored procedures for the requirement to handle the errors.
- Created Data Profiling packages to check the data discrepancies between the source data and data warehouse data, profiling was done on column level. As the source data comes from School Clerk’s, created some effective ways to cleanse the wrong data entered during the time of student admission.
- Developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for Developing Cubes using MDX.
- Expert in creating Star schema cubes using SSAS.
- Good knowledge on working with Dimension Usage properties, Dimension relationships, Dimension Hierarchies properties, SSAS Actions, perspectives and Browser.
- Developed Aggregations and calculated members for cube as per business requirements.
- Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.
- Created Analysis cubes, dimensions and business KPI’s using Sql server analysis services representing aggregations in several different ways - hierarchically and using custom groupings that the Fulton School System will use to amylase Students Test performance results. Created basic Time series MDX functions and MDX queries to support the business requirement.
- Designed Partitions in Cubes on time for improvement in performance using SSAS.
- Involved in deployment of SSRS reports on the SharePoint Portal.
- Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
- Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
- Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).
- Implemented Business Intelligence Reports using Sql Server reporting services, Excel reports using Excel and then Uploaded to SharePoint Server 2010 using Excel Services and Report server Web parts.
- Key product areas utilized also include data modeling, SSRS report subscription and data driven subscriptions, SSAS Analysis Services processing tasks, cube processing options and roles.
Environment: SQL Server 2005,2008,2012 SSIS,SSRS,SSAS, XML, Share Point 2010 and 2012,Infopath, C#,.Net
Confidential
SQL Server Developer / ETL Developer
Responsibilities:
- Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions.
- Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.
- Created functional requirement specifications and supporting documents for business systems. Experience in database design process and data modeling process for Billing Method using Erwin.
- Designed Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
- Built Drill Down, Drill through, linked and sub reports using SSRS 2005.
- Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
- Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data from various Databases and into Siemens servers using SQL Server Integration Services (SSIS).
- Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, and batch (.bat) files on a day to day basis.
- Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
- Deploying the packages (both the methods File system & SQL Server system) to different environments (test environment, production environment).
- 20 Users for various Reporting and Analytics requirements across multiple Business Units and departments.
- Experience in developing Life Cycle using Agile Methodology.
- Experience in optimization of queries, improving the performance and maintaining the database consistency with DBCC at regular intervals.
Environment: SQL Server 2000, 2005,2008,SSIS,SSRS,SSAS, XML, MS Project, MS Access 2000 & Windows 2K platform, Share Point, Crystal reports, Oracle 9i, C#,.Net.
Confidential
SQL Developer
Responsibilities:
- Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
- Worked on Client/Server tools like MS SQL Server 2000 Enterprise Manager and Query Analyzer to Administer SQL Server
- Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2000.
- Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping.
- Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
- Experience in writing stored procedures, functions, triggers and calling them in the packages.
- Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2000.
- Participated in maintaining and modifying tables and constraints for Premium Database using MS SQL Server
- Configured Database Mail, created operators, jobs and alerts for automating databases.
- Created DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc
- Designed DTS package, with DTS Import/Export wizard for transferring data.
Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.Net, Windows 2005/2008, Windows Active Directory, MS Access, MS Excel.