OBJECTIVE

• My objective is to combine cutting - edge technology experience to stimulate and accelerate company growth and implement world-class business intelligence (BI) solutions.

TECHNICAL SKILLS

• Dashboard Development
• Data Modeling
• Oracle 11g
• IBM DataStage 10.0
• SQL Server 2012/2016
• Informatica MDM
• MicroStrategy 8/9.0 Suite
• Business Objects XI R2/R3
• C#, .Net, JSON
• Teradata 13.0
• Power BI Desktop, Power BI Pro
• NoSQL - Mongo DB
• Tableau Server/Desktop 8.0
• Azure SQL, Azure DW, Azure SSAS
• Hadoop Ecosystem
• SSIS, SSAS, SSRS
• SAS Predictive Analytics
• Master Data Management (MDM)
• DBArtisan ER/Studio Data Architect
• Erwin DM NoSQL

PROFESSIONAL EXPERIENCE

Confidential

BI Architect/MongoDB Developer

Responsibilities:

• Creating, Reading and Updating Documents Data in MongoDB. Completely managed the MongoDB document database repository and the security. Cluster, Sharding, Replication maintenance as well as creation and removal of nodes.
• Responsible for administering and development of MongoDB (3.2 or above). Setting up Sharding and Replica Sets.
• Utilizing MongoDB command-line utilities as well as Ops Manager for Backup/Recovery, Disaster Recovery, Cluster Performance and High Availability implementations and Monitoring and Administration.
• Architect, implement, and test data processing pipelines, and data mining/data science algorithms on a variety of hosted settings, such as MongoDB, Azure Analytics and on-premise technology stacks.
• Migrate, augment and enhance data models and schemas from SQL Server 2016 STRUCTURED data models to MongoDB UNSTRUCTURED NoSQL data models.
• Architect all phases of the MDM HUB implementation including requirements analysis, registry/repository system design, programming, testing, roll-out, maintenance, and operational support.
• Used SSIS to develop and maintain all the customer data processes such as match/merge, slowly-changing dimensions, data profiling, standardization and data enrichment. Experience developing multiple cleansing and standardization scenarios using mappings & industry standard products.
• Develops data processing pipelines to ingest data from multiple data sources into MongoDB using SSIS and JSON.

Confidential

Enterprise BI Architect/Data Modeler

Responsibilities:

• Develops data processing pipelines to ingest data from multiple data sources into Azure SQL Server Data warehouse, Azure Data, Azure Data Factory.
• Responsible for designing OLTP and OLAP conceptual and logical models that represent business information requirements and business rules and that conform to the client’s architectural principles and standards.
• Responsible for creating OLTP and OLAP physical data models from logical models using appropriate data modeling transformation methods to ensure alignment and then incorporating technical requirements and constraints.
• Responsible for generating and maintaining scripts to replicate and update data models iteratively over the course of the development phases of the project.
• Prepare, maintain and publish data model diagrams, dictionaries, scripts and metadata files in accordance with project methodology and collaboration guidelines.
• Create Operational Data Stores (ODS), Hub and Spoke, Landing and Processing Zones, tables, views, stored procedures, indexes, SSIS packages, and SQL Agent Jobs in SQL Server and Azure SQL DW to support ETL processing and end user reporting. Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Design, optimize and refactor queries on Hadoop, Teradata, Oracle as well as SQL Server databases to develop and manage ETL processes and logical/physical data models.
• Tableau Server/Desktop 8.0 - configured and reporting of Data Modeling and Data analysis - relational database. Moved data with IBM DataStage 10.0 and SSIS ETL tools.
• Implement and set standards for the design and creation of Microsoft Power BI Dashboards and understand the detail of data, source of information, system of record and guarantee data accuracy with precision.

Skills Required: Hadoop, TeraData 13.0, DBArtisan ER/Studio Data Architect, Erwin DM NoSQL, Mongo DB, MongoDB Ops Manager, MS Azure, Azure Data Lake Analytics, Azure SQL Data Warehouse, Azure Data Factory, Streaming Analytics; On-Premise SQL Server 2016 (SSIS, SSRS, SSAS) BI Desktop, Power BI Pro, Data Modeling and Data Warehousing.

Confidential

Enterprise BI Architect/Data Modeler

Responsibilities:

