We provide IT Staff Augmentation Services!

Senior Bi Lead Developer Resume

Plymouth, MN

SUMMARY

  • IBM Certified Confidential report author, Confidential Admin and Framework Modeler
  • Over 10 years of IT working experience with 10 - year experience in Confidential BI data warehouse analysis, design & development, implementation of Data warehousing, as well as in Business Intelligence tools such as Confidential and Framework Manger Data Modeling.
  • Experience in Confidential 8.3, Confidential 8.4, Confidential 10, Confidential 11, Qlikview, Qlik Sense, OLAP building on client-server environment and Oracle, SQL Server, DB2 based applications with Windows NT, and Unix operating systems.
  • Great Full life cycle experience on Confidential and Qlikview BI Solutions development.
  • Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
  • As a team player with strong communicational, organizational and problem-solving skills is confident interacting with all levels of professionals.

TECHNICAL SKILLS

Business Intelligence: Cognos11, Confidential 10, Confidential 8.4, Confidential 8.3, Confidential 8.2, Confidential ReportNet 1.1, Confidential Framework Manager, Confidential Metrics Manager, Confidential BI / Suite7.3 (PowerPlay, Impromptu, Transformer, IWR, Confidential Upfront 7.3, MS Analysis Service 2000, MicroStrategy Desktop 7i, Oracle Forms/Reports, Crystal Report 9.0, Crystal Enterprise 9.0, Crystal Analysis 7.0, ProClarity, XL Reporter, Costpoint, Pervasive, ADP reporting, Qlikview 11, Qlikview 9, Qlik Sense, UltiPro

Other Tools: Erwin, TOAD, PVCS, Data Junction, MS DTS, PCAnywhere, Visio

ERP: Costpoint, FMS, AltiPro

PROFESSIONAL EXPERIENCE

Confidential

Senior BI Lead Developer

Responsibilities:

  • Managed and provide corporation wide reporting solution by using Confidential BI tools such as Framework Manager, report studio and query studio.
  • Gathered and analyzed report requirements from different department
  • Managed and analysis requirements, business rule and data to create best reporting solution for HR, accounting, purchasing and budgeting
  • Worked with different user to developed complex report by using Confidential report studio
  • Based on client needs, developed or modified framework manger model for reporting
  • Developed dashboard for ET management and client to monitor revenue, cost, labor utilization, HOA, Booking and backlog etc.
  • Utilizing Report Studio to create template and complex reports.
  • Install, configure and Upgrade Confidential system and maintenance Confidential by add user, setup security and update packages
  • Utilizing Framework Manager to create reporting models for reporting needs
  • Test and deploy reports and packages from Develop site to production site
  • Troubleshoot Confidential process when error
  • Trained end users
  • Design and developed BOD dashboard for company board meeting.
  • Design and developed Corporation Business Operation dashboard for executive team and top management.
  • Design and developed PM dashboard for project manage to track project P/L status.
  • Design and developed corporate spending dashboard to help company cash management team monitor real time company spending detail status.
  • Design and developed HR Metric dashboard to help HR department tracking New Hire, Veterans, Salary level and headcount.
  • Design and developed Business Optrak dashboard to help company monitor business potential for future year.

ENVIRONMENT: Confidential 8.4, Confidential 10.2, Confidential Framework Manager, Metrics 8.3, Costpoint 6.0, TOAD, Oracle 10g, SQL Server 2005, SQL Server 2008, Windows 2003 Server

Confidential, Plymouth, MN

Senior BI Consultant

Responsibilities:

  • Gathered and analyzed user requirements
  • Design and developed data warehouse for revenue analysis
  • Used Confidential Framework Manager to create model for business analysis and reporting
  • Setup security for the revenue data mart.
  • Used Analysis Studio to create analysis reports.
  • Used Report Studio to create template and complex revenue analysis reports.
  • Trained end users
  • Technical documentation for model and report development.

ENVIRONMENT: Confidential 8.3, Confidential Framework Manager, TOAD, Oracle 10g, ODI, Windows 2003 Server

Confidential

Senior BI Consultant - Senior Confidential Administrator and Report Developer

Responsibilities:

  • Gathered and analyzed user requirements.
  • Design and developed data warehouse solution for government clients
  • Installed several Confidential BI reporting systems
  • Used Confidential Framework Manager to create accounting, budgeting, and purchasing model.
  • Customized model to fit different clients needs
  • Used Transformer to create cubes for OLAP analysis.
  • Created cube data source and published the OLAP cube package on Confidential Connection.
  • Used Analysis Studio to create analysis reports.
  • Used Report Studio to create template and complex reports.
  • Customized Confidential Connection.
  • Maintenance Confidential systems
  • Worked with Informatica to design mapping file, ETL testing cases, and trouble shooting for ETL process
  • Installed and configured .Net Framework to run Confidential Go Office
  • Training end users
  • Troubleshoot process when error
  • Planed and upgraded v7.3 and v7.4 to Confidential 8.3 build the Confidential Production, Quality and Test environments.
  • Planed and executed installation of Confidential 8.3 production and testing environments.
  • Developed best practices for configuration and installation of Confidential system
  • Developed and implemented migration strategy using migration tools

Confidential, Potomac, MD

Confidential Developer

Environment: Confidential 8.3, Confidential Framework Manager, Confidential BI / Suite7.3, PowerPlay, TOAD, PVCS, Oracle 10g, Unix, Windows 2000, Windows 2003 Server, SQL Server 2005, Informatica, XL Reporter, Proclarity

Responsibilities:

  • Gathered and analyzed user requirements.
  • Designed business documentation.
  • Created detail technical design document which specify the reports and tools along with the SQLs, the logics and method of delivery.
  • Developed Standard Report templates, developed best practices document for reports and framework models.
  • Created Framework Manager project and metadata model, created a business view that contains model query subjects and shortcuts.
  • Used Confidential Transformer to create cubes
  • Prepared prototypes of the reports.
  • Created List and Crosstab Reports and customize reports with conditional formatting.
  • Created the Chart to present data graphically.
  • Tested reports for data validation and performance tuning.
  • Used Confidential Metrics Manager to create scorecards to track corporate performance to support decision-making.
  • Created Confidential cubes to feed Metrics Manager.

ENVIRONMENT: Confidential BI / Suite7.2 (PowerPlay, Impromptu, Transformer, IWR), Erwin, Data Junction, SQL Analysis Service, SQL Server 2000, Windows XP

Confidential

Programmer/Analyst

Responsibilities:

  • Designed and developed an ERP (enterprise resource planning) system for Confidential .
  • Integrated multiple management tasks such as quality control, material management, personnel management into one computer based information system.
  • Created logical flow, coded, tested and debugged Data Files Exchange System.
  • The purpose of the system was to establish connection and transfer data files between Host and Remote Systems.
  • Designed the MS Access 7.0 host database: tables, queries.
  • Created stored procedures for the remote SQL Server 6.5 database (to export necessary data).
  • Responsible for the design, development, testing, implementation and maintenance of the Quality Tracking System.
  • The system was designed to allow quality department to view and electronically annotate reports that are currently delivered to them on paper.
  • Worked closely with the project’s DBA to design and implement Database Stored Procedures.
  • Utilized ADO and used Crystal Reports for report generation.
  • Defined initial client specifications, project planning, design, coding, and testing of client interface.
  • Developed and maintained Bonus Calculator.
  • The system was a subset of the Quality Tracking System.
  • It calculated and kept track of the monthly bonuses paid out to workers personnel.
  • Utilized Visual Basic 4.0 and 5.0, MS Access 7.0, PDQ Comm 2.3 communications custom control.
  • Participated in development of Inventory and Event Tracking Subsystem to keep track of the jobs, materials, and participating departments and maintain optimum level of stock.
  • Used Visual Basic 4.0 and 5.0, Crystal Reports Professional.

ENVIRONMENT: Windows NT, VB 4.0, VB 5.0, MS Access 7.0, SQL Server 6.5, Crystal Reports

Confidential

Team leader

Responsibilities:

  • Designed & developed quality data collection methods and teams to perform data quality control.
  • Performed systems analyses, exporting, importing and analyzing data from various departments’ monthly.
  • Provided control reporting and solutions to address major quality issues.
  • Developed Ad Hoc data reporting tools.
  • Ongoing analysis of quality trends to in corporate proven corporate-wide investigation and supporting technologies into practice.
  • Led in the development of white-papers relevant to the field of data analysis monthly and annually.
  • Prepared and analyzed routine and ad hoc quality statistical information
  • Worked with senior management to develop and grow a highly visible cross­functional team for the delivery of quality analytical projects in a timely and cost- effective manner.
  • Monitored activities of all departments to ensure production quotes and deadlines were met.
  • Controlled production cost.
  • Generated and documented SOP (standard operating procedure).
  • Provided SOP and ISO9001 training.
  • Performed sampling design and estimation including calculation of sample sizes and estimate.
  • Provided advice and assistance to senior management.

Hire Now