SUMMARY:

• More than 15 years IT experience.Business intelligence and Data warehouse development:
• More than 12 years SQL (T - SQL/PL-SQL) development experience.
• More than 12 years SQL DBA experience.
• More than 12 years Data warehouse architecture design experience.
• More than 12 years Cube, MDX design experience.
• More than 8 years SSIS/SSAS/SSRS hand on coding experience.
• More than 12 years Data modeling experience.(CA Erwin, Power Designer, ER/Studio)
• 2 years MicroStrategy, Informatica development experience.MS SQL Server
• More than 12 years SQL DBA experience in SQL 6.5/7.0/2000/2005/2008/2012.
• More than 12 years strong experience on Confidential Office (Word, Excel, Access, VISIO)
• More than 12 years strong experience on Confidential Project.
• More than 12 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 12 years.
• Strong system analysis experience, more than 12 years.
• Strong coding experience, more than 15 years.
• Strong testing experience.
• More than 10 years experience in Oracle 7.3, 8, 8i, 9i 10g, 11g.
• 10 years PL-SQL coding in J Developer 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.

TECHNICAL SKILLS:

Language: JAVA,C++/C/C#,VB.Net,ASP.net,.net framework 2.0.3.0.4.0 ;PeopleSoft People Tools 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, lite speed, toad......), redgate (SQL compare, SQL source control, SQL CI......)

PROFESSIONAL EXPERIENCE

Confidential, Markham, ON

BI Architect/BI Developer

Responsibilities:

• 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 integrated environment with SSRS.
• Help trouble shooting bugs in existing DWH production tables.

Confidential

Sr.SA/BI Architect/BI Developer

Responsibilities:

• 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 integrated 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 )

Confidential

Responsibilities:

• As Technical Lead, directed team member’s work (around 20 members in this team).
• Team members are deployed both onsite and off shore.
• Trouble shooting on enterprise system level bug. Successful solved key problem which has blocked this project for several months, then project could continue.
• Third party software Motio integrated with Cognos.
• Working on Dev, QA, UAT, Production environment.
• Oracle Fusion and J Developer Environment.

Confidential

Sr.BI Developer/Architect/DB dev

Responsibilities:

• Business analysis of Accounting System.
• Complex T-SQL/PL-SQL coding with Stored Procedure, Trigger, Function.
• Build BI architecture use Confidential 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

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 BMO.
• Write manual of some task of DBA Teams in BMO.
• Refresh (restore) database from production dump as requirement from other teams in BMO.
• Backup database as the requirement from other teams in BMO.
• Informatica environment.
• SharePoint 2010 environment.
• Help other team’s project manager to decide resource determination.
• Security issues add, change User and Logins in SQL Server as requirement from other teams in BMO.
• Tuning performance of SQL Server's objects as requirement from other teams in BMO.
• Create and modification SQL Server job agents to make maintenance tasks as requirement from otherteams in BMO.

Confidential

Sr.BI Architect, Developer, Team Lead

Responsibilities:

• 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

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
• 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

Responsibilities:

• Manage all production SQL servers.(4 group, >= 15 nodes)
• Health check of all SQL Servers (2005, 2008).
• BI Solution of whole enterprise with Confidential BI Solution.
• ETL (Extract, transform, load) development use SSIS.
• Confidential 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

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.
• 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

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.
• Worked with a team of business to assist with a BI project that in phase 1.
• The initial responsibility was to review the phase one data marts/reports/cubes and make recommendations on how to streamline the process. Later 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 relationship management.
• Complete 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 and 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
• 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

System Analyst/DBA

Responsibilities:

• Assisted to setup SQL database security depend on request in ERP application, established end - user database access controls. Wrote ERP system's development's plan documents.
• Define architecture solution for customers in data warehousing and data management techniques.
• 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)
• Define architecture solution for customers in data warehousing and data management techniques.
• Leaded the overall logical/physical database design, development and maintenance of applications using SQL Server 2000 and DB2, Oracle, MySQL, plus end user .
• 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.
• 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.
• 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

Responsibilities:

• 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.

Confidential

System Analyst/Developer

Responsibilities:

• I worked as System analyst and developer, get requirement from business analyst and understand it, then built architect of the solution and did the coding task with other developers.