We provide IT Staff Augmentation Services!

Business Intelligence Consultant Resume

Daytona Beach, FL

SUMMARY:

I am a Senior Business Intelligence consultant with over 10 years of experience in architecting, designing, developing, testing, and deploying highly effective and scalable data warehouse solutions. I have concentrated on developing effective ETL architectures, which has allowed me to also design and develop data models that supported business reporting requirements. I’ve worked with proven methodologies that have honed my skills in Data warehousing. Integration of data quality and effective metadata strategies are the central points to delivering a viable solution. Knowledge transfer is one of my strong points. I pride myself on my excellent communication skills, both written and verbal. Feel free to contact me to discuss the other hats I have worn during large scale data warehouse projects such as Business Analyst, Team Lead, Data Modeler, ETL Developer and Report Developer.

TECHNICAL SKILLS:

ETL Tools: Informatica Cloud, Informatica MDM, Informatica 10

Database Tools: SQL *Plus, SQL Query Analyzer, Toad 11.5

Reporting Tools: OBIEE 11g, Informatica MX, Informatica DQ, Business Objects Xi/5.1, Crystal Reports 8.5

Languages: SQL, T - SQL, PL/SQL, UNIX Command Tools/Shell Scripting

Databases: Oracle 12i/11g/10g, Access 2013/2010, SQL Server 2012/2008

Operating Systems: Windows 8/7/Vista/XP, UNIX, LINUX, Sun Solaris

Data Modeling Tools: Erwin 9.0, Visio

Methodologies: Ralph Kimball’s Data Modeling and ETL Architecture, Star and Snowflake Schema Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Daytona Beach, FL

Business Intelligence Consultant

Responsibilities:

  • Provided various ETL, and data warehouse redesign recommendations which provided greater efficiencies while adhering to best practices
  • Created a stage layer for loading data and employed change data capture to pull deltas
  • Extensively worked with fixed width and CSV flat files from various vendors for loading into Salesforce
  • Worked on transformations such as Lookup, Aggregator, Expression, Joiner, Filter.
  • Created Stored Procedures and used them in the mappings by using them as Connected and Unconnected Stored Procedure Transformations in the mappings.
  • Facilitated the creation of test and development environments to mimic production and allow development adhering to a strict SDLC
  • Managed Informatica Cloud Secure Agent working environments
  • Wrote several Windows scripts for file movement and archiving
  • Provided peer training on data warehousing topics and advanced Informatica functionality
  • Reviewed Functional Requirement Documents.
  • Analyzed requirements and determined best use technology for design and implementation
  • Created documents to support ETL such as ETL Detail Design Documents, Run Documents and templates for future use

Confidential, Boca Raton, FL

Business Intelligence Consultant

Responsibilities:

  • Managed Informatica Cloud and PowerCenter 9.1 working environments
  • Wrote several Windows scripts for file movement and archiving
  • Provided peer training on data warehousing topics and advanced Informatica functionality
  • Reviewed Functional Requirement Documents.
  • Analyzed requirements and determined best use technology for design and implementation
  • Created documents to support ETL such as ETL Detail Design Documents, Run Documents and templates for future use
  • Provided various ETL, and data warehouse redesign recommendations which provided greater efficiencies while adhering to best practices
  • Performance tuned several long running inefficient Informatica Cloud and Informatica PowerCenter Jobs
  • Created a stage layer for loading data and employed change data capture to pull deltas
  • Worked with various IT teams in South America and Europe to coordinate data feeds to the various systems
  • Extensively worked with XML as sources and targets between web sites and various CRM applications
  • Realized a near real-time feed for order creation between websites and the ERP processing the order
  • Utilized Informatica Cloud to interface with Soap and Rest APIs for web integration, Salesforce objects as well as Amazon Web Services

Confidential, Orrville, OH

Business Intelligence Consultant

Responsibilities:

  • Provided various ETL, DAC, data warehouse, D-Series scheduling and OBIEE report redesign recommendations which provided greater efficiencies while adhering to best practices
  • Performance tuned several long running inefficient Informatica Jobs
  • Rewrote several Windows scripts to operate in a Unix Environment
  • Regression and Unit tested Informatica\DAC jobs migrated from the old Windows based repositories to the new Linux repositories and performed any code changes when necessary
  • Performed server side and client side configurations to get all features of the DAC client working on developer client machines
  • Regression and Unit tested OBIEE reports, after they were configured to point to the new environment
  • Identified errors in the current OBIEE reports and OBIEE RPD and provided solutions to resolve them
  • Provided peer training on advanced Informatica and OBIEE functionality
  • Created dimension hierarchies, initialization blocks & variables.
  • Created, modified, and administered OBI Intelligence Dashboards.
  • Employed T-SQL queries to interact with relational databases

Confidential, Tampa, FL

Business Intelligence Architect

