SUMMARY:

• To obtain a position as an Analyst/Engineer/Developer in order to utilize and develop my skills.
• Over 15 years of working experience as Sr. Business/Systems/Data/BI Analyst/Developer
• Worked on projects in various industries in Telecom, Biotech, Healthcare, Energy, Oil/Gas, Utility, Power, Media, and Retail.

COMPUTER TRAININGS AND SKILLS:

OS: DOS, Windows, Unix Solaris

Applications/Systems: MS Office (Word, Excel, Powerpoint, Access, Project, Outlook, OneNote), Office 365, SAP R/3 (MM, WM, SD, PM, PPM, PS, FI/CO, BPC), P6 Primavera, Sharepoint,Visio

Programming/Scripting: VB, Python, C++, Cobol, R

Database/Data Warehousing/Business Intelligence/Reporting: Foxpro, MS Access, MS SQL Server, SSMS, Confidential - SQL, SSRS, Cognos, Tableau, SAP (BW, BEX, BOBJ), Power BI, Hadoop, Apche Spark, Hive

ETL/Data Quality/Data Transformation: Data Stage, DTS, SSIS, Informatica MDM, Informatica Data Quality (IDQ Admin, Developer, Analyst)

Other Tools/Processes/Methodology: gRemedy, gMail, Lotus Notes, Clarity, Erwin, Salesforce, MDM, Data Governance, Data Warehousing (OLAP, OLTP, ROLAP, MOLAP), Client Server Methodology, AWS, Business Analysis (Gathering Requirements, System Requirements Specs., Functional Specs., Non-Functional Specs), SDLC, Agile, Waterfall, User Story, Planning, Requirement Analysis, Design, ETL, Data Conversion, Development, Integration and Testing, UAT, JIRA, HP QC, AB/Testing, Implementation, Operation and Maintenance, User Training, User Experience and Technical Documentation (Traceability Matrix, Workflow, Data Flow Diagram, Swim Lanes)

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

IDQ Developer - Supply Chain

Responsibilities:

• Developed rules, profiles, scorecards, mapping, mapplets, workflows and parameterization in IDQ Dev.
• Utilized IDQ Admin, IDQ Developer and IDQ Analyst tools for Data Quality.
• Created user stories, tasks, iteration status in Rally CA Agile Central. Attended daily scrum/sprint.Performed data profiling, data quality and data discovery.
• Developed mapplets and applied parameterized data quality rules.
• Migrated objects from Dev/Stage Environment to Prod Environment.
• Designed and created physical data objects and logical data objects from sources In CIFA (Oracle EBS). PTDB (My SQL) and Oracle PDH Cloud.
• Developed complex mapping transformations like matching, standardizer. labeler, joiner, aggregator, union, expression, filter, router, normalizer, parser etc.

Confidential, Cincinnati, OH

Software Engineer - IDQ Developer/Analyst/Administrator

Responsibilities:

• Developed data objects, logical data objects, profiles, mapping specifications, mapping, mapplets, rules, reference tables, scorecards from sources in Hadoop/Hive, SQL in Informatica Data Quality for Billing, Customer Merchants, Ledger, Settlement domains.
• Developed rules, profiles, scorecards, mapping, mapplets, parameterization and transformation in IDQ Developer in Virtual desktop (VDI).
• Created application to schedule mapping in Informatica Admin. Scheduled profiles/jobs, monitor runs/jobs, logs in IDQ Admin. Tested and deployed application.
• Utilized IDQ Admin, IDQ Developer and IDQ Analyst tools for Data Quality and Data Governance.
• Worked as part of Data Governance team to analyze, select solution, design, configure, test and deploy new functionality. Supported the Data Governance team and Data Stewards.
• Created user stories, tasks, test cases, iteration status, backlog in Rally CA Agile Central for Agile/Scrum/Kanban.
• Participated in Multi-Train PI Planning, Scrum ceremonies, Kanban (Daily Stand up, User Stories, Sprint Planning, Sprint Demo/Review, Sprint Backlog)
• Coordinated and write rules and transformations with Data Stewards. Managed documents in Sharepoint.
• Performed data profiling, data quality and data discovery. Developed and applied data quality rules.
• Migrated objects from Test Environment to Prod Environment.
• Designed and created logical data objects, mapping transformation to run/pushdown in Hadoop/Hive.
• Writing queries in SQL utilizing Hue for Hive/Impala in Virtual desktop (VDI).
• Write and developed queries, scripts, procedures in SQL Developer.

Confidential

IT Consultant/PM

Responsibilities:

