Divya Pathiramanna

Houston, TX, ***** ac5y6w@r.postjobfree.com PH: 832-***-****

Profile

Detail-oriented Data professional with over three years of experience in demanding environments

Proficient in data analysis and reporting, ETL process, performing quantitative and qualitative assessment of operational data

1+ Years of Business Objects/Web Intelligence Experience

1+ years of SAP Business Objects Data Services Experience

1+ Years of SAP BI BO Experience

Summary

1+ years of SAP BusinessObjects (BO) / Business Warehouse (BW) consulting experience involving Production support, requirements analysis, enhancement, development, testing and documentation

Specialized in working with BusinessObjects 4.x, ( Information Designer tool, Universe Designer, Web Intelligence, Explorer, Design studio and Analysis)

●Hands on experience using Oracle 8i/9i/10g, SQL Server 2000/2005/2008 and writing SQL Queries

●Proficient in using both SAP and Non-SAP sources such as BW, HANA, RDBMS and flat files etc.

●Skilled in SAP BODS job development, modification and testing

●Knowledge of implementing ETL Process, extraction of data from various type of sources, transforming data using DS transforms and loading data into application or database.

●Gained expertise in DS transforms, connectivity to source/target databases/applications

●In-depth knowledge in Oracle and MS SQL. Very proficient in coding complex SQL required for performing complex and detailed data analysis.

●Flexible and versatile to adapt to any new environment with a strong desire to keep pace with Latest technologies.

●Excellent analytical, time management, communication, interpersonal skills and a good team player.

●Efficient in providing detailed root-cause analysis and suggesting workarounds and solutions for recurring issues.

Education

Masters of Science in Information System Security

University of Houston, Houston, Texas, USA

Masters of Science in Network Communication:

University of Houston, Houston, Texas, USA

Bachelors of Technology in Electronics & Communication Engineering:

Calicut University, Kerala, India

Technical Skills

Business Intelligence

BusinessObjects 4.x/ XI3.0/ XIR2 6.x /5.x, SAP BW 7.x/3.5, Information Design Tool, Universe Designer, Web Intelligence, Design Studio, BI Launchpad,BO Analysis, Query Designer, Bex Query Analyzer

ETL Tools

SAP BW 7.x/3.5, SAP BODS, Data Modeling

Databases

HANA, Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server, MS Access., PeopleSoft, ERP systems

Programming

SQL, PL/SQL, T-SQL, Java Script, VB Script, HTML, XML, CSS,C,C++,COBOL, SAS

Operating Systems

MS-DOS, Windows 95/98/2000/NT/XP/7/8/10, Linux(Ubuntu 12.04, Kali linux),, UNIX,MVS, z/OS, MS Office tools

Mainframe

TSO, ISPF, JCL, CICS, SDSF, RACF

InfoSec Assessment / Compliance

PCI-DSS, ISO, COBIT, NIST framework, NSA-IAM, NSA-IEM, OWASP Top 10

SANS Top 25, Top 20 Critical Security Control

Information security skills

Cryptography, Secure coding, Penetration testing, Threat modeling, Incident response

Project Management

MS Project, PMBOK practices, MS Visio, Risky Project Professional, SAS JMP,

Risk Management, Nine Knowledge areas

Professional Experience:

Associate Consultant Feb 2017 – March 2018

Utegration LLC, Houston, Texas

Played a leading role in the onsite Production support team of Analytics for Centerpoint Energy, monitoring production Data Services jobs, responding to client/user queries and working to solve internal/external Data Services application issues.

Responsibilities

Primary lead for SAP BODS activities involving extraction of data from various type of sources, Data Profiling using DS/IS, transforming data using DS transforms and loading data into HANA database.

Analyze and fix web Intelligence report schedule issues and report data issues

Analyze data Services job failures and fixed issues without failing to meet the SLA

Detailed analysis on various data issues happening while loading from different input systems to HANA tables and worked with clients to get the source data issues resolved

Regularly monitor the Data Services job schedules and runs for various issues like run time, data extraction/loading issues, connectivity issues with various data bases and web services

Run reports and pull data using advanced functions such as VLOOKUPs, Pivot Tables, and Macros

Responsible for various manual tasks within Data Services such as update records, manual reconciliations, manual file loading, manual job reruns and file catch up loading for various job interrogations

Co-ordinate onsite and offshore production support teams and prioritize support work to meet Service Level Agreements

Environment: Data Services 4.1, Web Intelligence, HANA Studio, SQL, Oracle

Data Analyst Jan 2011- Apr 2012

Office of Institutional Research, University of Houston, Houston, Texas

Played a leading role in performing official university reporting and Institutional research

Responsibilities

Official university reporting

Institutional research and data analysis

Design and maintain databases

Perform statistical analyses to address various information requests

Solve external requests based on priority and deadline basis using SAS codes

Develop graphs, metrics, dashboards, and generate ad hoc reports

Environment: SAS 9.2, SQL, MS EXCEL, Microsoft SQL Server, PeopleSoft, MS Word, PowerPoint

Software Engineer Jan 2008-Aug 2009

Infosys Technologies, Bangalore, Karnataka, India

Served as a Support Engineer, Developer and Tester for KODAK’s Mainframe projects

Responsibilities

Support Engineer on mainframe maintenance project for the client, KODAK

Maintain and update mainframes databases by performing database maintenance activities

Handle customer and user requests on a timely basis

Conduct routine software activities for the maintenance and continuity of client’s business

Update and edit Mainframe databases and codes according to user needs

Developer and Tester in a ETL development project for KODAK

Played an offshore-leading role for the project by working with data extraction, transformation and loading on Unix environment

Developer and Tester for a development project with the client, AMERIPRISE

Gained expertise in developing COBOL codes for the generation of accurate reports on monthly and daily basis.

Environment: MVS, z/OS, TSO/ISPF, COBOL, JCL, DB2, CICS, Lotus Notes, IMS, Unix, ETL

CERTIFICATIONS

Certified Associate in Project Management (CAPM) - Project Management Institute

Lean Six Sigma Green Belt certified – University of Houston

Contact this candidate