We provide IT Staff Augmentation Services!

Sr. Bi Solutions Architect / Lead Bi Team Resume

SUMMARY:

  • Work closely with clients to analyze and document their specific requirements.
  • Communicate complex procedures or diverse information to resolve customer issues.
  • Provide quality service by appropriate follow through, urgency and persistence.
  • Gain superior knowledge of software functionality.
  • Learn new products, integrations and features.
  • Perform effectively and with confidence under high - pressure and challenging opportunities.

TECHNICAL SKILLS:

Knowledge of: T-SQL, SSIS, SSRS, SSAS, MDX, MDS, DQS, POWER BI, QLIKVIEW, QLIK SENSE, SQL SERVER, SQL PROFILER, DTS PACKAGES, SQL SERVER ADMINISTRATION, CRYSTAL REPORTS, VB, C#, VISUAL FOXPRO, XML, SOURCESAFE, TFS, SUBVERSION, SCRUM, DATAWAREHOUSE.

EXPERIENCE:

Confidential

Sr. BI Solutions Architect / Lead BI Team

Responsibilities:

  • Gather and document business requirements for BI solutions.
  • Propose and review data architecture of BI projects.
  • Lead TSQL Developer for the integration of the regional data warehouses.
  • Lead the BI team of developers on the architecture design and software development efforts.
  • Design a data quality solution using SQL Master Data Services and Data Quality Services.
  • Document data warehouse target to source mapping and transformations of the ETL process.
  • Define KPI metrics and associated visualizations.
  • Create and review data models for Qlikview and PowerBI applications.
  • Develop Qlikview and PowerBI solutions.
  • Lead review sessions with clients and overview of BI solutions.
  • Create and review SSAS models (Tabular and Multidimensional).
  • Standardization of the SSIS architecture and applications.
  • Develop SSIS source components using C# to extract data from custom file formats.
  • Create queries to extract data from ERP.
  • Monitor data warehouse database performance.
  • Tune DAX calculations.
  • Tune stored procedures and queries.
  • TFS Administrator for the BI projects source code.
  • Level 3 support of all BI solutions.
  • Work along with the DBA team to improve data architecture and storage guidelines for internal applications based on SQL Server.
  • Mentor other team members.

Confidential

DBA / Data Developer

Responsibilities:

  • Created SSIS packages to load data from external files(csv, excel) into the main system of records.
  • Generated summary reports and database logs of the import process.
  • Created plan and scripts to migrate database from MySQL to SQL Server.
  • Document datatypes mapping and transformations between environments.
  • Translate MySQL stored procedures to T-sql code.
  • Write T-sql functions to emulate MySQL proprietary functions and minimize impact of migration process.
  • Review and migrate sql code inside the java applications to T-sql standard.
  • Member of the data architecture team, establish guidelines and design principles of the new system architecture.
  • Data Modeling, database schema creation and write stored procedures (data layer objects) for new modules of the application.
  • Implemented a master data management solution using SQL server master data services.

Confidential

SQL BI Developer

Responsibilities:

  • Dimensional Data Modeling.
  • Review of the ETL architecture and processes.
  • Create ETL processes for automation and enhancements to the DW.
  • Developed SSIS packages to extract data from the data warehouse and create csv files to feed an external forecasting tool.

Confidential

DBA / SQL BI Developer

Responsibilities:

  • Dimensional Data Modeling.
  • Auditing of the ETL process and architecture to feed the cubes.
  • ETL Mapping documents.
  • Review improvements opportunities.
  • Auditing of the SSAS cubes (Fact Tables).
  • Audit Cubes measures and aggregations.
  • Review guidelines and recommend changes to best-practices.
  • Create BI reports using SSRS and MDX (Scorecards, Dashboards).
  • Create ETL processes for automation and enhancements to the DW.

Confidential

SQL BI Developer / DBA

Responsibilities:

  • Design and development of aggregations for the Investran Product.
  • Review and suggest changes to the database schema for better performance.
  • Development of the upgrade scripts for the product.
  • Performance tuning of SQL queries on the report wizard tool.
  • Design and review of the metadata for report wizard.
  • Development of T-SQL objects such as tables, procedures, functions and triggers.
  • Automation of DBA tasks using SSIS along with a Sharepoint interface.

Confidential

Sr. ETL Developer

Responsibilities:

  • Manage the workload of 2 in house BI developers and Supervise the work of an offshore development team.
  • Development and Performance tuning of the ETL process.
  • Support of the Data Repository.
  • Dimensional Data Modeling and data marts.
  • Create reporting solutions to deliver data to the external clients (SSRS & ETL).
  • Created integrations scripts using C#.
  • Established best practices and standards of the ETL processes and SQL development.
  • Design of aggregations for reporting purposes.
  • Mentor other SQL Developers.

Confidential

BI Developer

Responsibilities:

  • Dimensional Data Modeling for Data Warehouse.
  • Developed ETL, Data Marts and Cubes for the Data Warehouse.
  • Implemented a Reporting Solution using SSRS Scale-Out Deployment Architecture.
  • Migration and Automation of Reports from Crystal XI to SSRS.
  • Develop dynamic reporting solutions using SQL Server 2008 R2 Reporting Services.
  • Lead developer for T-SQL (Stored Procedures, Functions, Triggers) under Agile Scrum methodology.
  • SQL Server Database Administration and Performance Tuning.
  • Develop SSIS Packages for Software Integration.
  • Actively engage in design and development discussion for all Business Intelligence and database initiatives.
  • Responsible for Software upgrades on the Database layer.

Hire Now