SUMMARY:

• More than 20 years IT experience.
• More than 15 years SQL(T - SQL/PL-SQL) development experience.
• More than 15 years SQL DBA experience.
• More than 15 years Data warehouse architecture design experience.
• More than 15 years Cube,MDX design experience.
• More than 8 years SSIS/SSAS/SSRS hand on coding experience.
• More than 15 years Data modeling experience.(CA Erwin, Power Designer, ER/Studio)
• 2 years MicroStrategy, Informatica development experience.
• More than 15 years SQL DBA experience in SQL 6.5/7.0/2000/2005/2008/2012.
• More than 15 years strong experience on Microsoft Office (Word, Excel, Access,VISIO)
• More than 15 years strong experience on Microsoft Project.
• More than 15 years BI and data warehouse architect experience.
• 8 years SSIS/SSAS/SSRS strong experience.
• Strong SQL 2005 Development Experience with Cubes and Data Marts
• Strong Experience on SSIS, SSAS and SSRS.
• 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 and Analytics tools.
• More than 5 years MS Dynamic CRM experience.
• More than 5 years MS Dynamic Great Plains experience.
• More than 8 years SharePoint Experiences
• More than 12 years BizTalk Server experiences, version 2000, 2002, 2004,2006/R2,2009,2010.
• 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 20 years.
• Strong testing experience.
• More than 10 years experience in Oracle 7.3, 8, 8i, 9i 10g, 11g.
• 10 years PL-SQL coding in JDeveloper experience.
• More than 5 year in PeopleSoft Financials 9.0
• More than 5 year in PeopleSoft HRMS 9.0
• More than 5 year in PeopleSoft Campus Solution
• Strong experience and knowledge on PeopleSoft 8.49 development tools;
• More than 5 year in PeopleSoft Financial and HRMS 8.0
• More than 5 years in Oracle Hyperion experience.
• More than 3 years on Oracle EssBase.
• More than 10 years on DB2 (Version 8,9,10) experience.
• More than 5 Years Cognos development and administration experience.
• More than 15 Years experience in Unix and Linux Environment.
• More than 10 years PostgreSQL experience in University and work place .
• More than 15 years On CMMI experience.
• More than 10 years QA experience.
• More than 7 years on ITIL experience.

TECHNICAL SKILLS:

Language: JAVA,C++/C/C#,VB.Net,ASP.net,.net framework 2.0.3.0.4.0 ; PeopleSoft PeopleTools 8.4.9, T- SQL, PL-SQL include stored Procedure and trigger .

Cognos: Framework manager, Query Studio, Report Studio, Cognos Viewer, Analysis Studio, Cognos Connection, Report Net, Meritc Studio

DB Design Tools: ERWIN (Version 4, 7, Version 7.3), Power designer, Embacadera ER/Studio.

Third party support software: Quest (Spotlight,litespeed,toad......),redgate(SQL compare,SQL source control,SQL CI......)

PROFESSIONAL EXPERIENCE:

Confidential

BI Architect/BI Developer

• Build new dimension, fact tables and views.
• Built Stored procedure, functions.
• Built new dimensions, facts, calculated dimensions, cubes and MDX scripts in new cubes in SSAS.
• Built new SSAS cube to prepare for the report data source.
• Help to built master data service in enterprise environment..
• SharePoint 2010 and 2013 integeted environment with SSRS.
• Help trouble shooting bugs in existing DWH production tables.

Confidential

Sr.SA/BI Architect/BI Developer

• Trouble shooting on enterprise level Cognos system Migration bugs.
• Trouble shooting on Cognos and third party software integration.
• T-SQL in script checking in SQL Server 2005 and 2008.
• Cognos,proclarity,SSRS integreted in Sharepoint 2010 enterprise environment.
• Project on Confidential BI platform, SSIS, SSAS, SSRS.
• 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.
• Confidential Visual Studio 2008/2010/2012 and Business Intelligence Development Studio (BIDS)
• Zachman Framework environment to help design architecture.
• Help project manager decide resource arrangement.
• Encryption with DB security design with high and low level design.
• Design and build Data warehouse architecture.
• Report side use Oracle Hyperion Smart View for office, Planning, Financial Data Quality Management. Data relationship management.
• Reporting side used MicroStrategy.
• Informatica 9.1 Environment.
• MDM data designation in DWH.
• Work on IBM Cognos Migration Assistant, content database, Report Studio, Query Studio, Data Manager, Data Manager, PowerPlay, Transformer.
• Work on SAP BusinessObjects 4.0 Environment.(Dashboards, Webservices)
• As Technical Lead, directed team member’s work(around 20 members in this team).
• 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 integety with Cognos.
• Working on Dev, QA, UAT, Production environment.
• Oracle Fusion and JDeveloper Environment.

Confidential

Sr.BI Developer/Architect/DB dev

• Business analysis of Accounting System.
• 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 Confidential 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

Sr.BI Architect, Developer, Team Lead

• Build BI Architecture.
• Business requirement analysis.
• EDBMS Data modeling use Erwin.
• Design and build Data warehouse architecture.
• Confidential Visual Studio 2008/2010 and Business Intelligence Development Studio (BIDS)
• Work with project manager to allocate resource.
• SSIS/SSAS/SSRS development.
• T-SQL,PL-SQL scripting in SQL Server and Oracle.
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• Used Postgresql as DB source.
• Define architecture solution for customers in data warehousing and data management techniques.
• Data warehousing design and development.
• MS SharePoint application implementation.

Confidential

BI Developer/DB Developer

