Resume Text:
|
Bryan Donatz leuh5m@r.postjobfree.com (310) ***-****
Professional Summary
o Over 5+ years of experience in IT as a professional specializing in MS SQL Server 2005 / MS SQL Server 2008 /SQL Server Reporting Services 2005/2008 in Windows environment.
o Excellent experience in creating, managing, and deploying various types of reports using SQL Server Reporting Services and Report Manager.
o Experience in Data Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
o Experience hands on experience in several database high availability techniques like log shipping and database mirroring.
o Excellent experience in restoring system and as well as user databases.
o Hands on Experience with RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers using SQL Server, T-SQL.
o Hands on Experience using Data Modeling Tools like MS Visio.
o Hands on Experience in Forward / Reverse Engineering Data Models between ERWin and MS SQL Server
o Expert in writing code in Transact-SQL, support of the creation of objects in relational and databases.
o Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using SQL tools such as SSIS.
o Good Experience in creating Master Child Packages in SSIS.
o Hands on Experience in managing SSIS Package Configurations.
o Experience in pulling data from DB2, Oracle to SQL Server using SSIS.
o Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, fact, and dimension tables.
o Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
o Excellent experience in developing, creating, and maintaining reports based on business requirements with time efficiency in mind and easy of usability for non-proficient end users.
o Experience in creating multidimensional cubes using the SQL Server Analysis Services.
o Extensive experience in Optimizing Cubes using SQL Server Analysis Services (SSAS) 2005.
o Actively involved in Processing Cubes, adding KPIs and Calculated Members USING SSAS.
o Good experience in Designing Aggregations and pre-calculating the same in SSAS.
o Excellent communication and verbal skills.
o Excellent interpersonal, Analytical and Communication skills.
Technical Skills
RDBMS/DBMS: MS-SQL Server 2005 / MS-SQL Server 2008
Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL T-SQL, Data Transformation Services OLTP, SSIS, OLAP
Reporting Tools: Microsoft SQL Server Reporting Services 2005 / 2008.
Operating Systems: Windows XP, Windows 2003, Windows Vista, Windows 7
Programming Languages: T-SQL.
Design Technologies/Tools: Erwin, MS Visio
Data Warehouse / Business Intelligence Tools: Business Intelligence Development Studio
Professional Experience
iPayment Inc.
Calabasas, CA Aug 2009 – Nov 2009
Reporting Specialist
Project: BI Solution
iPayment Inc. is a merchant services and acquisition company. Their success to date is due to the ability to remain very competitive within their industry, proving a high profit margin. To improve and obtain the leading edge, my role within the company was to carry in the Business Intelligence element of Reporting Services. Through good communication and team skills, a reporting platform had been created to view all possible information with respect to their Agents/Sales Reps, and the financial information regarding the merchants with respect to monetary volumes, fee data, demography, financial trends, and risk factors of actual volume amount for both merchant and sales representative. In addition, reporting requirements were also consisting of information to see the inner workings of the company itself, allowing changes where necessary to lower overhead.
Responsibilities:
o Understand the underlying infrastructure within the company’s financial standards and guidelines with respect to the reporting requirements across multiple database servers.
o Created numerous ad-hoc reports using Excel for daily needs regarding merchant and Agent/Rep financial standings.
o Defined guidelines for reports to be implemented as a team effort into a new Web Interface portal to improve data analysis.
o Migration of large MS-Access databases to MS SQL Servers.
o Created and maintained automated reporting objects and database management items such as report notification deliveries, as well as and index defragmentation, disk space monitoring, and SQL performance. Also maintained Report Manager to deploy reports on specific events.
o Automated Database backups for multiple server environments.
o Created numerous merchant and reports to display risk and trends analysis
Environment:
Microsoft SQL Server 2005 / 2008, Microsoft SQL Server Reporting Services 2005 / 2008
METROPOLITAN NASVILLE PUBLIC SCHOOLS
Nashville, TN Jan 2009 – May 2009
Reporting Specialist
Project: BI Solution
A new project was underway to handle the AYP and ‘No Child Left Behind’ policy that would essentially affect the stake-holders and district employees of the District School System if there continued to be increasing absences, tardies, disciplinary actions and all other demographic and child-specific related problems that concluded whether or not the Nashville School System would be able to handle these problem areas. As part of the BI team, I was the reporting specialist that gathered all the necessary information to help assist the District to view the details of information that would eventually guide them in correcting the above mentioned problems. My reports wold handle over 130 schools, 70,000 students and 20,000+ employees.
Responsibilities:
o Understood the existing ETL and relational database framework.
o Analyzed and maintained any existing reports within the Reporting Services solution projects.
o Designed different project solutions to handle the wide array of reporting needs from different aspects of the Nashville Public School system.
o Maintained security integrity within reports using T-SQL code and report parameters.
o Using Cascading prompts to enforce the result sets based on the security levels of the end users.
o Participated in implementing the logical design to the physical design by creating tables.
o Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
o Reviewed the existing stored procedures and improved efficiency by critically evaluating the code or by replacing them with CLR stored procedures and UDFs to optimized performance of front end applications.
o Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
o Exported reports to Excel and MXL files using SQL server reporting services.
o Worked with the DBA to manage and configure the reporting database as well as securing the data warehouse and map users to their permissions and roles to enable them to operate effectively without affecting the integrity and security of the company height priority data.
o Created documentations of all objects and code created in support of the project as well as keeping records of all change request documents
Environment:
Microsoft SQL Server 2005, Microsoft SQL Server Reporting Services
PARAGON LABORATORIES, Torrance, CA Jan 2007 – June 2008
ETL / Data Warehouse Developer
Project: BI Solution
Our state-of-the-art manufacturing operations in Torrance, California include in-house analytical and microbiological laboratories, packaging and warehousing facilities. Paragon identifies industry trends far ahead of the competition their customers every advantage in the marketplace. The project was to create a customer data mart and migration from legacy to SQL server 2005 databases.
Responsibilities:
o Designed SSIS packages to migrate the data from oracle to the Staging Area.
o Implemented the Master Child Package Model for easier maintenance and better performance.
o Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
o Scheduled Packages using SQL Server Agent Jobs.
o Participated in designing Logical data models for the Data Warehouse.
o Participated in implementing the logical design to the physical design by creating tables.
o Transferred flat files from different sources to the Staging Area by using DTS, BCP and bulk insert.
o Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
o Reviewed the existing stored procedures and improved efficiency by critically evaluating the code or by replacing them with CLR stored procedures and UDFs to optimized performance of front end applications.
o Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
o Designed new Aggregations by creating Hierarchies and then pre calculating the Aggregations using Aggregation Wizard in SSAS.
o Implemented new and complex Calculated Members that will be permanently stored in cubes to boost query performance of reports.
o Created KPIs that will track the response and behavior of customers based on the project Requirement Documents.
o Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
o Exported reports to Excel and MXL files using SQL server reporting services.
o Scheduled several jobs using the SQL server agent as well as created alerts and mail confirmation of all packages and cube processes.
o Created documentations of all objects and code created in support of the project as well as keeping records of all change request documents
Environment:
Microsoft Windows Server 2003 Enterprise Edition, Microsoft SQL Server 2005, Microsoft SQL Server Reporting Services, Microsoft SQL Server Analysis Services
LA Weekly, LA, CA May 2006 – November 2006
DBA/ETL developer
Since 1978, LA Weekly has been decoding Los Angeles for its readers, infiltrating its subcultures, observing and analyzing its shifting rhythms, digging up its unreported stories and confronting the city's political leaders. The project initially was centered on the maintenance of existing databases, reporting databases and reports. The project shifted to create several data marts to optimize the performance on analytical reports and applications
Responsibilities:
o Participated in designing the Logical model by using Erwin based on the business requirement.
o Implemented the logical design to the physical design by creating tables , views and relationships
o Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing
o Encrypted several columns using the symmetric and asymmetric keys encryption and RC4 algorithm.
o Generated payroll reports, mailing labels, ad-hoc reports using SQL server Reporting Services SSRS 2005
o Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
o Maintained data integrity by creating checks and constraints and DML triggers in both relation production databases and data warehouses.
o Facilitated easy user interface implementation and consistent data entry into the database by creating views with triggers.
o Supported efficient data storage and manipulation by creating complex stored procedures and functions
o Modified SSIS, DTS Package, and DTS Import/Export for transferring data from heterogeneous sources to the pre-staging database.
o Crated complex stored procedures with T-SQL and D-SQL to profile the data and discover potential anomalies and missing data values.
o Data migration (import & export – BCP) from Text , CSV files to SQL Server 2005 and 2000
o Created and modified indexes to optimize query performance of several stored procedures supporting front end applications and reports.
o Participated in designing, testing disaster recovery model as well as designing backup strategies of all systems.
o Participated in the monitoring of the SQL server performance using tools like SQL profiler, database engine tuning adviser and command line tools.
o Developed stored procedures and functions to implement necessary business logic for interface and parameterized reports.
o Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by the UI team.
Environment:
SQL Server 2000 SQL Server 2005, ER-Win, T-SQL, Windows 2000, DTS, Excel, MYSQL Server, DB2.
Legal Beagle, Oakland, CA December 2005 – June 2006
SQL Developer/DBA
Legal Beagle needed to create DSS system to evaluate its business performance and to help portfolio management focus on services that are considered priority and vital to the organization as of whole. A large analysis data mart in conjunction with a parallel data mining effort jumpstarted the planning phase of this project.
Responsibilities:
o Facilitated easy user interface implementation and enforced security on critical customer information by developing indexed generic views.
o Facilitated consistent data entry into the database by developing stored procedures and triggers.
o Developed stored procedures to retrieve customer information from as required to evaluate eligibility for loan requests, account status etc.
o Wrote store procedures to generate account statements for different types of accounts.
o Monitored performance and optimizing SQL queries for maximum efficiency u7sing system stored procedures, log file views, activity monitor, and SQL profiler.
o Fine tuning of database objects and server to ensure efficient data retrieval by refining code replacing long joins with effective sub queries and refining the indexes in place.
o Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database
o Created backup strategies like full backup with differential and full backup transactional log in multiple environments.
o Designed a high availability plan for the servers using log shipping and database mirroring as well as mirroring the production and the testing environment for optimal development.
o Designed a disaster prevention and recovery plan using both the simple and the full recovery model
o Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.
Environment
SQL Server 2000 Enterprise Edition, Query Analyzer, T-SQL and Windows 2000/XP
Herbalife, Torrance, CA May 2003- November 2005
SQL Developer
Herbalife is a premier nutrition and weight-management company. The company offer life-changing products and an unparalleled business opportunity. What started with founder Mark Hughes' dream over 28 years ago has become a world-class company with over 1.8 million Distributors. The project was to build a new system according to the new requirements of a company and users because of marvelous growth in business. The new system provides all the features the old system is missing and improves performance of the company.
Responsibilities:
o Involved in creating logical and physical model of the database using MS Visio, MS SQL Server 2000.
o Implemented the developed database into SQL Server 2000 using T-SQL.
o Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
o Extensively involved in data gathering for the locations, and insertion into Database using XML, DTS, BCP, and manual entry.
o Supported advanced efficient data retrieval and manipulation by creating indexed view with triggers.
o Successfully implemented indexes on tables and views for optimum performance tuning.
o Supported some business specific relationships, and advance constraints by embedding triggers on tables
o Set up scheduled Jobs and alerts for updates and backups.
o Assisted VB Developers in creating Data Entry Forms and embedding Dynamic SQL in VB 6.
Environment:
SQL Server 2000 EE, SQL Server 2000, VB, ADO, Windows 2000/XP, Microsoft Visio
Education:
A.S. Computer Network Systems, ITT Technical Institute of Torrance
|
|
Similar ResumesI am looking for 4 people who have eBay US (eBay.com/ebay.com.au/autot
Sacramento, CA
- ebay, au, seller, kevin, pm, sacramento,...SQL SERVER DBA/Developer
Aurora, IL
- ssis, ssrs, data migration, ibs, dba, modeler,...j2ee 8_yrs experience
elk grove, CA
- mks, plm, epic, j2ee, sqlserver, ejb, junit,...Business Objects Manager Developer Management
Pasadena, CA
- dates, business objects developer,...Senior Investment Associate
Pollock Pines, CA
- stanley, monica, pines, dogs, registered, rest,...PeopleSoft HCM Functional Analyst
United States
- peoplecode, nvision, infopath, hcm, rpo, netapp,...Software Oracle Project Manager Analyst Business
Sacramento, CA
- discoverer, silverlight, biztalk, hl7, dancers,...Developer Project Data Business Sql Server Warehouse
San Mateo, CA
- business rules, data analysis, physical design,...Sr SQL Server DBA/Developer
Turlock, CA
- autobody, ssis, reporting services, dba, developer,...Java Developer
Valley Cottage, NY
- peri, hibernate, java developer, jboss, j2ee,... |