• Assigned in IT Projects concerning Data Warehousing, Business Intelligence, Database, Data Visualization, Dashboards, Reporting, Metrics, KPI’s, MDM, Data Governance, ETL, ERP, Coding/Scripting and Business Systems Analysis.
• Utilized Sharepoint for managing documents.
• Manage skillset in the team for project deployment. Managed budgets and scheduling.
• Supported and assisted in sourcing for prospective clients.
• Determining projects for bidding and coordinating with Development team.
• Conducted interviews for resources in the team. Managed Glassdoor, LinkedIn etc. recruitment dashboards.

Confidential, NY

Report Developer

Responsibilities:

• Debugged, developed and tested codes in VB codes to modify HR reporting templates to work for both Mac and PC.
• Debugged and written codes in Lotus script to modify program in Lotus Notes in DEV environment for TCP Cycle Tool for HR to make it work for both Mac and PC. make it work for both Mac and PC.
• Tested codes in QA environment and deployment of script and new releases.
• Attended conference calls concerning tasks/project status updates.

Confidential, Pleasanton, CA

Sr. Data Analyst

Responsibilities:

• Worked on large data sets performing data analysis, data manipulation, data cleansing and data mining.
• Applied various techniques like querying in Access SQL to extract and merge data or writing VB codes to automate tasks for contracts data. Validated data integrity and accuracy of data.
• Attended daily meetings to report progress of tasks and projects.
• Analyzed data and numbers/quantitative.
• Assisted and helped in the team as needed concerning contracts data and building the database in Access/VB. Managed Excel spreadsheets with formulas, pivot tables and VB codes.
• Gathered data from different sources to transform/convert into reports or analytical results.

Confidential, South San Francisco, CA

Sr. Business Analyst/VB IT Technology Consultant

Responsibilities:

• Imported tables from SAP and EDW into Access to design and develop programs/tools and GUI, data modeling for Data Operations group. Built latest master cube of all master data and production tables for auditing/reporting.
• Analyzed, designed, debugged, developed and automated systems/processes in Access/VBA to gather and manipulate SAP MM and recipe data. Debugged existing programs/codes, created GUI interface and trained users.
• Manipulated and processed data in Access and created codes in Excel and developed queries in Access SQL or VB codes. Developed queries utilizing SQL.
• Extracted Material master tables and recipe tables from SAP MM via ODBC and executing code/automation.
• Developed ad hoc requests that involved modification of processes, programs, codes, metrics and reports. Supported the Supply Chain group and internal customers concerning requests and projects.
• Attended weekly meetings for collaboration and project status/progress update.
• Conducted testing to ensure that data/reports adhered to all business rules/processes/requirements.
• Committed to continuous improvement of quality, processes, systems, analysis, data, reports, design, specs., modification and user support. Documented business processes when needed.

Confidential, San Ramon, CA

Sr. Business Systems Configuration Specialist

Responsibilities:

• Worked with Leadership and system users to validate and identify needs for developing custom reporting solutions to ensure alignment with changing system and/or end user needs. Worked with internal customers concerning requirements, specifications, documentation and reporting needs.
• Designed codes, debugged, tested and documented solutions for users to ensure ease of use, efficiency and quality. Provided system and report configuration development using various tools and/or languages
• Developed new and enhances existing reports, views, forms and other software functionality to meet clients need for assigned business systems/tools. Involved in other initiatives
• Assisted with solutions test planning and execution. Collaborates with users to investigate and troubleshoot system. Participated in solutions design efforts. Contributes to solutions design, analysis, and application prototyping sessions
• Managed data, business processes/workflows, data transformation, data integration, data warehousing and data modelling. Involved in architecture, design of entity relationship diagrams and development of conceptual, physical and logical data modeling. Recommended solutions to existing processes and develop new processes. Built ER, data models and metrics.
• Liaised and supported Transmission, Construction and Engineering in systems/reporting requirements.
• Configured, extracted tables/queries, developed and supported applications/systems in Access, VB, Excel, SAP (WM, PPM, PM PS), BW, BEX, BPC, P6 Primavera, Clarity and SQL.
• Assisted and supported in development of sites in Sharepoint. Supported Electric Operations in technical issues and requests in Clarity.
• Involved in initiative to develop roadmap in Master Data Management and Data Governance to ensure data accuracy and data integrity. Involved in BOBJ project.
• Developed documentations such as Technical Requirement/Specifications, Flowcharts, Workflow, Swim Lane and Data Flow Diagram as per request.

Confidential, Oakland, CA

Sr. BIDW Data/Business Analyst

Responsibilities:

