Bi Developer Resume Document Transcript

Orlando Rodriguez http://www.linkedin.com/in/orodrigueznjbi 5003 Florida Blvd. Email:abpn7h@r.postjobfree.com Phone: 609-***-**** Pennsauken, NJ 08109 BUSINESS INTELLIGENCE DEVELOPER Team and goal oriented with excellent time management skill. More than 10 years experience in operations analysis and solution requirement gathering. Well versed in identifying potential risks to be addressed at beginning of solution lifecycle. Analytical mind creative report development to solve actual operation situation or to demonstrate level of performance against the optimal standard. Strong background in database design and development. Disciplined in the iterative solution development methodology to convert users requirements onto a report design and functionality. TECHNICAL COMPETENCIES Business Intelligence/Reporting Applications: BI Development Studio; Visual Studio 6.0 to Visual Studio 2008 PowerPivot 2010; PerformancePoint 2010; Crystal Reports 8 - XI R2; Crystal Xcelsious 4.5 Dashboards; SharePoint 2010; Excel Services 2010 Database & Database Applications: MS SQL Server 2000 -2008 R2, Oracle, MS Access; SQL Developer; T-SQL; SSIS; SSRS; SSAS Programming Languages: C#; MDX; HTML; CSS; Visual Basic 6.0; VB.NET; ASP; ASP.NET Certifications: Microsoft Certified Professional Visual Basic 6.0 for Desktop and Distributed Applications. EDUCATION & TRAINING SetFocus, LLC http://www.setfocus.com/m (Graduation Date) 08/09 SQL Master s Program The SetFocus Business Intelligence Master s Program is an intensive, hands on, project oriented program where participants add knowledge of and valuable experience putting the Business Intelligence skill set to use in a simulated work environment. Camden County College, Blackwood, NJ 1998 A.A.S. Business Administration / Accounting and Information Systems Pending Completion (110 credits) LearnNowOnlineLLC - http://online.learndevnow.com/default.aspx Presently enrolled Ongoing enrollment to maintain Microsoft development skills using Visual Studio, SharePoint, SQL Server, and the Microsoft Network Infrastructure. BI WORK-STUDY EXPERIENCE Implemented a Labor Analysis Business Intelligence solution for a national construction company. Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability. Implemented subscriptions and snapshots in the SSRS Report Manager. Integrated reports from SSRS with SharePoint 2010 and created/deployed reports and BI Dashboards in PerformancePoint/SharePoint 2010. Created pivot tables in Excel Services/PowerPivot 2010 and integrated within SharePoint. Analyzing facts and dimensions for data analysis and design within SSAS. Created KPIs for reporting of scorecards and/or performance management. Created and deployed cubes, perspectives, partitioning, hierarchies, aggregations, users and roles in SSAS. Created report actions that are linked to a SSAS cube within pivot tables. Designed and deployed ETL solutions in SSIS. Imported data from OLTP, flat files, or other data sources and created data flow solutions to cleanse and validate imported data. Inserted and/or updated newly cleansed and validated data into OLTP or OLAP databases. Created stored procedures, functions, common table expressions, and views from T-SQL; queried OLTP data with T-SQL and OLAP (fact and dimension) data with MDX. Applied data warehousing concepts to SSAS solutions. Developed detail and summary reports, line and pie charts, trend analysis reports, sub- reports, and MDX queries according to business requirements using SSRS. PROFESSIONAL WORK HISTORYOJRSolutions 10/09 1/11Business Data Solutions Developer, Self-employed, Pennsauken, New Jersey Created web site to offer development services to potential clients of OJRSolutions. Converted legacy code (VB6) to VB.net. Created data centric desktop applications using C# and the .Net data management functionality to extract data into datasets from text files downloaded from an Internet web site. Maintained BI Development Skills at LearnDevNow.comUnited States Postal Service 11/98 4/08Operations Support Specialist, South Jersey In Plant Support, Bellmawr, New Jersey Used DTS, SSIS, MS Access, and Excel to extract and transform data from a variety of data sources to a staging database to be used as the source for local reports. Worked as part of a team of operations analysts and Six Sigma Analysts charged with gathering business requirements, analysis, and design of reports based on such requirements. Used MS Access and Excel to prototype reports before developing with SSRS and deploying on the report server. Designed and published Crystal Reports reports to allow management to measure, monitor, and manage performance at the strategic, tactical, and operational levels, based on OLAP cubes for the strategic and tactical managers and analysts, and on an OLTP database for the operational level supervisors and other employees. Designed and developed an application to forecast workload; to work in collaboration with an automated production planning system and to be utilized by approximately 500 processing and delivery centers. Trained staff on use of new programs and ad hoc report creation with Excel.Operations Support Specialist, Eastern Area Office, Pittsburgh, PA Created collection box control system to ensure that pickup schedule was followed. Designed and implemented contract enforcement web application for post offices.Information Systems Specialist, South Jersey District Office, Bellmawr, NJ Created database programming to meet departmental information requirements, i.e. Telephone directory on web, IT hardware inventory control system, EEO claims management system. Operated the help desk and assisted staff on hardware and software problems. Configured and repaired workstations