PROFESSIONAL SUMMARY:

• Six plus years of extensive experience in implementing, developing & maintaining various Business Intelligence application systems for Financial, Retirement, Investment, Insurance, Consumer Loans, Communications and Consulting sectors using wide range of BI tools.
• Experience developing powerful data visualizations using Microsoft Power BI, Qlik and Tableau.
• Good working experience on object - oriented programming like Java & Python.
• Knowledge of Hadoop Map Reduce and Big data concepts.
• Strong experience on end to end implementation of Oracle DRM and maintenance of metadata of various upstream and downstream systems.
• Hands on experience in both Relational and NoSQL database management using tools like Microsoft SQL server, Oracle SQL, MongoDB, and SQLite.
• Experience in interacting with various Data sources like Data warehouses, Exadata, OLAP sources, Packaged Applications (PeopleSoft, Oracle EBS, and SAP), Unstructured and Semi-structured data.
• Experience writing Linux shell scripts & Windows DOS scripts, which are used in Job automation process.
• Performed end to end installation of Oracle Hyperion EPM suite, OBIEE, Informatica, Power BI, Qlik Sense.
• Experience working with Extract, Transform & Load process using Microsoft SSIS, Informatica (E-T-L) and Oracle ODI (E-L-T).
• Extensive experience on SOAP & REST Web Service APIs for remotely interacting with Data Relationship Management server, Planning and Essbase instances.
• Knowledge of Hyperion EPM architecture and how it interacts with various downstream and upstream systems.
• Experience in Continuous Integration tools like Jenkins.
• Extensive experience using Microsoft Excel for building reports and performing calculations.
• Good Experience with Version Control Management tools like GitHub, IBM Clear Case.
• Experience in Agile software methodology with Version-One, JIRA & Rally.
• Highly curious about latest trends in Business Intelligence sector, technologies and thoroughly mastering them with a keen awareness of new industry developments and evolution of programming solutions.

TECHNICAL SKILLS:

Oracle Tools: Oracle Data Relationship Management, Essbase, Planning, Shared Services, Essbase Studio, Integration Services, OBIEE, Essbase Administrative Services, Oracle EBS R12

Data Analysis & Visualization: Microsoft Power BI Desktop, Power BI Report Server, PowerBI Service, QlikView, QlikSense, Tableau

Application Administration: Oracle WebLogic Server

ETL/ELT tools: Informatica, Oracle Data Integrator, Microsoft SSIS

Webservice: SOAP

Search & Analytics Engine: Elastic Search

Programing: Linux Scripting, Windows DOS, JAVA EE, Apache Ant, Python, MDX, MAXL, DAX, DRM Java Scripts & Native Formula Language, Hadoop MapReduce

Statistical Analysis: R Programming, Python, SAS

Python Libraries: NLTK, NumPy, SciPy, Pandas, MRJob (MapReduce)

Relational Database Management: Oracle SQL, Microsoft SQL server

Multidimensional database: Hyperion Essbase

Engineered Systems: Oracle Exadata and Oracle Exalogic

Version Control & Automation server: IBM Clear Case, GitHub, Jenkins

Ticket System: Service-Now

Document Management System: Microsoft SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Burlington, MA

Power BI Developer

Responsibilities:

• Connect and fetch millions of JSON documents to PowerBI through Elastic Search using REST API.
• Developed various dashboards and performed data analysis to handle unsolicited user access.
• Implementing time-based subscription schedule which is a latest feature in PowerBI service for scheduling reports and dashboards.
• Data modeling using Composite models in Power BI, retrieved data from REST Elastic search and SQL server.
• Implemented Row level security to restrict data access for required users.
• Successfully implemented IP Address mapping for GeoAnalysis using custom functions and performed Analysis using ArcGIS Maps.
• Co-ordinate with Admin team to install PowerBI gateway to allow multiple users to access data sources.
• Connect to files stored in OneDrive for your Power BI app workspace.
• Implemented various DAX functions for various fact calculations and calculated columns for efficient data visualization.
• Push Power BI .pbix files to Share Point for version control, making sure all the updates are stored as a separate instance.
• Interact with Office 365 Admin team to have Power BI app workspace groups created with legit members assigned.
• Identified Data quality issues using the latest data prep features, fuzzy matching capabilities and data profiling.
• Scheduled Automatic refresh and scheduling refresh in PowerBI Service.
• Created Workspace and content packs for business users to view the developed reports.

Tools: Power BI desktop, SQL server, Power BI service, REST, Elastic Search

Confidential, Burlingt on, MA

Data Analyst

Responsibilities:

• Created Mapping documents to outline data flow from source to targets.
• Data extraction from flat files, XML files and RDBMS databases into staging area and populated onto Data warehouse.
• Understand the existing ETL mappings in SAP Business Objects Data Designer and replicate the same to Informatica Power Center.
• Working on various kinds of transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner in Informatica.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
• Performed data extraction and data loading to DB2 for Informatica mappings.

