SUMMARY:

• 18 years IT experience.
• 10 years Team/Tech leader experience.
• Strong SDLC (System Development Life Cycle) experience.
• Strong business analysis experience, more than 15 years.
• Strong system analysis experience, more than 15 years.
• Strong coding experience, more than 18 years.
• Strong testing experience, more than 15 years.
• 15 years JAVA,C#,VB.Net,ASP.net,.net framework 2.0.3.0.4.0 , 4.6,T - SQL,PL-SQL;
• 18 years, C/C++ coding experience.
• 15 years on DBMS/EDW modeling Tools: ERWIN, Power designer, Embacadera ER/Studio.
• 15 years SQL (T-SQL/PL-SQL) development experience.
• 15 years Enterprise Data warehouse (EDW) architecture design experience.
• 15 years Data modeling experience.(CA Erwin, Power Designer, ER/Studio)
• 5 years Microstrategy with SDK development experience.
• 5 years Qlikview development experience.
• 5 years Informatica development experience.
• 5 years Tableau development experience.
• More than 5 years Cognos experience on Version 8.x, Version 10.x . Framework manager, Query Studio, Report Studio, Viewer, Analysis Studio, Connection, Report Net, Meritc Studio, Event Studio,Report Authoring.
• More than 5 Years Cognos,TM1 architect, development and administration experience(Install, configuration, maintenance).
• 15 years SQL DBA experience in SQL 6.5/7.0/2000/2005/2008/2012/2014.
• 15 years strong experience on Microsoft Office (Word, Excel, Access,VISIO)
• 15 years strong experience on Microsoft Project.
• 15 years on MSBI.(Cube, MDX)
• 15 years BI and data warehouse architect experience.
• 11 years SSIS/SSAS/SSRS hand on coding experience.
• Strong T-SQL (stored Procedure and trigger, function) and ETL, Encryption experience.
• Experience modeling and designing Relational/Star Schemas and analytical cubes.
• Experience with OLAP, MDX, DAX and Analytics tools, with types: tabular, multidimensional, and Power Pivot.
• 3 years on Microsoft Power BI solution..
• 5 years on Microsoft Dynamic ERP.
• 5 years MS Dynamic CRM experience.Version 4.0/2011/2013/2015
• 5 years MS Dynamic Great Plains experience.
• 8 years SharePoint Experiences.
• 10 years BizTalk Server experiences, version 2000, 2002, 2004,2006/R2,2009,2010.
• 10 years’ experience in Oracle 7.3, 8, 8i, 9i 10g, 11g.
• 10 years PL-SQL coding in JDeveloper experience.
• 5 years in PeopleSoft Financials 9.0
• 5 years in PeopleSoft HRMS 9.0
• 5 years in PeopleSoft Campus Solution
• Strong experience and knowledge on PeopleSoft 8.49 development tools;
• 5 years Informatica development experience.V8.1.1, V8.5.1, V9.0.1, V9.5.1, V9.6.1.Server configuration.
• 5 years BI,server, BI Answers, BI Interactive Dashboards, BI Delivers, Disconnected Analytics, BI publisher(XML publisher),BI Briefing Books.V11.1.1.70,V 11.1.1.90.
• 5 years in Oracle Hyperion experience.Interactive Reporting,SQR Production Reporting,Financial Reporting,Web Analysis.
• 15 Years experience in Unix and Linux Environment.
• 5 years VMWare experience. VMWare ESXi Server V5.0, V5.5, V6.0, VMWare Workstation V6,V7,V8,V9,V10,V11.
• AWS environment, administration and implementation,3 years.
• Big data,3 years experience in Hadoop, Spark. R, Python, NLP.
• SAP Hana,3 years

WORK EXPERIENCE:

Confidential

Global IT manager

Responsibilities:

