JAMES M. ETLING

**** ***** ******* ******, ***. * Chicago, IL 60640

317-***-**** adh113@r.postjobfree.com

Profile

Business Intelligence Professional with excellent critical thinking, troubleshooting and communication skills applied to produce results independently and in core project environments.

Work History

Polaris Consulting & Services Ltd, Senior Architect - Technology, Chicago, IL 2017-2020

Designed, Configured and Administered BI environments at The Northern Trust. Built and administered migration of 500+ user environment from Cognos BI v10.2.2 to Cognos Analytics v11.0.11. Performed Administrator duties/upgrades supporting several Cognos installations. Engaged with vendor to resolve upgrade-related issues for Cognos 11.0.x/11.1.x. Developed and performed Load Test plans for environment and Certification testing for client tools. Developed and scheduled automation scripts. Tuned environments as required. Oversaw monitoring standards and procedures all BI environments (Cognos, PowerBI, Hyperion). Supported IBM Cognos Analytics, Planning Analytics, CaseWare software installations. Managed service calls and requests in ServiceNow.

Sawdey Solution Services, Sr. Cognos Systems Administrator, Scott AFB IL 2015-2017

Designed, Configured and Administered Cognos BI 10.2.2 environment for SRDA at 618th Air Operations Center (TACC). Administered IIS website for Cognos. Performed Administrator duties for all Cognos server and client systems in division subnet. Maintained security compliance (STIG) at application and IIS website levels. Developed Framework Manager packages, reports and dashboards for conversion from MS Access to Cognos. Achieved CompTIA Security+ certification. Developed plans for future expansion and transition to Cognos Analytics (Cognos 11).

Tech Mahindra, Sr. Project Manager (Cognos Administrator), Cincinnati OH 2008-2015

Administered Cognos environments (v. 7.x-10.2.1, TM1 10.2.1) for multiple GE business units. Investigated performance and technical issues with Cognos in UNIX and Windows installs. Managed integration of security with Identity Manager provisioning. Migrated objects along Dev, QA/UAT, and Prod environments. Troubleshot report issues as needed. Managed IIS configuration of webservers, datasource connectivity, and application/dispatcher configurations. Adjusted configurations in Cognos as required. Administered third-party software (Genware, MotioCI).Built/designed reports and dashboards as needed. Handled alerts on 24/7 basis. Installed/configured services and upgrades. Built scripts in Windows/UNIX platforms as required to address functional needs. Developed macros for queries of Oracle and Cognos Access Manager. Achieved IBM Certification for Cognos 10 Administration. Set oncall schedule and managed team-specific web portal for documentation.

Ryan Consulting Group Inc., Cognos Administrator, Indianapolis, IN 2007-2008

Managed an integrated Cognos 7.x/8.x environment in Windows accessing Oracle 10g data warehouses for DoD Defense Finance and Accounting Service (DFAS) customers. Configured and installed Cognos 8.3 prototype server and clients, including validation and upgrading of all Cognos 8.12 production objects, environment customizations, security, SDK automation and process documentation. POC for Cognos Support. Applications include: Access Manager, Framework Manager, Metrics Designer, Planning (Analyst, Contributor Admin), PPES, Transformer, Cognos Connection (Query Studio, Report Studio, Metric Studio, Cognos Adminstration), Configuration Manager, IIS 6.0, XML, CSS, ETL, Windows Server 2003, SunOne LDAP Server, TOAD, Oracle 10g Client, Java, VBScript, ASP.

Marion County Information Services Agency. Contract Manager Indianapolis, IN 2006 – 2007

Managed and facilitated multiple projects to assure compliance with Information Services Agency criteria for agreed upon scope of work. Identified shortcomings in design, quality or delivery of contracted services and developed procedures to define, manage and monitor improvement. Primary point of contact for all City/County personnel and contracted vendors. Reported to CFO.

Indiana Department of Homeland Security, CSEPP Systems Analyst, Indianapolis, IN 2004 - 2006