• Developed Technical Requirement/Specifications, Flowcharts, Workflow, Swim Lane and Data Flow Diagram as per request.
• Recommended solutions to existing processes and develop new processes. Committed to continuous business processes improvements and issues/concerns.
• Worked in all phases of SDLC. Lead a project to rebuild existing Onsite Services process in Sharepoint in Access. Involved in Gathering Requirements, Planning, Requirement Analysis, Design, Data Conversion, Development, Integration and Testing, UAT, Implementation, Operation and Maintenance, User Training and Technical Documentation.
• Developed documentations such as Gap Analysis, BRD, Flowcharts, Workflow, Process Flow diagrams.
• Provided support concerning metrics, reports, dashboards and KPI’s to ensure accuracy of data/reporting in Sharepoint.
• Coordinated with PM, BA’s and Business Users concerning project modification, status and updates.
• Involved in architecture, design of entity relationship diagram and development of conceptual, physical and logical data models.
• Designed and developed technical documents as needed.
• Performed migration/testing across different environments (DEV/QA/PROD) and platforms.
• Developed Use Test Cases and Test Scripts for UAT. Developed and executed test cases/scripts in UAT.
• Trained users/clients within the department for supported applications/systems

Confidential, San Diego,, CA

Sr. BI Systems Analyst

Responsibilities:

• Involved in Performance Management Reporting project for KPI’s/Reports/Dashboard in Business Objects.
• Worked in all phases of SDLC and have used Agile methodologies/processes.
• Involved in data migration/implementation project from Cognos to Business Objects and assigned in Gathering Requirements, User Story, Planning, Requirement Analysis, Design, ETL, Data Conversion, Development, Integration and Testing, UAT, Implementation, Operation and Maintenance, User Training, User Experience and Technical Documentation.
• Developed tools/programs to support clients/users across all organization as per requirement.
• Supported applications/systems like Cognos, BOBJ, SQL DTS, VB, Access, Excel, Sharepoint. Assisted in I. Confidential . projects concerning Business Intelligence, Data Warehousing (OLAP, OLTP, ROLAP, MOLAP), ETL, Business Process etc.
• Worked in ETL and build packages/cubes in SQL 2005/2008/2008 R2, SSMS, SSIS and Transformer. Assisted in SQL queries, stored procedures, triggers, and events in SQL Server 2008 R2.
• Managed data, business processes/workflows, data transformation, data validation, data cleansing, data integration, and data modelling.
• Involved in architecture, design of entity relationship diagram and development of conceptual, physical and logical data models. Provided support/help concerning metrics, reports, business intelligence tools, dashboards and KPI’s to ensure accuracy of data/reporting.
• Assisted in PMR project in development of Universes, Queries, Dashboards Xcelsius and WEBI in BOBJ.
• Attended meetings to identify/rectify issues/concerns and coordinating status/progress of the project.
• Assisted PM and worked with Sr. Managers, SME’s, Data Owners, Business Process Owners, Consultants/Contractors, Vendor and Offshore Team to coordinate requirements/modifications of the project. Liaised and supported the Construction, Finance, Engineering groups in their reporting requirements.
• Performed migration/testing across different environments (DEV/QA/PROD).
• Assisted in Use Test Cases for UAT. Assisted in development and executed test cases/scripts in UAT.
• Coordinate with Business Leads and internal customers in continuous business process improvements and issues/concerns. Involved in I. Confidential . projects/initiatives.
• Assisted in design and development of specifications such as Security Matrix, Process Flow diagrams with Swim Lanes, Flowcharts, Workflow, Systems Requirements Specs., Functional Specs., Non-Functional Specs., Data Requirements Specs and Traceability Matrix, UAT Test Plan/Test Cases and Cause/Effect Diagrams. Assisted in development of Training manuals and Quick Reference Guide for Users.
• Received requests or ticket and solve/troubleshoot problems. Worked with the business to support/help in their requirements. Ensured proof of concept to establish whether the system satisfies some aspects of the purpose it was designed for.

Confidential, South San Francisco, CA

Business Systems Analyst/Software Engineer

Responsibilities:

