SUMMARY:

Consultant with functional and technical expertise in designing, implementing, and maintaining large - scale Enterprise Data Warehousing and Business Intelligence Solutions. Expertise in various ETL and Business Intelligence Reporting tools.

WORK EXPERIENCE:

Consultant

Confidential, MN

Responsibilities:

• Involved in multiple US based projects in activities like data modeling, ETL workflow development and testing, reporting and analytics development
• Experience in designing report on OBIEE (Oracle Business Intelligence Enterprise Edition) 10/11g, Microstrategy, BI Publisher 10/11g, Tableau
• Experience with Oracle Retail (Retek), Oracle ODI (Oracle Data Integrator) Application
• Experience with installation, configuration and implementation of Oracle’s Retail Analytics (RA) with ODI.
• Provided consulting support and services included: Installation and implementation, enhancement, integration, or audit to meet Client business requirements
• Experience with Oracle, SQL Server, Netezza and Teradata (BTEQ) Database.
• Possesses good knowledge and practice about whole software development life cycle, including requirements gathering, architecture design, coding, testing, tuning, integration, optimization and support.
• Experience in performing system analysis tasking, identifying client’s requirements, designing programs & developing accordingly.
• Hands-on experience in web technologies and database design and its implementation.
• Experience in customization, implementation, performance and optimization of Oracle
• Experience in ETL process in Quantisense and reporting on Pentaho
• Lead the team of offshore developers
• Experience in Confidential services

Offshore Lead

Confidential, MN

Responsibilities:

• Involved in multiple US based projects from offshore in activities like data modeling, ETL workflow development and testing, reporting and analytics development
• Maintained knowledge of Retail industry data warehousing and Business Intelligence functionality and technical skills
• Provided consulting support and services included: Installation and implementation, enhancement, integration, or audit to meet Client business requirements
• Performed information systems needs assessment, gathered information and recommended appropriate business systems and IT infrastructure for Confidential clients
• Designed, coded, debugged, and tested software components and products independently in a high-availability, high performance environment
• Designed Business Intelligence reports using different BI Tools
• Worked with clients to understand business requirements and wrote technical designs based on these requirements

Software Engineer

Confidential

Responsibilities:

• Experience in modifying Pumori Plus and ePumori (core banking/finance/ corporate system used by more than 100 bank or financial institutions and is arguably the biggest product to have come out of the Nepali IT industry) Centralized Banking Solution using Delphi 7 Software
• Installed Pumori software on client side
• More than 15+ client visit
• Added user in banking system for many clients
• Created reports for financial company using Crystal reporting tool and SQL database
• Worked with clients to understand their financial requirement
• Worked as support team for few clients supporting the issues
• Worked on Deposits, loans, financial accounts, off-balance accounts, Letter of Credit, Letter of Guarantee, Document Negotiation, Bills, Remittances, Credit/Debit/Smart Cards using Pumori System

BI Developer

Confidential

Responsibilities:

• Researched on Confidential Bluemix
• Created Chat bot using different services from Confidential Bluemix
• Experience in different services like Text to Speech, Speech to Text, Conversation, Cloudant NoSQL, DashDB, Natural Language understanding, Discovery, Tone analyzer, Visual Recognition
• Trained data on Confidential Knowledge Studio
• Worked with Confidential team on Helzberg project to create a chat bot and embed Pinterest account in chat bot. And recommend the rings type.

BI Consultant

Confidential, Columbus, OH

Responsibilities:

• Actively participate in creating and testing 50+ reports using BI Publisher.
• Participated in all aspects of the project involving reporting, planning, scope, estimation, timelines, weekly status reporting, design, development, testing, cutover planning, go-live and post production support
• Gathered requirement for new CR (Change Request) reports.
• Worked on SR’s with Oracle support.
• Support and bug fix on reports.
• Scheduled report and monitor Report’s batch using Control M Workload Automation.
• Successful Go-live.
• Training to Client on Reports and BI Publisher.

Data Analyst

Confidential, Columbus, OH

Responsibilities:

• Responsible for Segmentation data gathering for drive-it JDA Retail.Me project.
• Gathered very specific data in a very specific format which the third party (JDA Software) needed for the POC.
• Created script to export data from Teradata database to JDA.

BI Developer

Confidential, Basking Ridge, NJ

Responsibilities:

• Participate in report building using BI Publisher.
• Created different Retail Merchandise, Store Inventory Management and Retail Price Management reports.
• Schedule reports using BIP scheduler

Data Conversion and Microstrategy Developer

Confidential, Columbus, OH

Responsibilities:

• Led the history data conversion of 7 years of historical data from Confidential Legacy Data Warehouse to the new Data Warehouse built on the platform of Logic Enterprise Data Warehouse platform on Teradata v14 database.
• Developed the history conversion strategy involving Legacy Data Warehouse sourced from historical fact data, Foundation Data source mostly from new Oracle Retail Merchandising system as well as other legacy systems
• Designed and built history conversion framework and scripts in shell scripts leveraging Teradata’s Tools and Utilities like BTEQ, FastLoad, MultiLoad, TPump etc.
• Built automation around history conversion and validation process to produce data quality reports comparing the source and the targets to confirm the accuracy of the conversion and to pin point the reasons for the differences again leveraging TTU
• Fulfilled Teradata DBA role in the Confidential development environment centralizing and standardizing all the developer requests leveraging Teradata tools like Teradata Studio, Teradata Administrator and Teradata Viewpoint
• Conducted 7+ history conversion cycles with the conversion accuracy reaching close to 100% at the time of go-live
• Participated in all aspects of the project involving history conversion including assisting project planning, scope, estimation, timelines, weekly status reporting, design, development, testing, SIT, cutover planning, go-live and post production support
• Understood legacy system, and developed ETL to migrate data from different source like RMS, PKMS, and IIS to ODS database.
• Validated the data in ODS.
• Used MicroStrategy Visual Insight tool to develop report.
• Scheduled the report and monitored Control-M jobs.
• Lead the team of offshore developers.

Data Conversion Lead

Confidential, Basking Ridge, NJ

Responsibilities:

• Led data conversion from Confidential and Noble Legacy System to the new Data Warehouse built in the platform of Oracle Data Warehouse.
• Designed and built conversion framework and scripts in shell scripts.
• Responsible for data conversions, and executing data conversion cycles.
• Developed technical design for each subject areas.
• Validated data in RMS, RPM, ReIM, and SIM application.
• Provided go-live support for the implementation of RMS, RPM, ReIM, and SIM.
• Lead the team of offshore developers

ETL Developer

Confidential, Lyndhurst, NJ

Responsibilities:

• Actively participated on the ETL development efforts to reverse engineer Teradata Stored Procedures, Teradata DDLs, Teradata SQLs and other Teradata objects leveraging Teradata Tools and Utilities (TTU) to understand the business and technical aspects of the Teradata code and efficiently migrate them to Confidential Netezza compatible version where possible or rebuild them using different architecture from scratch where necessary
• Designed and built scripts in shell scripts leveraging Teradata’s Tools and Utilities (TTU) like BTEQ, FastLoad, MultiLoad, TPump etc.
• Assisted with project/resource estimates, development, test, go-live, transition and support plan throughout the project
• Lead the team of offshore developers.

Business Analyst

Confidential, Columbus, OH

Responsibilities:

• Involved in requirement gathering for BI Publisher reporting
• Analysis each attributes and metrics for reports
• Mapped attributed and metrics to its appropriate columns in database
• Created Report design document for every reports
• Created Sample report to present look and feel for Client
• Participated in all aspects of the project involving project planning, scope, estimation, timelines, weekly status reporting, design

ETL and BI Publisher Developer

Confidential

Responsibilities:

• Created a semantic layer that supported the client’s BI Publisher operational reporting. This semantic layer was sourced from RMS. Created the ETL scripts using Unix scripting that populated that semantic layer.
• Developed and validated all aspects of the solution (Semantic layer, ETL that populates semantic layer and BI Publisher operational reporting that draws from the semantic layer).
• Lead the team of offshore developers.
• Provided client with BI Publisher11g tool training and Semantic layer training.

OBIEE and BI Publisher Developer

Confidential

Responsibilities:

• Implemented and developed attributes and metrics on repository of OBIEE.
• Implemented and tested the SQL query using RMS.
• Assisted in RA and OBIEE configuration.
• Designed, implemented, and tested reports using BI Publisher 10g and OBIEE 11g.

ETL Developer

Toys "R" Us, Wayne, NJ

Responsibilities:

• Wrote KSH scripts to read the data file that was received from external system and performed validation on the data.
• Wrote PL/SQL packages to read file contents and populated staging tables.
• Processed the records on staging tables to RMS tables using base functionality wherever required.

ETL, OBIEE and Microstrategy Developer

Confidential, Saint Paul, MN

Responsibilities:

• Provided post go-live RDW v12 support and external OBIEE reporting schemas.
• Developed OBIEE 11g reports.
• Implemented extension/enhancements to RDW ETL scripts through the client’s Change Control process.
• Implemented the enhancement in MicroStrategy reports according to user requirements.