We provide IT Staff Augmentation Services!

Sr. Bi Developer Resume

Northbrook, IL

CAREER SUMMARY:

  • IT professional with more than 15 years of progressive professional experience as Data Analyst / BI Developer for Financial, Insurance, Pharmaceutical and Telecommunication Sectors;
  • Experienced in all stages of software development life cycle, from initial use - case analysis, conceptual database design and data modeling through implementation, documentation, testing, support, and users’ ;
  • Extensive data modeling experience: conceptual, logical, and physical diagrams (ERWin, MS Visio, Embarcadero), Relational and Dimensional databases (Star and Snowflake schemas);
  • Strong Oracle Database development skills on UNIX and Windows platforms: Packages, Procedures, Functions, Database Triggers, SQL DDL, and SQL DML. Tuning SQL and PL/SQL using Toad, and tkprof;
  • Object-oriented programming with Python;
  • Design and development of batch ETL processes - data sourcing, mapping, transformation, and loading (ksh scripts, SQL*Loader, external tables, SSIS);
  • Experience with Python for sourcing, manipulating, and analyzing data.

COMPLETE SKILL PROFILE

Databases and Database Access Libraries: Oracle 12c/11g/10g/9i, SQL*Plus, SQL Developer, SQL*Loader, Toad, tkprof, Pro*C, ODBC, PVCS, Reflection, Rapid SQL

Data Modeling Tools: Erwin, Embarcadero, ER/Studio, MS Visio

Business Intelligence Tools: Crystal Reports, SSIS, SSRS, MS Excel

Operating Systems: Windows, Unix

Programming Languages: SQL, PL/SQL, T-SQL, Python, Unix shell scripting (ksh), C, HTML, XML

BUSINESS EXPERIENCE:

Confidential, Northbrook, IL

Sr. BI Developer

Responsibilities:

  • Perform extensive data analysis and activity modeling across multiple business systems. Work directly with customers to understand and troubleshoot issues, collect data, elicit detailed requirements.
  • Analyze a wide variety of data: structured and unstructured with the goal of influencing system designs and implementations. Extract and develop data using Python and SQL with SQL Server and Oracle databases.
  • Studied existing reporting and ETL processes. Participate in evaluation and improvement of system design and system implementation of both reporting and ETL processes.
  • Perform data verification and ensure all data is migrated to target system accurately. Build automated ETL pipeline using SSIS.
  • Extract commonly used functions into a reusable set of packages and libraries. Participate in refactoring backend scripts, consolidating SQL scripts into stored procedures, improvement performance and efficiency of reports and ETL processes. Develop and maintain SSIS packages, PL/SQL and T-Sql stored procedures.
  • Provide post conversion testing and test converted data as per the test plan. Created Python programs to automate common pre and post-conversion tasks.

Environment: Windows, Oracle 10g, MS SQL Server 2008R2-2014

Programming Languages: T-SQL, PL/SQL, SQL, Python

Tools: Visual Studio 2013, SSIS, SSRS, Toad, TFS

Confidential, Rosemont, IL

Sr. Database Developer / Analyst

Responsibilities:

  • Played a lead role in the design and implementation of a conversion project for Customer Allowances and Supplier Incentives SystemsPerformed design and development of mapping, transformation logic and processes for implementing business rules and standardization of source data from multiple systems into the data warehouse.
  • Determined partition type and partition key for new tables based on analysis of source data and business requirements.
  • Created production database migration documents for Oracle DBA team and Unix Administrators. Accomplished migration of database objects and Unix scripts between Development and QA environments.
  • Created DTD and migration documents.
  • Data-intensive analysis and creating data integration processes using Python;
  • Performed hands-on ETL and Oracle development to create Marketing and Business Intelligence database solutions.
  • Made formal code review of PL/SQL, Python, and ksh scripts. Provided technical direction to developers.
  • Created PL/SQL packages for Front-End and Back-End applications. Created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases. SQL Tuning.
  • Performed hands-on ETL and Oracle development. Designed and coded most complicated Oracle processes. Created code to load different types of data (csv, binary, xml, JSON).
  • Worked closely with Java application developers, Business Analysts, and DBA team in order to determine and implement required database changes.
  • Generated business intelligent reports.
  • Created PL/SQL code to communicate with OBIP and LDAP servers.

Environment: Windows, Unix, Oracle 12c

Programming Languages: PL/SQL, SQL, Python, ksh, C

Tools: SQL Developer, SQL*Plus, Toad, SoapUI

Confidential, Lake Forest, IL

Data Warehouse analyst

Responsibilities:

  • Designed and created Oracle database objects for Health Fitness data mining system.
  • Designed logical and physical database structures. Tuned snowflake schemas for optimal performance.
  • Performed analysis and mapping of source systems data for ETL processing.
  • Created all source-to-target data mapping documentation.
  • Troubleshoot and diagnosed critical issues.
  • Created the most complex PL/SQL code.
  • Performed formal code review for the other team members.
  • Determined common Error handling strategy for PL/SQL code (for ETL processes and the reporting system).

