SUMMARY

• Solution - oriented Analyst with 12+ years of experience and domain knowledge in the areas of Hi-Tech, Asset/Wealth Management, Financial, Healthcare, Retail and Media industries.
• Capable of working with executive management and cross-functional teams.
• Technical Architect with experience deploying large enterprise data warehouse deployments.
• Provide in-depth education to customers within the context of business benefits and technical aspects of solutions.
• Working knowledge of various SAP modules.
• Excellent presentation skills with the ability to adjust between technical and non-technical audiences.
• Experience developing user guides and manuals, conducting training workshops, and presenting new systems and processes to end users.
• Skilled in developing logical and physical data models; source data analysis and development of ETL processes to load data.
• Proficient in all phases of the software development life cycle (SDLC) including requirements gathering, analysis, design, data conversion, system implementation, performance tuning, testing, production rollout, and post production support.

TECHNICAL SKILLS

Operating Systems: Windows, Unix / Linux

Tools: MS Office, MS Project, Erwin

Programming Languages: PL/SQL, Excel Macros, Python

Databases: MS Access, SQL Server, Oracle,Sybase, HANA

BI Tools: SAP Business Objects, SAP Data Services, SAP BW, SAP Design Studio,Lumira, Crystal Reports, Explorer,Tableau, SAC

DEVOPS Tools: Jenkins, Perforce, Nexus, Zabbix, Sitescope, Puppet

ERP: SAP, Netsuite

SDLC Methodologies/Process: AGILE, JAD, Structured Analysis/Waterfall

PROFESSIONAL EXPERIENCE

BI /Product Analyst

Confidential

Responsibilities:

• Utilize SAC to create dashboards to review performance of SAP Appcenter, combining data from multiple sources including Adobe Analytics, APIs, CRM and offline channels.
• Generate marketing channel level strategies backed by analytics.
• Extensive use of SAP Data Services to consume REST API’s.
• Preparing technical specification for ETL jobs to consume JSON files and API’s using Oauth2 Authentication.
• Confuring HANA to consume API’s and SDI, worked on creating HANA datawarehouse on SCP(Neo).
• Delivered performance metrics to leadership and Partners/Vendors on a weekly basis.
• Provide deep analysis and develop strategic recommendations for marketing and sales teams..
• Developed HANA Artifacts (models) like Attribute View, Analytic View, Calculation View
• Led overall product performance analysis initiatives and provided key stakeholders with LOB specific dashboards.
• Monitoring the growth of the databases, as a part of capacity planning.
• Utilized capabilities of SAC such as Data extracts, Data blending to build dashboards.

BI Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Work with business to deliver KPI's as part of ongoing project (Federal Reporting 2052A).
• Worked on ETL(BODS) Restarting capability for a date or date range or from point of failure or from beginning.
• Validation Framework to check the data quality and alert the variance in the data.
• Developed Test Plan, Deployments, Job Optimizations, Performance Tunings etc.
• Expertise in analyzing the problems and transferring the business concept to functional requirements.
• Implement ETL (BODS) framework to provide features such as Master Data Management, ETL-restart capability, security model and version control.
• Implement best practices including naming conventions, performance tuning, and error handling to ensure database integrity.

BI Analyst

Confidential

Responsibilities:

• Implement best practices including naming conventions, performance tuning, and error handling to ensure database integrity.
• Implemented HANA Security including User Management, Roles, and Privileges.
• Design and implement HANA info models using Attribute Views, Analytic Views, Calculation Views.
• Created Tableau scorecards, dashboards (using Stack bars, bar graphs, scattered plots, geographical maps), and Gantt charts (using show me functionality) for Management reporting.
• Created complex Universe and Business Objects reports to help Sales Audit team.
• Created different types of WEBI reports such as Master/detail, Cross Tab and Charts.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).

BI Analyst

Confidential

Responsibilities:

• Prepared ETL specifications and architecture documentation for new interfaces as part of ECom replatforming
• Reviewed and re-architected functional specifications for interfaces between Demandware E-Commerce platform and JDA PMM.
• Built interfaces to send product feeds to the order management system and load sales data in XML format to an instance of JDA Software’s Portfolio Merchandise Management system.
• Monitored and audited production load into the data warehouse for accuracy, conducting root cause analysis for failures, resolved production problems, and performed failure recovery.
• Migrated BODS jobs between different environments and set up schedules in UC4.
• Created WebI reports/universe on top of HANA views.
• Assisted with interface redesign as requirements were adjusted; and acted as lead BI Developer on several post-project enhancements and performance tuning requests.
• Conducted ongoing performance analysis and tuning activities, ranging from small process tweaks to large batch program rewrites.