Jerry Murillo Email & Phone Number

Chicago, Il, Us

Idaho Falls, Id, Us

-Idaho National Laboratory is one of the national laboratories of the Department of Energy (DOE).-Provide support for our clients to take control of their data and get value out of it by defining a reference architecture.-Help design the architecture of leveraging tabular data models and Power BI in a solution.-Choose the right way of sharing and designing the gateway configuration as well as the communication of Power BI with other tools and services.-Use Azure where appropriate.-Assist in defining data governance and data security requirements and provide methods to monitor the access of any sensitive data.

Chicago, Illinois, Us

•Anthony Marano Company is a wholesale distributor of fruits and vegetables that offers the freshest and best produce that can be found. By providing innovative solutions to meet every customer's unique produce needs, the Anthony Marano has become the leader in the produce industry.•Headquartered in Chicago with a vast distribution network that spans all over the Midwest.•Working on several Business Intelligence projects to assist the company in all facets of the company - Finance, Accounting, Marketing, Sales, Operations, and Inventory Analysis.•Major aspects of the projects involve maintaining the Data Warehouse and several related cubes, and reports that can provide more timely information to assist upper management in making critical business decisions..•Serves as subject matter expert in business intelligence concepts.

Rosemont, Illinois, Us

•Responsible for designing, developing, and implementing Data Warehouses, Tabular Model, Power View and Power Pivot reports for the organization. •Served as subject matter expert in business intelligence concepts. •Used SQL Server, SSAS, MDX, DAX, Tabular Model, SSIS, SSRS, Power Pivot, Power View, SharePoint, MS CRM, and T-SQL

Chicago, Illinois, Us

Worked with one of the most diversified steel manufacturers; it is headquartered in Chicago with manufacturing facilities located throughout the world. It produces a wide array of specialty steel products including plate, coiled plate, welded and seamless pipe for oil and gas applications, structural tubing, rail and wire rod / bar..•Working on a Business Intelligence project to assist the company in Inventory Analysis.•Major aspects of the project are to design a data warehouse, cubes, and reports that can provide more timely information on the impact of inventory transactions.•SSIS is used for ETL development, SSRS is used for reporting, and SSAS is used for the design and development of the OLAP cubes.•The deliverables will also help in ad-hoc retrieval and reporting and leverage the potential of new tools, such as PowerPivot.•Serves as subject matter expert in business intelligence concepts.

•Worked with a Credit Union that is a fully independent financial institution with more than 230,000 members. It offers a wide variety of financial products including checking, savings, credit cards, and mortgages.•Project is charged with designing and developing the data warehouse and SSAS OLAP cubes to supplement the cubes, data warehouse, and reports provided by the installed Symitar product.•Major aspects of the project are to design a data warehouse, cubes, and reports not provided by the Symitar product, but that can provide the more common data elements that an analyst in a financial institution would be most interested in.•SSIS is used for ETL development, SSRS is used for reporting, and SSAS is used for the design and development of the OLAP cubes.•The deliverables will also help in ad-hoc retrieval and reporting and leverage the potential of new tools, such as PowerPivot and Power View.•Serves as subject matter expert in business intelligence concepts.

Franklin, Tn, Us

• Worked with a heath organization that provides disease management and wellness programs to managed care companies, self-insured employers, governments, and hospitals, with the ultimate goals of improving members' health and lowering health care costs. Its disease management programs help members manage chronic illnesses like diabetes and emphysema, making sure they keep up with treatment plans and maintain healthy behaviors.• Responsible for designing, developing, and implementing Data Warehouses, Cubes, and SSRS reports for the corporation. Required to help design distribution strategy for PDW appliance. Serves as subject matter expert in business intelligence concepts.• Project is charged with designing and developing the data warehouse and SSAS OLAP cubes. Will also use SQL Server 2012 and SSDT and SSIS to develop an ETL solution for the company.• Major aspects of the project involve retrieving data from the Oracle source systems and storing the Data Warehouse in the PDW (Parallel Data Warehouse) appliance.• Responsible for developing data warehouse in PDW appliance, developing ETL and ELT strategies, monitor PDW performance, develop SSIS packages, OLAP cubes, SSRS reports, PowerPivot applications, and Power View reports using Microsoft BI tools.• Coordinate with executive level management to develop and prioritize strategic IT plans and processes to support organizational goals.• Responsible for optimizing data models for business intelligence implementations.• Responsible for knowledge transfer of BI concepts and procedures to the other IT staff members.• Databases are large – up to 8 TB (terabytes) in size.• Uses SQL Server Data Tools (SSDT) and SSIS for ETL purposes, along with PDW, SSRS, SSAS PowerPivot, Power View, and MDX.

