Sql Server Microsoft Office

Alina Weber

Palmdale, CA 754-***-**** ********@*****.***

Results-driven IT Professional with management skill and 16 years of experience improving profitability and driving long term company growth by delivering financial analysis and recommending solutions to C-level executives, corporate accounting and field operations. IT liaison with 8 years of experience with diverse Business Systems Analysis experience, SQL database development & analysis, BI development, business requirements elicitation, development of technical specifications, technical writing, gap analysis, risk management, troubleshooting and issue resolution.

- Six years of experience in analysis, design and implementation in translating the business requirements into the SQL Server 2000, SQL Server 2005, and SQL Server 2008 and 2016 database management system and SQL Server development.

- Seven years of development and maintenance of monthly dashboards that served as a tool for administrators and clinicians to monitor financial and operational efficiency of medical claims.

- Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.

- Extensive knowledge in data modeling and database architecture based on functional requirement of the system, experienced in Migration from SQL Server 2016, 2008 to SQL Server 2012, 2005 to 2008. Experienced in designing and developing reports in SQL Server Reporting Services by gathering business requirements and translating them into technical specification and creating reports with respect to business requirement. Expert in writing advanced T-SQL queries (DDL, DML).

- Highly motivated and possess ability to think, to analyze and to communicate with users and discuss their data, application and project requirement in a team environment.

TECHNICAL SKILLS

ETL Tools: Data Transformation Services (DTS), SQL Server Integration / Reporting Services SSIS/ SSRS.

Database Management Systems: MSSQL Server 2016/2012/2008r2/2008/2005, OBIEE 10.1.3.3, OFA, Oracle GL.

Database Utilities: Essbase, Enterprise Manager, Query Analyzer, SQL Server Profiler, SSMS, Teradata v. 12 / v.13.

Analysis Services: MSSQL Server Analysis Services (SSAS).

Reporting Tools: MSSQL Server Reporting Services, Business Objects, Cognos and Impact Intelligence.

Data Modeling Tools: Visio 8.0.

Programming Language: TSQL, C#.

Application Packages: Microsoft Office, Microsoft Office 365.

Operating Systems: Windows 7(X64)/Windows 2000/ Windows Server 2003 /Windows XP.

EDUCATION: Al. I. Cuza University, Romania (in collaboration with Université de Lyon)

MBA - 2001; GPA: 4.0 Bachelor of Business (Economics & Finance) – 2000; GPA: 4.0

LANGUAGES Articulate communicator with international business experience.

PROFESSIONAL EXPERIENCE

Database Administrator (contract) July 2016 – Present

Farmers Insurance, Woodland Hills, CA

●Architect the Microsoft Business Intelligence solutions utilizing MS SQL Server 2014 SSIS, SSAS, SSRS and Sharepoint, tailoring solutions for Financial Reporting and Operational Business Intelligence.

●Configure and optimize BI environment, which includes relational and OLAP layers, and data migration components; work in collaboration with the data warehouse environment and team.

●Collaborate with Infrastructure team to ensure system availability.

●Collaborate with BI developers and business owners to ensure the creation of production Business Intelligence designs and implementations.

Key Accomplishments:

●Troubleshoot BI Environment problems and tune for performance. Diagnose and resolve application bottlenecks and performance issues.

●Define and enforce coding standards, design styles and best practices.

●Develop and manage BI presentation layer training, and documentation.

Sr. Business Intelligence Developer (full time) April 2015 – Oct 2016

ABB Optical, Coral Springs, FL

●Gather and document functional and technical requirements, and translate requirements into reporting solutions, analytic tools and dashboards.

●Develop in-depth understanding of underlying data, data structures and business uses to ensure reports meet client needs; lead quality control and peer review processes to ensure integrity of the data available to users.

●Provide support as required to ensure the availability and optimized performance of developed reports and dashboards for both external and internal users.

●Design and implement technology best practices, guidelines and repeatable processes.

Key Accomplishments:

●Redesigned Distribution Center Datamart for speed and accuracy; improved distribution report speed from over 5 minutes per to under 1 minute per report by re-writing SQL stored procedures, eliminating redundant code and optimizing SSRS parameter structures.

●Maintained and supported production and non-production SSIS workflows, transformations and data mappings making sure adequate monitoring is in place, documented troubleshooting steps and trained application support representatives to ensure high availability.

●Provided a secure, scalable and stable ETL platform by installing and configuring Visual Studio BI Tools on a 64 bit Server thus ensuring Source Control standards implementation for BI Team.

IT Engineer (contract) Jan 2014 – April 2015

Banyan Gaming, Pompano Beach, FL

●Execute, manage and lead a set of Office 365 customers and partners through the on-boarding technical process.

