Jhon Laguerre, BS, CSM, CSPO

Software Developer at Atlanta Housing Authority
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Atlanta, Georgia, United States, GE
Languages
  • English Native or bilingual proficiency
  • French Native or bilingual proficiency
  • Haitian Creole Native or bilingual proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

LinkedIn User

Jhon was great colleague and friend to work with. He was very helpful in many aspects. His knowlegde in sql and reporting services (SSRS) was sharp and resourcesful. I enjoy working with him and would recommend him for any sql/ssrs opportunity.

Abdoulaye Kante

Jhon was a great source of help in Sql. He helped me overcome many challenges situations. At time I had difficulties in Sql and Jhon was able to explain it to me in a easy way to undertand it.

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • CSPO
    Scrum Alliance
    Sep, 2017
    - Nov, 2024
  • Certified Scrum Master
    Scrum Alliance
    May, 2015
    - Nov, 2024

Experience

  • Atlanta Housing
    • United States
    • Government Administration
    • 100 - 200 Employee
    • Software Developer
      • Oct 2014 - Present

       Currently working in an Agile/scrum environment.  Maintained the SQL database server by modifying existing and creating new objects such as tables, views, procedures or functions.  Created parental table with cascading deleted to enable to delete all foreign keys based on the primary key.  Proficient in SQL & Transact-SQL (TSQL)as a developer  Extracted, analyzed and visualized data using SQL and Excel for anomaly detection.  Using SSIS for data extraction from various sources to various destination  Creating report in SSRS by writing stored procedure, created dataset and deployed in report manager  Work with business users, application developers and support team to identify business needs, discuss solution options and document requirement analysis.  Write test case and work requirement to assist of getting PBI ready for play  Participated in designing the Data Warehousing i.e Fact and Dimension tables  Created ER diagrams using MS Visio.  Involved in Knowledge Transfer to the peers. Documenting the business logic ensuring maintenance is easy for the peers.  Used TFS(Team Foundation Server) as a backlog tool to track the sprint work.  Creating report in Yardi Voyager embedded with SQL scripts Show less

  • TEKsystems
    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • SQL\Oracle Developer
      • Aug 2013 - Jun 2014

       Meeting with internal client to gather requirements for various t-sql script  Work in a team of .Net c#, Oracle and SQL developer  Create new database and all new objects such as tables, triggers, function and stored procedure  Create new SPs or Modifying existing SP by adding new logic in either Oracle or SQL Server.  Created parameterized report in SSRS based on SQL Store Procedure dataset.  Create SSIS package with different logic and transformation to transfer data from oracle to SQL Server vice versa.  Schedule SSIS package to run daily through Task Scheduler in windows.  Created new or modify existing objects needed such as tables, functions, views and store procedures  Normalized or denormalized database by creating necessary index or removing index for performance wise.  Work with business users, application developers and support teams to identify business needs, discuss solution options and document requirement analysis. Show less

  • TEKsystems
    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Sql Developer
      • Jul 2012 - May 2013

      Center Diseases Control and Prevention are partners throughout the nation to create the expertise, information, and tools that people and communities need to protect their health. My responsibility is to maintain the SQL database in regard of the ARCHE study. Environment: MS SQL Server Management Studio 2008, Visual Studio 2010, SSRS 2008, Windows 7 platform Responsibilities:  Work on the Arche project by creating new and modifying existing objects such as tables, stored procedure, views and functions.  Work with business users, application developers and support teams to identify business needs, discuss solution options, document requirements, specifications and design.  Created new SSRS report according to the requirement based on design styles and data sources where will be extract such as server, database and tables.  Create drop down list with multiple select based on tracking ID, sources and location.  Create documentation for any modifying and new objects creating.  Created cascading deleted to enable to delete a tracking ID from all tables in the database Show less

  • Comcast
    • United States
    • Telecommunications
    • 700 & Above Employee
    • Consultant SQL BI/SSRS Developer
      • Oct 2011 - Apr 2012

      Comcast is one of the world’s leading media, entertainment and communications companies. My responsibility is to create various SSRS report based on the date range, division and region for the business services department. Environment: MS SQL Server Management Studio 2008, Visual Studio, SSRS 2008, SQL Server Agent, Windows 7 platform Responsibilities:  Work closely with client to gather the report requirement for design styles and data sources where will be extract such as server, database and tables.  ETL from various sources include different server, linked-server such as oracle, and different databases  Transfer files such as Excel, Flat, FTP  Created automation through SQL Server Agent by writing several steps query and schedule jobs for daily refresh  Created Fact and Historical tables with case statement logics in current server  Created new report or modify several existing report by adding division, region and date range  Created or modify several views and stored procedures by adding new logic according to the report requirement.  Created and modified a variety of parameterized, drill down, click through, chart, matrix reports using SSRS 2008, by obtaining data from different sources.  Created permissions and adding new role assignment for business users to gain access to the report folders and files through report manager  Set up and distributed file sharing reports to a network target folder.  Scheduled the reports to run on daily and weekly basis and email the results to the business users in the required format. Show less

  • ING
    • Greater Atlanta Area
    • Consultant DB2 SQL Developer
      • Jan 2011 - Sep 2011

      ➢ Working on performance tuning several stored procedure that needed to run faster by reducing their execution time. Create global temporary table to feed the main query for better performance. ➢ Created or modify several functions, views and stored procedures by adding new logic for better performance. ➢ Normalized or denormalized database by creating necessary index or removing index for performance wise. ➢ Work with business users, application developers and support teams to identify business needs, discuss solution options and document requirement analysis. ➢ Mapping queries by breaking them down into table, column name and field name. Maintained data integrity by performing validation checks. Show less

Education

  • Worcester State University
    Bachelor of Science, Computer Science
    2001 - 2006

Community

You need to have a working account to view this content. Click here to join now