Working on project to design and develop the data warehouse and SSAS OLAP cubes. Will also use SQL Server 2012 and SSIS to develop an ETL solution to populate the data warehouse. Will also use SSRS to develop reports. Data warehouse will store over 8 TB of data in a Microsoft Parallel Data Warehouse (PDW).

New York | San Francisco | London | Paris | Bermuda, Us

>Assured Guaranty is the leading provider of financial guaranty insurance. The company guarantees scheduled principal and interest payments when due on municipal, public infrastructure and structured financings.>This is a short-term project to design and develop the data warehouse and SSAS OLAP cubes. Will also SQL Server 2012 and SSDT (SSIS) to develop an ETL solution for the company.>Responsible for designing, developing, and implementing Data Warehouses, Cubes, and SSRS reports for the corporation. Code optimization, and front-end implementation and development. Serves as subject matter expert in business intelligence concepts. Uses SQL Server 2012, SSAS, SSIS, SSRS, T-SQL, and MDX.>Major aspects of the project involve fusing Risk Analysis with Management and Statistical Data Analysis by incorporating various attributes into the cube.>Solution involves integrating OLTP data by calling web services from the ETL application.>Responsible for developing data warehouse, OLAP cube and business intelligence solutions utilizing the Microsoft BI platform.>Coordinate with executive level management to develop and prioritize strategic IT plans and processes to support organizational goals.>Responsible for optimizing data models for business intelligence implementations.>Responsible for knowledge transfer of BI concepts and procedures to the other IT staff members.>Use SQL Server Data Tools (SSDT, formerly SSIS) for ETL purposes, along with SSRS, SSAS and MDX.>Use XMLA to automate the execution of the deployment and process steps for the SSAS cube.

Chicago, Il, Us

>SpringCM is the market leader in enterprise-class, cloud enterprise content management (ECM) and workflow solutions. SpringCM is a market leader in the knowledge management and content managerment fields.>This is a short-term project to upgrade the data warehouse and SSAS OLAP cubes. Will also migrate other SSIS and SSAS solutions to SQL Server 2012.>Responsible for designing, developing, and implementing Data Warehouses, Cubes, and SSRS reports for the corporation. Code optimization, and front-end implementation and development. Serves as subject matter expert in business intelligence concepts. Uses SQL Server 2012, SSAS, Analysis Services Tabular Model, SSIS, SSRS, PowerPivot, Power View, T-SQL, and MDX.>Major aspects of the project were for website usage monitoring, including page hits, navigational paths, etc.>Responsible for developing data warehouse, OLAP cube, presentation level reports and visualizations, and business intelligence solutions utilizing the Microsoft BI platform.>Coordinate with executive level management to develop and prioritize strategic IT plans and processes to support organizational goals.>Responsible for optimizing data models for business intelligence implementations. >Responsible for knowledge transfer of BI concepts and procedures to the other IT staff members.>Use SQL Server Data Tools (SSDT, formerly SSIS) for ETL purposes, along with SSRS, SSAS, PowerPivot, Power View, and MDX.>Use XMLA to automate the execution of the deployment and process steps for the SSAS cube

Chattanooga, Tn, Us

US Xpress provides dedicated, regional, and expedited team truckload services. The Company is one of the largest providers of expedited and time-definite services in the truckload industry and is a leader in providing expedited intermodal rail services.Worked in the Business Intelligence group using Microsoft BI tools, including SQL Server, SSRS, SSIS, and SSAS.

Gurnee, Il, Us

BrightStar Health Care franchises in-home health care businesses around the country. It currently has close to 300 franchised locations.• Responsible for designing, developing, and implementing PerformancePoint Dashboards, Data Warehouses, Cubes, and SSRS reports for the corporation.• Also develops dashboards on the SharePoint platform using PerformancePoint.• Created the project plan, served as BI architect and developer. Responsible for designing the data warehouse database, the OLAP cubes, the SSIS packages, the PerformancePoint dashboards, and the SSRS reports.• Coordinate with executive level management to develop and prioritize strategic IT plans and processes to support organizational goals.• Responsible for optimizing data models for business intelligence implementations. • Responsible for knowledge transfer of BI concepts and procedures to the other IT staff members• Code optimization, and front-end implementation and development. Serves as subject matter expert in business intelligence concepts.• Uses SQL Server, SSAS, SSIS, SSRS, T-SQL, and PerformancePoint.

