G. NARDOS

adj5qa@r.postjobfree.com / (***) *** - 0834

Skill set

• Data analytics and design

• Report development using various BI tools

o Power BI

o SSRS

o Excel

• ETL design, development, and deployment

o SSIS, Power BI

• Data modeling and design

o Modeler, SQL DBM, SSMS

• Requirements solicitation and documentation

• Agile Project Methodology -Azure Devops

• Project Management

• Complex Scripts development

• SQL, DAX, C# …

• On-premises, cloud Azure and AWS servers

summary experience

7+ Years of Experience with the T-SQL scripting/programming language, including the ability to develop, test, and implement database lifecycle development including Designing and building tables, Store Procedures, Schemas, Views, Database maintenance and Performance tuning.

Experience collecting user requirements and ability to understand complex business needs then translate them into BI application solutions.

Experience Translating Business rules into Conceptual, Logical & Physical models for OLTP / OLAP/ relational database design, multidimensional database design and development of the Enterprise Data Warehouse (EDW).

Experience on Developing and Maintaining reporting solutions, including Data warehouse, ETL processes code, Batch management and BI applications.

Expert in handling ETL testing process by Configuring logging, Error handling by using event handler, enable data views a, watch local variables on debugger and break points for SSIS packages.

Experience in Data analysis and data migration by transferring them using SSIS packages.

Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MS SQL Server, Excel, and Flat file to Microsoft SQL Server by using SSIS and DTS utility of SQL server.

Strong experience on Creating and managing ETL processes to Automate Deployment of packages and support integration between applications, including Business Intelligence and backend database server and reporting solutions.

Experience in Reporting, Data visualization and Presentation, BI, and/or data warehousing.

Expert relational database and data warehouse experience, understanding of SQL server, Oracle, and Snowflake.

Team oriented with strong interpersonal skills and able to work as part of a product team.

Strong background with SQL, Excel, Power bi, SSRS and other BI reporting and analytical tools.

Experience in Reporting, Metrics, KPI and Dashboard visualizations.

Experience using query tools, reporting tools, BI tools to create reports, metrics, dashboards, storyboards, and other data visualizations.

Experience on Creating Interactive reports including drill down, drill through and parametrized.

Experience in developing, bookmarks, slice and dice reports, visual interactions, embed in share point online, publish to web share to users and subscribers.

Experience in Convert and replicate existing Excel queries to Power BI reports and automate manual reporting processes.

Configure Power BI Gateways to refresh dataset from on-premises sources.

Experience using Team Foundation Server, TFS-GIT or other source code tools and Strong understanding of SDLC and Agile methodologies.

Designing, developing, and deploying solutions that support of business requirements using approved toolset and infrastructure

Education

Degree – information technology – Admas University college certification – Phoenix Technology College,

Work Experience:

Business Intelligence Developer

Central Bank since January 2018 - PRESENT

Project Overview:

work with users from identifying conceptual system requirements through completion. Responsible for the design, development, implementation, testing, deployment, and support of reports/dashboards.

Migrated organization orders, adjustments, objectives, and data in various formats like text-based files; excel spreadsheets, to SQL Server databases using SSIS to overcome the transformation constraints.

Automate package deployment and resolve performance related issues.

Create and maintain players data using complex T-SQL queries, views, and stored procedures in a multi-database environment.

Build enterprise data models using Microsoft's Power BI.

Partner with stakeholders across departments to understand data needs and define self-service reporting solutions.

Process and manage large quantities of data through SQL, DAX, and other languages to support the back-end data needs for our business intelligence applications

Develop, publish, schedule reports and dashboards to meet business requirements.

Develop visual reports, dashboards and KPI scorecards using Power BI desktop.

Optimize data models and visualizations maximizing Power BI’s speed of response and tune for performance.

Build measures, and computed measure apply logics, define tables relationship

Apply incremental data load and refreshment Apply row level security

