We provide IT Staff Augmentation Services!

Bi Consultant Resume

Irving, TX

PROFFESIONAL SUMMARY:

  • Having Nine years of total IT experience specialized in Business Intelligence and Data Warehouse.
  • Extensive experience as a Delivery Analyst Coordinator for ITIL based methodology implementations.
  • Extensive work experience as an ETL Analyst and Developer specialized in Power Center.
  • Experienced as an Analyst and Developer in Databases and Shell Script specialized in Oracle and Linux/Unix.
  • Worked on Big Data as an Analyst and Tester with the Cloudera environment.
  • Knowledge in Data Warehouse and Business Intelligence Architecture best practices techniques like centralized, federated and multi - tiered considering the implementation of a staging area or an operating data storage (ODS).
  • Interacted in Data Warehouse and Business Intelligence Design best practices techniques like bottom up and top down considering the implementation of an On-Line Analytical Process (OLAP), Data Marts and the Dimensional Modeling.
  • Participated in Data Modeling for Data Warehouse Design considering Surrogate Keys and Tables for Facts and Junk, Degenerate and the 3 different types for Slow Changing Dimensions; also the different type of schemas like Star or Snow Flake.
  • Involved in Data Warehouse Performance best practices techniques like Bit-Map and B-tree Indexes.
  • Worked on Master Data Management Design (MDM) to improve the ETL and reduce the size of the Data Warehouse creating a Golden Source database with the Pure Data to generate the Reports or the Data Mining process.
  • Knowledge in Data Mining Design and Implementation with techniques like Artificial Neural Networks (ANN), Decision Trees, Lineal Regression, Statistic Models and Grouping.
  • Performed in Reporting using tools like Pivot Tables in Excel, Qlik View and Power BI.
  • Responsible for ITIL Methodology Service Documenting and Implementing Throw Request for Changes (RFC) and Family & Friends (F&F) production stabilization.
  • Experienced in PMI Project Management methodology collaborating and generating on time deliverables based on the Gantt graphic to ensure the success of the project.
  • Participated in Agile Framework Methodology like SCRUM as a Developer, collaborating with the Product Owners, SCRUM Master and Stakeholders in Daily Meetings, Sprints, Burn-up and Burn-down charts and product backlogs.
  • Responsible for Data Warehouse as an ETL, Oracle and Linux Analyst and Developer working closely with business analyst, data modeler and BI lead to ensure the end to end designs meet the business and data requirements.
  • Experienced in ETL, Database and Shell Script Analyst and Developer to analyze, test, solve, validate, monitoring, documenting, develop and troubleshoot all the issues related with performance tuning, problems, incidents, changes, or errors in the system.
  • Involved in Management and Leadership to provide technical of ETL solutions for BI projects, work closely to project manager to develop and update the system tasks plan, keep the manager aware of any critical tasks issues, prepare reports to show the status of the system, perform interviews with all users and developers, take appropriate actions to improve any implementation, coordinate and communicate with clients or other external organizations, plan and build road maps for the future of the data integration, platform and influence in IT best practices and product recommendations.
  • Designed as a Big Data Analyst and Tester with the Cloudera Environment designing the integration of the sources into Hadoop ingested through Data Lake with Sqoop in order to test the motors development in Scala and executing those processes to test and ensure the quality of the information, analyzing the Java and Yarn logs to find the errors of the executions or analyzing the data through Hive or Impala directly into the Hadoop Datasets.
  • Knowledge in SQL Language for user defined database to execute DDL, DML, DCL and/or TCL commands to analyze, update, modify or extract the schema objects or the data itself.
  • Responsible for Data Processes Mappings analyzing and creating mapping documents to understand the beginning, transformations and ends of every single data in the whole process.
  • Involved in QA/UAT/PROD phases to help with the analysis of issues and data reconciliation.
  • Experienced in Shell Script (Unix/Linux) commands for perform file level verification tasks.
  • Participated in Data Quality Process like standardization, homogenization, domain validation, obligatoriness, uniqueness, filtering and views of cross tables as a final download.

TECHNICAL SKILLS:

ETL: Power Center, Talend Studio, Pentaho

Database: Oracle, SQL Server, MySQL

Data Modeling: SQL Developer Data Modeler, Visio

BI: SQL, Shell Script

Reporting: Qlik View, Power BI

Data Mining: Weka, SAS

Project: Microsoft Project, Open Project, Gantt Project

Methodologies: ITIL, PMI, COBIT, SCRUM

Big Data: Cloudera Environment (Hadoop, Yarn, Spark, Sqoop, Hive, Impala, Scala).

