Data Analyst Manager

Mohan Neupane ***** Fall Harvest Dr, Frisco TX ***33-0599 267-***-**** *********@*******.***

Professional Summary

Over 10 + years of IT experience with Telecommunication industry as System/Data Analyst and Data Warehousing Developer.

Participated in all phases of the System Development Life Cycle (SDLC), from Requirement gathering, Analysis, Design, Development, Production in various industries as Insurance, Finance, Telecom, Retail.

Strong understanding of the principles of Data Warehousing using Star Schema modeling.

Designed and created ETL Solutions with Informatica Power Center using various Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.

Developed and tested Mappings and Mapplets, Sessions, Workflows, Worklets and Tasks using Informatica

Designer, Workflow Manager.

Created and Executed Performance Tuning and Debugging of existing ETL processes.

Designed, created templates and Design Docs of Price offers for Production.

Worked closely with Data Governance and Sales Division team to resolve issues.

Mapped Offers in Enterprise Product Catalog (EPC) database by opting Markets in Availability, Pricing, and Rates Codes for Various Comcast products and promotions utilizing Amdocs billing system.

Performed rate code to product mapping for financial impact.

Excellent analytical and troubleshooting skills.

PROFESSIONAL EXPERIENCE:

NEW MEXICO ARMY NATIONAL GUARD Santa Fe, NM Jan,2020 – Nov 2020

IT SPECIALIST (DATAMGT)

Successfully interpreted data to draw conclusions for managerial action and strategy

Monitored and optimized the performance of the databases

Presented findings and data to team to improve strategies and operations

Performed Database backup/restore activities

Install New applications and established user access

Maintained necessary tracking and maintenance tools to manage application users to include Linux based accounts, oracle accounts

Went through training on technical guidance in the use of DBMS query, DBMS software design

Worked through CCRI checklist to review and validated systems and security to meet the standard

Evaluated installation procedure and implemented

Comcast, Philadelphia, PA Dec, 2018– Jan, 2020

Lead EPC Data Analyst

Responsibilities:

Collaborated on configuration and implementation of offers and rules within EPC to support Marketing needs and expanded use of Sales Portal across additional channels.

Monitored offer request queue and team capacity for implementation; Ensure proper work queue prioritization and timely escalation of issues.

Facilitated collaboration among EPC, Divisional IS, and Marketing teams to ensure clarity of direction and proper implementation of offers through EPC and the Billing Systems.

Monitored existing reports and alerts to identify offer data discrepancy issues among EPC and Billers, and coordinate with EPC, Divisional IS, and Marketing teams to facilitate analysis and timely resolution.

Managed offer QA reporting – eliminate or consolidate reports and add new reports or alerts as needed to drive improved offer quality assurance.

Proactively identify and implement improvements to drive increased efficiency and quality of offers implemented through EPC and the Billers.

Collaborated on Offer Management process improvement across all business lines for the company. Collectively, the EPC team will be responsible for defining a cohesive plan that includes the design of technology, people, and processes to support strategic improvements in offer management.

Responsible for the identification and resolution of information flow, content issues and issue resolution.

Participate in facilitation of team meetings, creation of status reports, and preparation of executive presentations to communicate EPC accomplishments, challenges, opportunities, and recommended courses of action.

Client: Centene Corporation, Saint Louis, MO Jan, 2017 – Dec, 2018

Informatica Developer

Responsibilities:

Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectation.

Used Informatica power Center 9.6 for extraction, loading and transformation (ETL) of data into the target systems.

Extracted data from different sources like relational Database, flat files.

Created mappings in power Center Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.

Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica power Center Designer.

Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).

Developed error handling & data quality checks in Informatica mappings.

Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.

Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts

Involved in Performance tuning for sources, targets, mappings and sessions.

Migrated mappings, sessions, and workflows from development to testing and then to Production environments.

Migrated mappings, sessions, and workflows from development to testing then to Prod environments

Documented the process for further maintenance and support.

Comcast, Philadelphia, PA July, 2010 – Jan, 2017

Lead Billing System Analyst/Data Mapper

Responsibilities:

Collaborate on configuration and implementation of offers and rules within EPC to support Marketing needs and expanded use of Sales Portal across additional channels.

Monitor offer request queue and team capacity for implementation; Ensure proper work queue prioritization and timely escalation of issues.

Facilitated collaboration among EPC, Divisional IS, and Marketing teams to ensure clarity of direction and proper implementation of offers through EPC and the Billing Systems.

Monitored existing reports and alerts to identify offer data discrepancy issues among EPC and Billers, and coordinate with EPC, Divisional IS, and Marketing teams to facilitate analysis and timely resolution.

Managed offer QA reporting – eliminate or consolidate reports and add new reports or alerts as needed to drive improved offer quality assurance.

Proactively identify and implement improvements to drive increased efficiency and quality of offers implemented through EPC and the Billers.

Collaborate on Offer Management process improvement across all business lines for the company..

Collaborated with various team to support strategic improvements in offer management.

Lead the EPC Data Setup to Support DotCom integration testing.

Investigated & resolved EPC Data related issues and tickets to support multiple integration environment.

Investigated & resolved DotCom defects pertaining to non-EPC Mapping in Integration environment

Participated in facilitation of team meetings, creation of status reports, and preparation of executive presentations to communicate EPC accomplishments, challenges, opportunities, and recommended courses of action.

Z&Z Investment Group Inc. Oct, 2005 – July, 2006

Role: Data Analyst

Location: Annandale, VA

Responsibilities:

Reviewed financial statement and analyses sales revenue, costs, and expenses.

Developed spread sheets to identify trends and develop forecasts

Developed and reviewed complex data to access dollar amount and business units.

Supported and collaborated with Senior Financial Analyst.

Used SQL to generate report.

Maintained the research database, renew and improve it from time to time and make sure safe storage of data.

Arranged analysis reports and be accountable to answer any queries, complaints or proposal.

Responsible for entering, transcribing, recording, storing, or maintaining information.

Maintained the company database up-to-date.

Worked on different data entry tasks at a time.

Maintained records for the already completed projects.

Prepared required registration forms and process payment of related fees.

TECHNICAL SKILLS AND APPLICATIONS:

Informatica Power Center 9.6, Repository Manager, Designer, Workflow Manager, workflow Monitor, Teradata 12 SQL Assistant, Oracle SQL Developer, Scheduling tools Tidal, EPC (Enterprise Product Catalog), SOAP UI, Linux, Putty, WinScp, Microsoft Suite,

CERTIFICATION: Oracle SQL Bootcamp, Linux+ Boot Camp

EDUCATION:

Master’s in Business Management, Graduated June 2009

Strayer University, 2730 Eisenhower Ave, Alexandria, VA 22314

Contact this candidate