Writes, validates, and executes test plans for solutions, applications, and/or operating systems. Ensures a high level of availability for all critical reports and applications.

Develop methods for data ETL and reporting, to meet business requirements and goals.

Integrate new systems with existing enterprise data warehouse structure.

Assist with research and development of new database tools, languages and platforms and providing a valid recommendation to senior management.

Maintain data integrity and security for all databases utilized including web, subscription, survey collection, and others as assigned

Builds SQL ETL routines to move, cleanse and prepare data for reporting

Translate business requirements into technical specifications that will be used to develop reports and dashboards for both internal and external use (full lifecycle)

Proactively identify, prioritize, and conduct analysis that drives meaningful change on KPIs, and critical objectives established by the stakeholder

Supports technical development of BI reports, applications, and other tools

Designed and implemented, cascading parameters, Drill -through and Tabular reports using SSRS.

Provide data to a variety of internal teams by designing and running queries and reports as needed.

Ensure database architectures address business requirements, system scalability, performance, governance, and reliability.

Lead development of database applications, interfaces, data transfer mechanisms and business intelligence platforms.

Develops information tools, algorithms, dashboards, and queries to monitor and improve business performance

Creates solutions from initial concept to fully tested production; and demonstrates results to a broad range of stakeholders

Developed queries for drill down reports to get the dataset required building the report, created data source and data sources views for metadata view.

Deployed generated reports onto the Report Server to access it through browser, involved in SharePoint integration while deployment of SSRS and ProClarity Reports.

Communicate directly as needed with non-technical business users to understand business needs and related requirements for reports and dashboards.

SQL Developer/ BI developer

ASCENSION April 2015 to November 2017

Project Overview:

responsible for assisting in the implementation of a data management solution. This includes the analysis, design, development, testing, installation, and initial maintenance of the solution and acting as interface with customers and other developers to determine the most efficient and cost-effective approach to meeting business requirements and include system integration, new code construction, modifications to existing modules, and package implementations

Design, develop, and support database management systems including analyzing database requirements of existing and/or new applications.

Responsible for creating and maintaining data warehouse schemas and ETL processes.

Created and Executed Daily jobs by using SSIS which Loads and updates database from flat files, Excel files, txt. files, and move them to archive folder dynamically with date stamp on.

adept at maintaining databases, queries, and report writing to interpret data utilizing reporting packages (Business Objects, SSRS, etc.), databases (SQL, Access, etc.), programming (XML), file formats (CSV, Flat file)

Perform Business and Data Analysis for insurance, reinsurance and corporate reporting and data requests using SQL, and/or other reporting/data mining technologies tools

Design and model data flows and procedures ensuring data quality and integrity

Working with data engineers and application engineers to ensure that data sets feeding the analytics platforms are tuned for optimal performance.

Work with power users of the analytics/reporting tools to advise on best practices for the business Intelligence reporting.

Troubleshoot and resolve issues with the processes used and the content produced by the BI platform.

Work with business stakeholders to define and improve standardized and ad-hoc analytics/reporting capabilities.

Responsible for ETL strategy, architecture, design, and development of the Enterprise Data Warehouse (EDW), designing and writing ETL code and batch management and error handling process.

Leads, designs, builds, tests, and maintains on-premises and cloud-based data pipelines to acquire, profile, cleanse, consolidate, integrate, and persist structured, semi-structured and unstructured data.

Works with internal and external data providers and subject matter experts to understand data sources and formats.

Understands and influences the data provider roadmap of planned changes.

Advocates for additional data sets and elements to improve delivered data products.

Leads, designs, and develops ETL processes for the data warehouse lifecycle (staging of data, ODS data integration, EDW and data marts).

Prepares key documentation to support the technical design in technical specifications. Authors and executes unit test scripts.

Data mapping from multiple data sources to SQL Server in a team-oriented and collaborative environment.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Contact this candidate