Tools: Informatica Power Center, SAP Business Objects Data Designer, IBM DB2

Confidential, Burlington, MA

Business Intelligence Analyst

Responsibilities:

• Implement GeoAnalytics and Geospatial Analysis to provide comprehensive mapping capabilities and expose hidden geographic relationships.
• Create reports and visualizations by interacting with big data sets and finding patterns in the data.
• Migrate existing QlikView Applications (Qvw) to QlikSense (Qvf) applications and resolve challenges faced during this process.
• Implement security with section access and application access with Data load scripts in QlikView and QlikSense.
• Develop load scripts in QlikSense to connect to Salesforce data source and write various data management queries.
• Working with QVD data files in QlikView and QlikSense.

Tools: QlikView, QlikSense, Qlik Management Console, Qlik GeoAnalytics, Microsoft SQL server, Microsoft SSIS

Confidential, Burlington, MA

Business Intelligence Analyst

Responsibilities:

• Develop Power BI data visualizations which are used for financial reporting of Delinquency rates and Loan originations for client.
• Connecting to various sources like mongo DB and SQL server to load the data in to Power BI and build relationships between different source tables.
• Converting all the existing static graphs of the client to timely refreshable dynamic visualizations in Power BI.
• Wrote various DAX scripts inside Power BI to perform complex data analysis.
• Wrote SQL
• Weekly presentations to business users about the reports and changes as per the requirement.
• Implemented Hyperlinking between multiple visualizations between multiple dashboards in Power BI.
• Recommended new Data visualizations that reflect key performance indications for improving better decision-making capabilities.
• Created various dynamically refreshable Power BI visualizations in power point so users can have latest reports for their presentation and analysis.
• Various location-based reports are developed so users can drill through the reports on their respective branches.
• Interacted with MongoDB databases for data lineage with SQL server and Experience in creating JavaScript for using DML operation with MongoDB.
• Involved in complete Data lineage process to validate end to end data validation process from various data sources to Power BI data query views.
• End to end Data lineage process, that involves data coming from various source systems to Microsoft SQL server and validate the data on Power BI visualizations.
• Created and stored number of T-SQL queries to validate data between different sources and Power BI.
• Write JSON scripts for changing data color schemes in Power BI desktop to replicate organization data color scheme.
• Interact with Business users and Senior architects for User Acceptance Testing of developed Visualizations and gather requirements if any further modifications are needed.
• Gaining knowledge on Microsoft SSIS tool, which is used to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Tools: Microsoft Power BI, SQL Server, Stored Procedures, Python, T-SQL, MongoDB, JSON, SharePoint, Microsoft Excel.

Confidential, Burlington, MA

Business Intelligence Analyst

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on business requirements.
• Converted existing static excel and OBIEE reports to dynamic tableau dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Performed extensive data analysis between Tableau and operational data sources to make sure valid data is coming through the reports.
• Interacted with geospatial files in Tableau and performed various geospatial routing operations and analysis.
• Cross examine large data sets and generate analysis with previous unseen patterns in data.

Tools: Tableau 9.1, SQL Server, SSIS, Stored Procedures, Python, T-SQL, SharePoint, Microsoft Excel.

Confidential, Kent, OH

IT Analyst

Responsibilities:

• Assist Professors and students during lab sessions for training students on and Oracle SQL and Microsoft office tools.
• Assisted students in development of minor database projects.
• Windows and Linux administration activities for all student systems in the lab.
• Provide security for students and professors to access database tools and other business-related tools and applications.
• Developed Backup and recovery plans for database and involved in research of various recovery strategies.
• Assisted professor in a project for collecting weather forecast data using Raspberry Pi device and required sensors to collect data.
• Gained knowledge on data collection and maintenance from electronic devices.
• Developed Auto retrieval and insertion of NOSQL data using PyMongo and MongoDB with Python programming.
• Implemented Machine Learning algorithms with Python NLTK classifiers, NumPy, SciPy, Pandas, Django.
• Used SAS & Qlik sense to develop data visualizations from the collected data and built various KPI reports for Data Analysis and decision making.

Tools: Oracle SQL, SAS, Python, Jupyter Ipython, NumPy, BottlePy, Pandas, Linux, SQLite, Qlik Sense

Confidential

Master Data Analyst/ Architect

Responsibilities:

