We provide IT Staff Augmentation Services!

Abraham Lozano 2544 Middleton Grove Drive - Brandon, Fl 33511 - Tel: (813)-385-6096 E-mail: Alozano60@hotmail.com Database Developer Resume

4.00/5 (Submit Your Rating)

Sse Business Intelligence, FloridA

SUMMARY:

  • Professional with over 20 years of experience in the computer industry. Accomplished and diverse business analyst, specializing in database administration, web development, programming, and networking. Proactive leader with superb technical acumen. Vast experience in design and development, application rewrites, upgrades, and conversions. Qualifications and accomplishments include:
  • An exceptional self - directed problem-solver known for timely and money-saving resolutions.
  • Strong supervisory and managerial credentials.
  • Self-motivated fast learner with commendable training skills.
  • Ability to thrive within fast-paced environments.

TECHNICAL SKILLS:

  • Hands-On technical leader with knowledge of building, deploying, managing, designing, implementing, supporting and maintaining large and complex Microsoft Windows AS/400 and SAP environments.
  • Able to implement solutions providing an increased availability of business connectivity and disaster recovery. Knowledgeable in LAN, WAN, DNS, DHCP, TCP/IP technologies.
  • Led an application support team of 2 to 3 people for 6 years providing 24 by 7 availability for new and existing developments. More than 20+ years of operations technical support experience.
  • 18+ Years as Business Analyst in Food and Beverage Production, Real Estate, Laboratory, Information Technology and Telecommunication.
  • 17+ years of experience in Windows server Administration Windows (NT, 2003, 2008 and 2012 servers) and IBM AS/400 server.
  • 11+ years as database integrator for application such SAP, SAP BW, BPC, APPIAN, WORKDAY, Clarity, PPM, SWITF, Remedy, Sales Force.
  • 10+ years of experience in RDBMS as Microsoft SQL Server, MySQL, Oracle, MS Access, SQL 400, and NOSQL MongoDB.
  • 6+ years of experience on BI tools such as OBIEE, SSAS, Power BI, BPC, COGNOS, SSRS.
  • 20+ years developing in T-SQL, VB.NET, C#.NET, ABAP, APEX, COBOL, Basic, PASCAL, Clipper, RPG 400, HTML, CGI, Java.
  • Over 17+ years in OS, and application security and data encryption.
  • 7+ years of experience on data transformation ETLs.

PROFESSIONAL EXPERIENCE:

Confidential, FLORIDA

SSE Business Intelligence

Responsibilities:
  • Successfully coached new team of business intelligence engineers, business analysts and developers responsible for internal analytics and technology reporting who routinely mechanize and automate formerly labor intensive or manual reporting activities.
  • Successfully designed and implemented automated data integration and reporting strategy between web-based Sale Force customer resource management system (CRM) and in-house SQL Server data mart system for Opportunity-to-Cash forecasting and new business pipeline management. This integration effort has resulted in sales management effectively realizing a 30% YOY growth in new business.
  • Designed, developed and implemented a mechanized new business recognition process integrating Salesforce with internal data mart which saves more than 30 man hours of manual analysis each month.
  • Successfully led major project to integrate financial and dimensional data from internal data warehouse to Appian business process management platform via Windows WCF Rest API services. In-house integration design and development realized a net $250k cost savings to the enterprise on this project.
  • Responsible for leading project to integrate accounting data from SAP R/3 for reporting of near real-time monthly/quarterly/annually financial performance metrics.
  • Lead all phases of technical Migration of SAP 5 to ECC6 in partnership with PWC (hardware and software); saving 20days of time projected.
  • Implemented interfaces with APPIAN, PPM, WORKDAY, SAP, SWIFT, CLARITY, Remedy, and Sales Force through Web services, ETLs, and triggers.
  • As member of multi-department team researched and implemented process that resulted in over $600K saving in circuit’s expenses.
  • Responsible for design, create and maintain BI Department Security Access for applications and Databases. Set up and maintenance authorization roles, profiles, and user authorization for R/3, BW systems and internal applications.
  • Administrator of 2 IIS server, 10 SQL servers, and 4 OBIEE servers.
  • Designed, development, implemented and maintain BI Internal Web site.
  • Install, configure, maintain and Support OBIEE 10g and 11G servers. Design, create and maintain OBI subjects areas. Support reports and dashboard creation.
  • Designed, developed, implemented and maintain planning and internal applications such as: head count and benefits planning, cost and cost allocation planning, FX rates planning, business opportunities planning, ISUP billing, revenue and volume. In SAP BW, BPC and SQL Server
  • Designed, developed, implemented, enhanced and integrated Network AP database applications such SS7, CCNA, ISUP, Pass-thru, MI, IP/Frame, and Services. Resulting in considerable financial savings for the company.
  • Analysis, design, develop, and test programs, report and interfaces using SAP Scripts, ABAP, Objects, ALV, SAP Quick Viewer in FI/CO, BDC, BAPI, ALE/IDOC, user exits, JavaScript, SEM-BPS, BEx Analyzer, infocubes, ODS, logic scripts, input schedule and Business Planning and Consolidation BPC.

We'd love your feedback!