• Imported tables from SAP and EDW into Access to design and develop programs/tools and GUI, data modeling for MDM and Data Operations group. Built latest master cube of all master data and production tables for auditing/reporting.
• Build master cubes of all master data/production tables every week and send notification of update.
• Manipulated and processed data in Access and created codes in Excel and developed queries in Access SQL or VB codes.
• Analyzed, designed, debugged, developed and automated systems/processes in Access/VB/Excel/SQL for SAP Material Master/Recipes. Debugged existing programs in Access/Visual Basic/SQL. Created GUI/Interface and trained users.
• Received ad hoc requests and produced reports depending on specs from different groups pertaining to Material Master, Bill of Material/Recipe and Business Rules/Processes/Audit Rules/Class A Data.
• Developed/generated metrics for Class A, Pareto charts and publish report every week in Livelink to all Business Process Management, Business Process Owners, Data Content Owners and Data Stewards.
• Extracted Material Master tables and Bill of Material/Recipe tables from SAP MM.
• Supported MDM, data quality, data integration, data governance, data analysis, data extracts, data audits, data evaluation, data entry, data builds/synthesis, data mining, data validation, data cleansing, data transformation, data modelling and master data in SAP Material Master, Bill of Material/Recipe, monthly reports and ad-hoc reports.
• Generated Daily Audit and Ad hoc Audit requests. Supported MDM and Data Ops Group/Supply Chain.
• Managed and supported the Data Ops group and give directives to meet the deadline of the project. Worked and supported Directors, Sr. Managers, Managers and Supervisors in Reporting and Analytics.
• Handled all ad hoc/monthly reporting requests for Clinical/Commercial, Supply Chain, Finance, Quality, Procurement and Logistics in SAP, BW, Access, VB, Excel, EDW. Supported with SAP/R3 functions in MM, Recipe Modules.
• Involved in architecture, design of entity relationship diagram and development of conceptual, physical and logical data models.
• Ensured that data/reports adhered to all processes/business rules/data dictionary and submitted gRemedy ticket for the business owner to make the necessary changes consistent to the business rules.
• Maintained the database, data dictionary, business rules, system codes and programs.
• Supported internal customers concerning business rules/processes/requirements, Material Master, Bill of Material/Recipe and all issues concerning SAP MM extracts, Access and Excel. Worked and involved in various projects and published weekly Class A Metrics for Business Process Owners and Data Content Owners.
• Validated data integrity and accuracy of data from source to target in SAP.
• Performed data analysis, data manipulation, data cleansing, data quality, data validation and data accuracy to ensure correctness of data in SAP.
• Validated Customer Master, Vendor Master, Finance data etc, in SAP OTC, SAP PTR and SAP SCE.
• Managed data extracts, data audits, data evaluation, data builds/synthesis and master data in SAP, Customer Master, Vendor Master, GL Master, Bank Master, Asset Master, P&L,Profit Center and Cost Center.
• Executed codes for data validation/conversion for data accuracy.
• Gathered data from different sources and convert/transform them into reports/analytical results.
• Assisted in projects and other initiatives as per request.
• Worked and supported in SAP FI/CO projects.
• Assisted in development of Access database/VB codes for Finance. Designed and develop entity relationship diagram for database.
• Managed spreadsheets, charts, comparison and analysis reports. Generated queries, modules and reports.
• Developed documentation as per request.

Confidential, Los Angeles, CA

Design Engineer

Responsibilities:

• Designed, aided and drafted engineering drawings in Autocad.
• Attended weekly meetings concerning project status/updates.
• Assisted in development of Access database/program for OSP Engineering. Managed spreadsheets.
• Designed data modeling for database.
• Attended trainings for continuous improvement of processes, systems and techniques.

Confidential

Analyst - Marketing, Finance

Responsibilities:

• Supported Master Data in SAP/R3 functions in CRM, Customer Master, Vendor Master, SD and FI/CO Modules. Supported Data Warehousing.
• Worked comprehensively on BEx Analyzer, Report Writer, Query Designer, Web Application Designer and Administrator Workbench. Designed and implemented BEx, Web Reports and Templates in BW.
• Assisted in architecture, design of entity relationship diagrams and development of conceptual, physical and logical data models.
• Developed SAP BW cubes/queries for different groups to support accurate reporting.
• Published scheduled weekly, monthly reports and ad hoc reports in BW Query Designer.
• Developed ad-hoc queries/reports, static reports, dynamic queries and statistical analysis. Handled large volume of data.
• Trained users on how to use BW, queries and report writing. Developed and maintained BW queries and workbooks.
• Managed data extracts, data audits, data evaluation, data builds/synthesis and master data in SAP SD, Customer Master, Vendor Master, Sales and Finance Revenue.
• Gathered data/information from different sources and convert/transform them into reports/analytical results.
• Managed complex spreadsheets, charts and analysis reports. Developed numerous queries/reports based on specs.
• Analyzed, designed, developed and maintained programs in Access/SQL.
• Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
• Involved in all project planning and forecasting using MS Project. Gathered functional and technical requirements.
• Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.
• Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Confidential

Business Analyst - Finance, IT

Responsibilities:

• Analyzed, designed, developed and maintained programs in Access/SQL. Developed numerous queries/reports.
• Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.
• Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.
• Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.