• Interact with business users and technical development team to implement new Versions, Hierarchies and support maintenance of PeopleSoft and EPMA metadata in DRM.
• Working as DRM Access Manager to provide security to metadata objects and nodes using Object access groups and Node access groups and authenticate business users and developers with essential security roles on metadata and objects.
• Nodes creation and Node level operations are performed to maintain Hierarchy structure in every Version.
• Enforced Business rules on Versions, Hierarchies, nodes and properties using Validations.
• Knowledge on Creating Blenders, Exports, Imports, Validations, Node types, Properties in DRM that are extensively used in day to day business process.
• Develop and configure Custom, defined, list value, lookup and inheriting properties and create property categories.
• Developed number of Linux shell scripts and Windows dos scripts which are used in automation of batch schedules.
• Developed API’s for DRM tasks groups like Blender, Import, Exports, Version Unload & load, etc. which can be called using wrapper scripts in nightly job process.
• Implemented SOAP based service in Java and is deployed to the Oracle WebLogic application Server as a J2EE Web Application.
• Handle daily technical production support, responsible for successful nightly business process, instruct offshore team with necessary actions to be followed when required.
• Involved in successful migrations of EPM metadata and Objects over the life cycle of projects.
• Successfully Upgraded DRM & Hyperion EPMA applications from 11.1.2.2 to 11.1.2.4.
• Supported and maintained parallelly over 15 Linux and windows servers during upgradation process.
• Implemented OBIEE Easy Push button concept that helps the life of business users easier in generating ad-hoc Hyperion Reports and trigger DRM processes.
• Deploy and administer PeopleSoft, DRM, EPM applications through WebLogic server.
• Implemented complex logic and business logic for derived properties and validations by using Native Formula Language and Java script.
• Created and Administered number of core and custom properties & property categories for Versions, Hierarchies and Nodes.
• Perform various node level operations and orphan node validations.
• Create and Manage various workflow tasks and models for Data Relationship Governance.
• Involved in complete change request management process and interacted with business users to contribute towards creation, management and automation of process associated with authoring and managing changes to master data.
• Interaction with organization auditors for auditing DRM master data using Audit option and analyze data changes by viewing baseline versions and change tracking properties.
• Created various export profiles that generates various file formats like XML and ADS for downstream systems (PeopleSoft & EPMA).
• Automated DRM Metadata Migration, Using Junit language in Eclipse, developed a process that migrates all the DRM extracted metadata objects (XML files) to destination DRM systems.
• Assisted IT Head of Infrastructure in implementing GitHub and Jenkins tools for automating complete Testing process of DRM and other Hyperion development process.

Tools: Oracle Data Relationship Management, Data Relationship Governance, JavaScript, Python, Peoplesoft Metadata, Linux, Windows scripting, Oracle WebLogic Server, Oracle Essbase, Essbase Administrative Services, Planning, OBIEE, FDMEE, Informatica, Jenkins, GitHub, SOAP, XML, JAVA EE, Junit, Eclipse, ServiceNow, Oracle SQL, Oracle Exadata, Exalogic, Oracle Analytics Cloud.

Confidential, Boston, MA

BI Staff Consultant

Responsibilities:

• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Modified existing mappings for enhancements of new business requirements.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in development, performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance. Key techniques used were resetting databases, grouping sparse member combinations, using parallel calculations, managing caches, two-pass calculations & changing buffer size.
• Troubleshoot critical issues in timely manner to- ensure the SLAs (Service level agreement) are met.
• Worked extensively on data loads, load rules, Calc scripts.
• Extensively used calculation commands and functions to improve the performance of applications. Developed Calc Scripts for complex calculations and optimized them.
• Created reports Using SmartView and Excel Add-ins.

Tools: Informatica, Oracle SQL, Oracle Essbase, Shared services, Planning, SmartView, Essbase Studio, MAXL, Calculation scripts, Microsoft Excel.

Confidential, Boston, MA

BI Associate Consultant

Responsibilities:

• Automated various business processes using MAXL scripting language.
• Interact with client on daily basis in handling production issues.
• Created Data Grids, Member Lists and Data Entry Forms and updated data on Essbase server.
• Perform regular cube deployments to build an outline and load data to Essbase application and database.
• Created various standard hierarchies in Essbase and designed how data is getting consolidated and navigated
• Created Calculation Scripts and Report scripts in Hyperion Essbase.
• Installed and configured the Oracle Data Integrator ODI software tool in a three-tier environment and performed periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Documentation of Daily, Weekly, Monthly, Quarterly and Annual processes.
• Extensively used ODI to load data from Oracle, XML files and flat files
• Deployed RPD and catalogs using Enterprise manager.
• Created new reports and dashboards as per the business need.
• Analysis, Design, Implementation, documentations and BI specifications that in corporate OBIEE development standards best practices as well as ongoing support for Data Warehouse.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool.
• Worked on Hyperion Workspace reports, validating the reports.
• Involved with Administration team in migration and installations of Hyperion EPM 11.1.2.1 to 11.1.2.2.
• Responsible for writing Unix Shell Scripts to schedule the jobs.

Tools: Oracle Essbase, Planning, Oracle SQL, OBIEE, Shared services, Oracle Data Integrator, SmartView, Essbase Integration services, Shell scripting, MAXL, Calculation scripts, Microsoft Excel.