Administered Sun and Samba server array and Windows clients at the Emergency Operations Center. Consult and assisted CSEPP (Chemical Stockpile Emergency Protection Program) counties with maintaining similar networks. Created security policies and department-specific shares. Resolved connectivity, firewall and installation issues for all third-party software used at State Emergency Operations Center (EOC), CSEPP county and Indiana National Guard locations. Consolidated and normalized data from previous systems into Training Division database. Created reports and developed code to enforce data integrity and business rules for Training Division database. Configured FOSRX (Marta Systems’ NOAA weather alert tracking system) to Agency specifications. Debugged Tracsys message tracking system to address long-standing design flaws. Managed design of statewide web-based Emergency Management message tracking system. Diagnosed and resolved firewall issues to enable GIS access at Stout Field via Indiana State VPN. Designed and administered conversion of printer queues for DHS. Department contact for Windows, MS Exchange, WebPuff, Sun and RAS Administration. IT support for Operation Hoosier Relief disaster recovery deployment to Biloxi, MS (Oct 2005).

Network Engineering Inc., IT Sales Consultant, Indianapolis, IN 2003

Initiated and maintained consultative relationships with small and mid-sized businesses for network integrator, developing IT strategies and identifying opportunities to solve client issues requiring custom solutions. Authored proposals including hardware, software, labor and subcontractor components tailored to address client-specific LAN/WAN requirements and budget constraints.

Compaq Computer Corporation, Senior Account Manager, Indianapolis, IN 1996 – 2001

Managed up to 50 accounts with annual sales totaling over $200 million dollars. Managed inside sales teams to coordinate activities with Field Sales for optimal profit and ongoing maintenance of accounts. Managed government hardware and software contracts for software for four states (GA, FL, NC, and SC). Account team lead and forecast manager for $100 million dollar FleetBank account. Created function design specification, set server standards and completed software development to create a custom call management tool for FleetBank in order to generate and report issue resolution, quote turnaround, quote-to-order frequency, and standards compliance metrics. Managed resolution of escalated issues for New York City and FleetBank accounts.

Member of integration committee transitioning Vanstar accounts to Inacom systems and related supply chain re-engineering committees. Restructured Marsh McLennan account team to resolve prolonged billing issues, reduce order cycle times, improved issue resolution and forecast accuracy. Successfully managed $60m rollout for CVS Pharmacy to 2,500 retail locations. Teamed with Field Sales to bid and secure $42m services contract with BCBS of Massachusetts.

Computer Solutions Systems Inc., Account Sales, Terre Haute, IN 1995 – 1996

Developed and increased commercial, government, and educational accounts surpassing business plan goals by 50%. Authored RFP and response proposals, incorporating product, network design, and labor estimates. Delivered the client presentation of these materials.

JADCORE, Inc., Production Manager, Terre Haute, IN 1993 – 1995

Responsible for production setup, quality assurance, inventory management and personnel decisions within a round-the-clock plastics compounding operation.

Hagen Industries, Sales & Marketing Manager, Shelburn, IN 1992 – 1993

Created new company objectives and managed shift of strategic focus from a finished plastics manufacturer to contract spice packaging. Served as Project Manager for process development, production planning, training, safety compliance, quality assurance, and personnel functions. Authored customer requirements, risk plans and competitive analysis documents.

Education

Post-Graduate Certificate – Applied Information Technology: Information Technology Institute, Denver, CO 2001

M.S. - Industrial Technology Management: Indiana State University, 1991

A.B. - Chemistry/Communications: Wabash College, 1989

Information Technology Certifications and Training: IBM Certified Cognos 10 Administrator, CompTIA Security+, Oracle, Java, .NET, Visual Basic 6.0, VisualAge for Java 3.5, DB2, SQL, COM/DCOM/COM+, RUP, UML, ERP, OOD, OOP, HTML/ASP/JSP, MS Access/Excel Expert, MS Project, IP LAN/WAN models, Unix/WinX platforms.

Related Experience

Project/Product Management: Resource Analysis, Strategic Planning, Risk Analysis, Investment Proposal/SOW, Supply Chain Management, Contracting, Market Forecasting, and Costing

Functional Management: Manufacturing, Marketing, and Standards Compliance

References Available upon request.

Contact this candidate