Oak Brook, Illinois, Us

Pleasant Prairie, Wi, Us

Uline is the leading distributor of shipping, industrial and packaging materials to businesses throughoutNorth America. Current project involves designing and developing a Data Warehouse to assist in gathering and reporting data on warehouse operations. This project aims towards providing systematic methods for assessing costs incurred and evaluating options for controlling those costs. Using SSIS (SQL Server Information Services) to Extract, Transform, and Load (ETL) data from the AS 400 database. SSIS packages are created to Extract, cleanse data from AS 400 databases and Excel spreadsheets into a dimensional data warehouse. OLAP cubes are to be created at the top of which the Dashboard reports and KPI’s are defined. The Dashboard will be used by upper management. Also involved in generating reports and charts using SSRS (SQL Server Reporting Services). Plan is to develop OLAP Cubes using SSAS (SQL Server Analysis Services) to help power users use the data in a multitude of different ways.

Lincolnshire, Il, Us

- Working with SAP data sources to develop and implement a Data Warehouse and OLAP Cubes.- Application will allow power users and other end users to expand their ability to analyze company operations.- Using the Microsoft BI Stack, including SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), and SSAS (SQL Server Analysis Services)

Expanded the functionality of the Data Warehouse intended towards the measurement and assessment of labor costs. This project aims towards providing systematic methods for assessing costs incurred and evaluating options for controlling those costs. Used SSIS (SQL Server Information Services) to Extract, Transform, and Load (ETL) data from different sources. SSIS packages are created to Extract, cleanse data from Oracle and SQL Server databases and Excel spreadsheets into a dimensional data warehouse. OLAP cubes are created at the top of which the Dashboard reports and KPI’s are defined using Share point Excel services, Generated reports and charts using SSRS (SQL Server Reporting Services). Developed OLAP Cubes using SSAS (SQL Server Analysis Services) to help power users use the data in a multitude of different ways. Laid the groundwork for an application that involved gathering budget forecast information, along with comparing actual costs. The application was designed to use a C# ASP.NET front end for gathering much of the information.

Houston, Texas, Us

- Responsible for developing data warehouse and business intelligence solutions utilizing the Microsoft BI platform.- Responsible for optimizing data models for business intelligence implementations.- Responsible for the maintenance of existing data warehouse and business intelligence implementations.- Responsible for database tuning, T-SQL proficiency, ER modeling and normalization, and query optimization.- Used SQL Server Integration Services (SSIS) for ETL purposes.- Used SSRS, SSIS, and SSAS tools extensively.

- Develops web applications using WCF and Web Services.- Develops aspx web pages using the .NET framework, C#, and SQL Server as the backend.- Develops numerous SSIS (SQL Server Integration Services) applications that use virtually every component in the SSIS toolbox. Has used Lookups, Merge, Split, Conditional Split, For Loop, FTP Task, Excel Source and Destination, Package Configurations using SQL, XML, and Environment Variables, and more. - Develops reports using SQL Server Reporting Services (SSRS). The reports use most of the features available in the tool, including parameters, subreports, column formatting, and implementing security constraints.- Security is paramount in all work done for the company. The company has to adhere to HIPAA regulations in the protection and dissemination of any data.- The database tables are very large considering that all claims history for every Medicare participant is being maintained.

- Worked on application for one of the manufacturing plants. Application is designed to help in order processing and monitoring progress of orders, raw materials, finished goods, and inventory control.- Worked on WinForms, using DataGridView and Oracle back-end.- Developed several reports using Crystal Reports and integrating the reports with other Windows applications.- Worked on Web application using Visual Basic and Oracle back-end.

Us