●Assist Office 365 customers and partners with configuration of on-boarding tools and processes technology.

Analyze, develop and communicate key on-boarding process and technology improvement feedback for Office 365 and entire deployment cycle.

●Deploying, Supporting and Maintaining Microsoft Dynamics CRM.

●Writing custom reports and SQL queries; deliver patching and system performance enhancements to existing Dynamics applications.

●Assist in Maintenance of Active Directory Environments including Group Policies as they relate to Dynamics Projects.

●Managed and Administrated the SQL Server 2008R2/2008/2005/2000 production and Non-production servers.

●Installation of SQL Server 2008R2/05 on Windows Server Clustered environment.

Key Accomplishments:

●Developed and implemented SQL server based CRM tools and converting legacy systems. Completed project under budget and three weeks ahead of deadline.

●Implemented a solution consisting of an accredited core ERP solution with integrated CRM and Service Management to provide access via internal intranet and external web portal extensions for flexible and user-friendly access to real-time financial and customer specific information.

●Improved the performance of SQL Queries and stored procedures using SQL Profiler.

●Configured TEMP DB on files and file groups and capacity planning of databases.

●Configured and deploying SSIS packages and SSRS reports.

Database Administrator/Sr. Business Intelligence Developer (contract) Jan 2013 – Dec 2014

AUTONATION, Ft. Lauderdale, FL

●Installation, configuration, upgrade and migration of databases; this includes owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents, reviewing service related reports (database backups, maintenance, monitoring) on a daily basis.

●Participated in business analysis analytics to gather required reporting and dashboard requirements; translation of business requirements into specifications that are used to implement these reports/dashboards, created from potentially multiple sources across various platforms (Cognos, SQL Server, SSIS and SSRS).

Key Accomplishments:

●Migration from legacy reports to more advanced BI solutions (such as QlikView) while providing support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users (SSAS, SSIS and BIDS). Created and optimized database objects (tables, indexes, views, user defined functions, stored procedures & triggers) using T-SQL, SQL Plus.

●Participated in reduction of infrastructure costs up to 30% by consolidating over 50 underutilized SQL Server instances to Shared infrastructure running SQL Servers 2008 and converting large number of Physical servers to Virtual environment running VMWare 5.5.

●Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.

●Worked on Client/Server tools such as SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server. Created Database Maintenance planner for the performance of SQL Server, which includes Database Integrity Checks, Update Database Statistics and Re-index the fragmented indexes. Created DTS packages to migrate data from various sources to the SQL Server 2005.

●Working on Capacity Planning Project, part of that gathered CPU, Memory and Space utilization metrics for 400 Production Oracle, Microsoft SQL Servers, MySQL and created projections using SQL Server 2008 Analysis Services Data mining and create reports using Reporting Services.

Database Administrator / Business Intelligence Developer (contract) Jan 2011 – Dec 2012

CENTENE CORPORATION, Sunrise, FL

●Development of New Global Data Warehouse, analysis and reverse engineering of infrastructure reporting (SSMS, SSRS, SSIS and SSAS).

●Performed analysis for ongoing audit and migration efforts, as well as management reporting - audit, content, storage, configuration, testing (Business Objects, T-SQL, SSMS, Teradata and SharePoint).

●Used Oracle Essbase to forecast likely business performance levels and deliver "what-if" analyses for varying conditions.

●Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Key Accomplishments:

●Created hybrid model enabling savings of $1M monthly by utilizing combined financial research and complex SQL coding analysis to eliminate outliers and redundancies of the overall population costs and utilization trends.

●Developed and maintained monthly dashboards that served as a tool for administrators and clinicians to monitor financial and operational efficiency.

●Led migration from SQL 2000 to SQL 2005 & 2008 across entire infrastructure, resulting in better performance, scalability, application flexibility, and ability to troubleshoot problems.

●Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP in staging database from MS Access, Sybase, excel.

Corporate Assistant Controller Jan 2002 – Dec 2010

ROANNE GENERAL HOSPITAL, Roanne, France

●Hired as an Assistant Controller to manage day-to-day accounting functions working under direct supervision of the Corporate Controller. Oversaw the activities of the accounting functions and maintained current financial accounting procedures in accordance with the European Commission Fiscal Management Manual and IFRS (MS Excel, VBA).

Key Accomplishments:

●Through relentless audit and controls, uncovered discrepancies in newly developed Ecopass program resulting in significant process improvement and tighter controls within the initiative.

●Nominated for award regarding outstanding service to internal client teams and sustained development during 2004.

●Overhauled existing annual budget process and successfully implemented a more streamlined system.

●Proficiency in MS Office (Word, Excel, Outlook, PowerPoint, Access). Used Crystal Reports v 8.0 to create drill down reports.

Contact this candidate