Responsibilities:

  • Conducted an enterprise assessment of the ETL, DAC, data warehouse, database and OBIEE report environments
  • From an architectural perspective, documented the gaps (in regards to the best practices) in the implementation and high level steps to rectify it.
  • Provided a mapping of the fields: A document which lists the Metadata mapping from source to target.
  • Supplied best practices for supporting a warehouse. A proposed list of resources and their duties and daily tasks.
  • Provided an analysis of the current ETL load strategy and changes required to move to an incremental load.
  • Examined a list of existing dashboards and reports that currently did not satisfy their reporting requirements and provided a list of standard fields and flex fields that will subsequently need to be added to the code.
  • Reverse engineered an ERD and provided a short write up of the model

Confidential, Melbourne, FL

Business Intelligence Consultant

Responsibilities:

  • Provided various ETL, DAC, data warehouse and OBIEE report redesign recommendations which provided greater efficiencies while adhering to best practices
  • Reverse engineered and documented several existing processes in a design template and Visio diagrams for high level overview
  • Automated several manual process loads into the data warehouse
  • Implemented a stage layer in the data warehouse for better auditing, restartability and load control
  • Implemented several DB scripts to periodically clean up the stage area based on process requirements
  • Converted several flat file and Excel source loads over to Oracle or Sql Server database sources
  • Implemented design and coding standards for ETL processing
  • Provided 24/7 on-call support for production processes with quick issue resolution and commitment to stated SLAs.
  • Coded and utilized AutoSys for the management of production processes and process integration
  • Worked on security design for the OBIEE presentation layer to control user access between the various departments
  • Integrated Oracle EssBase cubes into the OBIEE physical layer for direct querying and report generation
  • Utilized Smart view to identify needed datasets in Oracle EssBase
  • Built and modified physical, business and presentation layers.
  • Created dimension hierarchies, initialization blocks & variables.
  • Created, modified, and administered OBI Intelligence Dashboards.

Confidential, Miami, FL

Business Intelligence Consultant

Responsibilities:

  • Guided business stake holders through GL codes exercise to set global environment variables
  • Implemented design and coding standards for ETL processing
  • Coded Informatica template mappings that were replicated throughout ETL environment
  • Mentoring of team members on best practices and issue resolution
  • Converted PL/SQL written packages into Informatica 9.5 Mappings for better readability and reusability
  • Migrated code, identified dependencies and set up scheduling for production Informatica environments
  • Reviewed Functional Requirement Documents.
  • Created test cases from Functional Requirement Document's and specifications.
  • Built and modified physical, business and presentation layers.
  • Customized OBIEE Login Page as per client’s requirement.
  • Created custom style & skin to have very good look & feel.
  • Created dimension hierarchies, initialization blocks & variables.
  • Configured OBIEE for LDAP Users.
  • Created various types of Charts & complex graphs.
  • Created Dimension Hierarchies.
  • Created, modified, and administered OBI Intelligence Dashboards.

Confidential, Orlando, FL

Senior Systems Engineer

Responsibilities:

  • Developed coding standards for Informatica Applications
  • Participated in the pre-project planning process alongside business partners, initiative teams, and component coordinators to identify the appropriate assets to meet business functionality and the high-level designs associated with the BI portion.
  • Participated in business rule design sessions and how they translate to new workflow constructs for the new converged data marts.
  • Created detailed documentation that included, but not limited to: Level 1 / 2 diagrams, Application distribution diagrams, source to target mapping specs, data dictionary, Logical and Physical Star Schema data model diagrams.
  • Communicated project change requests to upper project management
  • Conducted code walk-thrus and enforced coding and metadata standards
  • Served as an experienced high level BI resource, especially during the project implementation phase, and to assist BI Project Lead in the delivery of the solution design.
  • Served as a technical resource to business partners for developing external vendor relationships that have impact on future BI Initiatives.
  • Worked with developers during crunch time to meet aggressive deadlines
  • Served on occasion as Tech lead on technical direction for processing issues.
  • Managed deliverables
  • Tracked milestones
  • Reported status to Project Manager
  • Designed and documented data models with Erwin
  • Redesigned parts of data model to adhere more dimensionalized model to support analytical processing.
  • Developed mappings and workflows with Informatica PowerCenter 9.5.
  • Redesigned and developed Informatica mappings/workflows that were completely developed instead of complicated SQL overrides
  • Created Custom PL/SQL
  • Created Custom UNIX/Perl shell scripting for workflow scheduling
  • Created OBIEE Administration Layer and user reports for various datamarts
  • Conducted KT sessions with junior employees to provide knowledge and guidance about existing systems and processes
  • Provided input on the Departmental IT Data Road Map

Confidential, San Francisco, CA

Business Intelligence Consultant