- Team Lead for Sales and Marketing website development. Had a group of 3 people. Obtained requirements from user department. Developed application to assist marketing department, incorporated reports using SSRS (SQL Server Reporting Services.) Website provided easy navigation for users to access their own particular areas, pages for data entry, and pages with reports were provided.- The applications worked on acquired data from a variety of sources, including mainframe and SQL Server databases.- Developed web applications using C#, VB.NET, ASP.NET, and ADO.NET.- Also developed applications using SSRS (SQL Server Reporting Services). - Integrated the SSRS reports into a web application where parameters were captured and passed to the report.- Responsible for creating databases, tables, and stored procedures for the applications which were being developed.- Worked with linked servers and also used SSIS (SQL Server Integration Services) to copy and data between servers. - Developed an SSAS (SQL Server Analysis Services) application for the marketing department so that the user community could compare the results against a similar application developed with Essbase.- Built a data warehouse/data mart. - Team Lead for installing TFS (Team Foundation Server). As Team Lead, formed committee to develop goals, standards, and review test plan. Also conduct interviews and gather requirements for the TFS environment. Assigned tasks and monitored task completion.- Developed a custom TFS team project template based on requirements. - Used Agile methodology for development of applications.- Involved in setting up standards for security related to SSRS applications and SSIS packages. Assisted in setting up standards for deploying SSRS applications and SSIS packages from the Development environment to the Test Environment to the Production Environment.- Involved in web-based design and architecture, and involved with prototyping and creating GUI’s.

Charlotte, Nc, Us

