Sign in

Data Analyst

United States
December 20, 2019

Contact this candidate


Tan MDam


Technical Skills:

Technologies: C#, MVC ASP.NET, WPF(MVVM), Entity Framework, HTML5, XML, Angular, jQuery, BootStrap, CSS

Database Systems: SQL Server, SSIS/DTS, SSRS, Crystal Report, Oracle

Hardware: Compaq/Hp Commercial and Consumer Desktops, Laptops, Servers, Switches and Routers, Wireless LAN/WAN

Software: Tibco, Siebel, LodeStar, Nucleus, SAS, Energy Credit, nMarket, AIM, Meditrac, Benefit Workstation, Infomaker, Data Junction, SAP, TFS (VSTS), Telerik, Remedy, HSP, PhaseWare, Accpac, PI/eDNA Historian

OS: Windows, Linux

Other: Ionic mobile framework, Xamarin, Dapper, Nodejs, Telerik Suite (KendoUI), DI (Unity, Autofac, Ninject)

Skills & Award:

Certified Boomi cloud integration PaaS. Integrated with JDE, Sage, Dynamics NetSuite, Salesforce, EcoSys, Origami, iCIMS

Awarded the 2014 Innovation Real Time Custom Application from InStep Historian Software.

Motivated professional with extensive leadership in software architect and development.

Knowledge with energy transactions (Inbound/Outbound), Energy Billing and Utility Business Processes

Jun 2017 - Present Quanta Tel. Services Houston, TX

Sr. Integration / .NET Developer

Designed and developed Boomi processes to integrate with internal/external cloud applications (JDE, iCIMS, ServiceNow, NetSuite, Benefit Solver, Dynamics, Sage etc.).

Refactored multiple Boomi processes to improve performance including emails notification error handling.

Use atmosphere api, queue orchestration/listeners, integration packs and many connectors.

Implement processes to capture and execute at a transactional level (CDC).

Develop/support a web (Angular) and mobile (Xamarin MVVM) data capture solution across the fleet.

Support and enhanced EDM/MDM data and processes.

Code review and suggest best practices.

May 2013 – Jun 2017 CPN Corp. 717 Texas Ave. Houston, TX

Sr. Technical Analyst/Developer

Agile SOA design, implement N-Tier connected data monitoring systems that identify data gaps with real-time notification.

Provide technical and data integration solutions across all applications for acquisitions & divestitures.

Meets with customers to establish production goals, priorities, schedules, timelines, and resources for projects.

Agile TFS scrum master liaison between critical business client/vendors for requirements gathering & designs.

Provides direction, coaching, guidance, support, and mentoring to project team to successfully guide team through project expectations and requirements with weekly status report that provide insights into the progress and priority.

Establish best practices and mentorship toward higher quality and more maintainable software development.

Aids in the establishment of best practices for application development and support and participates in strategic planning.

Collaborate with key business stakeholders, IT and management teams in delivering projects from designing to implementation and support.

Design & develop high performance reliable real-time applications to optimize gas and wind turbines.

Support daily operations pertaining to all applications and data flow between platforms.

Jun12 – May2013 Supply Pipeline Service 6969 Ardmore Houston, TX

IT Project Manager

Enforce IT. Policies, procedures and standards including infrastructure/application schematic layouts for auditing.

Drives systems integrations across the fleet to best meet user demands and improve operations to increase productivity.

Established in-house IT group plus support to reduce out-source/vendors dependencies by fifty-percent.

Design, strategize, and integrate IT infrastructure/application for all acquisitions & divestitures.

Onboard BI application to improve visibility and turn into actionable information.

Determining the scope, budget, timelines of IT projects and manages complete software development lifecycle.

Primary vendors’ contact for any software implementations and/or contract renewal. This includes system designs, development, installations, upgrades, conversions and maintenance.

Works it Director and peers to develop consolidated roadmap aligned with business strategy.

Completes development roadmaps, procedure work planning and controls project execution against the project plan and defined processes.

Provides mentorship for IT peers in areas of specific expertise and provides oversight, leadership, guidance, and professional growth opportunity for staff.

Oversees the development, installation, configuration, maintenance and support of all enterprise applications/systems.

Manage Back-Up & exercise Recovery Disaster Recovery for local and remote sites.

Responsible for cost scheduling, budget analyses, forecasting of technical aspects for all software & hardware.

Sept 2011 – Jun 2012 CPN Corp. Houston, TX

Sr. Application Analyst

Manage, architect and develop applications (MVC, HTML, jQuery) to monitor trades from various entities (ICE).

Analyze current business processes and procedures to enhance applications integration (web services & various files types) internally and external vendors.

