We provide IT Staff Augmentation Services!

Bi Developer Resume

SUMMARY

  • Worked in Insurance industry, Healthcare Company, Retailer, and Education System
  • Experience on SSRS, SSAS, SSIS, SharePoint, SAP Database Objects BI, Crystal Reports, Oracle, CRM, Sybase, PixelPoint POS
  • Production support: process, analyze, diagnose, and trouble shooting
  • Experience on SQL, TSQL (Stored procedure, function, trigger, and cursor)
  • Experience on logical and physical design schema, data modeling, and creating Database, Data mart, and Data Warehouse
  • Experience on creating and maintaining cube and data mining
  • Maintenance of data warehouse for loading data daily, monthly and cube processing
  • Worked on database of projects related to Retailer, Clinic trail, Healthcare, Insurance, Finance, Home and auto loan processing, School events, Human Resources, Lawyer office Business, and Weblog
  • Experience on automation, marketing campaign, data mining models and prediction analysis
  • Experience on Database Server: Oracle11g, SQL server 2008R2/2012, Sybase
  • Experience on Team foundation server (Agile)
  • More than 8 years’ experience of SQL Server 2005/2008/2012 , Sybase, Oracle, Access 2007/2010 database and Data Loading and Reporting tools such as: SSRS, SSAS, SSIS, and SAP Crystal Reports 2011/2013, experience on production support and some DBA
  • Experience on production support, troubleshooting database server possess daily
  • Performed database administrative functions like installation and configuration of database and BI services ( SQL Server 2008/2012,SSIS, SSAS, SSRS, and Oracle 11g, 12c), creating database, partitioning of database, creating indexes, login and user creation, role and permission configuration
  • Experience on auditing and monitoring database validation using stored procedure and trigger
  • Experience in performance tuning, query optimization, and database optimization by optimizing code, creating index, trigger, automation procedure and partition
  • Eexperience in data modeling using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling
  • Experience on maintaining and monitoring database performance by creating customizing logging, SQL profiler, and check points. SQL server maintenance plan backup/restore, and partition
  • Experience on load variety of large volume data files into SQL server 2008/2012 database tables, migrat e Oracle tables into SQL Server 2008/2012 database tables and generate Report with SSRS
  • Experience on SSIS, including extraction, transformation, and load (ETL) packages for data warehousing
  • Robust MS Access and Excel skills with Pivot tables, and Power Pivot
  • Proven ability to approach problems effectively, prioritize and complete multiple tasks
  • Creative, independent, hard worker, good team player with and ability to accept responsibilities and meet tough deadlines

TECHNICAL SKILLS

Databases: SQL Server 2005/2008R2/2012, Oracle, Sybase, CRM, Access

Reporting: SSRS, SAP Database Objects BI, Crystal Reports 2011\2013, iReport (Jasper Report), web reports - ShorePoint2010, SSRS-Report Builder

Analyzing: SSAS, Excel 2007/2010 (Powerpivot, Data mining, V Lookups, merge data, cross referencing), FlowJo DataAnalyzer, JMP,SAS

Language: SQL, T-SQL, PL/SQL, MDX, Visual Basic, MS macros, ASP.NET

Internet: MS SharePoint 2010

MS Office: Word, Excel, PowerPoint, Access, Outlook, Visio

Operating Systems and GUI: Windows Server 2008R2, Windows XP, Windows 7/8 Virtual Machine, VMware, SQL developer, SQL*Loader, TODA Installation, configuration and migration hands on skills Microsoft SQL Server 2008/2012, SSIS, SSAS, SSRSSharePoint 2010 Oracle11g, Oracle12c Sybase, SQL Anywhere (10, 12)

PROFESSIONAL EXPERIENCE

BI Developer

Confidential

Responsibilities:

  • Installed and configured PixelPoint POS Sybase and integrated Crystal reports viewer for end user, built and maintained developer for report test
  • Design and architecting data mart for different departments
  • Modified and maintaining marketing campaign mining models
  • Creating reports with sub reports, parameterized reports, nested groups, complex formulas, running totals, summaries and conditional formatting
  • Generating reports using tables, views, stored procedures
  • Worked on performance optimization of various reports
  • Automated reports for weekly, monthly and yearly schedule using Crystal Reports, VB and RDC (Report Designer Component) and delivered via Adobe PDF format. Exported reports to formats like PDF, Excel, and HTML
  • Extracted data from Sybase, custom manufacturing Pixel POS application, using Crystal Reports
  • Generated SSRS reports for department of Loss and Prevention
  • Generated Crystal Reports for all departments in the whole retail company
  • Troubleshooting and tickets solution on Crystal Reports
  • Wrote complex code of hierarchy for SSRS report
  • View codes and optimizing codes for performance tuning

SQL Developer

Confidential

Responsibilities:

  • Maintenance of data warehouse for loading data daily and monthly
  • Maintenance and development of cubes and dashboards, make sure the daily jobs are running and up to date
  • Modified and maintained cube, SSRS pivot reports, and SSIS packages
  • Created automation procedure for loading fact tables or dimension tables
  • Reviewed code, troubleshooting SSIS package implement and SSRS reports
  • Reviewed and modified the macro automation code to generate the end of month report using Access, DB2, Oracle and SQL Server
  • Created store procedure, function, and cursor for optimization of production performance
  • Production systems support, including the investigation and resolution of incidents, problems, service requests, and working assigned tickets
  • Perform a follow-up consultation and documentation related to the handling and resolution of issues
  • Maintenance of reports and documents on SharePoint site and TFS (team foundation server)

Business Intelligence Developer

Confidential

Responsibilities:

  • Created, implemented and maintained over 63 SSRS reports while also customizing many reports to meet individual client needs.
  • Used ICD9 and CPT codes.
  • Created drill down, drill through, sub and linked reports using MS SSRS 2008, including matrix report, parameter report, dashboard report with charts, cascading report
  • Generated cascading report and pass multiple values to parameters by User-Defined function
  • Managed the subscription of the reports and data-driven subscription reports on SSRS Report manager
  • Provided MS SSRS 2008 training and documentation to end user in order for them to develop their own ad-hoc reports
  • Reviewed query and improved the performance of SSRS report

Data Analyst

Confidential, VA

Responsibilities:

  • Installed, configured, maintained all components of SQL Server and SharePoint 2010 to support client's applications included monitoring, performance, environment stability and supported for customer’s projects
  • Documented installation, testing, configuration, analysis, report, and troubleshooting
  • Reviewed SQL query plans and logs, optimized database performance to support the solution
  • Generated SSIS packages, SSRS packages for client’s requirements
  • Created, configur ed and customiz ed W eb Application, Sites including Site Collection, Lists,
  • Designed and maintained databases for basic and clinical research, created tables with constraints, maintained data integrity
  • Gathered data from laboratories and clinical-associated research databases and data warehouse, cleansed and loaded data to SQL Server, Access and Excel
  • Developed database programmer, wrote SQL queries with advanced group functions and sub queries
  • Extracted, transformed, and loaded data with SSIS packages, schedule job
  • Analyzed data using SSAS, FlowJo-DataAnalyzer, Excel, JMP(SAS)
  • Generated various types of reports (such as matrix report, parameter report, dashboard report, cascading report, and custom coded reports) according to the requirements of scientist and physicians using SSRS and Excel
  • Developed and maintained databases such as performance tuning
  • Deployed and maintained reports on internal SharePoint 2010

Hire Now