Web: HTML, jQuery, Javascript, SEO, SEM, Wordpress

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

BI Consultant

Responsibilities:

  • Prepared the Estimations and Design specifications for the requirements with the Business Analysts and End Users.
  • Participation in the criteria decisions process to select the service provider.
  • Modeling new database schema based on the client requirements.
  • Used ETL for extract data from the source files and upload to Staging and Target area as per business logic.
  • Applied new business rules to data transformations and upload to the final database tables.
  • Used range partitioning to optimize data loads.
  • Writing SQL queries to verify the transactions and business logic like identifying the duplicate rows and data accuracy.
  • Coordinated and engaged to the team to reach the milestones by crossing major barriers while implementing requirements.
  • Implemented the Proof of Concept on the new solutions proposed for business requirements.
  • Development of dashboards and reports to show the final information to the end users.

Environment: SQL Server, Qlik View, Power Center.

Confidential, Boston, MA

BI CSI Consultant

Responsibilities:

  • Analysis, design and implementation to solve problems in the digital checks validation system.
  • Management of production passes and changes to stabilize the data warehouse credit risks system.
  • Responsible for productive support managing incidents, problems and quality plans of the checks treatment system.
  • Responsible for productive support managing incidents, problems and quality plans of the data warehouse credit risks system.
  • Application of palliative solutions to incidents of the university system, MIS, ODS and Cyber CRM.
  • Responsibility in the management activities that include execution of processes in productive environment, execution of query’s in productive environment, development of control boards and statistics and creation of RFC’s for implementations and documentation.
  • Night and weekend guard for open systems technology.
  • Analysis, design and implementation of productive incidents until a correct execution.
  • Participation in the crisis room for the solution of major incidents.
  • Knowledge to apply support in digital checks system, university system, MIS, ODS and Cyber CRM.
  • Collaboration in productive support in the applications, branches system, ATM system, audits and CIA.

Environment: Control-M, PowerCenter, DB2 Blue, SAS, Tibco, On Demand.

Confidential

Big Data Consultant

Responsibilities:

  • Mesh process design, from the ingestion to the final downloads.
  • Design of structures and relationships of the objects involved in the process mesh.
  • Design of the integration of manual interfaces.
  • Deliverables version control.
  • Integration motors unit tests.
  • Analysis of error logs through Java and Yarn in Hadoop.
  • Generic shell development for Hadoop processes execution with error capture function from Zoo Keeper.
  • Documentary management of RFC's for changes and installations in quality assurance, preproduction and production environments.
  • Change management through RFC's for stabilization in production environment with Family & Friends.
  • Collaboration in the design of the stages of data cleansing into the processes of data transformation.
  • Solving any technical issues arising during development and integration phases.
  • Coding data quality edit checks.
  • Documented logical, functional and technical diagrams, use cases, descriptions, installation plan and all the documentation related to the project.

Environment: Control-M, Cloudera Environment (Oozie, Hive, Impala, Hadoop, MapReduce, YARN, Spark, Zoo Keeper, Kerberos, Sqoop), Linux (Shell Script, Beeline, Hive Context, Spark-Submit), Scala (Lambda, Collects).

Confidential

Expert IT ETL BI Analyst

Responsibilities:

  • Collaboration in the infrastructure migration project of the ODS system, managing the changes through RFC’s in previous environments, coordinating the deliverables from external suppliers, performing unit tests, implementing the production in parallel and development of comparative tables of information validation to carry out the disconnection.
  • Management of evolutionary and corrective changes of the supply system and ODS with external suppliers.
  • Analysis, design, development, testing, implementation, support and maintenance of process mesh, shells, databases and ETL processes.
  • Creation, modification and reuse of mapplets.
  • Creation and modification of mappings and workflows.
  • Creation, modification and connection of sessions in the workflows.
  • Creation of queries for data filtering in ETL by partition and sub-partition.
  • Development and modification of batch processes to scheduling and automatization of ETL processes using PMCMD commands.
  • Coordination of the team of analysts of the ODS system, prioritizing, assigning work and tracking.
  • Participation in the weekly change committee as head of the ODS system.
  • Participation in the weekly committee MIS as head of the ODS system.
  • Analysis, design, testing, implementation, support and maintenance of process mesh, shells, databases and calculation engine OFSAA for integrated transfer rate.
  • Coordination of the team of analysts of the MIS system, prioritizing, assigning work and tracking.
  • Coding of data quality processes.
  • Participation in the weekly change committee as head of the MIS system.
  • Participation in the weekly committee MIS as head of the MIS system.
  • Worked on performance tuning identifying and resolving bottle necks.
  • Wrote complex SQL queries to validate and analyze the data in databases.
  • Worked with manipulation of variables and parameters into the ETL executions.
  • Data ambience in development environment using tables downloads to flat files and uploading through control files and SQL Loader.
  • Solving any technical issues arising during development and integration phases.
  • Defect assignment resolving escalated issues proactively.
  • Documented logical, functional and technical diagrams, use cases, descriptions, installation plan and all the documentation related to the project.