Responsibilities:

  • Provided 24/7 production support for ETL processes monitoring them closely for any issues.
  • Loaded data from Flat files, Heterogeneous database tables and Excel spreadsheets into target Oracle databases and applied Business Logic validations for inserting and updating records.
  • Worked with business users to ensure the availability of the source data and also to process requests for target data.
  • Worked with developers to enhance the ETL processes for better performance.
  • Worked on Informatica PowerCenter 8.0 tools - Mapping Designer, Workflow Manager and Workflow Monitor.
  • Used Workflow Manager for creating, validating, testing and running the sequential and concurrent tasks and scheduling them to run at specified time.
  • Responsible for the daily, weekly and monthly loads of data and handling all reject data.
  • Responsible for creating run-books and design documentation for several processes.
  • Documented technical specification, business requirements, and functional specifications during the development of processes and defined ETL standards.
  • Documented test cases and test plans data for the developed mappings.
  • Worked with audit team to ensure the quality of data, and provided them with excel sheet load logs to expedite validation of the data loaded.
  • Responsible for transferring functional and business knowledge of the processes to offshore teams in Bangalore, India.
  • Responsible for installing Business Object Xi onto client machines as well as performing administration duties with Business Objects Xi.

Confidential, Phoenix, AZ

Business Intelligence Developer

Responsibilities:

  • Designed, built and tested various Informatica PowerCenter 7.2 mappings to perform the ETL process from multiple Data sources to a Central Warehouse, according to the requirements.
  • Extensively used most of the Informatica transformations as required for implying the business rules.
  • Used Repository Manager to administer repository, implement repository security and define user roles & repository objects’ properties.
  • Created stored procedures for internal processing such as creating and dropping indexes, and truncating tables.
  • Used various active and passive transformations for data control and cleansing. Used various reusable transformations and mapplets.
  • Debugged mappings using the debugger in Informatica Designer and adjusting the tracing level to find logical or mapping errors.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent worklets and sessions and scheduling them to run at specified time
  • Used Workflow Monitor to monitor the workflows as they are executed and used the information provided to troubleshoot sessions and improved session performance.
  • Optimized/Tuned mappings for better performance and efficiency. Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
  • Involved in gathering, analyzing, and documenting business requirements, and data specifications for Business Objects Universes and Reports.
  • Involved with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
  • Created Aliases and Contexts for resolving Loops and checked the Integrity of the Universe. Worked extensively with @functions (@aggregate awareness, @select, @prompt, @where).
  • Checked the Integrity of the Universes. Exported the Universes to Repository for making available to users Developed and Deployed Reports, Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.
  • Designed, developed, tested and maintained reports using various techniques such as Sectioning, Ranking, Filtering, and Slice and Dice.
  • Created reports with graphical representation such as bar charts, pie charts for multidimensional analysis.

Confidential, Detroit, MI

Business Intelligence Developer

Responsibilities:

  • Used Informatica 7.1 extensively with transformations such as Lookup, Joiner, Aggregator, Filter, and Update strategy to create several mappings.
  • Followed the Slowly Changing Dimension methodology for loading data into the dimension tables.
  • Used Join Transformations to join the data from heterogeneous data sources such as flat files, Oracle tables and MS SQL Server tables.
  • Created multiple filter conditions in Filter transformation to filter and transfer only the required data from the source to the target.
  • Created Stored Procedures and used them in the mappings by using them as Connected and Unconnected Stored Procedure transformations in the mappings.
  • Used Workflow Manager to create Sessions and Tasks and used them to build Workflows and Worklets using various Tasks and scheduled the workflows to run at predetermined times.
  • Used Workflow Monitor to monitor the workflows as they are executed and used the information provided to troubleshoot sessions and improved session performance.
  • Involved in requirement gathering, preparing functional specifications.
  • Interacted with business users for the business reporting requirements and prepared reporting specifications.
  • Used Business Objects Designer to create Universes, identifying measure, detail and other dimensional objects.
  • Working on aliases, views, aggregate conditions, and contexts to resolve inconsistencies and to maintain universe integrity.
  • Created different types of reports, such as Master/Detail, Cross Tab and Bar Charts used in analyzing trends using Business Objects,
  • Used filters, conditions, calculations to enabling a high level of customization and to facilitate ease of use for the end user.
  • Responsible for creating reports based on products, by customer, by period, and comparative reports (area, region and product based).
  • Created shell scripts for better handling of incoming source file like moving file from one directory to another directory, extracted information from file names such as date for continuously incoming source.

Confidential, Windsor, ON

Oracle Developer

Responsibilities:

  • Gathered the project requirement and designed the project.
  • Created tables, views and synonyms
  • Created and modified implicit and explicit cursors
  • Responsible for writing various stored procedures, local and global procedures and packages.
  • Created indexes, sequences and triggers such as database triggers, event handling triggers
  • Created Materialized views to enhance performance.
  • Used stored procedures for fast retrieval of data from Database.
  • Managed the Tablespaces, and Indexes for applications.
  • Implemented Exception handling for executables, exceptions.

Hire Now