• Managing the planning, development, and delivery of an enterprise data warehousing and analytics platform leveraging the Teradata database appliance as the Data Vault and SQL Server 2012 as the Subject Matter Data Warehouse. The objective was to support real-time reporting and analytics in the Confidential Loan and ERP Environment.
• Used SQL Server 2012 to profile data, normalized (3NF) and de-normalized (star & snowflake) and canonical models.
• Worked on the Data model to meet different business reporting scenarios. Created Intelligent Cubes based on different business subject areas. Worked on the navigation of the Application by linking all the Dashboards using MSTR URL API’s.
• Created MicroStrategy object packages to migrate objects across different environments. Involved in color branding of the application for the different members of Company utilizing MicroStrategy dynamic attribute images.
• Created logical OLTP and OLAP data models, recognize source tables and columns, to build, Attributes, Facts, Hierarchies and Relationships necessary to create aMicroStrategyproject.
• Responsible for working with business stakeholders to gather, analyze, and then translate requirements in BI reporting area - either recommending an existing solution, developing a solution, or synthesizing requirement for delivery to engineering teams for development.
• Responsible for leading and coordinating cross functional teams on a project basis to effectively communicate database design activities to technical, non-technical, and third party (often off-shore) team members.
• Use TeraData 13.0 Utilities and Developer tools such as MultiLoad, FastLoad, FastExport, TPT, BTEQ, TPUMP,SQL Assist to load tables on a daily basis and capture duplicates records, constraint violations, populate a staging area for the data warehouse data.
• Use TeraData 13.0 utilities such as FastLoad, MultiLoad and TPUMP to load tables on a daily basis and capture duplicates records, constraint violations, populate a staging area for the data warehouse data.

Skills Required: Hadoop, TeraData 13.0, SAS Predictive Analytics, Power BI Desktop, Power BI Pro, Oracle 11g, SQL Server 2008/2012, Informatica MDM, SSRS/SSIS/SSAS, T - SQL, C#, Shell Scripting, Data Modeling and Data Warehousing.

Confidential

Enterprise BI Architect/Data Modeler

Responsibilities:

• Responsible for QA'ing other developers work, requirements gathering, training, interviewing users for requirements etc.. .
• Managed 32 TB (Big Data) TeraData to SQL Server 2008 R2 Data Warehouse that involved very complicated and high memory and CPU-intensive data massaging processes.
• Responsible for designing conceptual and logical models that represent business information requirements and business rules and that conform to the client’s architectural principles and standards.
• Responsible for creating physical data models from logical models using appropriate data modeling transformation methods to ensure alignment and then incorporating technical requirements and constraints.
• Responsible for generating and maintaining scripts to replicate and update database schemas iteratively over the course of the development phases of the project.
• Prepare, maintain and publish data model diagrams, dictionaries, scripts and metadata files in accordance with project methodology and collaboration guidelines.
• Used SSIS, PowerShell and C# to design ETL packages that extracted electricity and gas usage for residential and commercial customers for all Texas and 13 other States in America.
• Used SQL Server 2008/2012 to design and deploy data models for Staging, Operational Data Store and Data Warehouse. Managed Files and FileGroups, Rolling Window Table Partitioning.

Skills Required: Hadoop, TeraData 13.0, SQL Server 2008/2012, SSRS/SSIS/SSAS, T - SQL, C#, HTML5, Shell Scripting, Data Modeling and Data Warehousing.

Confidential

Data Warehouse Engineer

Responsibilities:

• Use SSIS, Informatica 8.5 and TeraData 13.0 utilities such as FastLoad, MultiLoad and TPUMP to load tables on a daily basis and capture duplicates records, constraint violations, populate a staging area for the data warehouse data.
• Responsible for building data and security models that supported ACH Credit and debits and online payments as well as detected the many forms of fraud and abuse of online transactions. Created database stored procedures and alerts that notified staff in the event of daily limits or suspicious activity including suspected terror funding in known regions around the World.
• Configure reports for end users in Desktop,MicroStrategyWeb and Distribution Services. Created Transformations (table based, formula based) for using in comparative reports like claims this year to last year (year to date and month to date).
• Responsible for designing and documenting logical and physical Enterprise Application (OLTP) and Data Warehouse (OLAP) databases and creating the related ETL Design Specifications and supporting documentation.
• Responsible for actively leading and participating in Data Governance Initiatives to support the Confidential Data Strategy across operational and analytical database environments.
• Responsible for leading and coordinating cross functional teams on a project basis to effectively communicate database design related activities with a wide range of technical, non-technical, and third-party team members.
• Responsible for the publication and distribution of Enterprise and Data Warehouse data models and related documentation throughout the company. Also searching for, identifying, and exploiting opportunities to enhance Enterprise analytical databases using knowledge gained from experience and from an understanding of emerging methodologies.
• Responsible for creating MSTR Projects, Intelligence Cubes, attributes, metrics and hierarchies, dashboards and documents using MicroStrategy Desktop and Web; as well as migrating reports from Cognos 8.3 to MicroStrategy.

