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.