• 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
• Confidential Visual Studio 2008/2010 and Business Intelligence Development Studio (BIDS)
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• T-SQL,PL-SQL coding.
• Used Tableau and Qlikview Business Intelligence tools.
• MicroStrategy Development.
• MDM data in DWH designation.
• Informatica 8.6 Environment.
• Used Cognos 8.1 Query Studio and Report Studio wrote reports.
• Oracle BI platform, include Cognos 8,Hyperion packages, financial data quality management, planning, Public sector planning and Budgeting, EssBase.
• Define architecture solution for customers in data warehousing and data management techniques.

Confidential

SQL Server DBA /BI Developer/Architect

• Manage all production SQL servers.(4 group, >= 15 nodes)
• Health check of all SQL Servers (2005, 2008).
• BI Solution of whole enterprise with BI Solution.
• ETL (Extract, transform, load) development use SSIS.
• Microsoft Visual Studio 2008/2010 and Business Intelligence Development Studio (BIDS)
• 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.
• Setup all daily/weekly/monthly maintenance solution on all servers.
• Director developer and junior DBA to work.

Confidential

SQL Server DBA/BI Developer

• 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.
• SSIS/SSAS/SSRS development.
• Build BI Architecture.
• IBM Cognos reporting designation.(Query Studio, Report Studio)
• Confidential Visual Studio 2008 and Business Intelligence Development Studio (BIDS)
• Data modeling use Erwin.
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• Encryption with DB security design with special requirement..
• MDM data with DB2 MDM management center.
• ETL (Extract, transform, load) in SSIS development.
• Data loading from Oracle to SQL Server.
• T-SQL/PL-SQL stored Procedure (XML) and trigger development.
• Did Report configuration
• Define architecture solution for customers in data warehousing and data management techniques.
• MDX and OLAP development.
• Install SQL Server 2008 enterprise version, SSIS, SSAS, 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

• 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.
• Worked with a team of business to assist with a BI project that in phase 1.
• 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.
• Assessed and recommended long term direction of database architecture in conjunction with the needs of data owners and business line managers in PeopleSoft ERP.
• Assisted to setup SQL database security depend on request in PeopleSoft ERP application, established end-user database access controls.
• 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.
• T-SQL and PL-SQL scripting in SQL Server and Oracle.
• Used Postgresql as DB source.
• Oracle Hyperion technology, SQR, Financial data, Quality management. Planning, Workforce planning. Data relation ship management.
• Complete Training from PeopleSoft Company on PeopleTools 8.44 I and II.
• Assisted with the planning, implementation, and testing of disaster recovery processes with SQL server 2000/2005.
• Created models for new database development for PeopleSoft system and changes to existing databases.
• Design SSIS, SSRS, SSAS packages in development server and deploy them into production servers.
• MS SharePoint administration, Designation and Implementation.
• Capacity Management Quest Capacity Manager for SQL Server
• Worked with network staff to install and configure relevant network components to ensure database access while maintaining consistency and integrity.
• Monitored SQL database system details within the database, ensuring optimum performance.
• Assisted with the planning implementation and operation of change control procedures related to data.
• Researched and recommended new products, services, protocols, and standards to support the application and system plans of the organization.
• Performed SQL database transaction and security audits as appropriate.
• 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)

Confidential

SQL &DB2 DBA/system analyst/team leader

• Leaded the overall logical/physical database design, development and maintenance of applications using SQL Server 2000 and DB2, Oracle, MySQL, plus end user training.
• Created RDBMS Database, performed database tuning, performance planning, backup planning and administered SQL servers and DB2 servers. This project ‘s back office included two group of Database Servers, one group is business databases, which included 8 SQL Servers, another is a data warehousing group which included 5 DB2 Servers, AIX Unix OS. In the Business group, we used replication to keep the data integrity.
• Build BI Architecture.
• Confidential Visual Studio 2000 and Business Intelligence Development Studio (BIDS)
• T-SQL/PL-SQL stored Procedure and trigger development.
• Work on Oracle 8,8i,9i system.
• ETL (Extract, transform, load) development in DTS.
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• Confidential Office: Word, Excel, Access, Visio, outlook, Project.
• Leaded and perform tested, reported, capacity planned, performance tuned.
• Participated in detailed design, code walkthroughs and development of .NET application (vb.NET, ADO.NET, XML)
• Transformed data from various data sources using OLE DB connection by creating various DTS packages;
• Define architecture solution for customers in data warehousing and data management techniques.
• Performed backup and recovery in SQL and DB2 server, Oracle servers;
• Generated Business Intelligence (BI) reports with Business Analysis Services (BAS) and MS SQL Server 2000 Reporting services;
• Designed ER diagrams (Physical and Logical using ERWIN) and mapped the data into database objects;
• Troubleshoot complex SQL and DB2 Server related production issues.

Environment: .NET, DBMS: SQL Server 2000, Oracle 8i/9i, DB design tools: ERWIN, OS: Windows 2000 server, Linux, Language: ASP/ASP.net, C++, C# (with ADO.net), foxpro.JSP/J2EE, JAVA/JavaScript, XML.VB. Software: Rational Rose (UML), MS project, Crystal report.

Confidential

SQL Database Administrator

• Analyzed, designed, translated data models in SQL Server;
• Developed, updated, maintained and monitored large-sized SQL server database;
• Performed data warehousing and data mining jobs in SQL, including data cleaning, data transfer, and data analysis with different methods;
• Define architecture solution for customers in data warehousing and data management techniques.
• Created DTS Packages using Custom SQL queries and Stored Procedures;
• Translate Business Requirements to Data Warehousing Requirements to Application and Technical Specifications.
• Confidential Visual Studio 98 and Business Intelligence Development Studio (BIDS)
• Worked with all department users to gather requirements and formulate the scope of the project, defined and captured metadata and business rules in coordination with other data warehouse team members to support the projects;
• Provided weekly special Analysis SQL reporting to marketing, finance department and direct general office;
• Provided technical support to big clients of Confidential Company.