Business Intelligence Developer

Thales provides governments with know-how, modular solutions, and a global perspective that includes the various technical and organizational aspects of intelligence.

Involved in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, and Cursors to support the existing applications.

Demonstrated strong knowledge of SQL and T-SQL scripting languages.

Experienced in building SSAS Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence, writing MDX Scripts.

Managed user groups and security in the Business Objects platform, Implemented the Extraction, Transforming and Loading (ETL) strategy by creating packages using SSIS to extract data from DB2, SQL Server, Excel files, other databases, and Flat File sources.

Utilized Reporting Services, Power BI (Dash Board Reports), Crystal Reports, SSRS using MS SQL Server, and supported services using MDX technology of the analysis services.

Applied strong knowledge of Data Warehousing methodologies, including star schemas and snowflake concepts.

Explored data in various ways and across multiple visualizations using Power BI, demonstrating strategic expertise in the design of experiments, data collection, analysis, and visualization.

Involved in troubleshooting, resolving, and escalating data-related issues validating data to improve data quality.

Demonstrated excellent analytical, communication, and interpersonal skills.

Applied strong investigative and troubleshooting skills.

Populated data warehouses (ETL).

Cleaned and standardized data, merging data from multiple data stores.

Automated administrative tasks.

Utilized recursive CTEs, CTE, temp tables, and effective DDL/DML Triggers for efficient data manipulation and data consistency.

Wrote T-SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, and Cursors.

Skilled in error and event handling: precedence Constraints, Break Points, Checkpoints, and Logging.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Utilized Microsoft Visual C# in the script component of SSIS.

Created configuration files to deploy SSIS packages across all environments.

Worked with the report manager to deploy reports across all environments.

Applied expertise in using global variables, expressions, and functions for reports with experience in handling sub-reports in SSRS.

Installed and configured Reporting services, assigning permissions to different levels of users in SSRS.

Demonstrated strong knowledge of Microsoft BI reporting tools (SSRS, SSAS) and other reporting tools like Power BI.

Demonstrated ability to handle multiple tasks, initiative, and adaptability.

Applied analytical skills, communication, critical thinking, and SQL development skills.

Worked as part of an implementation team and established close working relationships with business consultants, human resources specialists, and management.

Created T-SQL objects & scripts to maintain data integrity across all databases.

Evaluated large and complex data sets. Maintained the database using Procedures, Functions, Cursors, and Triggers.

Established techniques for raw data exchanges, built & maintained SSRS, ETL packages.

Assisted clients in using implemented software projects.

Provided pre-go-live and post-go-live support during the transition to the new system.

Created mechanisms for importing or exporting data to or from the database.

Analyzed and troubleshooted SQL statements, code, and modeled database objects.

Performed tasks related to the performance tuning of ETL jobs.

Reviewed, discussed, and worked within agreed timescales, providing feedback to project managers.

Worked in an agile environment, tracked down and resolved bugs.

Demonstrated the ability to adapt to the company's evolving environment by learning quickly and taking on expanded roles by implementing new procedures and improving existing ones.

Created a Windows Forms Application. Developed the back-end and frontend of the website based on the given specification.

Applied OOP concepts in designing and developing the application.

Facilitated projects in an office with other graduate students; served on short-term project teams.

Experienced in bug fixing and troubleshooting issues.

Developed code for functional stories in agile methodology.

Debugged and modified software components.

Demonstrated the ability to learn and quickly comprehend new concepts and technologies.

Assisted in promoting a positive enginering and team culture.

Created technical documentation.

Communicated ideas, issues, status, and outcomes with the team and trainers.

Introduced to Business Intelligence, Tableau. Worked with Kendo UI, Html5, CSS, AJAX, HTTPS, JQuery, Web Services, database connection.