Skills Required: TFS (Team Foundation Services), MicroStrategy 9, SQL Server 2005/2008, Oracle 11g, SSRS/SSIS/SSAS, T - SQL, C#, Cognos 8.3, Shell Scripting, Informatica 8.5, TeraData 13 and Perl.

Confidential

Enterprise Data Architect/Data Modeler

Responsibilities:

• Responsible for interpreting business needs into a practical design. And work as a business consultant and also as a technical consultant. All other work activity after the data design was based on the data architecture design.
• Responsible for providing data solution designs for Data Warehousing, Business Intelligence, Master Data Management and other Enterprise information delivery needs.
• Wrote queries against a massively parallel processing (MPP) architecture (over 200 TB) to feed dashboards, scorecards, data points and metrics to fulfill analytics and business needs specific to Confidential re-designs and product launches.
• Used TeraData Manager, Dashboard and Performance Monitor (PMON) to monitor database performance and load skewness in real time. Also to move free disk space between databases.
• Use TeraData 13.0 utilities such as BTEQ query language, FastLoad, MultiLoad and TPUMP to load ~100 tables on a daily basis and populate a data warehouse of ~200 TB's of data.
• Responsible for developing custom ETL scripts using PL/SQL, T-SQL, O-SQL, Perl and SSIS which moved Gigabytes of data to the MPP cluster. Managed multiple projects and performed QA/QC testing of data.
• Responsible for creating MSTR Projects, Intelligence Cubes, attributes, metrics and hierarchies; as well as performance tuning, creating dashboards and writing reports and documents using MicroStrategy Desktop and Web.

Skills Required: SAS Predictive Analytics, MicroStrategy 9, Oracle 11g, SQL Server 2005/2008, Aster Data, MapReduce/SQL- MapReduce, SSRS/SSIS/SSAS, T - SQL, C#, Shell Scripting and Perl.

Confidential

Oracle Enterprise Data Architect/DBA

Responsibilities:

• Direct, manage and implement all aspects of an extremely complicated and high-volume ETL process; as well as manage the entire lifecycle of the data warehouse for the organization. ETL processes were first hand written in Perl and UNIX and eventually, when budget was increased, converted those ETL processes to Oracle Warehouse Builder and Business Objects Data Integrator mappings and transformations.
• Worked with internal and external customers to gather requirements for data integration projects and report delivery schedules. Most customers were technical leads and Senior Management members from every major area of the business.
• Made reporting the epicenter for defining, synthesizing and implementing business and product performance metrics across the Enterprise. Such metrics included Churn, Breakage, Cost-Per-Click and Conversion Rates to fine-tune and expand marketing campaigns.
• Performance tuning queries, stored procedures, functions, schemas and create logical and physical data models. Perform assigned tasks in the areas of database administration including installation, backups, cluster setup, 24x7 support, capacity planning, and database performance tuning.
• Used to Oracle Warehouse Builder to architect a high performance data warehouse for Enterprise Reporting. Proposed and documented a data warehouse infrastructure which included multi-dimensional modeling, archive and replication strategy complete with Visio diagram and documentation.
• Performed an upgrade of 175+ reports from Crystal Management Server 9 to Business Objects XI. Implemented BO Web Intelligence (WEBi) to design dashboards, scorecards and X-Celsius dashboards for users.
• Authored documentation that addresses “Best Practices”, “Test Plan” templates, “Coding Standards”, Data Warehouse Data Dictionary and “Naming Conventions”. Conducted training sessions that included requirements gathering, data layout, known data issues and technical roadmaps going forward.
• Skills Required: SQL Server 2005, SAS Predictive Analytics,Oracle Real Application Clusters(RAC), Oracle Warehouse Builder, PERL, Business Objects Data Integrator, Oracle 10g, Business Objects XI, Crystal Reports 10, SSRS/SSIS/SSAS, T - SQL, PL/SQL, ASP.NET 3.5, Replication and SQL Server Cluster design.

Confidential

Sr. Business Intelligence Engineer

Responsibilities:

• Used Oracle Warehouse Builder for the importation of data into the data warehouse.
• Developed the complete application infrastructure from the ground up.
• Slowly transitioned ETL procedures from Informatica PowerCenter to Oracle Warehouse Builder (OWB). Informatica was on the decline and OWB was emerging.
• Developed specifications for the importation of data from various internal and external data sources. SQL Server databases were the primary OLTP data sources.
• Created tables, referential integrity, indexes, views, constraints, stored procedures, and scripts for the massaging and cleansing of data.
• Used PL/SQL to develop and design financial reports from various perspectives and with various requirements.

Skills Required: Oracle 10g, Oracle Warehouse Builder, SQL Server 7 - 2000, TFS (Team Foundation Services), Oracle Discoverer, Business Objects XI, Informatica PowerCenter, PL/SQL, C#, VB.Net, Perl.