Robert Crisan Email & Phone Number

Utica, Mi, Us

Utica, Mi, Us

Troy, Michigan, Us

• Lead the design and development of major new BI initiatives. Manage BI resources – internal, contract, offshore, and external 3rd party vendors. Provided both strategic and tactical direction. • Implemented best practices in configuration and processes across BI and SQL Server installations. • Monitor off-shore team performance, verifying adherence to SOW and SLA requirements. • Mentor BI team members on best practices. Provide guidance as needed. Analyze and prioritize workload.• Review project requirements with business users and assure they are properly documented, fulfilled, and delivered. Develop project plans and resource estimates.• Evaluate direct reports performance, set formal goals and objectives in line with BI and Corporate initiatives.• Train off-shore team on proper UAT set up and execution, user communication, intra-group collaboration.• 9 SQL DB instances, 4 SSAS, 4 SSRS, 20 production BI user databases. Over two dozen deployed solutions. 250 ETL packages. 6 cubes. 500+ SSRS reports.• Designed new BI Server architecture best suited to support current and future business needs and minimize cost.

IT Consulting and Services firm

Northville, Michigan, Us

• Senior SQL DBA solely responsible for administering 1360 user databases across 63 instances, including extensive virtualization and SQL Server 2014 clusters. DBs up to 1.8 TB in size. 24x7x365, worldwide support. • Designed and developed customized SQL monitoring system based on Central Management Server functionality. Automated reporting of SQL Server drive space, failing jobs, instance and database inventory, SQL restarts, and invalid DB principals using SSIS eliminating the need for any 3rd party monitoring tools.• Implemented backup/archive, integrity check, and optimization processes. Developed SOX/Audit SSRS reporting. Led effort to segment databases after division of Federal Mogul into two distinct business units. Hardened security. Documented environment. Planned and executed SQL upgrades from 2008 R2 to 2012 and 2014.• Conducted numerous performance tuning initiatives including reducing critical corporate month-end financials runtime process from 4 hours to under 4 minutes.

Dearborn, Mi, Us

• ETL and BI Functional Lead, designed and developed SSIS ETL processes supporting client’s SAP migration utilizing Agile methodologies. Using Python and ArcGIS API, scrubbed name and address data using Geocoding process. • Designed and updated Universe structure and user reports using Business Objects enterprise products.

• Inventoried and documented infrastructure, secured the environment, established disaster recovery processes, set up DB maintenance, conducted training of both users and developers, implemented and enforced SQL security “best practices”. Created and published corporate standards for SQL Server development. • Supported over 300 SQL Server databases up to 1 TB in size across 42 instances. Initiated and implemented SQL “Development/QA/Production” architecture across the organization. • Tuned and\or reengineered problematic mission critical processes. Analyzed query plans. Reduced execution time from many hours\minutes to minutes\seconds or better. Reviewed\approved new DB code and changes.• Automated claims\check entry and exception processes eliminating manual entry of a few thousand claims per day. • Lead technical resource on multiple high-profile corporate systems and initiatives including new Claims and Reinsurance Management Systems. Supported Actuarial Department and corporate data marts.• Developed dozens of ETL processes utilizing SQL 2000 DTS and SQL 2008R2 SSIS. Converted DTS packages to SSIS projects. Proactively identified root cause and resolved data quality and integrity issues. Developed SSRS reports.• Created formal processes, controls, and documentation to satisfy SOX (Sarbanes-Oxley) compliance.• Planned, directed, and executed migration from SQL 2000 to SQL 2008 R2. Mentored junior level DBAs and developers.

• Senior DBA supporting over 100 databases up to 500 GB in size across fifteen servers.• Responsible for development and support of company’s Data Warehouse and Cubes using MS Analysis Services. Star and Snowflake schema. • Automated creation of new databases, security, and associated maintenance plans required for monthly billing.• Led development of sales report application allowing sales force daily access to revenue and quota numbers. CEO directed all management personnel and agents to make use of this information.• Introduced company to the use of SQLMail in DTS Packages and automated creation and distribution of many reports, automating FTP file send\receive.

