OBJECTIVE

• To become a successful professional and contribute towards the completion of the organizational objectives and in the process enrich my knowledge and skills.

SUMMARY

• Extensive experience in Requirement Gathering, Analysis, Design, Development, Testing and Deployment of commercial applications.
• Development on OBIEE 11g,OBI Apps 7.9.6.2,Matillion,AtScale,AWS,AWS Redshift,AWS Athena, AWS Spectrum, AWS lambda, AWS Glue,Informatica,DAC,Tableau, PowerBI,Alteryx tool
• Extensive experience on Data modeling,Designing, Testing
• Intermediate experience in predictive analytics
• Good communication and interpersonal skills.

TECHNICAL SKILLS

• OBIEE 11g, OBI Apps 7.9.6.2,Tableau,PowerBI, AtScale,Cognos 8, DAC
• AWS Redshift Matillion, Alteryx, Informatica Powercenter 8
• Python,XML, PL/SQL, Java, Java Script, C, C++
• Redshift,Athena,Spectrum, Data Lakes,Oracle 11g, MS SQL,MS Access, MySql
• PyCharm IDE,Python, Jupyter Notebook
• Microsoft MDS

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst /Data Analyst

Responsibilities:

• Gathering requirements from drafting them to a technical design document
• Designing the roadmap for reporting solution
• Providing strategic input for the infrastructure and capacity requirement
• Development of reports/mapping and providing innovative solution to the team
• Providing solution and strategic guidance to the team
• Customization of existing OOTB RPD to suite the business requirement
• Customization of existing Informatica jobs
• Worked with variables on OBIEE RPD
• Troubleshooting OBIEE RPD/Presentation layer issues
• Improving OBIEE query performance using explain plans
• Setting up row and column based security in OBIEE RPD layer
• Customization of OBIA Finance module like AP, AR,GL and aging
• Support of the existing MTM financial system on OBIEE platform
• Use of javascript on OBIEE presentation layer
• Gap analysis and data analysis for data modelling
• Designing the data model for cloud - based redshift warehouse
• Creation of data models on Microsoft Visio
• Migration of existing OBIEE OOTB subject to custom Redshift Datawarehouse
• Draft migration strategies and best practice
• Development of Jobs in Matillion redshift ETL tool
• Import of JSON S3 data into redshift using matillion
• Offloading historical data to Redshift spectrum using Matillion, Python and AWS glue
• Working on AWS components like S3,Dynamodb and Lambda for troubleshooting issues
• Creating lambda SQS queues to create event based trigger for matillion
• Unloading data to AWS Athena using Glue and matillion
• Design of data lakes
• Export and import of data from data lakes
• Migration using GIT hub
• Migration of jobs from DEV,UAT to PROD in matillion
• Creation of BI semantic layer cubes in AtScale cloud-based tool
• Migration of OBIEE RPD logic to AtScale cubes
• Migration of AtScale cubes to Tableau and PowerBI
• Creation of reports in Tableau and PowerBI
• Provide support to users in UAT and PROD environment
• POC for time series predictive analysis using python and SARIMA model
• Worked on data exploratory techniques for finding correlation in variables
• Data cleansing for predictive analytics
• Building predictive analysis stories on Jupyter Notebook
• Using AWS sagemaker to publish jupyter notebook on cloud
• Build reports in alteryx for adhoc analysis
• Build alteryx flows for validating data
• Used Agile methodolgy for project execution
• Usage of microsoft ADO for the project and scrum meetings
• Worked on Microsoft MDM service
• Interfaced MDM with Redshift datawarehouse

Confidential

Lead Programmer Analyst

Responsibilities:

• Gathering requirements from drafting them to a technical design document
• Designing roadmap for reporting solution
• Providing strategic input for infrastructure and capacity requirement
• Development of reports/mapping and providing innovative solution to the team
• Providing solution and strategic guidance to the team
• Customization of existing OOTB RPD to suite the business requirement
• Customization of existing OOTB informatica mapping to tie up with source information
• Designing data model and mapping/reporting solution for non-OOTB requirements
• Enablement of new modules in OBIEE RPD
• Upgrade of OBIA 7.9.6.3 to OBIA 7.9.6.4
• Upgrade includes addition of new modules(for e.g EAM) into new RPD
• RPD upgrade also included merging of 7.9.6.3 RPD with OOTB 7.9.6.4 RPD
• Upgrade of Informatica repository 7.9.6.3 with 7.9.6.4.
• Configuration of production incremental load in DAC and informatica to accommodate 7.9.6.4 upgrade
• Migration & Merging of RPD from DEV to QA & Production environment
• Migration of informatica code from DEV to QA & Production environment
• User & security group maintenance in OBIEE weblogic console
• User & security group maintenance in informatica admin console
• Configuration of DAC for load from different environment
• Migration of code for DAV from DEV to QA & Production environment
• Responsible for overall health of OBIA system from development,best practice & infrastructure
• Worked on path for upgrade of OBIA from 7.9.6.4 to 11.1(ODI)

Confidential

Assistant Consultant

Responsibilities:

• Coordinating with business users for requirement gathering
• Analysis of existing reports based on Cognos platform
• Feasibility study for the Cognos reports
• Fetching of package level data from Cognos framework manager
• Report categorization by analyzing reports in Cognos report studio, Query Studio & Analysis studio
• Studying of Cognos oracle (EBS) ERP data for OBIA modules
• Categorization of reports for OBIEE Apps SCM/Services/Financial modules
• Designing strategy for reports not fit for OBIEE Apps platform
• Redesigning of Cognos data model/Report according to OBIEE platform
• Making decision for routing of Cognos packages to standalone OBIEE, OBIA & BI Publisher
• Designing decision matrix to showcase the decision parameters for routing the solution to various technologies
• Migration of Query studio reports and adhoc analysis to OBIEE answers
• Gap analysis for existing OBIA SCM, Servicing, Financial Analytics etc for cognos oracle ERP reports
• Estimation and resource loading planning for the project
• Preparation of BRD for requirement freeze
• Designing of data model for standalone OBIEE model
• Creation of RPD & Report level design document according to OBIEE standards
• Security model design for migration from Cognos to OBIEE
• Engagement of users for SIT & UAT and providing assistance during the process
• Development & coordination along with offshore development team for smooth delivery
• Creation of migration document & validation of migrated code
• Documentation for the process involved in the migration strategy
• Project planning, management and scheduling various modules for each release
• Performance optimization design for problematic reports
• Test strategy creation for performance & stress testing