Data Analytics Lead, Consultant
NewSignature
Total years of experience :18 years, 1 Months
• Oversee analytics projects to extract, manage, and analyze customer data from multiple applications, ensuring that deadlines are met
• Help clients establish architecture and technical design for data warehouse, ETL, and data migration/integration projects along with technical oversight for resources on all phases of the project
• Design and build data pipelines to migrate large-scale data from existing on-premises data platform to Azure data lake using Azure Data Factory
• Responsible for delegating development tasks to data engineers and developers
• Mentor the developers with one-on-one sessions to help with their career growth
Technical Environment:
End-to-end Microsoft Analytics solutions with the entire Microsoft SQL Server Analytics stack whether On-Premise or Cloud, Power BI, Azure Data Lake, Azure Blob Storage, and Azure Data Factory
Consult with sales, product, and finance managers to gather business requirements for business reports and dashboards
•Translate business requirements into technical specifications document for development phase
•Provide end to end analytics solution (data extraction, data transformation, data warehousing, SQL development, reports, and dashboards) for sales, marketing, operations, and finance departments
•Reports and dashboards include:
•Microsoft multiple products sales dashboards in Power BI
•Microsoft events dashboard in Power BI
•Marketing operations reports (for marketing budget and commitment tracking) in SSRS
•Financial expense report (OPEX) in Excel and SSRS
•Responsible for generating analysis and presenting results back to stakeholders
•Extract data from corporate source data systems to local Canadian cloud servers
•Automate and streamline reporting processes
•Communicate requirements and/or issues effectively to the business groups
Technical Environment:
Power BI, Visual Studio with MS BI Stack (SSIS, SSRS, SSAS), SQL Server, Azure Studio
ETL Development using SQL stored procedures and SSIS on the implementation of Guidewire update for a local client, in support of additional functionality scheduled for the insurance application
•Develop operational reports using Cognos environment; and fix defects where required
•Develop analytical reports using Cognos reporting studio
•Interact with business users, functional teams, and SMEs to facilitate execution of the project
Technical Environment:
Guidewire, MS SQL Server 2012, SSIS, Cognos 10
BI Consultant for Data warehouse and Reports Development in Microsoft BI environment.
•Conversion of SAP Crystal Reports to Microsoft environment reports using MS Report Builder
•Technical Documentation consisting of information such as Data Source, Data Mapping, and ETL information for database developers
•Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies for new reporting requirements
Technical Environment:
Crystal Reports 8.5, MS BI Stack (SSRS, SSAS, SSIS), MS SQL Server 2008/2012, IFS, Oracle 11, Visual Studio
Provide consulting services in Business Analysis, Business Intelligence, and Data Warehousing projects
•Analyze which strategies are the most effective and what new strategies/technology can be implemented for the business and clients
Technical Environment:
Google Analytics, MySQL, Excel, MS BI Tools
Worked closely with the Supply Chain & Manufacturing Organization and Finance Department to establish necessary performance tracking, reporting, benchmarking in business intelligence solutions
•Served as a developer for BI reporting systems such as SAP BI/BO, and Crystal Reports
•Installed SAP Xcelsius 2008 in the development environment and created rolls and groups in Central
Management Console and based on the profile to give access to the business users
•Worked on Business Object Importer, BO Editor, Data Integrator, and Redefining Display
•Built Universes and Created Complex and Ad-Hoc Reports using Web Intelligence and Xcelsius
•Design and implement Key Performance Indicators Dashboards, BI reports, user training, and day to day support of BI solutions for Supply Chain & Manufacturing Organization
Technical Environment:
Worked with faculty and staff to design, implement, test and support computing systems across Ryerson. Support an IT infrastructure that effectively exploits technology for the benefit of faculty, staff and students.
•Analyzed, designed, and coded significant components of department’s intranet website ASP.NET using Visual Studio 2003, and SQL Server 2000. The website served as a knowledge-base for the department and includes function such as entering data, uploading/downloading files, Edit Information, Posting Messages, and search for information
•Document/Update User Manuals, Applications Operation Manuals, and Training Packets
Technical Environment:
ASP.NET, Visual Studio 2003, SQL Server 2003
Investment Bank)
•Primary role was to work from Global Access queues according to documented procedures to administer system access requests, maintain end user accounts, department moves, application permissions, and resolve permission related faults
Technical Environment:
Windows 2003 Server Support