Perform root analyzes, business impact on failures and provide best practice solution for each individual trade. Including but not limited to trading data, risk calculations, and operations.

Support multiple fast pace trading, risk, and financial systems for all gas and electric trades including hedging, energy credit calculations.

Work closely with operations, development team to determine project time line and resources on deliverables.

Participate in the product cycle from requirements definition and project scope to product release and support including migration.

Create system and business process flow charts and diagrams for training purposes.

Dec 2010 – Sept 2011 MX Energy Houston, TX

Sr. Integration Analyst

Design internal and integrate with external applications for daily transaction files.

Work as a member of the Quality Management team to ensure that requirements documentation can be easily translated into test plans and that testing plans are completed.

Analyzing volume impact, business impact, root cause and provide a suitable solution for each utility transaction.

Differentiate the current workflow process each business function (Acquisition and Enrollment, Billing, Remittance, Collection etc.) vs. the previous workflow process toward improving productivity.

Participate in the product cycle from requirements definition and project scope to product release and support.

Supervised support for LoadStar Energy Billing System, GIS and Tibco for deregulated markets.

Design, implement and execute manual and automated test scripts.

Create reports and automated jobs using DTS/SSIS and SSRS for daily monitoring work flow process.

Mar 2009 – Jun 2010 Dental Economic Houston, TX

Sr. Application/Data Analyst

Responsible for leading new market implementation and designs including client engagements, status reporting, and billing.

Streamline department’s processes towards efficiency and productivity.

Requirements gathering, requirements document, data analysis, analysis document, high level design documentation

Identify and perform key data analytics to identifying trends, patterns, and insights to further IT goals.

Create and provide database analyst on maintaining, data modeling, backups, security, disaster recovery, and enhancement for maximum performance on multiple server environments.

ETL data conversions, data warehousing experience creating and analyzing data extracts, system analysis, business analysis and data decomposition

Data Mapping, writing SQL queries, store procedures, creating data models, creating business requirements and reports using Crystal Report for Accounting and Finance departments

Provide support, create and implement custom tools in C#, query/store procedures to streamline business processes including reporting and data warehousing for multiple applications.

Create & implement DTS/SSIS packages for data mining and data manipulation from different sources includes EDI 824/277ect.,

Feb 2007 – Jan 2009 Stewart Title Company Houston, TX

Sr. Technical Application Analyst

Introduced agile/scrum process to improve the software development process.

Identify risks, potential roadblocks and resolves in a timely manner.

Allocate team resources on issues according to urgency

Setup and manage virtual environments to analyze and troubleshoot to find root causes for internal .NET applications.

Provided support for all clients throughout the U.S. on multiple platform including .NET, SQL

Create custom tools, modules and Store Procedure to streamline business process.

Work with PM on logging and regression test for all enhancements and bugs for future releases

Work closely with other departmental teams & managers to resolve issues & implement project tasks.

Process ad-hoc test, UAT full cycle testing for all releases.

Feb 2004 – Sept 2006 Mercer Human Resource Consulting Inc. Houston, TX

Implementation Application Analyst

Ensure that well-defined requirements are derived from the product and customer requirements. This includes ensuring that the deliverables of the project are clearly understood. Ensure that there is well-defined system architecture and functional analysis in the WIP.

Implement and manage support HIPPA compliance new business processes through business operations and new systems for Health and Welfare (HW), Time Management Absence (TAM) and ADP batch Payroll.

Use base object modeling (BOM) to create the full product development lifecycle.

Create User and object modeling Functional Requirement to ensure project documentation is complete and accurate.

Control and coordinate change to the project at the level of requirements, timescales and resources.

Implement, customize & upgrade Functional, User Requirement, & BOM into new or current systems using various tools.

Develops and recommends solutions and strategies, based on the analysis of customer business goals, objectives, needs, and existing systems infrastructure

Act as a central point within the project for the escalation and resolution of issues that affect the project activities.

Provide project leadership to promote maximum productivity while striving to minimize costs

Manage implementation, setup, upgrade and customize work in process modules for new and on-going clients.

Configures new system settings, update new changes, Batch Processing, and Regulatory Reporting accordingly.

Feb 2001 – Jan 2004 HP Houston, TX

System Analyst

Create Functional and User Requirement documents and seamlessly integrate it into on-going projects.

Create Test Tools, Test Plans and Test Scripts for validation in in multiple test environments.

Support and implement validation scripts for manual and automated testing/WinRunner.

Validates and loads test tools and test components for automated/manual testing.

Compile and Analyze regulatory report to scope project go-live risks.

Enterprise level software/hardware configurations including migrations.

Software packaging


1998 - 2002 STC Springfield, MA

Computer Information Technology

Contact this candidate