SUMMARY

• Business Intelligence Analyst having end to end data flow experience from the data creation to the end user data reporting. Expertise in Retail, Tax and Accounting domain with knowledge in diverse technical tools. Proven capability to help business quickly leverage data into strategic decision making with realization of efficiency increase.

TECHNICAL SKILLS

• ETL Tools: Informatica, SAP BODS, SSIS
• Reporting tools: Tableau, SAP BOBJ, Universe designer
• Languages: SQL, Shell Scripting, PL/SQL, Python
• Databases: Oracle, SQL server, MY SQL, IBM DB2
• Operating system: Linux, Unix, Windows
• Statistical tools: SAS, R
• Others: JIRA, IBM QC, ClearQuest, Rational ClearCase

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Business Reports & ETL Developer

Responsibilities:

• Led and managed staff of 5 offshore developers and responsible for successful execution of all project deliverables.
• Designed and deployed data warehouse for WK Business Intelligence team from ground up.
• Successfully deployed SAP BODS landscape in Amazon cloud services.
• Created data models and designed ETL jobs to build data marts for analytics reporting.
• Analyzed data sets and proactively found patterns and insights in the data and reported to Business.
• Created dashboards utilizing Tableau to support requirements for the business users.
• Accountable for building Type2 data marts for reporting historical changes to Business. Reports feature the historical life cycle of a products, customers and contracts.
• Automated migration of user accounts from Intelliconnect platform to Cheetah.
• Developed mappings in Informatica to load data from various sources into the staging and reporting schemas.
• Domain knowledge of SAP ECC tables, SAP BW DSO and process chains and SFDC objects.
• Responsible for the performance tuning of the Oracle SQL queries, ETL jobs and processes.
• Expertise with Data Cleansing, Data Profiling and Data Mining using SAP BODS, Sap DQM, Tableau.
• Worked with business users in understanding requirements and delivering the BOBJ and Crystal reports based on business need.
• Responsible in delivering month end data reporting for the Marketing, Tax and Legal business teams.
• Experience in resolving on - going production maintenance issues and bug fixes by monitoring Informatica sessions and DSE production batch jobs.
• Responsible for the Informatica/BODS/Tableau/Linux admin tasks for user creation, granting access, refreshing reports, content migration and deployments.

Confidential, Chicago

Business Intelligence and Analytics Developer Analyst

Responsibilities:

• Delivered the ICM reports by reducing the errors to almost 70% by creating a monthly run book and Delivered the ICM reports by reducing the errors to almost 70% by creating a monthly run book and following standard practices.
• Reduced the turnaround time for ICM month end commissions reporting from 20 days to 7 days by automating the whole process.
• Created the SQL queries to harmonize the transactional and analytical data and reported to Business.
• Successfully implemented jobs migration from SAP BODS 3.2 to 4.0
• Created nightly job in SAP BODS to extract the SAP ECC OLTP data into OLAP data marts.
• Successfully deployed SAP BODS landscape in Amazon cloud services.
• Designed and developed SAP Universes for month end activities for ICM.
• Created database procedures and functions in PL/SQL for database inserts/updates.
• Designed and developed ad-hoc queries requested by business on Oracle, Tableau and WEBI.
• Created standard documents for the existing SAP BODS jobs by analyzing the batch jobs.

Confidential

Software Developer/Technical Consultant

Responsibilities:

• Travelled onsite and worked together with Business to analyze and report the data discrepancies between different systems using shell scripts.
• Designed scripts to reconcile systems and made them efficient by reporting and fixing critical issues.
• Effectively handled business user queries and was a core part of implementing and testing the ordering system for Confidential Homeplus.
• Involved in doing development for the change requests and the defects raised by the APAC teams.
• Responsible for writing python module which has enabled internationalization for web screens.
• Facilitated meetings among relevant teams to discuss the impact of the changes and problem tickets.
• Created a UNIX shell script to automate package creation process which has reduced the manual effort by 50%
• Created move scripts to move the files between upstream and downstream systems using ftp.
• Build a Malaysia AIX Production server for ordering from scratch in the dedicated timelines and received value award from Malaysian team manager.
• Temporary fixed a lot of issues using Scheduling Scripts through crontab.
• Involved in performance testing of the system and worked on developing and fixing various ordering functionalities in order to make the system better and more efficient for ordering.
• Supported in country production batches for U.S. Czech, Slovakia, Thailand and reduced the business impact by putting manual workarounds for the new issues in the system.
• Performed defect tracking, documentation and change requests using Rational Clear Quest and HP quality center.