• DB modeling, build new dimension in EDW, fact tables and views.
• Draw whole pangeo global (Canada, USA,China) IT infrastructure topologic map. I gathered information from different location, and draw in several maps.
• Microsoft Dynamics CRM project, from start to build a complete new CRM system, select MS dynamics CRM from a lot different CRMs in the market, as senior role, I contributed my ideas and help market team make decision, select outsource develop team,partipated customization process.
• Microsoft Dynamics Nav project, it is exist, I were worked on a EFT function, after investigated on the structure of NAV internal core, I found Pangeo don't have the development license on development activity, So delivered this task to an out source company.
• Tableau development project, Architecture designation.
• Trouble shooting enterprise VOIP system, located hackers. There were some hackers enjoy to attack Pangeo's VOIP system, I used the information gathered to located hackers. From that time, Pangeo's voip system became security. This is an exciting story which I met first time in my IT professional life.
• Microsoft BI development project.
• AWS environment, administration and implementation.
• On site to China branch factory, help them build new plant's IT infrastructure system.It is a new plant in a big factory, everything is new, I worked as senior level member in the factory high level team and gave my suggestion and final decision on IT aspect.
• Worked on new real time monitor system for automobile production line in China.This task failed on my side.It is complete system writed by delphi 7.0 and connect with production side.This software wrote by another elite guy which spent 5 years, I have only several weeks to understand it,the time is too limit to complete this task. It is not my strong point.
• A lots other tasks help other clerks in different locations.
• There is a project in US branch,use Microsotrategy as their new BI environment,I help them to design the architecture.

Confidential

Senior Tech Leader/Senior BI Architect

Responsibilities:

• DB modeling, build new dimension in EDW, fact tables and views.
• Built new dimensions, facts, calculated dimensions, cubes and MDX scripts in new cubes in SSAS.
• Migrate new system into Cloud.
• Help to build master data service in enterprise environment..
• SharePoint 2010 and 2013 integrated environment with SSRS.
• Help trouble shooting bugs in existing EDWH production tables.
• Tableau as end BI tool architecture development.
• Microsoft Power BI development project.
• MicroStrategy SDK sevelopment.

Confidential

Senior Tech leader/PM/Senior BI Developer

Responsibilities:

• Trouble shooting on enterprise level Cognos system Migration bugs.
• Trouble shooting on Cognos and third party software integration.
• Working on very complex EDW environment.
• Working on TIBCO spitfire, TIBCO spitfire Web Player Client, TIBCO spitfire Professional, TIBCO spitfire Server, TIBCO spitfire web Player Server, TIBCO spitfire Platform.
• Cognos, ProClarity, SSRS integrated in SharePoint 2010 enterprise environment.
• Project on Microsoft BI platform, SSIS, SSAS, SSRS, Power BI.
• MicroStrategy used as whole enterprise BI environment, I have touch it.
• Help developers working on High level design and Low level design on SSAS, cube.
• Directed and checked developers working on SSIS, SSRS, reporting scripting(MDX and T-SQL).
• Build Cognos BI architecture, Used Query Studio and Report Studio wrote reports.
• Microsoft Visual Studio 2008/2010/2012 and Business Intelligence Development Studio (BIDS)
• Zachman Framework environment to help design architecture.
• Help project manager decide resource arrangement.
• MicroStrategy SDK development with VB,C++,XML..
• Tableau as BI Tool development solution project.
• Work on IBM Cognos Migration Assistant, content database, Report Studio, Query Studio, Data Manager, Data Manager, PowerPlay, Transformer.

Confidential

Responsibilities:

• Team members onsite and off shore.
• Trouble shooting on enterprise system level bug. Successful solved key problem which has blocked this project for several month, then project could continue.
• Third party software Motio integrate with Cognos.
• Working on Dev, QA, UAT, Production environment.
• Oracle Fusion and JDeveloper Environment.

Confidential

Sr.BI Developer/Architect/DB dev

Responsibilities:

• Business analysis of Accounting System.
• EDW environment from Microsoft Dynamics GP2010.
• Complex T-SQL/PL-SQL coding with Stored Procedure, Trigger, Function.
• Build BI architecture use Microsoft Visual Studio 2008/2010/2012 and Business Intelligence Development Studio (BIDS).
• Encryption with DB security design.
• Write SSRS Report project base on Microsoft Dynamics Great Plain 2010.
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• Use SSAS build cubes from Data warehouse.
• SSRS Reports relative with Receivable, Payable, GL, Bank.

Confidential

SQL DBA

Responsibilities:

• Database side, mix of SQL Server (40%), Oracle (30%), Sybase (20%), other (DB2, 10%)
• More than 200 projects at same time.
• Update project management information of DBA Teams of Confidential .
• Write manual of some task of DBA Teams in Confidential .
• Refresh (restore) database from production dump as requirement from other teams in Confidential .
• Backup database as the requirement from other teams in Confidential .
• Very large and complex EDW environment.
• Help other teams project manager to decide resource determination.
• Security issues, add, change User and Logins in SQL Server as requirement from other teams in Confidential .
• Microsoft Dynamics CRM 4.0,APS,MPP,PDW environment.
• Cognos TM1 environment.
• Tuning performance of SQL Server's objects as requirement from other teams in Confidential .
• Create and modification SQL Server job agents to make maintenance tasks as requirement from otherteams in Confidential .

