Manager - Applications/BI Resume - Hire IT People

SUMMARY:

Twenty years of industry experience in architecting, leading teams to develop custom Softwares.
10+ years' experience developing automation data warehouses and business intelligence solutions.
Expert level database experience with writing and tuning PL/SQL to obtain extreme performance.
Exposure to data science technologies and techniques including Python, R programming.
Let’s get things done fast & effective, ready to take over challenges in big data world.

TECHNICAL SKILLS:

Languages: Java, JavaScript, PERL, SQL, PL/SQL, Python, PHP, R

BI Tools: Tableau, Shiny, Plotly, Business Objects, Crystal Reports, SQR, MS Reporting, Xcelsius, MicroStrategy, QlikView

Databases & Tools: Oracle, MS SQL Server, DB2, Access, Hadoop, Toad, SQL Developer

ETL Tools: Alteryx, Informatica, IBM Infosphere (DataStage), RIDL

Application Server: WebLogic, Tomcat, Glassfish, Micro Service

Other Software: TIBCO, PMATT(HP PPM), MS Office, Visio, Putty, WinSCP, Erwin, Toad

PROFESSIONAL EXPERIENCE:

Confidential

Manager - Applications/BI

Responsibilities:

Technical owner of current BI reporting solution implemented using Micro strategy & Business Object.
Architected Micro Strategy solution and migrated existing BO platform to Micro Strategy reporting solution and successfully migrated existing reports serving >6,000 customers saving more than 500k annually.
Developed stories for management using Tableau and have working knowledge of Tableau & Power BI.
Maintained Confidential & Confidential ’s Project and Portfolio management java based solutions, enhanced out of box functionalities along with custom modules to manage more than 7000 live PM projects data including risks, issues, jeopardy and change management data. Develop ETL based data warehouse solution to capture project data Confidential daily.
Developed and integrated Confidential & Confidential 's applications logins, databases login, server logins, expiration and recertification requests to a single sign on platform.

Confidential

Sr. BI/DW Developer

Responsibilities:

Developed and maintained reporting layer for Retail Banking database and Mobility dashboards, replaced 16 performance management dashboards with a single dynamic dashboard.
Developed business objects universes and reports as per the technical specifications.
Developed oracle SQL loaders and procedures for data reconciliation with oracle and DB2 databases.

Confidential

DW Developer/ QA Analyst

Responsibilities:

Designed and developed java modules using EJBs, JSP & Servlets.
Involved in development of ETL mapping and Tibco Rendezvous, Business works, Business connect, JMS, adapters and Hawk process to monitor and test the middleware transactions.
Automated the back-end multi-tier testing using Oracle SQL, PL/SQL, PERL and UNIX shell scripts to check the data consistency in the application and database as data was fetched from three different tiers.

Confidential

Developer

Responsibilities:

Involved in developing and testing custom software module for handling materials management.
Developed reports for purchase orders, sales orders, and goods issued and goods receipt.
Coded database procedure to calculate average purchase price of material for costing analysis.

Confidential

Developer

Responsibilities:

Developed custom software applications for medical store, Inventory maintains and finance transactions.
Developed inventory reports and daily alerts reports for low, expired, overstock & stop loss inventory.
Created financial module as a plug in application with its onset of front end data entry screens and reports.