Environment: Windows, Unix

Programming Languages: PL/SQL, SQL, ksh

Tools : SQL Developer, SQL*Plus

Confidential, Rosemont, IL

Database Developer

Responsibilities:

  • Design and development of mapping, transformation logic and processes for implementing business rules and standardization of source data from multiple systems into the data warehouse.
  • Create and review DTD and Specification documents. Do formal code review of PL/SQL and ksh scripts.
  • Provide technical direction to developers.
  • Create PL/SQL packages for Front-End and Back-End applications.
  • SQL Tuning.

Environment: Windows, Unix

Programming Languages: PL/SQL, SQL, ksh

Tools: SQL Developer, SQL*Plus, OWD, SoapUI

Confidential, IL

BI Developer

Responsibilities:

  • Designed and developed ETL processes. Created SSIS packages and PL/SQL procedures to modify and export data from flat files and Oracle databases into a Data Warehouse. Identified security and staging requirements, handled errors and data anomalies. Documented packages and applied naming standards.
  • Designed and built multi-dimensional cubes using SSAS, including the use of custom MDX for complex calculations.
  • Developed complex PL/SQL and T-SQL statements - packages, triggers, views, exceptions, collections, analytical functions, and regular expressions. SQL query performance tuning.
  • Uncovered data anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within the data. Implement a quality process that assesses, designs, transforms, and monitors quality of the source data.
  • Modified and created reports using Crystal Reports 10 and MS SSRS 2008 services. Worked with tabular reports, matrix and chart reports, parameterized reports, sub reports, and drill down reports. Designed and created PL/SQL and T-SQL procedures to implement complex business logic.

Environment: s: Windows

Programming Languages: PL/SQL, SQL, T-SQL

Tools: Erwin, Toad, MSBI( SSAS, SSRS, SSIS), Crystal Reports

Confidential, Las Vegas, NV

Solution Analyst

Responsibilities:

  • Collaborated with Technical Lead to understand solution design and processing specifications.
  • Accomplished database design, programming, data architecting, and SQL tuning. Created Oracle and SQL Server database objects as a part of a Web-based application. Worked with different types of source data such as flat files and XML. Utilized Oracle database DBMS packages for creating and parsing XML data.
  • Updated existing PL/SQL, T-SDQL programs, and SQL queries as well as analyzed problems and requirements, defined recommendations, implemented solutions for the report system utilized Oracle Reports 10g service. Fixed anomalies, extended functionality, and amended logical errors.

Environment: s: Windows, Unix (Solaris)

Programming Languages: PL/SQL, SQL, T-SQL

Tools: Erwin, Oracle SQL Developer, SQL*Plus, tkprof, MS SQL Management Studio, SQL Loader, AccuRev, TrackIt, SSRS

Confidential, Deerfield, IL

Database Modeler

Responsibilities:

  • Was involved in design of the snowflake data model for the post-adjudication PBM Data Warehouse.
  • Designed ETL mapping documents to map source data (PBM system) to the target database. Created PL/SQL stored procedures for the ETL processes.
  • Tuned individual SQL statements used by the application. Identified required b-tree and bit-map indexes to remove unnecessary full-table scans. Created all supported documentation such as data model Metadata and Volumetric, CRUD Matrix, DDL, and ER Diagrams.

Environment: s: HP-UX, Windows

Programming Languages: PL/SQL, SQL.

Tools: Erwin, Embarcadero ER/Studio, SQL Developer, SQL*Plus, Oracle Developer Suite 10g

Confidential, Buffalo Grove, IL

Database Developer

Responsibilities:

  • Designed two web-based projects implemented in Oracle, MS SQL Server, UNIX, and Business Objects.
  • Created required documentation - “Detail Technical Design” and Specifications.
  • Connected with business representatives and business analysts to understand the business needs and requirements, and resolve issues with data and reports.
  • Designed and implemented ETL processes to load data from UNIX flat files into Oracle Data Warehouse.
  • Some of the files contained more than one million records. Defined business and mapping data rules. Created UNIX perl and ksh scripts, Oracle Stored procedures; utilized SQL Loader and External tables.
  • Created PL/SQL procedures and functions used by the batch process. Created new and tuned existing SQL required by the application. Created reports about the existing static data for business analysts and defined the missing data working in conjunction with the testing team and business analysts. Utilized SQL Loader utility and TOAD tool to load data from flat files into the NextGen database.
  • Was responsible for gathering test and production data requirements. Analyzed system and business requirements in order to identify required data. Possessed and created data and the requisite stored procedures for all applications deemed in scope for the testing by the NextGen program.

Environment: Unix (Solaris), Windows

Programming Languages: PL/SQL, SQL, ksh,, T-SQL, C

Tools: Toad, SQL*Plus, SQL Loader

Hire Now