Environment: PowerCenter, Shell Script, Oracle, Control-M.

Confidential

BI Developer

Responsibilities:

  • Collaboration in the migration project and unification of multiple databases to a single one for the implementation of the ERP Time Share Ware.
  • Development of ETL jobs to obtain the data from other databases and upload to a staging area and then apply the transformations and finally upload to the ERP database.
  • Development of database stored procedures to upload the data executing a stored procedure object in the ETL.
  • Development of reports and programs to generate information about the migration process in real time to dashboards.
  • Wrote complex SQL queries to validate and analyze the data in databases.
  • Unit tests of all developed objects.
  • Implementation to the generic migration process at the end of the validation of the developed objects.
  • Participation as a developer under the SCRUM methodology.
  • Requirements survey for definitions of new products established by users.
  • Modification of the engine of the execution of the works for the generation of error records and automatic sending via email.
  • Coordination of deliverables with the data quality team.

Environment: Talend Studio, Informix, SQL Server, QlikView, Java.

Confidential

BI Developer Analyst

Responsibilities:

  • Requirements survey with business analyst to translate business requirements into technical specifications.
  • Development of ETL process.
  • Design, development and unit tests of ETL objects such as mappings, workflows and Mapplet.
  • Creation, modification and reuse of Mapplet.
  • Creation and modification of mappings and workflows.
  • Creation, modification and connection of sessions in the workflows.
  • Creation of queries for data filtering in ETL by partition and sub-partition.
  • Wrote complex SQL queries to validate and analyze the data in databases.
  • Analysis, design, development and unit testing of generics shell scripts for execution of mesh processes, data transformations and execution of stored procedures.
  • Analysis, design, development and unit testing of packages, stored procedures and functions.
  • Analysis, design and development of process meshes.
  • Data ambience in development environment using tables downloads to flat files and uploading through control files and SQL Loader.
  • Creation of database objects such as tables and stored procedures.
  • Worked with manipulation of variables and parameters into the ETL executions.
  • Development and modification of batch processes to scheduling and automatization of ETL processes using PMCMD commands.
  • Worked on performance tuning identifying and resolving bottle necks.
  • Documented logical, functional and technical diagrams, use cases, descriptions, installation plan and all the documentation related to the project.

Environment: Power Center, Linux, Oracle.

Confidential

Jr. BI Developer

Responsibilities:

  • Development of a web portal for access to sales applications.
  • Web application design for sales agenda.
  • Graphic design of icons and images for the sales agenda.
  • Analysis of existing CRM telemarketing queues to decide which ones will stay and which ones not.
  • Redesign of some CRM telemarketing queues.
  • Development of new telemarketing queues for CRM.
  • Analysis of existing CRM database tables to ensure the functionality of CRM telemarketing queues.
  • Creation and development of new relational databases of national postal codes for CRM.
  • Migration of new databases to the CRM through ETL tool.
  • Documented logical, functional and technical diagrams, use cases, descriptions, installation plan and all the documentation related to the project.

Environment: Oracle, Cognos Data Manager, Visual Studio, VS Web Developer, Web Matrix 2, Photoshop, Illustrator, Pivotal.

Confidential

Systems Analyst

Responsibilities:

  • Development of a web portal for complaints and suggestions for students.
  • Analysis, design and development of database for the complaints and suggestions web portal.
  • Development of stored procedures and triggers for sending reports of the complaints and suggestions mailbox to the academic responsible.
  • Analysis, design and previous tests of the academic performance prediction system with neural networks.
  • Selection of initial process variables and data sources to obtain the bests results.
  • Preparation and cleaning of data sources as a pre-processing phase.
  • Research about tools and techniques of KDD process to design the architecture and final phases of the solution.
  • Data transformation using and ETL tools to obtain the pure data for the data mining.
  • ANN tests using the back-propagation algorithm.
  • ANN prediction tests to identify patterns to evaluate the results.

Environment: Visual Studio, Dream Weaver, Weka, Artificial Neural Networks, Pentaho.

Hire Now