Confidential

Team leader/Sr.BI Architect/Developer

Responsibilities:

• Build BI Architecture.
• EDBMS Data modeling use Erwin.
• Design and build Data warehouse architecture.
• Microsoft Visual Studio 2008/2010 and Business Intelligence Development Studio (BIDS)
• SSIS/SSAS/SSRS development.
• Government EDW environment.
• T-SQL,PL-SQL scripting in SQL Server and Oracle.
• MS Dynamics CRM 4.0 environment.
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• Define architecture solution for customers in data warehousing and data management techniques.

Confidential

BI Developer/DB Developer

Responsibilities:

• Perform/assist in requirements gathering and documentation of requirements
• Develop source-to-target mappings and develop ETL(Extract, transform, load) code - SSIS
• Assist in production implementation of ETL(Extract, transform, load) code
• Microsoft Visual Studio 2008/2010 and Business Intelligence Development Studio (BIDS)
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• MDM data in DWH designation.
• Define architecture solution for customers in data warehousing and data management techniques.

Confidential

SQL Server DBA /BI Developer/Architect

Responsibilities:

• Manage all production SQL servers.(4 group, >= 15 nodes)
• BI Solution of whole enterprise with Microsoft BI Solution.
• ETL (Extract, transform, load) development use SSIS.
• T-SQL/PL-SQL stored Procedure (XML) and trigger development.
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• 30% DBMS system in Oracle 10g and 11g.
• Define architecture solution for customers in data warehousing and data management techniques.
• Apply 3th party solution (Quest) apply into enterprise environment.

Confidential

SQL Server DBA/BI Developer

Responsibilities:

• Work with teammates in evaluating reporting requests, assessing feasibility, developing prototypes and designing a production/delivery plan.
• Complex T-SQL/PL-SQL script inside Report.
• Microsoft Visual Studio 2008 and Business Intelligence Development Studio (BIDS)
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• MDM data with DB2 MDM management center.
• Define architecture solution for customers in data warehousing and data management techniques.
• Install SQL Server 2008 enterprise version, SSIS, SSAS, and SSRS.
• Develop working knowledge of all related data sources
• Develop code / logic to assemble & combine disparate data from various reporting systems
• Automate Business Sales / Care production reports enabling self-serve & automatic distribution solutions
• Fully document all requirements & technical solutions.

Confidential

SENIOR DATABASE ADMINISTRATOR

Responsibilities:

• ETL (Extract, transform, load) development in SSIS and PeopleSoft SQR.
• Collected all departments’ requirement within ERP system.
• Worked with server staff to allocate physical data storage in PeopleSoft ERP system.
• Designed, installed, monitored, maintained and performance tuned the production and development SQL databases and PeopleSoft application 9 - Tools 8.49, ERP (Financials-all modules) 9 - Tools 8.49), and HRMS 9 - Tools 8.49.
• The initial responsibility was review the phase one data marts/reports/cubes and make recommendations on how to streamline the process. then worked with the team to collect requirements, build prototypes, and transfer to production all SQL code needed for Phase 2.
• Assisted IT staff in developing database architectures, coding standards, and quality assurance policies and procedures in PeopleSoft ERP with SQL.
• Analyze current client database and systems. Identify the problems and propose solutions for the same.
• Oracle Hyperion technology, SQR, Financial data, Quality management. Planning, Workforce planning. Data relation ship management.
• Design SSIS, SSRS, SSAS packages in development server and deploy them into production servers.
• MS SharePoint administration, Designation and Implementation..
• Performance Management Spotlight® on SQL Server Enterprise
• Development and Administration Toad® for SQL Server
• Backup and Recovery LiteSpeed™ for SQL Server
• Capacity Management Quest Capacity Manager for SQL Server
• Trouble shooting with Database and network problem. Provided on-call support as appropriate.
• Monitored and directed work output of less senior individuals performing a similar role.
• Environment:Windows 2003, 2008 server; VMware ESX 2.0/3.0 Server; SQL 2000, 2005 SERVER; PeopleSoft ERP 8.49; Linux (Fedora version 8, 9)