SUMMARY

• Versatile Business Intelligence analyst with a solid background in Information Systems. Adept at recognizing gaps in business processes, then building procedures and functions that fill those gaps and answer data management and reporting needs. Strong programmer with a knack for clean, efficient code. Proven history of improving efficiencies by automating processes. Expert problem solver with a talent for identifying and troubleshooting ongoing data issues.
• Database Analysis Process Design Database Administration Business Intelligence
• VBA Spreadsheet Development Data Management Database Design Code Development
• Process Automation Troubleshooting Process Improvements Reporting
• MS Access SQL Querying Quality Assurance Bilingual: English Romanian

TECHNICAL SKILLS

SQL Server Reporting Services, TSQL, Oracle PL SQL, Cognos, Visual Basic for Applications / VBA, MS Office, Visio

PROFESSIONAL EXPERIENCE

Confidential

Lender Placed Insurance Provider

Data Architect SQL Server

• Implement bank data into SQL Server 2005 database. Utilize T-SQL in conjunction with PowerShell and xpCommandshell to extract csv files and format them for import into pre-defined tables. Involved in the implementation of SQL Server Reporting Services 2012, contributing to codified standards, and writing the instruction manual on SSRS 2012 development, using both Report Manager and Business Intelligence Development Studio.
• Offered visibility into building reports in SSRS, as an alternative to Excel Spreadsheets with Data Connections.
• Suggested uses of SSRS Report Manager, as a replacement for Business Intelligence Development Studio, that would offer more direct access to the data.
• Conducted information training sessions on the development studio and the report manager, showing how to go from establishing a data source, to having a completed report.

Confidential

Business Intelligence SQL Developer SQL Server

• Support QL Servicing, delivering user-interactive reports to business leaders, using SQL Server Reporting Services, as the platform. Create SQL Stored Procedures, designing web reports that take user input for processing and returning data. Optimize Existing Stored Procedures when they no longer performed correctly. Interact with Business Leaders, collecting requirements for user-interactive reports.
• Created centralized reporting for Quicken Loans Servicing using SQL Server Reporting Services
• Gathered requirements for reports to measure the progress of reinstating clients who have defaulted on their loans. Metrics included the speed with which we sent out reinstatement applications which usually had to go out 45 days after default and the speed with which these were filled out by the client and returned within 30 days, or so .
• Created visibility around this process which didn't exist before, leveraging SQL to report on these steps in a way that the source system couldn't.
• Increased productivity with SSRS by giving enabling the team to send out applications to clients in a timely manner and to contact clients ahead of time who would likely be late in paying.
• Converted de-normalized data into normalized data, loaded it to our database, and reported on completions of steps required for foreclosure. Parameters for completion included the Property State, past Default activity, and the type of loan whether Purchase or Refinance .
• Extracted loan data from SQL Server and Transformed data-type to text for FTP, using SSIS.
• Expedited data sequential execution of Stored Procedures and data transformation and extraction using SSIS.
• Enabled business leaders to boost productivity by going to one location for metrics, work lists, and scorecards, removing their reliance on cumbersome Linux-based software for production metrics, using SSRS for both parameterized and single snapshot reporting.

Business Intelligence Analyst SQL Server

• Automated manual report building processes, transitioning Excel, Access, and Web-App based systems for gathering and calculating data into SQL Server Queries. Gathered report requirements from clients and built SQL Server reports that were executed on a weekly/monthly basis. Created Stored Procedures for pulling data and utilized Report Builder for hosting the reports on a website, to be accessed at will by the client.
• Reduced jobs of several days down to several hours.
• Decreased reliance on legacy systems by reverse engineering data extracts to build logic into SQL Server-based queries, allowing for a higher degree of accuracy.
• Decreased file-sizes for Excel Pivot-table based reports by removing pivot tables, replacing them with SQL queries, and returning the data to Excel. Cleanliness and accuracy also increased, as a result.
• Delivered instant results, by creating Stored Procedures that create reports which take input from the client as parameters.

Confidential

Business Intelligence Analyst Oracle, Excel, Access, VBA

• Performed Ad-hoc queries, process reporting, and data mining requests on an as-needed basis. Created and maintained queries and Excel based procedures for ongoing data mining and reporting initiatives, on a monthly and daily basis. Supported the Enterprise Quality group in calculating weekly performance metrics and checking them against baselines.
• Scheduled long-running code in Cognos to extract, aggregate, and report data.
• Showed the flow of menus used by OnStar advisors in servicing clients, by writing Visual Basic code in Visio, going from a tabular view of screen IDs and relationships to a flow-chart presentation.
• Streamlined processes and queries for extracting, mining, and reporting OnStar call data to monitor call-center performance, user experience with OnStar, and outstanding problem resolution cases.
• Integrated MSAccess with Oracle to speed up reporting and data mining due to limited bandwidth.
• Reduced the process time for obtaining and reporting monthly roadside assistance call data, from Oracle, from 45 minutes to 15 minutes, creating an Access database for reporting and data manipulation while using Oracle only for extraction.

Confidential

Software Developer/Application Designer VBA

• specs, possible inconsistencies and redundancies between the two applications. Planned, executed, and validated the entire development process, coordinating with developer of viewing tool to merge the two applications.
• Built Excel-based data mining tool to author automobile feature data for generating Product Direction letters, used as spec designs for making cars. Integrated PivotTables with tradition Excel tables to model relationships among vehicle features, model years, and regions of distribution. Collaborated with developer and dba to integrate authoring tool with viewing tool into 1 file, defining functional
• Consolidated vehicle feature data into one central location, where it could be viewed or changed without affecting the source data, until changes are published.
• Developed testable prototype of Excel-based authoring tool, to be brought to stakeholders.

Confidential

Business Intelligence Analyst

• Ensured unified efforts towards GM goals across a global corporate landscape by administering Excel reports and schedules, assuring that all personnel remained current on accurate milestones and project dates. Automated report updating by implementing macros that accessed extracted text data files integrated into Access. Maintained integrity of information covering deliverables dates, benchmarks, key managers, engine types, and vehicle dates.
• Reduced update time for the 3-year report from 3 days to 20 minutes.
• Improved efficiency of data mining and reporting by developing applications bridging Access and Excel.
• Automated schedule production, introduced internal data quality checks, and lowered file sizes by designing and implementing code capable of pulling data from the 3-year report to populate schedules.