- Responsible for creating and maintaining new functionality on the internet web site used for communicating customer-related information back to the customer. The type of information being displayed includes past invoices, statements, purchase orders, bills of lading, delivery information, contact information, etc. Customers and Customer Sales Representatives use the application extensively to monitor sales, deliveries, and payments.- The application can be used for placing orders over the internet on a 24/7 basis without requiring assistance from a Customer Service Representative.- The web site application is also used to setup and maintain email and fax notifications of various progressions during the processing of an order. For example, a customer can set up a system of notifications as to when a particular order is loaded onto a delivery truck, when it is actually delivered, when it is invoiced. The notification can be sent out via email and/or fax.- Served as Team Lead for providing data to the SAP project. Had a group of 2 people. Used SSIS to extract data from existing applications, manipulate the data, and provide the data in a usable format for the SAP team. Worked with the end user department in formulating and merging data from existing applications.- Use .NET technologies (ASP.NET, VB.NET, C#, VBScript, JavaScript, WCF, Web Services, XML, SQL Server, SQL Server Reporting Services, and Transact SQL)

Auburn Hills, Michigan, Us

- Responsible for creating and maintaining new functionality on a manufacturing application that uses a .NET web-based intranet application for reporting and administrative purposes and uses .NET Windows applications to control the computers on the assembly line. Data is transmitted from one workstation to the next using .NET Remoting. For each item manufactured, all pertinent data is captured on the assembly line using XML, and then when the manufacturing process is complete, the XML data is sent to the server using MSMQ. On the server the XML data is written to a SQL Server database. This application uses VB.NET and C# with SQL Server as the backend. Web Forms, WinForms, Web Services, Windows Services are all used. Some pages display charts. Most of the .NET controls are used, including drop down lists, datagrids, calendar controls. Also evaluated using Windows Workflow (WF).- Developed reports using SQL Server Reporting Services (SSRS). The reports use most of the features available in the tool, including parameters, subreports, column formatting, and implementing security constraints. - Responsible for the offshore development of the GUI presentation layer. Developed specifications, responsible for all communications, and worked with offshore web designers to ensure tasks were completed in a timely manner according to the specifications.- Web pages developed allow the editing of datagrids and drop down lists within the datagrid.- Developed web applications using .NET technologies (ASP.NET, VB.NET, C#, Web Services, VBScript, JavaScript, XML, SQL Server, SQL Server Reporting Services, and Transact SQL)

Charlotte, North Carolina, Us

- Responsible for implementing the NEXUS Energy Vision product.- Application is an intranet application using C#, ASP.NET, Oracle.- Used UML and Use Cases to help in Systems Analysis.- Used Enterprise Architect to assist in modeling Use Cases, Class Diagrams, and Sequence Diagrams- Procedure developed to take data from an existing SQL Server database and convert it to an Oracle database.- Developed user input panels using C#, ASP.NET, Oracle.

Auburn Hills, Michigan, Us

- Responsible for creating and maintaining new functionality on a web-based intranet application. The new application uses VB.NET and C# with SQL Server as the backend. Some of the pages use Web Services. Some pages require displaying SQL Server data in the form of bar graphs and line graphs. Most of the .NET controls are used, including drop down lists, datagrids, form validation using regular expressions.- Web pages developed allow the editing of datagrids and drop down lists within the datagrid. - Developed reports using SQL Server Reporting Services (SSRS). The reports use most of the features available in the tool, including parameters, subreports, column formatting, and implementing security constraints.- Develop web applications using .NET technologies (ASP.NET, VB.NET, C#, VBScript, JavaScript, XML, SQL Server, SQL Server Reporting Services, and Transact SQL)- Involved in web-based design and architecture using UML, and involved with prototyping and creating GUI’s.- Rewrite an existing Visual Basic 6 manufacturing application using WinForms and Web Forms and VB.Net and utilize .NET Remoting and XML in the solution. Requires redesigning the SQL Server database tables.- Developed a Windows Service to read messages from a queue using MSMQ.

IT consulting firm developing applications for Fortune 500 companies.

Instructor related to IT disciplines

Winston-Salem, Nc, Us

Winston-Salem, Nc, Us

 Integral member of the Year 2000 project team.  Trained new staff members in using CA-Ideal and in the process of analyzing Ideal code for modifications.  Provided team with techniques for modifying databases and dataviews; process of analyzing code and making corrections; and process of controlling and implementing changes. Used IBM mainframe, AS/400, and client/server systems to develop new on-line applications to control and modify schedule for product shipment out of the Distribution Center. Before developing these applications, the process was very haphazard and caused many delays and carrier surcharges because of scheduling problems between plant personnel and the carriers. The new system corrected these problems, improved product flow, reduced the number of late shipments, and reduced the surcharges being made by the carriers.

Chicago, Il, Us

- Worked for Hanes Hosiery.- Developed a new on-line application to help Field Sales Personnel in managing their accounts. The new application was closely linked to the client server application that was also being developed. The application developed was responsible for gathering and storing customer information, linking certain indicators with other applications such as Billing, and correcting erroneous sales. The application was designed to minimize the reliance on paper forms. After five months on the assignment, was elevated to the project leader position. - Worked closely with end users, DBAs, and the project management staff. The application was written for a multi-platform environment, using various languages and databases. - Worked on mainframe applications using CA-Ideal, COBOL II, DB2, DATACOM/DB, SQL. - Helped design DATACOM/DB databases. - Worked on client-server applications using PowerBuilder, Oracle, SQL

Phoenix, Az, Us

- Responsible for developing an application to track Medicare/Medicaid recipient interactions with the Department and to link the recipient’s records with other departmental records. The application required the use of structured analysis and development techniques (Foresight, ADW, process models, data models), and the use of data normalization techniques to develop the databases. Incorporated several techniques to speed development, such as, developing a program model from which to copy other programs, and a standard naming convention for panel fields. - Used CA-Ideal, CA-Dataquery and DATACOM-DB.

- Responsible for designing and maintaining databases.- Used data normalization techniques extensively.- Interfaced with both, end users and application developers, to help identify and document systems requirements.- Helped develop the system development methodology and monitored the adherence to the policies established in the methodology.- Worked with DB2, DATACOM/DB, ADABAS.

- Worked as Data Administrator.- Responsible for designing ADABAS databases and instructing the programming staff on the most efficient method of accessing data bases. - Worked closely with the system development methodology to ensure corporate procedures were being followed.- Utilized data normalization techniques in designing databases.

London, England, Gb

- Held various roles over 11 years. From Programmer/Analyst to Systems Analyst to Sr. Systems Analyst. Also had roles as DBA, EDP Auditor, and Project Leader.- Responsibilities were to analyze and design computer applications, to budget the department's resources, and act as liaison between users and the DP staff.- Analyzed and designed IMS and ADABAS computer applications, maintained existing systems, and wrote computer programs for various departments within the company.- As an auditor, responsibilities were to:>> develop and implement a plan for establishing an EDP audit function within the company, and >> perform financial and operational audits of various departments within the corporation- Acted as the DBA for the ADABAS database. Responsibilities included:>> The daily, weekly, and monthly backup of all the ADABAS databases and reindexing the files as required.>> Responsible for designing new tables and identifying primary keys. >> Provided the programming staff with technical guidance in the best method of accessing the various databases available.

- Reponsible for all IT operations at the Air Force base.- Supervised a staff of up to thirty individuals.- Supervised programming staff, operations staff, and data administration staff.- Communicated with upper managerment regarding all the IT activities.- Communicated with the user community regarding thier particular applications.

Master Of Arts - Ma, Accounting

Bachelor Of Arts - Ba, Mathematics

Mathematics

H.S. Diploma, Academic