• Sole architect of logical and physical database designs and business logic for multiple critical, high profile projects for the client, Ford Motor Co., including Blue Oval Certification. Designed strategic multitenant data model allowing reuse outside current project, with architecture ensuring a stable, secure environment. Over 150 tables.• Led team of three DBA’s. Authority to review and approval of all database and code changes. Directed DBA’s on the implementation and enforcement of naming and coding standards and best practices. • Responsible for development and support of ETL processes. Assessed data quality and availability. Integrated data from various sources, defined data validation requirements. Conducted import/export data analysis - currency, frequency, access, platform, and transfer mode. • Responsible for design and construction of stored procedures and DTS Packages, schema creation and maintenance, ad hoc reports using Access, as well as database tuning and code optimization.• Designed and created dozens of reports used in assuring quality of system data which were instrumental in client’s decision to renew project contracts with VSI. Developed Access UI for ongoing report generation. Created automated process allowing users to initiate data export and other SQL processes via email.

• Lead DBA for telecommunications firm supporting over 40 SQL Server 7.0 databases up to 40GB across 3 servers. Responsible for trigger and stored procedure design and development, replication, DTS Packages, performance tuning, security, data modeling, and DB standards. Developed and implemented database disaster recovery strategies and procedures. Implemented a structured DB development environment including a formal change control process.• Set up numerous data marts to facilitate management decision-making.

Minneapolis, Mn, Us

• Development manager for 12-member team and lead DBA responsible for SQL Server implementations across 5 servers. Developed and enforced database standards. On call 24x7. Hire\Fire authority.• Authority to review and approve all technical deliverables. Evaluated technical staff. Mentor for junior level individuals. • Responsible for logical/physical design and implementation of all significant data models and applications including Ford Certification, Ford and GM Used Car Certification, Chrysler Five Star Dealership, and many CRM applications to support CMG’s Call Center.• Flexible, scalable designs allowed reuse and significant cost savings to Carlson. Extensive direct contact with clients and vendors including Ford, Chrysler, GM, Saturn, and Audi.• Responsible for performance tuning, database backup and restore, disaster recovery, T SQL, data quality and integrity, query and application performance, data and application security.

Detroit, Michigan, Us

• GM Technical Systems DevelopmentManaged 18-member team responsible for design, development, and support of the vehicle order and logistics systems used across all 31 GM North American assembly plants. 1200+ modules. Determined and prioritized user requests and release schedule, responsible for work assignments, release build content, quality, and documentation. Provided technical guidance and direction to team, responsible for formal reviews. • GM St. Louis Assembly PlantLed the successful migration to new order processing system at the St. Louis Assembly Plant – the system that controlled the building of vehicles. 1200+ modules. Designed and developed all required interfaces. Planned project and directed team members. Reviewed and approved all work.• GM Truck and Bus Production Systems Support GroupProvided first line support for various mainframe manufacturing plant applications including order processing, quality assurance, logistics, and material for 4 GM Truck and Bus assembly plants. Systems written in PL/I, Assembler, COBOL, and JCL, using VSAM and sequential files with CICS interfaces. On call 24x7.• GM Technical Data Management FacilityResponsible for design, development, and implementation of several subsystems for an engineering drawing library application. Developed two versions simultaneously: PL/I using DB2 database on IBM mainframe and in C with Ingres database on UNIX platform. • GM Orion Assembly Plant Developed and supported mainframe and PC plant systems written in Access, BASIC, C, PL/I and JCL, using DB2, VSAM, and sequential files and CICS interfaces on IBM mainframe, PC, Welch Allyn (bar code), and PLC platforms. Developed and implemented process allowing vehicle data to be collected using hand-held and fixed position scanning devices. • GM Vehicle Order Management Participated in the design and development of prototype of dealership vehicle order application. VB 3.0 front end over Access 2.0 database.