We provide IT Staff Augmentation Services!

Bi Architect/bi Developer Resume

SUMMARY:

  • More than 15 years IT experience.
  • 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.
  • More than 12 years SQL DBA experience in SQL 6.5/7.0/2000/2005/2008/2012.
  • More than 12 years strong experience on Microsoft Office (Word, Excel, Access, VISIO)
  • More than 12 years strong experience on Microsoft 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.
  • More than 10 years on DB2 (Version 8, 9, 10)experience.
  • More than 5 Years Cognos development and administration experience.
  • More than 12 Years experience in UNIX and Linux Environment.
  • More than 8 years PostgreSQL experience in University and workplace.
  • More than 12 years On CMMI experience.
  • More than 10 years QA experience.
  • More than 7 years on ITIL experience.

SKILLS SUMMARY:

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

WORK EXPERIENCE:

Confidential

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

Technical Lead

Responsibilities:

  • 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

Responsibilities:

  • 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 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 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 other teams 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.
  • Microsoft 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
  • Microsoft 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 Microsoft 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

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

Senior SQL DBA

Confidential

Responsibilities:

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

Hire Now