We provide IT Staff Augmentation Services!

Bi Developer Resume

Chicago, IL

SUMMARY:

Experienced in BI development, systems analysis, hardware/software support and networking. Development experience with T - SQL, SSIS, SSRS, UNIX, ETL, Data Migration, Data Warehouse & Modeling, Crystal Reports, PeopleSoft, Powershell and Informatica. Articulate and proactive developer who is attentive to detail and streamlines communications between I.T. and all business partners.

TECHNICAL SKILLS:

  • SQL Server, Oracle and Unix
  • Reports - SSRS, Tableau, Crystal and Oracle Reports
  • ETL - SSIS, T-SQL, Informatica and SQL Loader
  • Cognos
  • Unix shell scripting
  • Excel
  • Data Conversions
  • Data Analysis
  • Data warehouse migration
  • SDLC
  • Access, Visio
  • PowerShell
  • Hardware and Networking
  • PeopleSoft

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

BI Developer

Responsibilities:

  • Developed Procedures, Queries and Views for datasets with SSRS, Tableau and adhoc reports for medical claims and final reports.
  • Created Linked, Drill-down, Drill-through, Parameterized and Sub-Reports using SSRS.
  • Fixed bugs in existing Procedures and Queries.
  • Tuned SQL Queries and reports for maximum efficiency and performance.
  • Created Tableau extracts from different sources for datasets.
  • Created Tableau workbooks from multiple data sources using Data Blending.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.

Confidential, Bernardo, CA

BI Developer

Responsibilities:

  • Developed Procedures and Queries into SSRS and adhoc reports for the County of San Diego.
  • Created Linked, Drill-down, Drill-through, Parameterized and Sub-Reports using SSRS.
  • In charge of ETL Conversion project using SSIS packages from SharePoint and a Windows 2000 Server which was expiring. Created SSIS Packages with flat files and CSV files from the two systems. Saved Confidential all the Maintenance and Monthly costs for the operation and Maintenance of the 2000 Server. Finished the project ahead of schedule.
  • Developed Procedures, Functions, Triggers, Tables, and Views in T-SQL for ETL Processes and Reporting.
  • Met with various Business units and System Analysts in the County and within Confidential in regards to initial specifications for projects through completion following the SDLC methodology.
  • Fixed bugs in Procedures and Queries that caused errors in GL balances and in final reports. This saved the county many hours of processing time with accurate balances.
  • Created T-SQL adhoc Queries for different Business Units to find quick solutions to data problems and for future SSRS reports.
  • Tuned SQL Queries, ETL Packages and reports for maximum efficiency and performance.
  • Assisted DBA in deployment and performance tuning of Procedures and reports.

Confidential

Senior Developer

Responsibilities:

  • Developed dynamic procedures to run modules and multiple scripts dynamically. Removed all hard coding and replaced with variables for automation. This saved many hours of processing time for the systems analysts who were running scripts manually which increased more chance for errors. Also saved hours of time for the System Analysts with performance tuning.
  • Developed T-SQL Procedures, Functions, Triggers, Tables, and Views for ETL and Reporting for different modules.
  • Created a process to compute file statistics for all of Confidential ’s file loads using PowerShell, SSIS, T-Sql and SSRS. This program would keep track of all files selected that came from Confidential Legacy system with any changes, history and aging.
  • Optimized procedures for better performance across multiple databases.
  • Developed an Audit table with T-Sql to keep track of all ETL Packages run in the SSMS Job queue with time and history. Created Error handling through T-SQL with DB mail which would email Project Managers of Error detail if requested.
  • Assisted in deployment from Development to QA to Production.

Confidential, Austin, TX

BI Developer

Responsibilities:

  • Developed ETL packages using SSIS for data conversions from PeopleSoft and Truecomp to Beqom software. Created error tracking and email system with Lookups for different modules. Converted flat files to tables using SQL Server 2012 BIDS.
  • In charge of creating a final SSRS Commission report for all Sales employees. This report produces paycheck information with their commissions at Confidential on request with a mobile App.
  • Developed T-SQL Procedures, Functions, Triggers, Tables, Views for ETL and Reporting.
  • Trained clients in Report Builder 3.0 to create their future reports with the new Beqom system. This saved Confidential the cost of hiring consultants to develop minimal changes on the reports.
  • Developed Forms and trained employees in using the Beqom application.
  • Assisted in deployment from Development to QA to Production.
  • Documented and revised Technical design document for different parts of the Project.

Confidential, San Marcos, CA

Programmer/Analyst

Responsibilities:

  • Worked with department managers in design, testing, implementation and evaluation. Matched system requirements, scope and all needs of the project with business analysts.
  • Developed Application package, components, triggers, queries, tables and PeopleCode for student/faculty applications.
  • Unit tested all processes before passing to QA department.
  • In charge of resolving issues and providing deliverables to the departments involved in the project though the SDLC process.
  • Developed scripts to move the application product to different Oracle instances for testing and completion to production.
  • Documented Technical design specs for definitions, objects and processes for each phase of the project.
  • Trained in SSIS, SSRS, PeopleTools, PeopleCode and Application Engine.

Confidential, San Diego, CA

Systems Analyst

Responsibilities:

  • In charge of gathering the data specifications, hardware and software requirements for the client.
  • Communicated with clients the technical specifications needed to successfully implement the business requirements and goals.
  • Signed off on the high level and detail design with the client.
  • Setup systems for new clients.
  • Developed applications in Access databases, Excel spreadsheets, PowerPoint presentations according to the design and customer needs.
  • Tested applications and processes to design specifications and performance analysis.
  • Trained customers in databases and development of modules;
  • Instructed customers in using Excel, developing spreadsheets, importing data, using macros, functions and formulas.
  • Trained clients to create reports and use charts in Access, Excel and PowerPoint.
  • ETL and reporting project with SSIS and SSRS.
  • Developed Excel Pivot Tables, Macros and VLookups.
  • Created reports on ICD9 and ICD10 codes with RAF score analysis. Including dual eligibles.
  • Optimized all scripts and modules for best performance.
  • Monitored systems for future development and upgrades.

Confidential, San Jose, CA

Lead Programmer

Responsibilities:

  • Supervision of all data integration of Wachovia’s incentive software to Confidential software through the whole SDLC process from flat files to live implementation.
  • Developed with SQL*Plus, PL/SQL, Unix and Informatica;
  • Integration including importing, updating, creating tables, queries and implementing into the software;
  • Assisting in development of Datamart and report access for Wachovia; performance tuning of data flow and reports for Wachovia;
  • Created millions of records for testing of Confidential insurance transactions;
  • Converted blogs and data from Confidential history data using Unix Korn shell scripts and PL/SQL;
  • Met daily with upper management to highlight and review results of test analysis.

Hire Now